30 окт2019

tuning zabbix for hevy snmp v2

Written by Super User. Posted in Articles Unix

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 -u root -p
 
mysql> show global variables like '%max_connections%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 300   |
+-----------------+-------+
1 row in set (0,00 sec)
 
mysql> show global variables like '%open_files_limit%';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 10000 |
+------------------+-------+
1 row in set (0,00 sec)
 
mysql> show global variables like '%table_open_cache';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| table_open_cache | 16000 |
+------------------+-------+
1 row in set (0,00 sec)

 

 

 

в файл /lib/systemd/system/mysql.service
добавить
LimitNOFILE=65535
LimitNPROC=65535

Login