How do I increase the number of connections available on MySQL Server?
By default, when you install MySQL Server, you can have up to 100 simultaneous connections to the MySQL Server. For each person logged into the report writing program, you will use 5 connections. This means you can have up 20 users using the report writing program at the same time. If you wanted to have 60 people using the report writing program all at the same time, you will have to increase the number of simultaneous connections allowed by MySQL Server by editing the “C:\Windows\my.ini” file on the computer running your MySQL Server. If you open the “my.ini” file using a text editor, you will need to add the line “max_connections=300” to increase the number of simultaneous connections to 300. You will want to put this line of text under the [mysqld] section of the “my.ini” file. The [mysqld] section of Your “my.ini” file should look something like this after you add the “max_connections=300” line. [mysqld] basedir=C:/mysql #bind-address=192.168.1.92 datadir=C:/mysql/data #language=C:
Related Questions
- Where do I make changes on the webserver to increase the number of servlet sessions that are simultaneously allowed on the server?
- Does the X Server use too much RAM, and should that RAM usage dramatically increase during an X session?
- How do I increase the number of connections available on MySQL Server?
