Hi guys,
after about 10 days from the start of a VPS, I found myself suddenly with the
MySQL which used a disproportionate percentage of the CPU.
Reading on the internet I noticed that it happened to many and, becoming aware of the meaning of many variables
MySQL , I realized that it is not easy to configure
MySQL ad hoc ..
So I decided to avail myself of the help of
MySQL Tuner and
Tuning-Primer, trying to find a meeting point between these two programs, I arrived at this configuration:
Quote
join_buffer_size = 4M
key_buffer_size = 384M
max_allowed_packet = 2M
thread_cache_size = 32M
myisam-recover-options = BACKUP
query_cache_limit = 50K
query_cache_size = 0
query_cache_type = 0
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_file_per_table = 1
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 32M
read_buffer_size = 4M
sort_buffer_size = 1M
table_open_cache = 1000
table_definition_cache = 1000
max_connections = 100
innodb_log_file_size = 16M
skip-name-resolve
tmp_table_size = 512M
max_heap_table_size = 512M
MySQL Tuner however it keeps asking me to increase the
join_buffer_size, but as I see from the analysis, the values are already high..!
Quote
[--] Physical Memory : 7.8G
[--] Max MySQL memory : 5.0G
[--] Other process memory: 1.9G
[--] Total buffers: 1.0G global + 41.2M per thread (100 max threads)
Il VPS ha queste caratteristiche:
Quote
CPU Intel® Xeon®: Intel® Xeon® E5-2660 v2 e Intel® Xeon® E5-2683 v3 (4 cores)
RAM 8Gb & SSD
You can help me..? f9