MySQL Sandbox

too many connections with sandbox

Asked by marc

im having a problem with a website thats just happen since using sandbox on it.

it comes back with an error ERROR 1040 (00000): Too many connections and when i try to log in via the terminal it has the same error even as the master user. i think restarting it would fix the problem temporally but i can log on to restart it using this methord # mysql -u root -password -S /tmp/mysql_sandbox5131.sock, Is there a way to restart mysql sandbox or close all connections without connecting!? (as i can't connect :) ) or backup the database. thanks for any help

marc

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Sandbox Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#1

Hi,
I hope you are not using the sandbox in production, as it was not designed for that purpose.
Anyway, the "too many connections" problem would happen with any installation,normal or sandbozed, and it usually depends on the application.
To fix the problem, do the following:
1) shut down the application that is sending connections;
2) on the command line, cd to the sandbox directory
3) find a .pid file in the data directory, and look inside. It contains the ProcessID of the server
4) run the command "kill ProcessID" where ProcessID is the number you got from the previous step.

If that doesn't kill the server, you have two options:
* wait until the connections timeout
* run the ./send_kill script, but be aware that this script will eventually kill the server by force, and you may end up with corrupted data.

Can you help with this problem?

Provide an answer of your own, or ask marc for more information if necessary.

To post a message you must log in.