I am currently receiving hundreds of MySQL ‘mysql_connect(): Too many connections’ errors each day.
I have emailed my hosting provider requesting that the MySQL max_connections setting be increased from it’s current setting of 70 and they have come back to me blaming the errors on the size of my board and the fact that I have over 73k posts in one forum room as this has a negative impact on indexing. Their suggestion is that I split the largest room into two or more, which something I do not really want to do.
The research I have done suggests not only that my forum is not overly big nor that these too things are in any way linked. Could I please request that anyone from vBulletin reading this clarifies this issue. I just want the errors to stop and to be able to provide a better service to my userbase.
My board typically has 120-160 people logged on at any given time.
Thank you very much for your time.
Tony.
I have emailed my hosting provider requesting that the MySQL max_connections setting be increased from it’s current setting of 70 and they have come back to me blaming the errors on the size of my board and the fact that I have over 73k posts in one forum room as this has a negative impact on indexing. Their suggestion is that I split the largest room into two or more, which something I do not really want to do.
The research I have done suggests not only that my forum is not overly big nor that these too things are in any way linked. Could I please request that anyone from vBulletin reading this clarifies this issue. I just want the errors to stop and to be able to provide a better service to my userbase.
My board typically has 120-160 people logged on at any given time.
Thank you very much for your time.
Tony.
Comment