Concurrent / simultaneous MySQL connections

IMHO that would depend on the hosting company and what resources you are limited to.

Let’s say you pick Amazon’s MySQL RDS. There are seven server models permitted. Each model allows a maximum value for the number of connections.

I wrote a post about this last month in the DBA StackExchanage : Should I increase max_connections in AWS RDS t1-micro for MySQL?. Here is a chart from my post:

MODEL      max_connections innodb_buffer_pool_size
---------  --------------- -----------------------
t1.micro   34                326107136 (  311M)
m1-small   125              1179648000 ( 1125M,  1.097G)
m1-large   623              5882511360 ( 5610M,  5.479G)
m1-xlarge  1263            11922309120 (11370M, 11.103G)
m2-xlarge  1441            13605273600 (12975M, 12.671G)
m2-2xlarge 2900            27367833600 (26100M, 25.488G)
m2-4xlarge 5816            54892953600 (52350M, 51.123G)

Although you can pay for more IOPs per server model, this does not help with connections. You are pretty much locked in with the given numbers for max_connections.

If you do not like where MySQL RDS locks you in, then you could switch to Amazon EC2. See my post Too Many database connections on Amazon RDS where I recommend switching to Amazon EC2 to have far more indepedence and responsibility for tuning MySQL for Connections, Memory, Disk, and so forth.

Of course, the pricing for Amazon may shy you away from RDS and EC2. This example shows you basically two principles:

  • Live with Hosting Restrictions
  • Find a Hosting Company that can do one of the following:
    • Accommodate you with Connection tuning for WordPress
    • Allow you some latitude in doing your own tuning

Although a mitigating factor, budget concerns are beyond the scope this answer.

Related Posts:

  1. How to run WordPress across 2 VMs for high availability
  2. How can I find the source of slow queries in WordPress?
  3. WordPress MySQL & PHP Performance
  4. Is it useful to turn on MySQL query cache for performance
  5. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  6. Slow Mysql Queries
  7. Best settings for MySQL to speed up site? [closed]
  8. How do I join a $wpdb query with user meta using default value if not exist?
  9. Alter wp_post table vs. post_meta performance/speed
  10. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  11. WordPress plugin overloading with tmp tables
  12. How to simulate web traffic to test performance of a website
  13. Regular XML-RPC timeouts
  14. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  15. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  16. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  17. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  18. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  19. When to use SELECT … FOR UPDATE?
  20. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  21. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  22. Search for all occurrences of a string in a mysql database
  23. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  24. How to convert a string to date in MySQL?
  25. MySQL COUNT DISTINCT
  26. How to update a record using sequelize for node?
  27. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  28. Convert MySQL to SQlite [closed]
  29. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  30. Convert partially non-numeric text into number in MySQL query
  31. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  32. MySQL: What’s the difference between float and double?
  33. How can I search (case-insensitive) in a column using LIKE wildcard?
  34. MySQL Select Multiple VALUES
  35. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  36. How to unblock with mysqladmin flush hosts
  37. Node.js MySQL – Error: connect ECONNREFUSED
  38. Solution to “subquery returns more than 1 row” error
  39. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  40. How To have Dynamic SQL in MySQL Stored Procedure
  41. MySQL – UPDATE query with LIMIT
  42. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  43. What SQL Query to do a simple find and replace
  44. Scanning Database for malicious Data
  45. how to refresh wordpress permalink settings? (without admin panel)
  46. Ordering posts by day (not time) AND meta value
  47. wpdb->prepare function remove single quote for %s in SQL statment
  48. Problems with DBDelta with FOREIGN key?
  49. Programmatically changing role information; editing role name and deleting
  50. Search and replace in post content
  51. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  52. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  53. Mysql / WordPress killing my server with 80k users [closed]
  54. Performance issues with large website [closed]
  55. Join new table with SQL query
  56. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  57. Improve wp query perfomance on large db
  58. MySQL crashed because of the large number of requests
  59. Why doesn’t this code add a table to my database?
  60. SQL database export-import
  61. Can Someone Help Me Fix This WordPress Missing Argument Error?
  62. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  63. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  64. SQL Database, repeated tables?
  65. Backing up and restoring multiple sites efficiently
  66. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  67. Code to remove authors with no posts connected to them
  68. SQL Query in WordPress – Getting Impossible WHERE error
  69. WordPress create database not working
  70. database optimization and server errors
  71. Setting up WordPress Locally on WAMP for a new site (with one already)
  72. Calling mysql_query() on another database, assumes WordPress using that database
  73. WordPress VIP realpath Alternative?
  74. querying user bookmarks from a large number of bookmarks
  75. Pull post name from value of a specific meta key
  76. PHP variables in mysql query
  77. How to fix the amount of comments displayed for each post?
  78. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  79. SQL query to change custom field in WordPress database
  80. SQL. Select category descendants
  81. How can I figure out what is making my WordPress site so slow?
  82. MySQL Actibity without any active visitors via Google Analytics
  83. Why is this function so slow?
  84. How to configure WordPress Database for CentOS 7
  85. Why is local wordpress install calling live site executions?
  86. Display MySQL as part of a Page
  87. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  88. WP Meta Query – mixed AND / OR query doesn’t work
  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. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  95. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  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?