powerbook
10-10-2006, 12:25 PM
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?
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?