Re: OT: MySQL Healthcheck
- From: William Muriithi <william.muriithi@xxxxxxxxx>
- To: cicciuxdba@xxxxxxxxx
- Date: Mon, 25 Mar 2013 18:37:36 -0400
Alan,
> Now, my question to the list is what does a MySQL healthcheck entail?
>
Depends with your setup? Mind describing it a bit for us? Single instance?
Size? Master - slave? Master - master? Shared storage?
> 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
Transaction logs are self maintained. It cleans them after commiting data
to storage. If you want to back them up look for ibdata01 and ibdata02 file.
> start checking if they are using innodb or if there are any MyISAM
Start there then. It will drive the backup strategy that will fit your
system best.
> 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).
You don't need to backup software like rman. If you are running on lvm, use
it to snapshot your data directory and copy them over using rsync.
Alternatively, do a mysqldump if the database is not too large.
Other things I would check
What SQL_mode is it using? Turn on strict for good data integrity
If older than MySQL 5.5, enable innodb plugin
If the application is generating utf data, ensure the database is saving in
the same format
Adjust innodb_buffer_pool_size to match your hardware if using innodb
extensively or key_buffer if your database is primarily myism based.
Enable slow queries for pointers when something is really none optimal
>
> Thanks in advance
> Alan.-
>
William
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
