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:

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


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..!

[--] 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:

CPU Intel® Xeon®: Intel® Xeon® E5-2660 v2 e Intel® Xeon® E5-2683 v3 (4 cores)

You can help me..? f9

Options: ReplyQuote

Written By
MySQL Configuration
May 15, 2018 04:49AM
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.