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


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.

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.