军哥急救啊，Mysql起不来

xiaosevenjun

mysql重启报这个错误了Starting MySQL. ERROR! The server quit without updating PID file

licess

130821 10:09:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/DC03R11DS19-06.pid ended
130821 10:09:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130821 10:09:56 InnoDB: The InnoDB memory heap is disabled
130821 10:09:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130821 10:09:56 InnoDB: Compressed tables use zlib 1.2.3
/usr/local/mysql/bin/mysqld: Can't create/write to file '/tmp/iblbbU83' (Errcode: 28)
130821 10:09:56  InnoDB: Error: unable to create temporary file; errno: 28
130821 10:09:56 [ERROR] Plugin 'InnoDB' init function returned error.
130821 10:09:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130821 10:09:56 [ERROR] Unknown/unsupported storage engine: InnoDB
130821 10:09:56 [ERROR] Aborting

df -hi看看硬盘或分区是否已满

xiaosevenjun

[root@DC03R11DS19-06 ~]# df -hi
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/mapper/vg-root     115M    380K    114M    1% /
tmpfs                   4.0M       1    4.0M    1% /dev/shm
/dev/sda1                63K      39     63K    1% /boot
/dev/mapper/vg-tmp       64K      52     64K    1% /tmp
[root@DC03R11DS19-06 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg-root   1.8T   34G  1.7T   2% /
tmpfs                  16G     0   16G   0% /dev/shm
/dev/sda1             243M   28M  203M  12% /boot
/dev/mapper/vg-tmp   1008M   34M  923M   4% /tmp

我查看了看到并没满啊

licess

这个错误一般都是磁盘满了

你再看一下/tmp 权限

你安装的时候选innodb了没？如果不用innodb可以my.cnf关闭试试

xiaosevenjun

tmp 权限是这样

  drwxrwxrwt.   5 root root 307200 Aug 21 17:48 tmp

安装时有选择innodb