At 03:38 PM 10/24/2002, you wrote:
Mark,Does anyone have any good maintenance tips for MySQL that should be done on a regular basis? I know table optimization is good to do from time to time but I would like to know of there is anything else I can do to help keep MySQL stable and running smoothly.Thanks Mark
Just my 2 cents (so you know you're getting you money's worth<g>), is don't forget to frequently defrag the hard disk. If you have the time, you *may* want to unload and reload the data every now and then (make sure you have backups in place). This helps to make the data more contiguous specially if using InnoDb. Or you can use Optimize Table if you do a lot of deletes to MyISAM tables. Large tables may pose a problem with the Optimize command because some people have reported crashes. Of course, and I stress again, make sure you have backups in place. Run Myisamchk daily (hourly?) on your tables to make sure they haven't become corrupted. And like changing the oil in your car, make sure the car is not running at the time.<g> (In other words, have scheduled down times when you can perform routine maintenance.)
Also see http://www.linux.gr/cgi-bin/info2www?(mysql)Performance and http://i4net.tv/marticle/get.php?action=getarticle&articleid=4
Mike
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
