MySQL connection error. How to fix?

Question

MySQL

When scripts that intensively pull the database are running, the Django 2.2 admin panel starts periodically giving such an error, while the scripts themselves work fine and do not fall.

Lost connection to MySQL server at 'reading initial communication packet', system error: 95

What can be wrong? In Django or in the database or what else? How to fix?
OS: Ubuntu 18.04
Base: MariaDB 10.4.7
Python 3.6.8
Django 2.2

Answer 1

You create a new connection for every request. Under load, your DBMS will spend more time establishing and breaking connections than executing queries. Well, it looks like your project is exceeding the number of connections allowed by the DBMS configuration. Try using persistent connections .