A few days ago, I was doing some changes on my site, and suddenly it went out with words: “Database connection failed!”, I was so surprised! But after the rebooting my server, it started to work, like nothing happened! But by my experience, I was sure, that it will happen again! So, I was very curious and I opened the MySQL logs, there were more than 5000 lines, but happily, I found the information about the server crash and it was something like that:
Of course, I’ve started to google that error and I found the solution! To fix it, you need to go to:
/etc/mysql/conf.d/ , and create file
my.cnf, then you need to put that code into the file:
[mysqld] max_connections = 50 max_user_connections = 10 innodb_buffer_pool_size = 32M
After all of the changes, you need to reboot your MySQL server!
Now it should work. You can see the difference only on when you will have a lot of traffic on the server, or after some time!