On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: > Hi, > > I've read the performance tuning tips for InnoDB > (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit > when the log files are full and the buffer pool is checkpointed. > > By 'geting bit', I mean for several minutes the db server basically > stops, and our website stops serving pages. Does anyone have advice > about what we can do to alleviate this? Instead of having three 150mb > log files, would we be better off with 30 15mb log files?
It shouldn't matter how many files you have. InnoDB sees them as one striped file anyway. > Our log files are on the same raid array as the data, but would it > really make that much difference to move them to a separate disk? It can if things are I/O bound, and they likely are. > Alternately, is there a way to trigger this action at night, so we can > avoid it happening during the day? It shut us down for about five > minutes today. You could increase the size of your logs. That'll increase recovery time if there's ever a crash, but it should give InnoDB more breathing room. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,335,360,828 queries (241/sec. avg) --------------------------------------------------------------------- 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