| Routine maintenance of mysql DB's [message #460] |
Sat, 09 December 2006 23:56  |
 carpii
Messages: 46
Registered: November 2006 |
Member |
|
|
Hi, Im a MSSQL DBA/Developer who uses MySQL for my personal projects. With MSSQL, there are several routine tasks I do just to keep the databases running smoothly (defrag of indices etc, integrity checks etc)
On MySQL I use innodb, and my database is now growing to a non trivial size (130GB). What routines should I be running regularly ?
Maybe ANALYSE/OPTIMISE table?
Any other you can suggest please?
Thanks
|
|
|
|
|
| Re: Routine maintenance of mysql DB's [message #465 is a reply to message #464 ] |
Tue, 12 December 2006 08:04  |
mushu
Messages: 3
Registered: December 2006
Location: Krakow, Poland |
Junior Member |
|
|
You don't need to perform any regular tasks, besides perhaps query log rotation and, if you have it enabled, binlog purging. At least I can't think of any other.
Defragmentation (OPTIMIZE TABLE) may be performed from time to time, but there is no simple rule on how often or if at all. In MySQL, there are number of things that affect fragmentation, even the storage engine used or the table structure.
Maciek
|
|
|
Members
Search
Help
Register
Login
Home
