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.
Hi,my mysql sometime auto sotp.not working.
Hi,my mysql sometime auto sotp.not working.
How to fix it.
Thanks.
My VPS informatoin.
Digitalocean 512 ram
Thanks.
My VPS informatoin.
Digitalocean 512 ram
Re: Hi,my mysql sometime auto sotp.not working.
Based upon your meaningless report there's very little we can do for you. Want help? Provide information. Errors, log files, screenshots, anything that can actually be useful.
Check /var/log/mysqld.log for errors. It's a start.
Check /var/log/mysqld.log for errors. It's a start.
Re: Hi,my mysql sometime auto sotp.not working.
Hi.
I change the Digitalocean 1G RAM plan.but the problem still here.
This is log
I change the Digitalocean 1G RAM plan.but the problem still here.
This is log
Code: Select all
141114 10:13:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141114 10:13:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141114 10:13:43 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
141114 10:13:43 [Note] Plugin 'FEDERATED' is disabled.
141114 10:13:43 InnoDB: The InnoDB memory heap is disabled
141114 10:13:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141114 10:13:43 InnoDB: Compressed tables use zlib 1.2.7
141114 10:13:43 InnoDB: Using Linux native AIO
141114 10:13:43 InnoDB: Initializing buffer pool, size = 50.0M
141114 10:13:43 InnoDB: Completed initialization of buffer pool
141114 10:13:43 InnoDB: highest supported file format is Barracuda.
141114 10:13:43 InnoDB: Waiting for the background threads to start
141114 10:13:44 InnoDB: 5.5.40 started; log sequence number 1671219
141114 10:13:44 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
141114 10:13:44 [Note] - '127.0.0.1' resolves to '127.0.0.1';
141114 10:13:44 [Note] Server socket created on IP: '127.0.0.1'.
141114 10:13:44 [Note] Event Scheduler: Loaded 0 events
141114 10:13:44 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-0+wheezy1' socket: '/var/lib/mysql/mysql.sock' port: 3306 (Debian)
141114 10:14:09 mysqld_safe A mysqld process already exists
141114 10:17:06 [Note] /usr/sbin/mysqld: Normal shutdown
141114 10:17:06 [Note] Event Scheduler: Purging the queue. 0 events
141114 10:17:06 InnoDB: Starting shutdown...
141114 10:17:06 InnoDB: Shutdown completed; log sequence number 1671219
141114 10:17:06 [Note] /usr/sbin/mysqld: Shutdown complete
141114 10:17:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Re: Hi,my mysql sometime auto sotp.not working.
my my.cnf file
Code: Select all
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=700
max_user_connections=30
wait_timeout=10
interactive_timeout=50
long_query_time=5
slow_query_log=0
key_buffer = 128M
myisam_sort_buffer_size = 64M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
table_cache=1536
thread_cache_size=286
interactive_timeout=25
connect_timeout=5
max_allowed_packet=64M
max_connect_errors=1000
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
tmp_table_size=64M
max_heap_table_size=64MB
bind-address= 127.0.0.1
innodb_buffer_pool_size=36M
innodb_flush_log_at_trx_commit=2
!includedir /etc/mysql/conf.d/
Re: Hi,my mysql sometime auto sotp.not working.
Restart mysqld using ssh and tell me the error. I think the problem is mysql is already running from before you might need to kill the old process. Are you using vesta cp and what OS do you have?
Re: Hi,my mysql sometime auto sotp.not working.
I am also on digitalocean with 1gb ram on centos 6.5 and MySql stops at least onece everyday. What cron script can I run to re-started mysql ?
Re: Hi,my mysql sometime auto sotp.not working.
mikepeace wrote:I am also on digitalocean with 1gb ram on centos 6.5 and MySql stops at least onece everyday. What cron script can I run to re-started mysql ?
Start a new thread and provide us with the following logs files,
- /var/log/mysqld.log
- /var/log/vesta/system.log
Re: Hi,my mysql sometime auto sotp.not working.
My mysql stop again. this is log. Thanksjoem wrote:mikepeace wrote:I am also on digitalocean with 1gb ram on centos 6.5 and MySql stops at least onece everyday. What cron script can I run to re-started mysql ?
Start a new thread and provide us with the following logs files,
- /var/log/mysqld.log
- /var/log/vesta/system.log
Code: Select all
141218 3:09:42 [Note] Event Scheduler: Purging the queue. 0 events
141218 3:09:42 InnoDB: Starting shutdown...
141218 3:09:44 InnoDB: Shutdown completed; log sequence number 2232350
141218 3:09:44 [Note] /usr/sbin/mysqld: Shutdown complete
141218 03:09:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141218 03:09:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141218 3:09:45 [Note] Plugin 'FEDERATED' is disabled.
141218 3:09:45 InnoDB: The InnoDB memory heap is disabled
141218 3:09:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141218 3:09:45 InnoDB: Compressed tables use zlib 1.2.7
141218 3:09:45 InnoDB: Using Linux native AIO
141218 3:09:45 InnoDB: Initializing buffer pool, size = 128.0M
141218 3:09:45 InnoDB: Completed initialization of buffer pool
141218 3:09:45 InnoDB: highest supported file format is Barracuda.
141218 3:09:45 InnoDB: Waiting for the background threads to start
141218 3:09:46 InnoDB: 5.5.40 started; log sequence number 2232350
141218 3:09:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141218 3:09:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141218 3:09:46 [Note] Server socket created on IP: '0.0.0.0'.
141218 3:09:46 [Note] Event Scheduler: Loaded 0 events
141218 3:09:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Killed
141218 10:22:36 mysqld_safe Number of processes running now: 0
141218 10:22:36 mysqld_safe mysqld restarted
141218 10:22:41 [Note] Plugin 'FEDERATED' is disabled.
141218 10:22:41 InnoDB: The InnoDB memory heap is disabled
141218 10:22:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141218 10:22:41 InnoDB: Compressed tables use zlib 1.2.7
141218 10:22:41 InnoDB: Using Linux native AIO
141218 10:22:42 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
141218 10:22:42 InnoDB: Completed initialization of buffer pool
141218 10:22:42 InnoDB: Fatal error: cannot allocate memory for the buffer pool
141218 10:22:42 [ERROR] Plugin 'InnoDB' init function returned error.
141218 10:22:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141218 10:22:42 [ERROR] Unknown/unsupported storage engine: InnoDB
141218 10:22:42 [ERROR] Aborting
141218 10:22:42 [Note] /usr/sbin/mysqld: Shutdown complete
141218 10:22:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141218 10:53:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141218 10:53:44 [Note] Plugin 'FEDERATED' is disabled.
141218 10:53:44 InnoDB: The InnoDB memory heap is disabled
141218 10:53:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141218 10:53:44 InnoDB: Compressed tables use zlib 1.2.7
141218 10:53:44 InnoDB: Using Linux native AIO
141218 10:53:44 InnoDB: Initializing buffer pool, size = 128.0M
141218 10:53:44 InnoDB: Completed initialization of buffer pool
141218 10:53:45 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141218 10:53:45 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141218 10:53:46 InnoDB: Waiting for the background threads to start
141218 10:53:47 InnoDB: 5.5.40 started; log sequence number 2243516
141218 10:53:47 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141218 10:53:47 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141218 10:53:47 [Note] Server socket created on IP: '0.0.0.0'.
141218 10:53:47 [Note] Event Scheduler: Loaded 0 events
141218 10:53:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.40-0+wheezy1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Code: Select all
2014-12-18 01:56:26 v-add-firewall-chain SSH
2014-12-18 01:56:26 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:06:27 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:06:49 v-add-firewall-chain SSH
2014-12-18 02:06:49 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:15:01 v-update-user-disk admin
2014-12-18 02:15:03 v-update-web-domains-disk admin
2014-12-18 02:15:23 v-update-mail-domains-disk admin
2014-12-18 02:15:23 v-update-database-disk admin admin_default
2014-12-18 02:15:24 v-update-database-disk admin admin_loan
2014-12-18 02:15:25 v-update-database-disk admin admin_shop
2014-12-18 02:15:25 v-update-database-disk admin admin_db38
2014-12-18 02:15:25 v-update-database-disk admin admin_loan2
2014-12-18 02:15:26 v-update-database-disk admin admin_game
2014-12-18 02:15:26 v-update-database-disk admin admin_mobi
2014-12-18 02:15:26 v-update-database-disk admin admin_cell
2014-12-18 02:15:27 v-update-database-disk admin admin_shop2
2014-12-18 02:15:28 v-update-database-disk admin admin_money
2014-12-18 02:15:23 v-update-databases-disk admin
2014-12-18 02:16:50 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:17:12 v-add-firewall-chain SSH
2014-12-18 02:17:12 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:27:13 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:27:37 v-add-firewall-chain SSH
2014-12-18 02:27:36 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:37:36 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:37:58 v-add-firewall-chain SSH
2014-12-18 02:37:58 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:47:58 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:48:25 v-add-firewall-chain SSH
2014-12-18 02:48:25 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 02:52:02 v-add-firewall-chain SSH
2014-12-18 02:52:02 v-add-firewall-ban 103.41.124.40 SSH
2014-12-18 02:58:25 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 02:58:53 v-add-firewall-chain SSH
2014-12-18 02:58:53 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 03:02:02 v-delete-firewall-ban 103.41.124.40 SSH
2014-12-18 03:08:53 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 03:09:19 v-add-firewall-chain SSH
2014-12-18 03:09:19 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 03:10:38 v-add-database admin cell2 cell2 ****** mysql localhost utf8
2014-12-18 03:19:20 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 03:19:44 v-add-firewall-chain SSH
2014-12-18 03:19:44 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 03:23:23 v-change-web-domain-proxy-tpl admin cellphone2feel.com caching jpeg,jpg,png,gif,bmp,ico,svg,tif,tiff,css,js,htm,html,ttf,otf,webp,woff,txt,csv,rtf,doc,docx,xls,xlsx,ppt,pptx,odf,odp,ods,odt,pdf,psd,ai,eot,eps,ps,zip,tar,tgz,gz,rar,bz2,7z,aac,m4a,mp3,mp4,ogg,wav,wma,3gp,avi,flv,m4v,mkv,mov,mp4,mpeg,mpg,wmv,exe,iso,dmg,swf no
2014-12-18 03:29:45 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 03:30:32 v-add-firewall-chain SSH
2014-12-18 03:30:32 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 03:40:33 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 03:40:52 v-add-firewall-chain SSH
2014-12-18 03:40:52 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 03:50:52 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 03:51:19 v-add-firewall-chain SSH
2014-12-18 03:51:19 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:01:19 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 04:01:42 v-add-firewall-chain SSH
2014-12-18 04:01:42 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:11:43 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 04:12:04 v-add-firewall-chain SSH
2014-12-18 04:12:04 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:22:05 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 04:22:42 v-add-firewall-chain SSH
2014-12-18 04:22:42 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:32:42 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 04:33:05 v-add-firewall-chain SSH
2014-12-18 04:33:05 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:43:06 v-delete-firewall-ban 27.152.183.95 SSH
2014-12-18 04:43:34 v-add-firewall-chain SSH
2014-12-18 04:43:34 v-add-firewall-ban 27.152.183.95 SSH
2014-12-18 04:53:35 v-delete-firewall-ban 27.152.183.95 SSH