Slow Mysql Queries

WP options (which is one of the most basic and used storage APIs) can be stored with or without “autoload” setting. Usually this is reasonable, since many options will be checked on each and every page load, so loading them in bulk during core load is much more efficient than individually.

Problems usually start when two problems compound:

  1. the total amount of options gets significantly large (let’s say hundreds of thousands, but it depends);
  2. large amount and/or size of options are marked for autoload which shouldn’t be.

There is no generic solution to this issue, since there is no generic common cause.

You would need to examine your actual data to see which options get loaded and what exactly happens to be a bottleneck.

Related Posts:

  1. How can I find the source of slow queries in WordPress?
  2. WordPress MySQL & PHP Performance
  3. Is it useful to turn on MySQL query cache for performance
  4. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  5. Concurrent / simultaneous MySQL connections
  6. Best settings for MySQL to speed up site? [closed]
  7. How do I join a $wpdb query with user meta using default value if not exist?
  8. Alter wp_post table vs. post_meta performance/speed
  9. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  10. WordPress plugin overloading with tmp tables
  11. How to simulate web traffic to test performance of a website
  12. Regular XML-RPC timeouts
  13. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  14. Cannot add or update a child row: a foreign key constraint fails
  15. Cannot delete or update a parent row: a foreign key constraint fails
  16. Cannot delete or update a parent row: a foreign key constraint fails
  17. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  18. Rename a column in MySQL
  19. Not unique table/alias
  20. Install mysql-python (Windows)
  21. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  22. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  23. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  24. Disable ONLY_FULL_GROUP_BY
  25. MySQL WHERE IN ()
  26. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  27. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  28. difference between primary key and unique key
  29. grabbing first row in a mysql query only
  30. How to export a mysql database using Command Prompt?
  31. MySQL Error #1133 – Can’t find any matching row in the user table
  32. How can I prevent SQL injection in PHP?
  33. Best way to store an array in MySQL database?
  34. MySQL date formats – difficulty Inserting a date
  35. How to grant remote access permissions to mysql server for user?
  36. How to check if mysql database exists
  37. #1062 – Duplicate entry for key ‘PRIMARY’
  38. How can I convert a string to a float in mysql?
  39. Is there a Profiler equivalent for MySql?
  40. How to use greater than operator with date?
  41. Drop all databases in MySQL
  42. How to get the count of each distinct value in a column?
  43. How to replace the domain name in a WordPress database?
  44. WordPress database scalability from the code perspective
  45. Optimize WordPress Query that take 5 seconds to execute
  46. MySQL Replication Latency Issues in wp-admin pages
  47. Increment value (value = value+1) of $wpdb->update
  48. How can I debug my database connection for unit testing?
  49. Extending the database
  50. SQL query not working in alphabetical post title/content search
  51. Changing BIGINT to INT
  52. Importing MariaDB into Mysql in WordPress
  53. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  54. Keeping database within limits, please help!
  55. HTML Entities in Post Title
  56. Can’t find my wordpress DB in phpmyadmin
  57. Deprecated: mysql_connect():
  58. MySQL Rank & $wpdb
  59. Improve performance by removing unnecessary database queries
  60. $wpdb select all meta for each post
  61. Calculate average crossing post categories
  62. Replacing link URL ending strings via MySQL
  63. Many slow queries post_type = ‘attachment’;
  64. SQL command to convert all tags in lowercase?
  65. Problem with admin login after deployment
  66. Find out how many times the user has logged in
  67. WordPress(wpdb class) and mysql stored procedures
  68. Is it possible to create a WordPress table using array and loop?
  69. Can’t run database query
  70. How to stop $wpdb from prepending database name
  71. Match tag names with form titles
  72. Error missing MySQL extension
  73. Getting Error Trying to Create Table
  74. Best approach for a custom database filling in WP custom post types
  75. Why doesn’t custom mysql query return results? Is syntax correct?
  76. Insert two row in wordpress database
  77. SQL statement using placeholder is not returning results
  78. How to Bulk find and replace MySQL for post image url
  79. Wpdb query with dynamic table name
  80. update multiple rows in mysqli table base on two values
  81. Extract all users along with yoast metadata description
  82. How can I verify WordPress nonce from the following code?
  83. Deleting a table row through query
  84. How to write in MySQL more characters in user_nicename
  85. $wpdb->get_var not returning count
  86. Custom user query – orderby meta_key (that may not exist)
  87. Weird characters displayed when importing WordPress MySQL db
  88. How to get Attachments(image) with specific width\height ratio
  89. What is the cron doing?
  90. Apache Redirect based on WordPress permissions
  91. SQL error on restoring database
  92. MySQL database gives blank page (white screen of death)
  93. Datatabase error: Commands out of sync
  94. why is $wpdb->update() causing a DB error from within wp_set_password()
  95. Global MySQL replacing of text patterns/matches
  96. remove wordpress post links
  97. SQL get last entry of a specific gravity form
  98. mysqldump to a tar.gz
  99. Where is my mysql log on OS X?
  100. Can running a WP-Cron to update_post_meta cause performance issues?