Those variables are easy to tune.
The evidence popup here between 128 and 256K
for in memory workload.
My SQL SQL layer is optimistic and think that data will come from
the storage engine at the speed of the memory bus , but in
practice for IO bound workload and range scan in the table order
it could not be the case , for MyISAM when reading from tables on
disk, IOs are aligned on the read buffer so it may be of an
intrest to increase it here.
In myisam.cc my_default_record_cache_size is set to
global_system_variables.read_buff_size;
To show IO size :
strace -p id_mysqld -e read -e write
If monitoring smaller IO request size from
iostat -xm, it may be that you are …
Showing entries 1 to 1
Dec
21
2011
Showing entries 1 to 1