I read that Bluehost limits the number of database connections from one user to 15. I believe my webapp is using up all those connections. Whenever I try to use the cake console to access the database, I get the following error:
2011-11-29 05:06:58 Warning: Warning (2): mysql_connect() [function.mysql-connect]: User myusername already has more than 'max_user_connections' active connections in [/home2/myusername/public_html/myapp/cake/libs/model/datasources/dbo/dbo_mysql.php, line 561]
How can I make sure there are connections for the cake console to use?
Edit:
Just to be clear, my app is not running out of connections. However, every time I try to access the database from the cake console I get that error. This leads me to believe that cake is creating and holding onto the connections for some reason.
If you have the root user account (or with super privileges),
you can change cli script to connect using root,
as root connection even the max connection is reached (max + 1)
You can make use of php_sapi_name to distinguish between normal web access or via console.
I don't think max connection is capped at 15,
if so you should consider another hosting company other than bluehost (because is suck) ...
To verify this, issue a SQL like :-
show variables like "max%";