jera
Member
Hello friends,
Reading on the forum, I see that 2GB of ram and 2CPU is enough to run mailwizz. I have a VPS with 4 vCPU Cores
8 GB RAM and I feel slow, when I manage campaigns of 35k or 45K contacts. So I feel like maybe I'm not getting the most out of my server.
I tried to apply this tutorial (https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/), but they only mention 4 options and in my settings I see that there are more options.
Can you help me to get the most out of my VPS please?
I share my MySQL configuration
Reading on the forum, I see that 2GB of ram and 2CPU is enough to run mailwizz. I have a VPS with 4 vCPU Cores
8 GB RAM and I feel slow, when I manage campaigns of 35k or 45K contacts. So I feel like maybe I'm not getting the most out of my server.
I tried to apply this tutorial (https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/), but they only mention 4 options and in my settings I see that there are more options.
Can you help me to get the most out of my VPS please?
I share my MySQL configuration
SQL:
[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
innodb_buffer_pool_size=6G
innodb_flush_log_at_trx_commit=2
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
max_connections=500
max_user_connections=50
wait_timeout=10
interactive_timeout=50
long_query_time=5
!includedir /etc/mysql/conf.d/