Handler_read_rnd is too high (more than 2GB)
- by pnm123
Hello,
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)
Thank you, pnm123
PS: Currently there are 7,068,528 rows on the advertising program's database.