Hang Up Followed By Can’t select database

Try a plugin like Query Monitor to see if there are queries or things you can identify quickly. A DB may need a log rotated or you could have some DEBUG process turned on that is logging. Backups running on your server will also have an impact. It’s something you’ll have to look into. Same with crons, virus scanners and any other bulk process.

If you have too many connections then you can create a DB bottleneck. Check your pages and process that you aren’t using an excessive amount of queries when they could be reduced. Also make sure to use functions that cache queries when possible.

Some good info at https://10up.github.io/Engineering-Best-Practices/php/#performance is worth looking into.

Also try connecting to your DB to see what is happening. Running EXPLAIN can tell you more about slow queries. https://dev.mysql.com/downloads/workbench/

Related Posts:

  1. Split WP install between 2 databases?
  2. What causes the “max_user_connections” warning on WordPress frontend?
  3. Error establishing a database connection – with Debug Data
  4. SQL Error wp_commentmeta – incorrect table definition
  5. Error establishing database connection – high traffic?
  6. Trouble Migrating all data blog from WordPress.com to WordPress.org
  7. How to fix database error duplicate entry
  8. Why does changing Database Table Prefixes result in loss of content?
  9. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  10. Error establishing a database connection – WordPress setup, everything else is working
  11. Restoring .sql backup results in “Error establishing a database connection”
  12. Print output of Table Creation
  13. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  14. MySQL SELECT increment counter
  15. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  16. Using wpdb to connect to a separate database
  17. Multiple developers / editors working on a site in progress
  18. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  19. Detecting errors generated by $wpdb->get_results()
  20. WordPress Database lost auto increment
  21. Restoring WordPress posts from database only
  22. Slow wp_term_relationships query
  23. How to use “TRUNCATE TABLE” MySQL statement?
  24. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  25. When importing database, it shows error
  26. WordPress for a very large website
  27. What are conventions about the schema of the $table_prefix
  28. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  29. Is deleting orphaned wp_options entries safe?
  30. How to solve slow WordPress site caused by attachment_metadata
  31. Strange Deadlock database error for the query “Delete From wp_options”
  32. Delete all post meta except featured image
  33. WordPress showing install screen after max_questions error
  34. WooCommerce – Query for ordered products
  35. Large database causes slow load
  36. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  37. Database slowdown after update to 3.4.1
  38. Query WordPress database by registered date and role
  39. Tons of Twitter rows in my database
  40. How to insert data into MySQL database from the form created in WordPress site
  41. Set Display Name to first and last name (phpmyadmin SQL Query)
  42. Why are no posts showing despite my apparently correct DB restoration?
  43. Select Multiple meta_value from WP DB; Single Query
  44. Which is more efficient? Using usermeta, or creating a new MySQL table?
  45. Is it possible to split database tables using HyperDB?
  46. What happens if I overwrite the current wp_options table with a backup from a week ago?
  47. WordPress database error – Error in SQL syntax – I can’t identify any error?
  48. CRUD operations using WordPress database API
  49. $wpdb doesn’t like to store arrays
  50. Handling large N data in WordPress
  51. How to Mirror WordPress database from Remote server to Local server
  52. Is MariaDB’s Aria storage engine suitable for WordPress?
  53. Catalina an MAMP Database Conenction Error
  54. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  55. A MySQL DB within a MySQL DB
  56. How do I query wp_options for expired transient pairs with MySQL commands?
  57. Is there a way to recover the table wp_term_relationships?
  58. “Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen? [closed]
  59. WordPress running SQL query to update database from form
  60. Migration: Copying database content to a different server
  61. What do these phpMyAdmin errors mean on my WordPress databaes?
  62. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  63. Moving to another server database connection error [closed]
  64. Remove empty rows from the database
  65. Custom WordPress Table wpdb
  66. Why this query is not showing any result on wordpresss home page?
  67. Best practice to limit results in get_row()?
  68. Global__r connection timed out
  69. Trouble running $wpdb->query() with last_insert_id
  70. how to encyrpt DB_PASSWORD in wp-config
  71. Moving WordPress site to new domain – database import [duplicate]
  72. Error code when migrate
  73. How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
  74. How can I find user role in Mysql?
  75. How to import products in host instead of database on wordpress?
  76. Having all “non-PHP” files on a different server
  77. Featured image from custom to WordPress database
  78. error establishing a database connection 3
  79. WordPress Database Query works in phpMyAdmin but not in the code
  80. “wordpress error in establishing database connection” and missing tables
  81. next comment id number wordpress
  82. Delete all users meta that named: user_avatar
  83. Merging development site with live site
  84. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  85. spambot registering without providing email or password, bypassing registration process
  86. Possible to restore wordpress database from mysql56 and sqlite files?
  87. Missing latest posts and options after DB migration via phpMyAdmin
  88. Catchable fatal error in formatting.php
  89. Check if a database is well installed
  90. live site do not update after importing sql database
  91. How do i get value from wp_postmeta?
  92. “MySQL server has gone away” since update to 3.8
  93. featured image not showing up with mysql_connect
  94. MySQL Database User: Which Privileges are needed?
  95. Import Excel (or csv) Table with user-data as subscribers to wordpress
  96. SQL query : Select a thumbnail for a media
  97. Server database problem
  98. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  99. Uploading to WordPress Database
  100. Have WordPress Use a Different Database for users