DiskPageBufferMemoryparameter (similar to innodb_bufferpool), in order to avoid disk seeks. It is much (understatement) faster to fetch data from the
Here is an example/tutorial how to use this information and how to check the hit ratio of the
DiskPageBufferMemory. Next time, I will explain about other counters you can get from
Finally, no more educated guesswork is needed.
Let's take an example.
I have a table t1 with 650000 record
CREATE TABLE `t1` ([Read more...]
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`data1` varchar(512) DEFAULT NULL,