WP get stuck with a query on MySQL when the site is resumed

I had an issue similar to this with two separate machines (db and web). Calls from web server to the db server were taking an extraordinary amount of time and it turned out to be that MySQL was trying to do IP resolution on each call to it, causing a DNS lookup. Because the db server was internal and had no connection to the outside world, the lookup would eventually timeout.

I resolved the problem by adding the skip-name-resolve directive in the my.conf file on the db server.

Related Posts:

  1. MySQL SELECT increment counter
  2. Exclude Statement in SQL
  3. Detecting errors generated by $wpdb->get_results()
  4. wpdb update add current timestamp not working
  5. Displaying content from one WP site on separate WP site
  6. Lost the `wp_options` table: what’s the best way to restore the site?
  7. Performance Gains of Relational DB Setup
  8. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  9. what is the wp_5_posts table in the database?
  10. Migrating data between local and development server
  11. store simple data in get_option()
  12. How might I retrieve a featured post image from an external WP site and display it as a link back?
  13. What is the database table for pages?
  14. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  15. What are conventions about the schema of the $table_prefix
  16. WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
  17. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  18. Is deleting orphaned wp_options entries safe?
  19. How to build a movie database with wordpress?
  20. What’s the most efficient database method to add and query usermeta?
  21. How to solve slow WordPress site caused by attachment_metadata
  22. Is database safe after merging a branch of a more recent version over an older one?
  23. Hook to be used when creating a database table
  24. Delete all post meta except featured image
  25. Large database causes slow load
  26. Database slowdown after update to 3.4.1
  27. WooCommerce sku location in DB
  28. How to insert data into MySQL database from the form created in WordPress site
  29. Emoji support and MariaDB 10.0.30-
  30. Is it possible to store visitors IPs in wp_postmeta table?
  31. How do I copy a wordpress database?
  32. Export all content from wordpress
  33. Import live site to local setup without access to live site
  34. A field with dashes in the slug [closed]
  35. Creating a Video Content Page (how to use query strings in wordpress)- Help!
  36. Modify Database in Multi-Site wp_usermeta table
  37. Form Data not getting stored in WordPress database
  38. Hook directly into query execution
  39. Best way to tell if a user account is active, using the database only
  40. How to Mirror WordPress database from Remote server to Local server
  41. WordPress is not creating table in database after activating plugin,
  42. Is MariaDB’s Aria storage engine suitable for WordPress?
  43. How do I delete these post types in my WordPress database?
  44. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  45. How do I query wp_options for expired transient pairs with MySQL commands?
  46. data (html) migration to posts
  47. WordPress running SQL query to update database from form
  48. How to fix database error duplicate entry
  49. Use same database on main domain & sub domain
  50. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  51. WPDB SQL query with prepare() returning variable, not db value
  52. Why user_pass column in wp_users table is varchar(64)
  53. Why this query is not showing any result on wordpresss home page?
  54. How to migrate a database from a server to another
  55. How to display content from external db with relevant urls
  56. Reinstalling wordpress from database breaks the site
  57. how to count click tab menu and insert to database
  58. Adding prefix to WordPress database tables breaks admin capabilities?
  59. What is the best way to resurrect and update my old WordPress site?
  60. Trouble running $wpdb->query() with last_insert_id
  61. Using $wpdb | checking entered email against existing emails in db
  62. wp-cli: Error establishing a database connection: undefined constant DB_USER
  63. Add pdf to a website
  64. Can I customised default WP table
  65. Woocommerce – Check product stock availability from external database
  66. Get results from wordpress data custom table
  67. Outputting query results
  68. Help With a Large WordPress Based MySQL Database on Shared Hosting
  69. Database migration issues – Error #1046 No database selected
  70. Can two domains use the same database?
  71. Search Character Set Problem
  72. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  73. How to fix Uploaded to this post option to see group of images uploaded to a post?
  74. adding user_id and name to a separate table whenever a user register based on role
  75. How to access a table in a wordpress database using REST API?
  76. How do I loop/iterate through posts to edit all img tags?
  77. User saved through WordPress backend does not show up in database table users
  78. How to optimise this database query?
  79. How to retrieve user data based on role using SQL?
  80. Adding featured for post using database
  81. Missing latest posts and options after DB migration via phpMyAdmin
  82. get_the_terms is not working
  83. Store id from database query in cookie
  84. Split database on large site?
  85. Store the wordpress “featured image” under »wp_posts« Database table
  86. Return image urls with specific base string?
  87. What WordPress file is saving new users to database
  88. Restoring .sql backup results in “Error establishing a database connection”
  89. Link to handle $_GET request
  90. WordPress sync with phpbb
  91. “MySQL server has gone away” since update to 3.8
  92. Getting deleted users in database
  93. Options of accessing wordpress data from mobile app
  94. Getting data from a table using a query
  95. Database interaction (private-public) [closed]
  96. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  97. wp_usermeta key problem
  98. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  99. Database Queries are crashing the server
  100. Uploading to WordPress Database