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.
Mysql server stops always
-
- Posts: 32
- Joined: Sat May 30, 2015 3:33 pm
Mysql server stops always
Mysql always stopping in my vesta cp. I run vesta cp on 1vcpu with 1.24 GB of RAM. I'm not able to restart or start service. Only workaround what I currently have to restart server . Please let me know how can I fix it. I haven't enabled swap memory to this server .
-
- Posts: 32
- Joined: Sat May 30, 2015 3:33 pm
Re: Mysql server stops always
Created a swap, following this post :
http://forum.vestacp.com/viewtopic.php?f=14&t=9239
will let you know if this stops again
http://forum.vestacp.com/viewtopic.php?f=14&t=9239
will let you know if this stops again
-
- Posts: 32
- Joined: Sat May 30, 2015 3:33 pm
Re: Mysql server stops always
This is my RAM usauge status. It stopped once , but not frequent .
. Help me for permanent solution.
. Help me for permanent solution.
Re: Mysql server stops always
Make changes in your mysql config -> my.cnf
or this
Code: Select all
key_buffer = 16K
max_allowed_packet = 1M
thread_stack = 64K
table_cache = 4
sort_buffer = 64K
net_buffer_length = 2K
Code: Select all
max_connections= 20
connect_timeout= 5
wait_timeout= 28800
max_allowed_packet= 32M
thread_cache_size = 50
sort_buffer_size= 4M
bulk_insert_buffer_size= 16M
tmp_table_size= 32M
max_heap_table_size= 32M
join_buffer_size= 256K
#
# * MyISAM
#
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched. On error, make copy and try a repair.
myisam_recover = BACKUP
key_buffer_size= 128M
open-files-limit= 5000
table_open_cache= 2000
myisam_sort_buffer_size= 128M
concurrent_insert= 2
read_buffer_size= 2M
read_rnd_buffer_size= 1M
#
# * Query Cache Configuration
#
query_cache_type= OFF
#
# * Logging and Replication
#
log_warnings= 2
slow_query_log= 1
slow_query_log_file= /srv/d_cs-amx/mysql/log/mariadb-slow.log
long_query_time= 5
log_slow_verbosity= query_plan
log_bin= /srv/d_cs-amx/mysql/log/mariadb-bin
log_bin_index= /srv/d_cs-amx/mysql/log/mariadb-bin.index
sync_binlog= 1
expire_logs_days= 3
max_binlog_size = 100M
#
# * InnoDB
#
default_storage_engine= InnoDB
innodb_buffer_pool_size= 128M
innodb_log_buffer_size= 8M
innodb_file_per_table= 1
innodb_open_files= 1024
innodb_io_capacity= 1024
innodb_flush_method= O_DIRECT
innodb_thread_concurrency= 0
innodb_stats_on_metadata= off
innodb_old_blocks_time= 1000
Re: Mysql server stops always
Well, there is no _permanent_ solution. Time to time you will need to make changes, when it needed.anjalimay6 wrote:This is my RAM usauge status. It stopped once , but not frequent .
Help me for permanent solution.
-
- Posts: 32
- Joined: Sat May 30, 2015 3:33 pm
Re: Mysql server stops always
Sorry I'm not expert in this , could please give me the file location?
Re: Mysql server stops always
MySQL - my.cnfanjalimay6 wrote:Sorry I'm not expert in this , could please give me the file location?
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu
https://vestacp.com/docs/#config-log-lo ... hel-centos
-
- Posts: 32
- Joined: Sat May 30, 2015 3:33 pm
Re: Mysql server stops always
Thanks alot ! always read manuals ! :)