I am doing an estimate on how much i/o[disk read write] on Mysql 5.6 [innodb storage engine], for getting idea how to calculate total number of disk read write i have searched a lot on SO on DA and googled also and encounter a post give on this link Which is quite helpful.
It says I have to use SHOW STATUS
mysql>SHOW STATUS;
And monitor Key_read
and Key_write
for physical index read write , Created_tmp_disk
_tables and Created_tmp_files
for creating temp file for creating temp table and file on disk.
As i am using innodb , buffer pool size also affected on total number of disk read operation [which is totally depend on availability of hot pages ] so here i am confused about
1>>.What are the Innodb "Server Status Variables” i should consider while counting disk read write?
2>>.Are there any other "Server Status Variables” i should consider while counting disk read write?
3>>. Are there other factor i am missing here?
4>>. Dose hard disk type and speed will affect on total i/o disk read write?
thanks in advance!!!