WordPress.org

Ready to get started?Download WordPress

Forums

User xx_e2 already has more than 'max_user_connections' (13 posts)

  1. bastoy
    Member
    Posted 1 year ago #

    I got the following error :

    User xx_e2 already has more than 'max_user_connections' active connections.
    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

    i dont update wordpress plz a need solutions

    i have in database 10230 tables very bigg data
    Ty

  2. Are you getting this error when upgrading or just when using the sites?

    You may need to ask your host for help, as it sounds like you need more connections allocated, so you may need a bigger/better server.

  3. bastoy
    Member
    Posted 1 year ago #

    a create one file in wp-content with name db-error.php.

    i have bigg server also i set max_users_connections to 50 .
    i lost a lot of visitor.
    Thank you for ur reply.

  4. a create one file in wp-content with name db-error.php.

    I'm sorry, I don't understand what you've said.

    When are you seeing this error? What are you doing at the time the error occurs?

  5. bastoy
    Member
    Posted 1 year ago #

    i get this error by email because i put notification in db-error.php if mysql server have any problem me go to restart this server again and again for solve this problem . so a need one solutions

    TY bro

  6. You need to look into server optimization, database caching, and possibly database sharding,

    You have a big DB, and a lot of traffic. Go look at SharDB and HyperDB.

  7. bastoy
    Member
    Posted 1 year ago #

    thank you, I will try

  8. rustyknight1217
    Member
    Posted 1 year ago #

    I'm having the same problem with a website I'm developing. Everything was fine and, after walking away from WordPress for awhile (yesterday), I came back to inability to navigate and error message:

    Error establishing a database connection

  9. Edward A. Sanchez - Please make your own topic :)

  10. rustyknight1217
    Member
    Posted 1 year ago #

    Why...if its the same issue?

  11. bastoy
    Member
    Posted 1 year ago #

    you can solve this problem with the update for your version of wordpress.
    Mr ipstenu hyperdb it used in multi tables and multi database right ?
    but for me a lot of tables and one database meby it exception case ?

  12. Edward A. Sanchez - Because it's not (unless you also have 10230 tables). Also we REALLY like separate threads, so you can have personal support.

    bastoy - HyperDB or SharDB would be your best bets. If your DB is this huge, you need to look into splitting it up. (It's Ms. Ipstenu ;) )

  13. bastoy
    Member
    Posted 1 year ago #

    thanks , Ms. Ipstenu

Topic Closed

This topic has been closed to new replies.

About this Topic