Database slowdown after update to 3.4.1

If you’ve got 60,000 records, try cleaning post/page revisions; these really accumulate and cause excessively long queries. I’ve seen database sizes drop 90% with huge increases in performance.

Run the query below in phpmyadmin or from the command line and then optimize:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type="revision"

Talk to your web host, too. Maybe MySQL or your CPU is being throttled down.

Related Posts:

  1. Using wpdb to connect to a separate database
  2. How to fetch Data in WordPress using MySQLi or $wpdb
  3. wpdb->insert multiple record at once
  4. WordPress database scalability from the code perspective
  5. How to define composite keys with dbDelta()
  6. WordPress for a very large website
  7. Inserting Post Meta From SQL
  8. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  9. Why does dbDelta() not catch MysqlErrors?
  10. How to solve slow WordPress site caused by attachment_metadata
  11. What causes the “max_user_connections” warning on WordPress frontend?
  12. How to execute mulitple statement SQL queries using $wpdb->query?
  13. Which is more efficient? Using usermeta, or creating a new MySQL table?
  14. wpdb_prepare with multiple or condition
  15. WordPress database error – Error in SQL syntax – I can’t identify any error?
  16. Multiple wp_options tables to share content across installs
  17. Advanced SELECT query with condtional statements
  18. Improve performance by removing unnecessary database queries
  19. Redirecting to old domain after migration website
  20. Create table from array with prepare
  21. How to prevent/delay MySQL connections when an object cache is used?
  22. WordPress running SQL query to update database from form
  23. Have working sql query… trying to adjust it to use $wpdb
  24. Custom WordPress Table wpdb
  25. Best practice to limit results in get_row()?
  26. Trouble running $wpdb->query() with last_insert_id
  27. Query Column of Specific ID from Database Table
  28. How to create more than one new wpdb object?
  29. Optimizing function that automatically creates internal links based on post title string
  30. How to connect and insert data in database of wordpress?
  31. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  32. “BS_” rows in postmeta table
  33. Where is the HTML-handler part in the wpdb class?
  34. WordPress Database Query works in phpMyAdmin but not in the code
  35. insert data from a form:: Warning Empty query mysqli::query()
  36. How can I get $wpdb to show MySQL warnings?
  37. How To connect to the same WordPress database with different database user
  38. Mysql Queries per Visit – Crazy High
  39. using same mysql user with many databases
  40. Uploading to WordPress Database
  41. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  42. WPDB Insert or if exists Update
  43. get_results using wpdb
  44. $wpdb won’t insert NULL into table column
  45. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  46. WP_Options ID high
  47. WordPress database error: [Query was empty] [closed]
  48. Error establishing a database connection – with Debug Data
  49. Can I transfer a mysql database to another site?
  50. When and why should I use $wpdb different return types?
  51. Database with mixed collation (utf8mb4 & utf8_general_ci)
  52. How wordpress accesses its own database
  53. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  54. Is it safe to convert tables from MyISAM to InnoDB?
  55. Migrating database / content of non-CMS site to WordPress
  56. How to use a different database to list and manage comments in the backend
  57. Delete all post meta except featured image Using SQL
  58. How do I properly update the WordPress database password?
  59. Adding new row to wp_post table
  60. Show last modified date of database
  61. $wpdb->insert is not working
  62. WordPress Install and Database on separate hosting?
  63. Extracting the post_id via the wp_insert_post action (external db query)
  64. How do I get the posts within a certain year/date(with sql query)?
  65. Update from 4.5 to 4.6 failing
  66. fastest replacement DB
  67. Does auto_load to ‘no’ in wp_options improve performance
  68. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  69. Duplicated site isn’t recognized as a site
  70. Changing root password in PHPMyAdmin for WordPress Database when going live
  71. How to properly check if a table exists in WordPress Database using Show Tables Query
  72. creating new field on mysql
  73. $wpdb->query can’t insert data
  74. Problem migrating to localhost
  75. SQL query to set posts in bulk based on the post content
  76. How can I detect right db type?
  77. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  78. Second ezSQL initialization for MSSQL
  79. Fetch a single row from a custom table for to a given ID
  80. Database create or redirect
  81. Recovery – Restore Database after moving folder location locally
  82. Replacing javascript link in WordPress database without getting mysql syntax errors
  83. What is my error trying to create a new table in the database?
  84. Writing a function for WP Cron to run a SQL command daily
  85. Job and Employee Performance Tracking with Product Safety
  86. What structure and database storage method should I use for temporary storage that may be written concurrently?
  87. how to access 2nd Mysqli Database from different server for wordpress
  88. Using wpdb to connect to a different database is not working
  89. How to map data on CSV to web pages?
  90. Search and Replace in Windows XAMPP site
  91. About wp database hooks (error establishing connection)
  92. How to get specific table by current user login
  93. WordPress Database Posts Table query
  94. Should I Use only wpdb Class to Write Custom Queries?
  95. How to extract some part of WordPress full source code
  96. Why are my WordPress post queries so slow?
  97. MySQL database migration to WordPress
  98. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  99. PHP Warning: Error while sending QUERY packet
  100. WordPress database connection failed, while mysql client is working [closed]