954,174 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

maximum connection to mysql database

Hi,

How do I change maximum connection to mysql database and maximim user connection to mysql?

Thanks

veledrom
Master Poster
754 posts since Apr 2008
Reputation Points: 42
Solved Threads: 0
 

You can set these limitation by changing server system variables in MySQL configuration (my.cnf) file
max_connections for maximum connections to MySQL.
max_user_connections for per user connection.

mwasif
Posting Whiz
315 posts since Dec 2007
Reputation Points: 29
Solved Threads: 48
 

There will be 4000 user will connect to my MySQL database through PHP web form. Probably 2000 will be concurrently.

Now what do I change in my system or MySQL to prevent connection problems?

Also, what do you suggest me to do to serve such amount of people at a time?

veledrom
Master Poster
754 posts since Apr 2008
Reputation Points: 42
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You