Member Avatar for veledrom

Hi,

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

Thanks

  • 2 Contributors
  • 2 Replies
  • 80 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by veledrom

Recommended Answers

All 2 Replies

Member Avatar for mwasif

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.

Member Avatar for veledrom

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?

Edited by veledrom because: .
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.