I'm proud to announce mycheckpoint, a monitoring utility for MySQL, with strong emphasis on user accessibility to monitored data. mycheckpoint is a different kind of monitoring tool. It leaves the power in the user's hand. It's power is not with script-based calculations of recorded data. It's with the creation of a view hierarchy, which allows [...]
I had a call from a new customer last week. They had issues with their MySQL server. Apparently, it was repeatingly crashing, every few hours. To have their production system kept alive, they used a script to periodically see if MySQL was still alive, and if not - start it. I was first thinking in [...]
A set of useful queries on INFORMATION_SCHEMA follows. These queries can be used when approaching a new database, to learn about some of its properties, or they can be regularly used on an existing schema, so as to verify its integrity.
I will present queries for:
* Checking on database engines and size
* Locating duplicate and redundant indexes
* Checking on character sets for columns and tables, looking for variances
* Checking on processes and long queries