maximum connection to mysql database

Expand Post »

Hi,

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

Thanks

Similar Threads

mySQL database on diffrent server in PHP
Need Help Downloading Files from MySQL Database in PHP
Mysql database backup and restore using mysql.data.client in C#
Newbie question: PHP form not writing to MySQL database in PHP
Create a Module Class that takes care of database connection (MYSQL) in Visual Basic 4 / 5 / 6

veledrom

Reputation Points: 38

Solved Threads: 0

Master Poster

Offline

724 posts
since Apr 2008

Permalink

Feb 9th, 2010

Re: maximum connection to mysql database

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

Reputation Points: 29

Solved Threads: 47

Posting Whiz

Offline

312 posts
since Dec 2007

Permalink

Feb 10th, 2010

Re: maximum connection to mysql database

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?

Last edited by veledrom; Feb 10th, 2010 at 11:42 am. Reason: .

veledrom

Reputation Points: 38

Solved Threads: 0

Master Poster

Offline

724 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Trouble displaying special characters

Next Thread in MySQL Forum Timeline: help with ERD

DaniWeb Message

Cancel Changes

User Name
Password