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 previous 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
[Message index]

Read Message
Read Message
Read Message
Read Message
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 21:09:16 EDT 2009

Total time taken to generate the page: 0.01979 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.