… value of Handler_read_rnd_next and divide it by number of total threads connected (ever?) will that give us a reasonable row reads per second? When I ran “mysqladmin extended -r -i 10 | grep Handler_read_rnd_next” I got a value of… good row reads per second or I am misled by the data. What should I read into when the value of Handler_read_rnd_next is…

… the Handler_read_rnd_next status variable. Here’s an easy way to watch it (innotop is another handy way): mysqladmin extended -r -i 10 | grep Handler_read_rnd_next — ignore the first line of output… | Handler_read_rnd_next | 429224 | So the server was reading roughly 43K rows…