We run a high traffic blog with around 500 real-time users and 10000 posts. We are hosted by self on VPS - 16gb, 4 core with separate mysql DB server - 4gb, 2 core; both SSD. No problem with hosting server But the database server at times running out of connections, though we have more than sufficient 312 max cconnections ceiling. We don't have any stray plugins and our maximum execution time is around 5 minutes. Anyone have any idea regarding what might be causing the issue. peaks the maximum 312 connection-db Database connections - peaks at working hours

More insights: What we could correlate is that the days when our bloggers (max 10) work from our office under a single IP and slow -interrupted network connection this issue happens to be more frequent. The issue is more frequent at peak publishing hours than during idle hours.

Or is the database server running out of ram which is eventually causing the connections blackout. Search engine crawls usually drink more Cpu but the bots don't establish more than 30 db connections and our servers are totally fine handling the bots.

Also prevelant when a single admin keep the posts in edit mode for long periods of time

wp config details

'WP_MEMORY_LIMIT', '256M; 'AUTOSAVE_INTERVAL', 160; max_execution time 500

Our query monitor has some PHP 7.2 depreciation warnings though the theme is stable with some slow queries, also posts revisions are vital for us.

  • Additional information request. Post on pastebin.com and share the links. A) complete (not edited) my.cnf or my.ini Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server connection limit tuning analysis. – Wilson Hauck Mar 4 at 23:14
  • Please post the data from your MySQL hosting server for suggestions to improve efficiency. – Wilson Hauck Mar 17 at 20:44
  • Thanks for your concern, we now upgraded mysql to 4 core 16GB; the problem seems to be persistant, from what we could diagnose is that the hosting apache server first hits an abnormal ram consumption (possibly due to memory leak), or can the problem be attributed to bad bots. – edtamil Mar 18 at 11:58
  • We are trying to get clearance from the company end to retrive and post the informations you've requested. Thanks for your interest in this – edtamil Mar 18 at 11:59
  • Looking forward to your posts to allow specific custom suggestions and questions once the data is available from the MySQL hosting server. After comment to @wilsonhauck letting me know data is available, please allow 48 hours for analysis to prepare suggestions/questions. – Wilson Hauck Mar 24 at 0:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.