OT: MySQL Healthcheck

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 25 Mar 2013 16:24:25 -0300
Message-ID: <CAJ2dSGT4nEM0yHn4D4R=wbUoU1u5AUNzoynbzDJ_8SHu7VvoXQ_at_mail.gmail.com>

Hi List,
  The "OT" in the subject is because this is an Oracle list and my question is (mostly) geared to MySQL.

  I've been asked (by a project manager) to perform a healthcheck on a MySQL database before we take over administration. I found myself googling for something as simple as a Healthcheck.

  Now, my question to the list is what does a MySQL healthcheck entail?

  I checked that the data is in a separate filesystem and that it has plenty of room, and some my.cnf parameters, but I'm worried about transaction log rotation and stuff like that. Not to mention I didn't even start checking if they are using innodb or if there are any MyISAM tables... not to mention there's no backup policy implemented yet which means we'll have to consider backups at a later time (which may require additional software).

Thanks in advance
Alan.-

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 25 2013 - 20:24:25 CET