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]#
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