Another MySQL DBA

Knowing the size of your data is of course helpful.  The tools have become easier over the years and different versions of MySQL but it is s...

A MySQL DBA is often asked to help with various versions of MySQL. SELECT VERSION(); +----------------+ | VERSION() | +--------...

Secure access to the database is likely priority number one for any database administrator. If it is not then you need to seriously look int...

I have seen the desire for a smaller ibdata file come up lately on the forums.mysql.com The innodb database uses the ibdata file(s) to st...

CHECKSUM TABLE is useful information when you are checking the status of a table. This is often used before and after a backup and restore t...