I've had vBulletin running for several years now, but only recently (the past few weeks) I've been inundated with these error messages. These vBulletin error messages are flooding my inbox. I have asked the hosting company to increase the number of connections but they will not do this.
-----------------------------------------------------------------------
Database error in vBulletin :
mysql_connect(): User dbo67339750 has already more than 'max_user_connections' active connections
/homepages/34/d66110281/htdocs/forum/includes/class_core.php on line 279
MySQL Error :
Error Number :
Date : Saturday, June 17th 2006 @ 01:13:15 PM
Script : http://www.anchorbay.co.uk/forum/showthread.php?p=72072
Referrer :
IP Address : 66.249.66.98
Username :
Classname : vb_database
-----------------------------------------------------------------------
Here's the reply from the hosting company (One & One, Professional package):
-----------------------------------------------------------------------
Question Is there a limit on concurrent MySQL server connections from a Linux Shared package?
Answer Yes, there is a limit. Not more than 18 connections are allowed at the same time.
You can also check this settings in the mysql session as well.
mysql> SHOW VARIABLES;
and should see a long output like this:
| max_user_connections
18
| max_tmp_tables | 32
| transaction_alloc_block_size
|8192
|| transaction_prealloc_size |
4096
|| version |
4.0.25-standard-log
|| version_comment | Official MySQL
RPM
|
| version_compile_os |
pc-linux-gnu
|| wait_timeout | 3
Below is the link for detailed explanation of each settings:
Have a nice day.
------------------------------------------------------------------------------------------
and:
------------------------------------------------------------------------------------------
Unfortunately, we cannot increase the number of database connections.
Please check some notes on our Frequently Asked Questions article regarding this issue for your possible workaround.
What are the differences between MSSEE and MSDE?
MSSEE is an improvement on MSDE (Microsoft SQL Desktop Engine).
The changes are:
* MSSEE removes the maximum 4 simultaneous database connections limits
that was present in MSDE.
* The maximum database size has been increased to 4GB.
* A GUI now helps to administrate the Microsoft SQL Server 2005 Express Edition. The old MSDE only provided a limited webbased user interface or 3rd party products with extra costs.
If you have any further questions please do not hesitate to contact us.
------------------------------------------------------------------------------------------
I have no idea what their replies mean to be honest.
So... what can I do to fix this? It's causing no end of headaches for me.
-----------------------------------------------------------------------
Database error in vBulletin :
mysql_connect(): User dbo67339750 has already more than 'max_user_connections' active connections
/homepages/34/d66110281/htdocs/forum/includes/class_core.php on line 279
MySQL Error :
Error Number :
Date : Saturday, June 17th 2006 @ 01:13:15 PM
Script : http://www.anchorbay.co.uk/forum/showthread.php?p=72072
Referrer :
IP Address : 66.249.66.98
Username :
Classname : vb_database
-----------------------------------------------------------------------
Here's the reply from the hosting company (One & One, Professional package):
-----------------------------------------------------------------------
Question Is there a limit on concurrent MySQL server connections from a Linux Shared package?
Answer Yes, there is a limit. Not more than 18 connections are allowed at the same time.
You can also check this settings in the mysql session as well.
mysql> SHOW VARIABLES;
and should see a long output like this:
| max_user_connections
18
| max_tmp_tables | 32
| transaction_alloc_block_size
|8192
|| transaction_prealloc_size |
4096
|| version |
4.0.25-standard-log
|| version_comment | Official MySQL
RPM
|
| version_compile_os |
pc-linux-gnu
|| wait_timeout | 3
Below is the link for detailed explanation of each settings:
Have a nice day.
------------------------------------------------------------------------------------------
and:
------------------------------------------------------------------------------------------
Unfortunately, we cannot increase the number of database connections.
Please check some notes on our Frequently Asked Questions article regarding this issue for your possible workaround.
What are the differences between MSSEE and MSDE?
MSSEE is an improvement on MSDE (Microsoft SQL Desktop Engine).
The changes are:
* MSSEE removes the maximum 4 simultaneous database connections limits
that was present in MSDE.
* The maximum database size has been increased to 4GB.
* A GUI now helps to administrate the Microsoft SQL Server 2005 Express Edition. The old MSDE only provided a limited webbased user interface or 3rd party products with extra costs.
If you have any further questions please do not hesitate to contact us.
------------------------------------------------------------------------------------------
I have no idea what their replies mean to be honest.
So... what can I do to fix this? It's causing no end of headaches for me.
Comment