Title: bryanwang's Replies | WordPress.org

---

# bryanwang

  [  ](https://wordpress.org/support/users/bryanwang/)

 *   [Profile](https://wordpress.org/support/users/bryanwang/)
 *   [Topics Started](https://wordpress.org/support/users/bryanwang/topics/)
 *   [Replies Created](https://wordpress.org/support/users/bryanwang/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/bryanwang/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/bryanwang/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/bryanwang/engagements/)
 *   [Favorites](https://wordpress.org/support/users/bryanwang/favorites/)

 Search replies:

## Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [100,000 articles in WordPress?](https://wordpress.org/support/topic/100000-articles-in-wordpress/)
 *  Thread Starter [bryanwang](https://wordpress.org/support/users/bryanwang/)
 * (@bryanwang)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/100000-articles-in-wordpress/#post-731210)
 * The problem was caused by ‘random post plugin’.
 * `Copying to tmp table | SELECT ID, post_title, post_content FROM wp_posts WHERE
   post_status = 'publish' AND post_password ='' ORDER BY RAND() LIMIT 10`
    This
   caused the problem.
 * Disable it, the problem resolved.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [100,000 articles in WordPress?](https://wordpress.org/support/topic/100000-articles-in-wordpress/)
 *  Thread Starter [bryanwang](https://wordpress.org/support/users/bryanwang/)
 * (@bryanwang)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/100000-articles-in-wordpress/#post-731182)
 * 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!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [100,000 articles in WordPress?](https://wordpress.org/support/topic/100000-articles-in-wordpress/)
 *  Thread Starter [bryanwang](https://wordpress.org/support/users/bryanwang/)
 * (@bryanwang)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/100000-articles-in-wordpress/#post-731146)
 * Thanks for your reply.
 * When showprocesslist, wp was executing the following commands,
    Sending data 
   | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.
   post_type = ‘post’ AND |
 * The page stopped loading.

Viewing 3 replies - 1 through 3 (of 3 total)