bryanwang

Thank you Pinoy.ca,

I tryed the comand, here is the stats.

---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id      |  Host      | db                 | Command | Time | State        | Info                                                                                                 |
+---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 1429797 |  localhost | cellphone | Query   |    0 | NULL         | show processlist                                                                                     |
| 1444976 |  localhost | cellphone | Query   |   88 | Sending data | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND |
| 1444985 |  localhost | cellphone | Query   |   88 | Sending data | SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND |
| 1445034 |  localhost | cellphone | Query   |   75 | Sorting result | SELECT ID, post_title, post_content FROM wp_posts WHERE post_status = 'publish' AND post_password =' |
| 1445100 |  localhost | cellphone | Query   |   75 | Copying to tmp table | SELECT ID, post_title, post_content FROM wp_posts WHERE post_status = 'publish' AND post_password =' |
+---------+-----------+-----------+--------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+

It takes 88 seconds to ‘Sending data’, 75 seconds to ‘Sorting result’, and more time to ‘Copying to tmp table’.

Any help will be appreciated!

Thanks!