军哥急救啊，Mysql起不来

xiaosevenjun 发表于 2013-8-21 10:19:53

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

licess 发表于 2013-8-21 12:50:46

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:56InnoDB: Error: unable to create temporary file; errno: 28
130821 10:09:56 Plugin 'InnoDB' init function returned error.
130821 10:09:56 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130821 10:09:56 Unknown/unsupported storage engine: InnoDB
130821 10:09:56 Aborting

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

xiaosevenjun 发表于 2013-8-21 13:16:21

回复 2# 的帖子

# 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
# df -h
Filesystem          SizeUsed Avail Use% Mounted on
/dev/mapper/vg-root 1.8T 34G1.7T 2% /
tmpfs                16G 0 16G 0% /dev/shm
/dev/sda1          243M 28M203M12% /boot
/dev/mapper/vg-tmp 1008M 34M923M 4% /tmp

我查看了看到并没满啊

licess 发表于 2013-8-21 17:29:38

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

你再看一下/tmp 权限

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

xiaosevenjun 发表于 2013-8-21 17:58:45

回复 4# 的帖子

tmp 权限是这样

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

安装时有选择innodb

页: [1]

VPS侦探论坛's Archiver