Hello dpeca
I would like to know if there are any special setting to set myvesta to handle 10k visitor at a time.
Before this, using the same server, i am using vesta with nginx + phpfpm, and can handle 10k visitor at a time without the server go into high load...
the server spec is Intel(R) Core(TM) i7-7700K CPU @ 4.20GHz, 8 core, 32GB
in january, when i open for an event registration, the server load is around 4-5 (max) (using nginx + phpfpm vestacp)
yesterday, when open an event for registration, the server load goes max 8 for over an hour (that is the time the registration is open...)
any idea why or tips to solev this matter...
or is it okay...
thanks for your advice in advanced...
- Azlan
Setup MyVesta to handle 10k visitor at a time
- myVesta
- Site Admin
- Posts: 932
- Joined: Fri Jun 19, 2020 9:59 am
- Has thanked: 8 times
- Been thanked: 6 times
The only thing you can do is to alter mysql buffers - viewtopic.php?f=27&t=322
And check "pm.max_children" in pool.d folder of php-fpm - viewtopic.php?f=18&t=54
And check "pm.max_children" in pool.d folder of php-fpm - viewtopic.php?f=18&t=54
what is the number that i can change it.. i already set it to 10 for the pm.max_childrendpeca wrote: ↑Thu Mar 04, 2021 3:55 pm The only thing you can do is to alter mysql buffers - viewtopic.php?f=27&t=322
And check "pm.max_children" in pool.d folder of php-fpm - viewtopic.php?f=18&t=54
my setting
pm = ondemand
pm.max_children = 10
request_terminate_timeout = 90s
pm.max_requests = 6000
pm.process_idle_timeout = 10s
pm.status_path = /status
here is the line that i change in mariadb.cnf
skip-external-locking
key_buffer_size = 512M - before it is 256M
max_allowed_packet = 32M
# table_open_cache = 256
sort_buffer_size = 4M - 2M before this
net_buffer_length = 16K - 8k before
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
# thread_cache_size = 8 - before uncommented
# query_cache_size= 16M - before uncommented
# thread_concurrency = 8 - before uncommented
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections=200
max_user_connections=199
# wait_timeout=30 - before uncommented
interactive_timeout=50
long_query_time=5
// before this few lines was not in my conf file
table_open_cache = 20480
thread_cache_size = 384
query_cache_size = 50M
# thread_concurrency = 16
wait_timeout = 180
join_buffer_size = 16M
query_cache_type = 1
tmp_table_size = 512M
innodb_buffer_pool_size=4G
// up till here...
!includedir /etc/mysql/conf.d/
basically i just follow the ones that you put to optimize the database if have RAM more than 32GB
skip-external-locking
key_buffer_size = 512M - before it is 256M
max_allowed_packet = 32M
# table_open_cache = 256
sort_buffer_size = 4M - 2M before this
net_buffer_length = 16K - 8k before
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
# thread_cache_size = 8 - before uncommented
# query_cache_size= 16M - before uncommented
# thread_concurrency = 8 - before uncommented
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections=200
max_user_connections=199
# wait_timeout=30 - before uncommented
interactive_timeout=50
long_query_time=5
// before this few lines was not in my conf file
table_open_cache = 20480
thread_cache_size = 384
query_cache_size = 50M
# thread_concurrency = 16
wait_timeout = 180
join_buffer_size = 16M
query_cache_type = 1
tmp_table_size = 512M
innodb_buffer_pool_size=4G
// up till here...
!includedir /etc/mysql/conf.d/
basically i just follow the ones that you put to optimize the database if have RAM more than 32GB