The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Enormous Handler_read_rnd_next in MySQL
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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|