sv1cec
13 Mar 2007, 12:43
Folks,
Upon checking my status variables for my database, I see a huge number for Handler_read_rnd (81M) and Handler_read_rnd_next (3,812.55M) and the second number is increasing rapidly (it was 3,810.07 about 2 minutes ago).
At this moment, my board is not very active (about 80 users online), Server Load Averages 1.05 0.97 0.93.
I read the explanation offered by MySQL for this parameter, so I went around checking for tables that are used without indexes (or with wrong indexes) and I can't find anything significantly wrong.
Do you guys have any idea what can cause this? Is there any way I can find out what tables are causing this?
Many tnx
Upon checking my status variables for my database, I see a huge number for Handler_read_rnd (81M) and Handler_read_rnd_next (3,812.55M) and the second number is increasing rapidly (it was 3,810.07 about 2 minutes ago).
At this moment, my board is not very active (about 80 users online), Server Load Averages 1.05 0.97 0.93.
I read the explanation offered by MySQL for this parameter, so I went around checking for tables that are used without indexes (or with wrong indexes) and I can't find anything significantly wrong.
Do you guys have any idea what can cause this? Is there any way I can find out what tables are causing this?
Many tnx