Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Routine maintenance of mysql DB's
Routine maintenance of mysql DB's [message #460] Sat, 09 December 2006 23:56 Go to next message
carpii is currently offline carpii
Messages: 48
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
Report message to a moderator
Re: Routine maintenance of mysql DB's [message #461 is a reply to message #460 ] Sun, 10 December 2006 00:50 Go to previous messageGo to next message
migandhi is currently offline migandhi
Messages: 9
Registered: December 2006
Junior Member
Please check this link for information
http://dev.mysql.com/doc/refman/5.0/en/backup.html
Report message to a moderator
Re: Routine maintenance of mysql DB's [message #464 is a reply to message #461 ] Mon, 11 December 2006 17:15 Go to previous messageGo to next message
carpii is currently offline carpii
Messages: 48
Registered: November 2006
Member
Hi, thanks for the advice, but I dont have any issues with backups

Im mainly interested in any maintenance tasks I should run, maybe tables and indices get fragmented, and should be defragged occasionally
Report message to a moderator
Re: Routine maintenance of mysql DB's [message #465 is a reply to message #464 ] Tue, 12 December 2006 08:04 Go to previous message
mushu is currently offline 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
Report message to a moderator
Previous Topic:Where is the official InnoDB scalability patch?
Next Topic:Performance problem with > 1GB table and some queries
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 20:31:06 EDT 2009

Total time taken to generate the page: 0.04915 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.