These are good ideas. Just remember, if it ain't broke, don't fix it. Unless I see performance degradation, I don't see the need to do maintenance that could potentially create huge downtime (defrag doesn't work, table files are permanently destroyed). The risks must be weighed.
I used ext3 filesystem which needs virtually no maintenance. Innodb seems to just keep on chugging without any loss of speed. Granted, my data is for the most part low write, high read with the writes being sequential. I am very diligent about indexing as well (extremely important for high-read systems). Also, I use oversized hardware to keep things snappy without having to waste time worrying about the minutae (ie. an extra $1k on hardware can be an amazing boost) -----Original Message----- From: mos [mailto:mos99@;fastmail.fm] Sent: Thursday, October 24, 2002 6:23 PM To: [EMAIL PROTECTED] Subject: Re: MySQL oil change At 03:38 PM 10/24/2002, you wrote: >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 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
