Jump to content

MariaDB Limits


Recommended Posts

Each user can now open a maximum of 10 connections to MariaDB on Johnny and Tommy.

Back in 2021 and earlier we had a limit of 3 connections on Johnny and 6 connections on Tommy. Tons of people would write bad code that doesn't ever close database connections and then they would hit the limit and complain to us about the errors. The forum and Discord were full of messages like, "The reason you can't open any new connections is because you already have 6 open connections that have all been sleeping for hours without even doing anything."

When we switched to Plesk we decided to do an experiment and leave the connections unlimited to see if people could be responsible and not abuse our generosity. It worked well for 3 years, but in the last 2 weeks one person on Tommy and three people on Johnny have (probably unintentionally) launched a denial of service attack on our MariaDB databases causing hours of downtime for thousands of other users.

So, the time has come to enforce a limit again. A few bad people always ruin the fun for everyone else.

  • Like 2
Link to comment
Share on other sites

Hi!, I'm a newbie at the moment, and I'm amazed at how you provide this high quality service. I think users should choose to use database-less software as often as possible. Congratulations!

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...