MySQL crashed because of the large number of requests

MySQL shouldn’t crash because of queries like those, but it could feel like it does because your site won’t work.

I’d first run

SELECT option_name, length(option_value) FROM wp_options WHERE autoload = 'yes' ORDER BY length(option_value) DESC;

to see if some option has accumulated a large value (I’ve seen wp-cron entries grow very large in one release ~2 years back).

Also check how many options will be automatically loaded:

SELECT count(*) FROM wp_options WHERE autoload = 'yes';

Those are usually a few hundred, if it’s a very large number, investigate further.

If both these queries don’t show anything weird, you may want to look into MySQL itself. Is the RAM on your machine exhausted and (slow) SWAP is being used? Is there a faulty hard disk and re-reads are timing out?

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. String concatenation in MySQL
  5. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  6. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  9. When to use SELECT … FOR UPDATE?
  10. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  11. 1052: Column ‘id’ in field list is ambiguous
  12. Escape string Python for MySQL
  13. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  14. Search for all occurrences of a string in a mysql database
  15. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  16. SQL ZOO List each continent and the name of the country that comes first alphabetically
  17. How to convert a string to date in MySQL?
  18. MySQL COUNT DISTINCT
  19. How to update a record using sequelize for node?
  20. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  21. Convert MySQL to SQlite [closed]
  22. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  23. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  24. Convert partially non-numeric text into number in MySQL query
  25. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  26. MySQL: What’s the difference between float and double?
  27. How can I search (case-insensitive) in a column using LIKE wildcard?
  28. MySQL Select Multiple VALUES
  29. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  30. How to unblock with mysqladmin flush hosts
  31. If variable equals value php [duplicate]
  32. Node.js MySQL – Error: connect ECONNREFUSED
  33. Solution to “subquery returns more than 1 row” error
  34. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  35. How To have Dynamic SQL in MySQL Stored Procedure
  36. MySQL – UPDATE query with LIMIT
  37. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  38. What SQL Query to do a simple find and replace
  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. Search and replace in post content
  47. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  48. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  49. wpdb insert and boolean fields
  50. Join new table with SQL query
  51. Why doesn’t this code add a table to my database?
  52. SQL database export-import
  53. Select multiple wp_postmeta keys with single select
  54. Can Someone Help Me Fix This WordPress Missing Argument Error?
  55. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  56. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  57. SQL Database, repeated tables?
  58. Backing up and restoring multiple sites efficiently
  59. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  60. Code to remove authors with no posts connected to them
  61. SQL Query in WordPress – Getting Impossible WHERE error
  62. Are these WordPress tables safe to add indexes to?
  63. WordPress create database not working
  64. database optimization and server errors
  65. Locally restoring a ManageWP full site backup
  66. WordPress doesn’t save changes some times
  67. Setting up WordPress Locally on WAMP for a new site (with one already)
  68. Custom SELECT Query not returning the_title and the_permalink
  69. Calling mysql_query() on another database, assumes WordPress using that database
  70. WordPress VIP realpath Alternative?
  71. querying user bookmarks from a large number of bookmarks
  72. Pull post name from value of a specific meta key
  73. PHP variables in mysql query
  74. How to fix the amount of comments displayed for each post?
  75. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  76. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  77. How to simulate web traffic to test performance of a website
  78. SQL query to change custom field in WordPress database
  79. SQL. Select category descendants
  80. MySQL Actibity without any active visitors via Google Analytics
  81. How to configure WordPress Database for CentOS 7
  82. Why is local wordpress install calling live site executions?
  83. Display MySQL as part of a Page
  84. SELECT statement wrong?
  85. mysql query on wp_user and user_meta problem
  86. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  87. WP Meta Query – mixed AND / OR query doesn’t work
  88. How to Import Multiple Values in custom field
  89. Second completely independent and disposable WordPress installation in subdirectory?
  90. get_results suddenly not working on a single table
  91. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  92. Query sql for truncate post_content in wp_posts table
  93. Foreach only outputs if id is 0
  94. SQL – Pull products of particular category from a remote WordPress woocommerce db
  95. Efficiently loop over huge number of posts
  96. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?
tech