From MySQL Cluster 7.1.9 (not yet released) it is possible to get
better stats on disk data tables. In fact, the statistics makes
it possible to tune the
parameter (similar to innodb_bufferpool), in order to avoid disk
seeks. It is much (understatement) faster to fetch data from the
DiskPageBufferMemory than disk.
Here is an example/tutorial how to use this information and how to check the hit ratio of the
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,
`data2` varchar(512) DEFAULT NULL,
PRIMARY KEY (`id`)