Too many connections
Recently I have started getting this database error email. It starts at 10:30PM and last about 20-30 minutes after which all is normal.
This is the first of the error:
Database error in vBulletin :
mysql_connect(): Too many connections
/hsphere/local/home/xxxxxxxx/forum.autocareforum.com/includes/class_core.php on line 311
The ip is from China 180.76.5.64
Night before last the host terminated service and this was one of the issues:
->Query summary
Time: 24% (3696 sec) Amount: 20% (31 queries) Rows Examined/Sent: 557 / 502 Avg. Query Exec/Lock Time: 119 / 43 sec.
Used databases: [pitzerw_vb]
Query example: use pitzerw_vb; SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','style cache','languagecache','products','pluginlist','cr on','profilefield','loadcache' ,'noticecache','bbcodecache');
|id table rows Extra
|1 datastore 15 Using where
They turned it back on 7 hours later and suggested that it was an optimization issue, so I ran repair and optimization and it said all was fine.
I am running 3.8.4 patch 2
Thanks
|