https://www.icyphoenix.com/viewtopic.php?f=35&t=422&p=3350#p3350
-----------------------------------
Paul_RS1
Tue 26 Sep, 2006 19:11

Looking At Mysql Logs When The Site Slowed To A Crawl..
-----------------------------------
Does this mean high usage - It's a SQL log:

Handler_read_rnd  	1 Meg  	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 	266 Meg 	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.

My site slowed to a crawl once i had more than 10 people online..


