count of db connections exceeded

Tags:
AWS RDS
DB Connections
when the no of users are increased, my application raising an issue count of db connections are exceeded, unable to connect to database. mysqli_specialchars() function issue raising. my allication is in aws server. how can i come out from this issue
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Approximate how many users are connected to this database? What type of OS like all users have same operating system or there are mixed OS? Is your application customized/ house made?
    139,010 pointsBadges:
    report
  • ToddN2000
    I'd check to see if there are any connections that may have not terminated correctly. You may need to set a timeout parameter to end broken / dropped connections. How man connections are currently active? Does that seem like a valid number or higher than normal? If this is a new issue, what has changed recently any hardware or software? 
    132,840 pointsBadges:
    report
  • Subhendu Sen

    Try this one, for permanent changes add this line in my.cnf & then restart MySQL:

    max_connections = 50 (or what the number you have to require)

    For more concepts, please link here, https://dev.mysql.com/doc/refman/8.0/en/user-resources.html

    139,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: