修改了my.cnf,innodb启动失败

ban_ping

OO不能用oracle的经验来揣测mysql，它不像oracle那么严谨，生命力很强，没有配置参数都能起来。

〇〇

在jingguanding的帮助下，解决了

[oracle@redflag11012501 ~]$ id mysql
uid=102(mysql) gid=106(mysql) groups=106(mysql)
[oracle@redflag11012501 ~]$ exit
logout

[root@redflag11012501 tmp]# cat /etc/my.cnf|grep pid
[root@redflag11012501 tmp]#  ll /var/lib/mysql/*pid
-rw-rw---- 1 root root 6 06-04 19:40 /var/lib/mysql/redflag11012501.pid
[root@redflag11012501 tmp]# mysqladmin -u root shutdown
mysqladmin: Unknown OS character set 'GB18030'.
mysqladmin: Switching to the default character set 'latin1'.

[root@redflag11012501 tmp]#
[root@redflag11012501 tmp]# service mysql start
Starting MySQL.The server quit without updating PID file (/var/lib/mysql/redflag11012501.pid).[失败]
[root@redflag11012501 tmp]# chown -R mysql:mysql /var/lib/mysql
[root@redflag11012501 tmp]# service mysql start
Starting MySQL...The server quit without updating PID file (/var/lib/mysql/redflag11012501.pid).[失败]
[root@redflag11012501 tmp]# mysqld_safe &
[1] 1416
[root@redflag11012501 tmp]# 110608 11:18:56 mysqld_safe Logging to '/var/lib/mysql/redflag11012501.err'.
110608 11:18:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110608 11:18:58 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended

