Vesta Control Panel - Forum

Community Forum
https://forum.vestacp.com/

Hi,my mysql sometime auto sotp.not working.

https://forum.vestacp.com/viewtopic.php?f=14&t=6264

Page 1 of 1

Hi,my mysql sometime auto sotp.not working.

Posted: Thu Nov 13, 2014 2:01 pm
by szkin
How to fix it.
Thanks.
My VPS informatoin.
Digitalocean 512 ram

Re: Hi,my mysql sometime auto sotp.not working.

Posted: Thu Nov 13, 2014 2:54 pm
by Milka
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.

Re: Hi,my mysql sometime auto sotp.not working.

Posted: Fri Nov 14, 2014 10:35 am
by szkin
Hi.
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.

Posted: Fri Nov 14, 2014 11:07 am
by szkin
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.

Posted: Fri Nov 14, 2014 6:59 pm
by joem
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.

Posted: Wed Dec 17, 2014 3:55 am
by mikepeace
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.

Posted: Wed Dec 17, 2014 5:01 am
by joem
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.

Posted: Thu Dec 18, 2014 1:21 pm
by szkin
joem 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
My mysql stop again. this is log. Thanks

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
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/