tag:blogger.com,1999:blog-13606853.post4771968043283172489..comments2023-12-28T16:01:32.344+05:30Comments on Whatever....: innodb configuration and optimizationgamegeekhttp://www.blogger.com/profile/00557771372755358783noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-13606853.post-35988975422413721202009-11-18T11:59:49.687+05:302009-11-18T11:59:49.687+05:30from facebook : To increase write speed on mysql 5...from facebook : To increase write speed on mysql 5.1 slave change the innodb_io_capacty to 100. <br />Quote from facebook : "Setting up two replicas of the same master, one running 5.0.84 and one running 5.1.38+1.0.4 showed the 5.1 server writing about 2x as much to disk, and having a little trouble keeping up the master. Mark helped identify the insert buffer cache as the likely culprit. gamegeekhttps://www.blogger.com/profile/00557771372755358783noreply@blogger.comtag:blogger.com,1999:blog-13606853.post-9968692332584529912009-11-18T11:56:30.414+05:302009-11-18T11:56:30.414+05:30Facebook says : To increase i/o performance for in...Facebook says : To increase i/o performance for innodb increase innodb_log_file_size and put innodb_flush_neighbors_on_checkpoint in my.cnfgamegeekhttps://www.blogger.com/profile/00557771372755358783noreply@blogger.com