Bug #3869 | MYSQL database server shuts down after using system for few hours. | ||
---|---|---|---|
Submitted: | 24 May 2004 5:12 | Modified: | 24 Jun 2004 7:24 |
Reporter: | Mohammad NULL ! | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.0.18 | OS: | Windows (Windows Server 2003) |
Assigned to: | CPU Architecture: | Any |
[24 May 2004 5:12]
Mohammad NULL !
[24 May 2004 5:34]
MySQL Verification Team
You need to provide more information for us to try to repeat your bug report. Like a repeatable test case. Thanks.
[24 May 2004 5:58]
Mohammad NULL !
It seems when number of application connections increases database server Could not create connection. Issue is sporadic. When client uses application 5 to 6 hours it shurs down server. It is OK if server slows down with increase number of connections but shutting down is frustating my clients. Here is error message when accessing jboss appication. HTTP ERROR: 500 SQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?)) RequestURI=/jrt/index.jsp
[24 May 2004 6:20]
MySQL Verification Team
I assume that you have configured adequately the below server configuration key for your system needs: C:\mysql\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.18-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like "%max_connection%"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 100 | +-----------------+-------+ 1 row in set (0.00 sec) the above is the default value. also please read the below MS's support articles and search for another related ones: ttp://support.microsoft.com/default.aspx?scid=kb;en-us;196271
[24 May 2004 7:08]
Mohammad NULL !
Default is set to 100. I think default 100 is too low for application we are using.I want to change server variable "max_connections" to 500. I have used this command Set global max_connections =500. It sets server variable to 500 but when I restarts MYSQL Server it resets back to 100. is there way I can permanently change server variable?
[24 May 2004 7:24]
MySQL Verification Team
You only need to add the below to the [mysqld] section in your my.ini or my.cnf configuration file: [mysqld] max-connections=500 .... C:\mysql\bin>mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.18-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like "%max_connection%"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 500 | +-----------------+-------+ 1 row in set (0.00 sec)
[14 Feb 2005 22:54]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".