Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am running an advertising program and there are some SELECT, UPDATE and DELETE queries when showing ads. Sometimes, displaying ads is fast but sometimes it is too slow. At this time, it is slow and Handler_read_rnd and Handler_read_rnd_next is as mentioned below.

Handler_read_rnd    2,844.68 M
Handler_read_rnd_next   2,945.63 M

How can I speed-up displaying ads (decreasing Handler_read_rnd and Handler_read_rnd_next)

PS: Currently there are 7,068,528 rows on the advertising program's database.

share|improve this question
up vote 1 down vote accepted

Better start looking at your queries and indexes. Make sure you have proper indexes setup and check your queries for large joins, which both can make those counters go up.

There are about a bazilion guides for how to optimize MySQL out on the net. One place to start is here. Or you can have a look at the MySQLPerformance blog.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.