How to set max connections in mysql?
First we want to enter into the Mysql command line prompt by giving the Password
MySQL> Enter the password : xxxxxxx
To know how many connections are in the database
MySQL> show variables like "max_connections";
It will list out the output as
Variable Name Value
max_connections 100
Default value for the max_connections is 100.
If we want to increase the max connections then we wan to give
Set global max_connections = "our value" [our value refers= 200,300,500 etc...]
It will affect immediately. and it will again remain to max_connections as 100 when the mysql server restarts.
For that we want to change the
My.conf[for linux OS] or My.ini file [for windows OS]
Thanks for viewing our post..
MySQL> Enter the password : xxxxxxx
To know how many connections are in the database
MySQL> show variables like "max_connections";
It will list out the output as
Variable Name Value
max_connections 100
Default value for the max_connections is 100.
If we want to increase the max connections then we wan to give
Set global max_connections = "our value" [our value refers= 200,300,500 etc...]
It will affect immediately. and it will again remain to max_connections as 100 when the mysql server restarts.
For that we want to change the
My.conf[for linux OS] or My.ini file [for windows OS]
Thanks for viewing our post..
Comments
Post a Comment