Like index maintenance we have index reorganize/rebuild, update stats, shrink database log files , database backup/restore in MS SQL server, What are maintenance steps and performance steps for Mysql server/database ?
views:
68answers:
2
+1
A:
ANALYZE TABLE will scan keys and store data that'll help future JOINs. I don't know how useful/needed it actually is but I bet it surely depends on what your typical db workload and table structure are.
OPTIMIZE TABLE will defragment your tables and reclaim unused space but, as you can read in the documentation, it is often unnecessary at all.
You can invoke them via SQL or with the mysqlcheck tool.
While mostly unnecessary, I usually schedule a mysqlcheck -Aao during low activity times (that means weekend nights in my case).
Luke404
2010-04-15 18:28:13
mysqlcheck -Aao , How can we schedule it?
Paresh
2010-04-20 12:13:02
use cron (http://en.wikipedia.org/wiki/Cron)
Luke404
2010-04-23 11:46:05
A:
Richard Varno
2010-09-08 18:37:14