We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
How to reduce RAM usage MySQL?
How to reduce RAM usage MySQL?
I have big memory problem, sql use too much.
Config:
Graphs:
Setup:
ubuntu 16.04
nginx+php7.0-fpm
wordpress 1.200 articles, ~2k visitors per day.
Config:
Code: Select all
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 32M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
#innodb_use_native_aio = 0
innodb_file_per_table = 1
max_connections=200
max_user_connections=50
wait_timeout=10
interactive_timeout=50
long_query_time=5
query_cache_type = 1
tmp_table_size = 64M
max_heap_table_size = 64M
skip-name-resolve
!includedir /etc/mysql/conf.d/
Setup:
ubuntu 16.04
nginx+php7.0-fpm
wordpress 1.200 articles, ~2k visitors per day.
Re: How to reduce RAM usage MySQL?
MySQL Config Tuner Scripts
viewtopic.php?f=14&t=14148
viewtopic.php?f=14&t=14148