Many slow queries post_type = ‘attachment’;

This is bug #31071: media / post_mime_type related queries are very slow on larger sites. It should have been fixed for version 4.8 now.

You can try it on a test site that is a mirror of your production site. There are some very interesting ideas in that bug discussion. See if you can use some of them right now already, like adding an index.

Related Posts:

  1. How to get Attachments(image) with specific width\height ratio
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  5. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  6. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  7. SQL – Update multiple records in one query
  8. When to use SELECT … FOR UPDATE?
  9. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  10. Database sharding vs partitioning
  11. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  12. Search for all occurrences of a string in a mysql database
  13. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  14. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  15. How to convert a string to date in MySQL?
  16. MySQL COUNT DISTINCT
  17. How to update a record using sequelize for node?
  18. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  19. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  20. Convert MySQL to SQlite [closed]
  21. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  22. Convert partially non-numeric text into number in MySQL query
  23. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  24. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  25. MySQL: What’s the difference between float and double?
  26. How can I search (case-insensitive) in a column using LIKE wildcard?
  27. MySQL Select Multiple VALUES
  28. How to do a batch insert in MySQL
  29. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  30. How to unblock with mysqladmin flush hosts
  31. Node.js MySQL – Error: connect ECONNREFUSED
  32. Solution to “subquery returns more than 1 row” error
  33. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  34. How To have Dynamic SQL in MySQL Stored Procedure
  35. MySQL – UPDATE query with LIMIT
  36. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  37. What SQL Query to do a simple find and replace
  38. WordPress mysqli and PDO
  39. Scanning Database for malicious Data
  40. how to refresh wordpress permalink settings? (without admin panel)
  41. Ordering posts by day (not time) AND meta value
  42. wpdb->prepare function remove single quote for %s in SQL statment
  43. Problems with DBDelta with FOREIGN key?
  44. Is it useful to turn on MySQL query cache for performance
  45. Programmatically changing role information; editing role name and deleting
  46. Same option_id=0 for 2 options in wp_options?
  47. Check if image exists before uploading with media_sideload_image()
  48. How to let a user choose an authors and save it to the database?
  49. Search and replace in post content
  50. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  51. wpdb insert and boolean fields
  52. MySQL crashed because of the large number of requests
  53. What are the issues associated with upgrading MySQL for WordPress?
  54. How to find meta entries with their posts missing via SQL?
  55. Mysql SELECT posts
  56. SQL Database, repeated tables?
  57. #1115 – Unknown character set: ‘utf8mb4’
  58. How to add a private user page populated from sql?
  59. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  60. Code to remove authors with no posts connected to them
  61. SQL Query in WordPress – Getting Impossible WHERE error
  62. WordPress create database not working
  63. Import CSV to MySQL, with custom registration field information
  64. database optimization and server errors
  65. Update Custom Post Type Taxonomies with SQL
  66. Setting up WordPress Locally on WAMP for a new site (with one already)
  67. Calling mysql_query() on another database, assumes WordPress using that database
  68. WordPress VIP realpath Alternative?
  69. querying user bookmarks from a large number of bookmarks
  70. Pull post name from value of a specific meta key
  71. PHP variables in mysql query
  72. How to fix the amount of comments displayed for each post?
  73. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  74. Lock wait timeout exceeded; try restarting transaction
  75. How to simulate web traffic to test performance of a website
  76. SQL query to change custom field in WordPress database
  77. SQL. Select category descendants
  78. What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
  79. MySQL Actibity without any active visitors via Google Analytics
  80. How to configure WordPress Database for CentOS 7
  81. Why is local wordpress install calling live site executions?
  82. Add row to SQL array
  83. Display MySQL as part of a Page
  84. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  85. Use custom query if main search query returns zero results in wordpress
  86. WP Meta Query – mixed AND / OR query doesn’t work
  87. Can I use mysql queries to replace query_posts()?
  88. Second completely independent and disposable WordPress installation in subdirectory?
  89. get_results suddenly not working on a single table
  90. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  91. Query sql for truncate post_content in wp_posts table
  92. How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
  93. Foreach only outputs if id is 0
  94. Using queries in and i see 7000+queries?
  95. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  96. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  97. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  98. How do I load a sql.gz file to my database? (importing)
  99. How to find source of these strange SQL queries?
  100. Batch Replace URLs in WordPress Database