Hi,
How do I change maximum connection to mysql database and maximim user connection to mysql?
Thanks
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?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.