We are starting CHRISTMAS Sale. Get 30% OFF on lifetime licenses with code: FYSKK72

Help me. STOP mysql auto service

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
duytoi
Posts: 12
Joined: Mon Jun 20, 2016 8:46 am

Help me. STOP mysql auto service

Postby duytoi » Fri Jul 22, 2016 8:52 am

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
VestaCP Team
Posts: 5587
Joined: Sat Dec 01, 2012 12:37 pm
Contact:

Re: Help me. STOP mysql auto service

Postby imperio » Sat Jul 23, 2016 9:00 pm

What OS on your server?
Write more about problem
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

duytoi
Posts: 12
Joined: Mon Jun 20, 2016 8:46 am

Re: Help me. STOP mysql auto service

Postby duytoi » Sun Jul 24, 2016 1:05 am

imperio wrote: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
VestaCP Team
Posts: 7807
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: Help me. STOP mysql auto service

Postby skurudo » Tue Jul 26, 2016 1:20 pm

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

https://vestacp.com/docs/#config-log-lo ... hel-centos
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

duytoi
Posts: 12
Joined: Mon Jun 20, 2016 8:46 am

Re: Help me. STOP mysql auto service

Postby duytoi » Thu Jul 28, 2016 5:24 am

skurudo wrote: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
VestaCP Team
Posts: 7807
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: Help me. STOP mysql auto service

Postby skurudo » Thu Jul 28, 2016 10:52 am

duytoi wrote:
skurudo wrote: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?
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

duytoi
Posts: 12
Joined: Mon Jun 20, 2016 8:46 am

Re: Help me. STOP mysql auto service

Postby duytoi » Thu Jul 28, 2016 2:12 pm

skurudo wrote:
duytoi wrote:
skurudo wrote: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
VestaCP Team
Posts: 7807
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: Help me. STOP mysql auto service

Postby skurudo » Mon Aug 01, 2016 12:57 pm

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
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

duytoi
Posts: 12
Joined: Mon Jun 20, 2016 8:46 am

Re: Help me. STOP mysql auto service

Postby duytoi » Tue Aug 02, 2016 2:43 am

skurudo wrote: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
VestaCP Team
Posts: 7807
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: Help me. STOP mysql auto service

Postby skurudo » Tue Aug 02, 2016 7:43 am

duytoi wrote: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
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 1 guest