Database connection error with high concurrent users

A little extra info – this site has a few thousand posts. Also, the test I did without plugins was with the plugins disabled. I’ll run a test on a bare install of WP in the morning to see how that does.

Hi,

You will need to tweak MySQL server settings so that it can accommodate more concurrent users. MySQL connection rates can be improved by either adjusting MySQL settings, or providing more memory and processing power to the overworked server. Query caching and proper indexing can also help to improve MySQL performance. Refer following guides to tweak MySQL server for big number of concurrent connections.

https://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/

https://codex.www.ads-software.com/High_Traffic_Tips_For_WordPress

Thanks,

I used the Percona tool for my.cnf config but the performance doesn’t appear to be improved. I was able to crash the server with a load test on a fresh install of WP so that at least reasonably rules out an issue with the install.

Mysql is still maxed at 200mb of memory usage, shouldn’t that be changing? The database size is around 100mb.

This is what I used in the config file: https://pastebin.com/h0Q2TCTG

Mysql is still maxed at 200mb of memory usage

you can try bumping it to 2gb or something and then test it. also i wasnt able to acess New relic Screenshots

Sorry, there was a blank page in the notebook. View with this link.

How would I bump up the memory to 2gb? The generated config file from the Percona tool should have increased it past 200mb but it appears to have not.

this article has some good points beside links posted by accuwebshotsing above

https://www.ewhathow.com/2013/09/how-to-increase-mysql-memory-limit/ experiemnt with them and select the one’s which works best for your website

also your relic screenshot doesnt display much load. CPU was 50% at 100 concurrent users and RAM wasnt’used much either.