Help me. STOP mysql auto service

[duytoi]

My VPS setup STOP Mysqld Vestacp often for unknown reasons. I use the VPS Digitalocean

We wish ADMIN and support you in my forum fixing

This is the error I get every time services are Mysqld STOP " Error establishing a database connection "

This is my site https://sharelachuan.com

Regards !

[imperio]

What OS on your server?
Write more about problem

[duytoi]

What OS on your server?
Write more about problem

Screenshot images error
http://i783.photobucket.com/albums/yy11 ... dlep2w.png
Mysqld restart Failed

Commandline SSH
http://i783.photobucket.com/albums/yy11 ... o22k7p.png

Vestacp

http://i783.photobucket.com/albums/yy11 ... qe7xnv.png

I'm using Centos 6.7 x32

It is frequently also the error is about 1-2 days

Regards.

Toi Duy

[skurudo]

What's mysql error log say? -> /var/log/mysqld.log

https://vestacp.com/docs/#config-log-lo ... hel-centos

[duytoi]

What's mysql error log say? -> /var/log/mysqld.log

https://vestacp.com/docs/#config-log-lo ... hel-centos

My log mysql

160623 21:53:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160623 21:53:22 [Note] /usr/libexec/mysqld (mysqld 5.5.50) starting as process 13496 ...
160623 21:53:22 [Note] Plugin 'FEDERATED' is disabled.
160623 21:53:22 InnoDB: The InnoDB memory heap is disabled
160623 21:53:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160623 21:53:22 InnoDB: Compressed tables use zlib 1.2.3
160623 21:53:22 InnoDB: Using Linux native AIO
160623 21:53:22 InnoDB: Initializing buffer pool, size = 128.0M
160623 21:53:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160623 21:53:22 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160623 21:53:22 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160623 21:53:22 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160623 21:53:22 InnoDB: Waiting for the background threads to start
160623 21:53:23 InnoDB: 5.5.50 started; log sequence number 0
160623 21:53:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160623 21:53:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160623 21:53:23 [Note] Server socket created on IP: '0.0.0.0'.
160623 21:53:23 [Note] Event Scheduler: Loaded 0 events
160623 21:53:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.50' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
160623 23:20:28 [Warning] IP address '103.200.116.232' could not be resolved: Name or service not known
160624 1:03:00 [Warning] IP address '58.221.44.81' could not be resolved: Name or service not known
160624 3:24:13 [Warning] IP address '113.108.21.16' could not be resolved: Name or service not known
160624 3:24:15 [Warning] IP address '113.108.21.16' could not be resolved: Name or service not known
160624 3:49:37 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:49:47 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:49:58 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:10 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:14 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:26 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:29 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:44 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 3:50:59 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 8:10:45 [Warning] IP address '222.174.5.42' could not be resolved: Name or service not known
160624 9:08:23 [Warning] IP address '218.244.254.49' could not be resolved: Name or service not known
160624 13:17:42 [Warning] IP address '119.147.115.12' could not be resolved: Name or service not known
160624 19:23:57 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 19:23:58 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution
160624 19:24:00 [Warning] IP address '124.172.136.24' could not be resolved: Temporary failure in name resolution

[skurudo]

What's mysql error log say? -> /var/log/mysqld.log

https://vestacp.com/docs/#config-log-lo ... hel-centos

My log mysql

It's all nothing more?

[duytoi]

What's mysql error log say? -> /var/log/mysqld.log

https://vestacp.com/docs/#config-log-lo ... hel-centos

My log mysql

It's all nothing more?

exactly. That is all the log

You need to provide more information ?

[skurudo]

You can make changes in my.cnf file and reload MySQL.
I think mysql eat too much.

Code: Select all

wait_timeout=10
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

key_buffer_size = 64M
myisam_sort_buffer_size = 32M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
table_cache=512
thread_cache_size=8
interactive_timeout=25
connect_timeout=5
max_allowed_packet=1M
max_connect_errors=1000
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
tmp_table_size=16M

#innodb_use_native_aio = 0
innodb_file_per_table

[duytoi]

You can make changes in my.cnf file and reload MySQL.
I think mysql eat too much.

Code: Select all

wait_timeout=10
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

key_buffer_size = 64M
myisam_sort_buffer_size = 32M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
table_cache=512
thread_cache_size=8
interactive_timeout=25
connect_timeout=5
max_allowed_packet=1M
max_connect_errors=1000
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
tmp_table_size=16M

#innodb_use_native_aio = 0
innodb_file_per_table

Thank you for your support . Let me change the my.cnf configuration file with the information you provide.

I have not found a place to my.cnf file, my.cnf file path to where? ^_^

[skurudo]

I have not found a place to my.cnf file, my.cnf file path to where? ^_^

/etc/my.cnf

https://vestacp.com/docs/#config-log-lo ... hel-centos