The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
MySQL Runtime Information
Hi,
I've been having some response errors all of a sudden. I then had a look at MySQL runtime information (shared server) and the info below were highlighted. Handler_read_rnd 12 M The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. Handler_read_rnd_next 2.81 G The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have. Slow_queries 27 k The number of queries that have taken more than long_query_time seconds Can anyone please point me in some direction to where I can find info on this related to vBulletin. I haven't installed any hack lately. Many Thanks... Edit: With shared hosting I don't know if this might also have to do with other databases on the shared server? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|