Find The Efficiency Mysql Database Slow Sql Statement-mysql Database, Sql Statements, The
Explain to understand the SQL implementation of the state.
Explain select * from wp_posts \ G; Use the show status like "Handler_read%"; to understand the effect of the index.
Handler_read_key value that the index of high effective, Handler_read_rnd_next the index value at the high inefficiency.
With the show processlist view the current operating state.
Mysql> show processlist; +-----+-------------+--------------------+ | Id | User | Host | db | Command | Time | State |
