…queries per second and higher, lots of memory, lots of CPU cores, and most queries are running faster than one millisecond…time to execute. To give some context, normally these take 75 microseconds. I can see it clearly when I scan the slow query…MySQL…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… the IO is slow (when the FS cache is cold, IO to slow IO subsystem happens) …milliseconds before being able to move to the hot list. In MySQL 5.6 the default value of innodb_old_blocks_time is changed…_time=0; mysql> set global innodb_old_blocks_time=0; Query OK, 0 rows affected (0.00 sec) mysql> …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… some complex batch job query) you are likely …_old_blocks_time which specifies amount of milliseconds which …time to non zero value, if not I would strongly suggest changing default from zero in MySQL…slow it down more than 100 times. The solution is rather easy though. Setting innodb_old_blocks_time…
