Where to increase max MySQL connections in DigitalOcean

[Shannon G]

Hi there - I have a client getting a connection error when trying to import a 10k list. Looking through other threads, I understand that I need to increase my max connections for MySQL. Can someone please tell me the name of the file I need to adjust in a DigitalOcean VPS? I'm running a search for my.cnf, but it's been going for over an hour and has come up with nothing so far.

I have the most recent version of MailWizz.

Thank you!

 

[twisted1919]

Did you try /etc/my.cnf ? Or /etc/mysql/ folder which might contain the right .cnf files?

 

[Shannon G]

That's where I found it, thank you! Added in the extra lines from https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/ , upgraded my server, switched "Parallel sending via PCNTL" to No and now everything looks good. Basically, followed your Performance Improvements article after updating my.cnf. Thanks for providing so much info between the articles and this forum!

 

[CaLViN]

You could also try phpmyadmin to edit your default settings,fyi.

 

[twisted1919]

You could also try phpmyadmin to edit your default settings,fyi.

Just a caveat to this, those settings won't stick, if you want them applied server wide, you need to do them in the mysql server configuration.