in logs sql you can see error
cat /var/log/mysql/error.log
2019-10-30T13:06:59.738016Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-10-30T13:06:59.738104Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
in default settings zabbix applience (ubuntu)
# cat /proc/$(pgrep mysqld)/limits
Limit |
Soft Limit |
Hard Limit |
Units |
Max cpu time |
unlimited |
unlimited |
seconds |
Max file size |
unlimited |
unlimited |
bytes |
Max data size |
unlimited |
unlimited |
bytes |
Max stack size |
8388608 |
unlimited |
bytes |
Max core file size |
0 |
unlimited |
bytes |
Max resident set |
unlimited |
unlimited |
bytes |
Max processes |
15630 |
15630 |
processes |
Max open files |
1024 |
4096 |
files |
Max locked memory |
65536 |
65536 |
bytes |
Max address space |
unlimited |
unlimited |
bytes |
Max file locks |
unlimited |
unlimited |
locks |
Max pending signals |
15630 |
15630 |
signals |
Max msgqueue size |
819200 |
819200 |
bytes |
Max nice priority |
0 |
0 |
|
Max realtime priority |
0 |
0 |
|
Max realtime timeout |
unlimited |
unlimited |
us |
mysql> show global variables like '%max_connections%' ; |
+-----------------+-------+ |
| Variable_name | Value | |
+-----------------+-------+ |
| max_connections | 300 | |
+-----------------+-------+ |
mysql> show global variables like '%open_files_limit%' ; |
+------------------+-------+ |
| Variable_name | Value | |
+------------------+-------+ |
| open_files_limit | 10000 | |
+------------------+-------+ |
mysql> show global variables like '%table_open_cache' ; |
+------------------+-------+ |
| Variable_name | Value | |
+------------------+-------+ |
| table_open_cache | 16000 | |
+------------------+-------+ |
в файл /lib/systemd/system/mysql.service
добавить
LimitNOFILE=65535
LimitNPROC=65535