T
T
Tarasiuk2020-02-14 22:15:21
Windows
Tarasiuk, 2020-02-14 22:15:21

"Too many connections" mariadb 10.4 msi (windows)?

Good evening everyone. the server yells “Too many connections” People, if anyone can tell me, installed mariadb 10.4 for Windows, there is no max_connection config in my.ini file, I decided to dig stumbled upon this topic https://mariadb.com/kb/en/configuring-mariadb- with... (not advertising)

the result was:
fc6e95945dcb.jpg

according to the manual it turned out like this:
bc572939d0ba.jpg

max-connections=300 (parameter changed to 0)
63676101436c.jpg


The whole point is that you need to somehow increase the max_connection
, please answer me) thanks in advance

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Roman Mirilaczvili, 2020-02-15
@2ord

1. https://my-biz.com.ua/news/61/65/MySQL-oshibka-too...

Why?
There are two options:
Errors in the code of programs that use the MySQL database.
...
Indeed, the load on the server exceeds its capabilities.
...

2.
Usually too many connections indicates that requests are processed slowly by the server. Examine slow queries

To sum up:
this is usually a poorly written application and much less often - an overload relative to the default settings.
We look at the results of the
SHOW FULL PROCESSLIST command

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question