MySQL Forums
Forum List  »  Performance

MySQL Configuration
Posted by: Luigi Donato
Date: May 15, 2018 04:49AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Configuration
152
May 15, 2018 04:49AM
69
May 15, 2018 10:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.