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

Re: Help me. STOP mysql auto service

Postby duytoi » Sat Aug 06, 2016 3:30 am

skurudo wrote:
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


The issue remains unresolved adding /etc/my.cnf configuration file. STOP Mysql auto service and it can not be restarted, I have to restart the service httpd restart mysqld then succeed.

P/S: httpd memory of up to more than 1gb

Please help me solve the problem completely.

Regards.

Duy Toi

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 Aug 11, 2016 3:02 pm

duytoi wrote:Please help me solve the problem completely.


Any new logs may be? Can you show?
-> 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 23, 2016 4:34 am

skurudo wrote:
duytoi wrote:Please help me solve the problem completely.


Any new logs may be? Can you show?


Mysqld Log :

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
"/var/log/mysqld.log" 2625L, 209529C


Please Help me. Thanks you very much


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 3 guests

cron