[1]+  Done                    mysqld_safe
[root@redflag11012501 tmp]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@redflag11012501 tmp]# ll /var/lib/mysql/*pid
ls: /var/lib/mysql/*pid: 没有那个文件或目录
[root@redflag11012501 tmp]# ll /var/lib/mysql/
总计 88
drwx--x--x 2 mysql mysql  4096 06-02 17:59 mysql
-rw-rw---- 1 mysql mysql   150 06-04 19:42 mysql-bin.000015
-rw-rw---- 1 mysql mysql   677 06-08 11:03 mysql-bin.000016
-rw-rw---- 1 mysql mysql    38 06-04 19:57 mysql-bin.index
drwx------ 2 mysql mysql  4096 06-02 17:59 performance_schema
-rw-rw---- 1 mysql mysql  5175 06-08 11:18 redflag11012501.err
-rw-rw---- 1 mysql mysql 44866 06-07 13:44 redflag11012501-slow.log
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x 2 mysql mysql  4096 06-02 17:59 test
drwx------ 2 mysql mysql  4096 06-04 20:32 tpch
[root@redflag11012501 tmp]# service mysql start
Starting MySQL...The server quit without updating PID file (/var/lib/mysql/redflag11012501.pid).[失败]
[root@redflag11012501 tmp]# ll /var/lib/mysql/
总计 88
drwx--x--x 2 mysql mysql  4096 06-02 17:59 mysql
-rw-rw---- 1 mysql mysql   150 06-04 19:42 mysql-bin.000015
-rw-rw---- 1 mysql mysql   677 06-08 11:03 mysql-bin.000016
-rw-rw---- 1 mysql mysql    38 06-04 19:57 mysql-bin.index
drwx------ 2 mysql mysql  4096 06-02 17:59 performance_schema
-rw-rw---- 1 mysql mysql  6047 06-08 11:21 redflag11012501.err
-rw-rw---- 1 mysql mysql 44866 06-07 13:44 redflag11012501-slow.log
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x 2 mysql mysql  4096 06-02 17:59 test
drwx------ 2 mysql mysql  4096 06-04 20:32 tpch
[root@redflag11012501 tmp]# mysqld --user=root
110608 11:21:55 [Note] Plugin 'FEDERATED' is disabled.
110608 11:21:55 InnoDB: The InnoDB memory heap is disabled
110608 11:21:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110608 11:21:55 InnoDB: Compressed tables use zlib 1.2.3
110608 11:21:55 InnoDB: Using Linux native AIO
110608 11:21:55 InnoDB: Initializing buffer pool, size = 20.0G
110608 11:21:57 InnoDB: Completed initialization of buffer pool
110608 11:21:57 InnoDB: highest supported file format is Barracuda.
110608 11:21:59  InnoDB: Waiting for the background threads to start
110608 11:22:00 InnoDB: 1.1.7 started; log sequence number 58674268879
110608 11:22:00 [Note] Event Scheduler: Loaded 0 events
110608 11:22:00 [Note] mysqld: ready for connections.
Version: '5.5.13-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
110608 11:22:25 [Note] mysqld: Normal shutdown

110608 11:22:25 [Note] Event Scheduler: Purging the queue. 0 events
110608 11:22:25  InnoDB: Starting shutdown...
110608 11:22:28  InnoDB: Shutdown completed; log sequence number 58674268879
110608 11:22:28 [Note] mysqld: Shutdown complete

[root@redflag11012501 tmp]# ll /var/lib/mysql/
总计 92
drwx--x--x 2 mysql mysql  4096 06-02 17:59 mysql
-rw-rw---- 1 mysql mysql   150 06-04 19:42 mysql-bin.000015
-rw-rw---- 1 mysql mysql   677 06-08 11:03 mysql-bin.000016
-rw-rw---- 1 root  root    126 06-08 11:22 mysql-bin.000017
-rw-rw---- 1 mysql mysql    57 06-08 11:22 mysql-bin.index
drwx------ 2 mysql mysql  4096 06-02 17:59 performance_schema
-rw-rw---- 1 mysql mysql  6047 06-08 11:21 redflag11012501.err
-rw-rw---- 1 mysql mysql 45039 06-08 11:22 redflag11012501-slow.log
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x 2 mysql mysql  4096 06-02 17:59 test
drwx------ 2 mysql mysql  4096 06-04 20:32 tpch
[root@redflag11012501 tmp]# tail var/lib/mysql/redflag11012501.err
tail: 无法打开 “var/lib/mysql/redflag11012501.err” 读取数据: 没有那个文件或目录
[root@redflag11012501 tmp]# tail /var/lib/mysql/redflag11012501.err
110608 11:21:22 InnoDB: Using Linux native AIO
110608 11:21:22 InnoDB: Initializing buffer pool, size = 20.0G
110608 11:21:24 InnoDB: Completed initialization of buffer pool
110608 11:21:24  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /user1/mysql_db/ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
110608 11:21:24 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended
[root@redflag11012501 tmp]# chown -R mysql:mysql /usr1/mysql_db/
chown: 无法访问 “/usr1/mysql_db/”: 没有那个文件或目录
[root@redflag11012501 tmp]# chown -R mysql:mysql /user1/mysql_db/
[root@redflag11012501 tmp]# service mysql start
Starting MySQL........The server quit without updating PID file (/var/lib/mysql/redflag11012501.pid).[失败]
[root@redflag11012501 tmp]# mysqld_safe --user=root
110608 13:59:54 mysqld_safe Logging to '/var/lib/mysql/redflag11012501.err'.
110608 13:59:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql


110608 14:00:28 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended
[root@redflag11012501 tmp]#
[root@redflag11012501 tmp]#
[root@redflag11012501 tmp]# tail /var/lib/mysql/redflag11012501.err
110608 13:59:59 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.13-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
110608 14:00:26 [Note] /usr/sbin/mysqld: Normal shutdown

110608 14:00:26 [Note] Event Scheduler: Purging the queue. 0 events
110608 14:00:26  InnoDB: Starting shutdown...
110608 14:00:28  InnoDB: Shutdown completed; log sequence number 58674268879
110608 14:00:28 [Note] /usr/sbin/mysqld: Shutdown complete

110608 14:00:28 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended
[root@redflag11012501 tmp]# mysqld_safe &
[1] 8415
[root@redflag11012501 tmp]# 110608 14:01:06 mysqld_safe Logging to '/var/lib/mysql/redflag11012501.err'.
110608 14:01:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

[root@redflag11012501 tmp]#
[root@redflag11012501 tmp]# 110608 14:01:13 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended

[1]+  Done                    mysqld_safe
[root@redflag11012501 tmp]# tail /var/lib/mysql/redflag11012501.err
110608 14:01:11 [ERROR] Failed to open log (file './mysql-bin.000018', errno 13)
110608 14:01:11 [ERROR] Could not open log file
110608 14:01:11 [ERROR] Can't init tc log
110608 14:01:11 [ERROR] Aborting

110608 14:01:11  InnoDB: Starting shutdown...
110608 14:01:13  InnoDB: Shutdown completed; log sequence number 58674268879
110608 14:01:13 [Note] /usr/sbin/mysqld: Shutdown complete

110608 14:01:13 mysqld_safe mysqld from pid file /var/lib/mysql/redflag11012501.pid ended
[root@redflag11012501 tmp]# pwd
/var/tmp
[root@redflag11012501 tmp]# cd  /var/lib/mysql
[root@redflag11012501 mysql]# ll
总计 104
drwx--x--x 2 mysql mysql  4096 06-02 17:59 mysql
-rw-rw---- 1 mysql mysql   150 06-04 19:42 mysql-bin.000015
-rw-rw---- 1 mysql mysql   677 06-08 11:03 mysql-bin.000016
-rw-rw---- 1 root  root    126 06-08 11:22 mysql-bin.000017
-rw-rw---- 1 root  root    126 06-08 14:00 mysql-bin.000018
-rw-rw---- 1 mysql mysql    76 06-08 13:59 mysql-bin.index
drwx------ 2 mysql mysql  4096 06-02 17:59 performance_schema
-rw-rw---- 1 mysql mysql  9885 06-08 14:01 redflag11012501.err
-rw-rw---- 1 mysql mysql 45588 06-08 14:01 redflag11012501-slow.log
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_HISTORY
-rw-r--r-- 1 mysql mysql   121 06-02 17:59 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x 2 mysql mysql  4096 06-02 17:59 test
drwx------ 2 mysql mysql  4096 06-04 20:32 tpch
[root@redflag11012501 mysql]# tail redflag11012501-slow.log
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.5.13-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.5.13-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.5.13-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
[root@redflag11012501 mysql]# cat RPM_UPGRADE_HISTORY
MySQL RPM installation of version 5.5.13-1.rhel5
Upgrade/install finished at 2011年 06月 02日 星期四 17:59:33 CST

=====
[root@redflag11012501 mysql]# chown mysql:mysql mysql-bin.*
[root@redflag11012501 mysql]# service mysql start
Starting MySQL.......[确定]
[root@redflag11012501 mysql]#