On Tue, Aug 03, 2004 at 11:11:52AM -0700, Jon Drukman wrote: > > We were having terrible problems with a master/slave setup. The > master does a huge amount of writes, and the slave simply started > lagging behind, despite both machines being identical hardware-wise. > This made the application basically unusable because eventually the > slave was hours behind the master, and had no chance of ever > catching up. I disabled InnoDB on the slave (skip-innodb in the > my.cnf file) and now it has caught up and is keeping up fine. > > The weird thing is it worked fine with InnoDB enabled for many weeks. > > Also even after we re-converted all the slave's Inno tables back to > MyISAM it *still* lagged out. Only after I disabled the Inno engine > entirely did the problem abate. > > Any ideas why? Does InnoDB use resources even if there are no > active tables using the engine?
This is most confusing. You're not using InnoDB *at all* and it was slowing down the slave? What InnoDB options had you set in my.cnf anyway? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]