Re: Very high disk utilization by mysql server during reads.

[Aftab Khan]

Questions:

> I have key_buffer_size=5G
It should be around 25% of the RAM size on dedicated server, so that more RAM is available to cache data pages.


1. How much RAM do you have?
2. Provide output of:
[ CODE ]
SHOW CREATE TABLE table_name\G
SHOW TABLE STATUS 'table_name'
[ /CODE ]

Replace table_name with actual table name

3. What SQL(s) do you use to read data? provide us

[ CODE ]
EXPLAIN SELECT ....
[ \CODE ]

Note: Remove spaces from [ CODE ] ... and [ /CODE ]



Edited 1 time(s). Last edit at 07/06/2012 07:02AM by Aftab Khan.