Comment 1 for bug 997117

Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

This is unlikely to be a bug; Threads_running=52 is unlikely to be incorrect. It's much more likely that you simply didn't see the spike. Please try running the tool again while also running something like "mysqladmin extended-status -i1" or watching the server with innotop set to a 1-second refresh interval and write back if you can confirm that Threads_running doesn't increase at the moment the tool claims it does.

The estimate comes from EXPLAIN, so that's just an artifact of MySQL's inexact statistics.