tag:blogger.com,1999:blog-3247171317808202855.post1924176992761856880..comments2008-02-11T17:16:56.846-08:00Comments on DBA Dojo: MySQL vs MySQLslap round 2roobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3247171317808202855.post-37780880962195772442008-02-11T17:16:00.000-08:002008-02-11T17:16:00.000-08:00Hi Mark,Thanks for the comment.In my day job we ha...Hi Mark,<BR/><BR/>Thanks for the comment.<BR/><BR/>In my day job we have some clients with larger than 8 Gig innodb_buffer_pool_size. On EC2, I guess it is another thing to test out.<BR/><BR/>For logfiles the recommended number is two.<BR/><A HREF="http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#option_mysqld_innodb_log_file_size" REL="nofollow"> innodb_log_file_size</A><BR/>This isroobaronhttp://www.blogger.com/profile/08420801903669108937noreply@blogger.comtag:blogger.com,1999:blog-3247171317808202855.post-39587382765449940592008-02-11T13:46:00.000-08:002008-02-11T13:46:00.000-08:00Curious if you've ever pushed the innodb_buffer_po...Curious if you've ever pushed the innodb_buffer_pool_size to 8G or higher? We're running jobs on the same ec2 extra large box you did some of your tests on and have pushed the buffer from 5G to 10G (box is dedicated to mysql, database is about 120G and is laid out in file per table format) and things...changed. for one, the cpu usage of the db is now into double digits (yeah!) but then Markhttp://www.blogger.com/profile/13622716100913884033noreply@blogger.com