Jump to content

Handler_read_rnd_next is big


Recommended Posts

Handler_read_rnd 582 k

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 4,571 k

When in the back-office and i update, create a product , i have to stay as long as 10 second so that the page loads.

I have 150 categoryes, and i think that`s the problem.
Can i uptimize something from mysql to make it faster ?

Link to comment
Share on other sites

×
×
  • Create New...