…and so if the left operand is big such …. Now as well know that ‘join_buffer_size…i_o_custkey` (`o_custkey`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Test Cases Now let’s see the test cases and then see how…to note is that I have scaled down the time taken by MySQL 5.5 to finish the query on IO bound…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is…is “buf0buf.ic” what means there is some buffer pool contention. However if you want to know more – you need to…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…is about 1000 per second. Logging to /dev/null It is interesting to know how…is negligibly small in IO-bound workload even if all queries are logged. In general logging all queries can hurt MySQL…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…to expose and enforce I/O priorities and arbitration. I‘m not sure whether MySQL do leverage those features though (maybe it would be useful to…to consumers (although MySQL offers INSERT DELAYED). Back to the subject, I don’t know anything about tpcc (and even less about how…
