Mysql start/stop

Support/Development for MySQL, MariaDB, and other database systems
xakru
New Forum User
New Forum User
Posts: 2
Joined: Fri Jun 07, 2013 4:55 am
Location: Moscow

Mysql start/stop

Unread post by xakru »

[root@CentOS-63-64-minimal log]# mysql -V
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1

if i have enabled skip-networking in config all fine.
But if skip-networking is disabled i have some errors. Mysql cannot turn off himself.

Code: Select all

[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 2018 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
 2396 pts/0    Sl     0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/CentOS-63-64-minimal.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
 2489 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 2528 ?        SN     0:00 /bin/sh /etc/init.d/mysqld start
 2562 ?        SN     0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
 2944 ?        SNl    0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/CentOS-63-64-minimal.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
 2970 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 3017 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]# 

and if i'll start mysql after when i have stoped this at first time, i have errors

Code: Select all

Version: '5.5.31-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
130531 23:45:11 [Warning] IP address '218.93.205.140' could not be resolved: Name or service not known
130601  7:57:20 [Warning] IP address '66.199.146.70' could not be resolved: Name or service not known
130602  9:10:55 [Warning] IP address '173.208.202.182' could not be resolved: Name or service not known
130603 19:43:50 [Warning] IP address '218.8.245.123' could not be resolved: Name or service not known
130604  7:01:41 [Warning] IP address '118.119.254.21' could not be resolved: Name or service not known
130604  7:25:05 [Warning] IP address '173.208.240.203' could not be resolved: Name or service not known
130605 13:30:10 [Warning] IP address '222.73.86.69' could not be resolved: Name or service not known
130605 14:57:00 [Note] /usr/libexec/mysqld: Normal shutdown

130605 14:57:00 [Note] Event Scheduler: Purging the queue. 0 events
130605 14:57:00  InnoDB: Starting shutdown...
130605 14:57:02  InnoDB: Shutdown completed; log sequence number 951248779
130605 14:57:02 [Note] /usr/libexec/mysqld: Shutdown complete

130605 14:57:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130605 14:57:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130605 14:57:03 [Note] libgovernor.so not found
130605 14:57:03 [Note] Plugin 'FEDERATED' is disabled.
130605 14:57:03 InnoDB: The InnoDB memory heap is disabled
130605 14:57:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130605 14:57:03 InnoDB: Compressed tables use zlib 1.2.3
130605 14:57:03 InnoDB: Using Linux native AIO
130605 14:57:03 InnoDB: Initializing buffer pool, size = 128.0M
130605 14:57:03 InnoDB: Completed initialization of buffer pool
130605 14:57:03 InnoDB: highest supported file format is Barracuda.
130605 14:57:03  InnoDB: Waiting for the background threads to start
130605 14:57:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130605 14:57:04 [Note] libgovernor.so not found
130605 14:57:04 [Note] Plugin 'FEDERATED' is disabled.
130605 14:57:04 InnoDB: The InnoDB memory heap is disabled
130605 14:57:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130605 14:57:04 InnoDB: Compressed tables use zlib 1.2.3
130605 14:57:04 InnoDB: Using Linux native AIO
130605 14:57:04 InnoDB: Initializing buffer pool, size = 128.0M
130605 14:57:04 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130605 14:57:04  InnoDB: Retrying to lock the first data file
130605 14:57:04 InnoDB: 5.5.31 started; log sequence number 951248779
130605 14:57:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130605 14:57:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130605 14:57:04 [Note] Server socket created on IP: '0.0.0.0'.
130605 14:57:04 [Note] Event Scheduler: Loaded 0 events
130605 14:57:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.31-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
And only when i stoping mysql at second time i have no errors.
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: Mysql start/stop

Unread post by faris »

Does this help: http://serverfault.com/questions/393862 ... e-resolved

Please note the comments about security that are also made in that post.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
xakru
New Forum User
New Forum User
Posts: 2
Joined: Fri Jun 07, 2013 4:55 am
Location: Moscow

Re: Mysql start/stop

Unread post by xakru »

no, problem not in resolving. In MySQL 5.1 I don't have same problem.
Post Reply