I have mysql start error:
我有mysql启动错误:
131223 19:03:24 [Note] Plugin 'FEDERATED' is disabled.
131223 19:03:25 InnoDB: Started; log sequence number 55 4050118616
131223 19:03:25 [ERROR] Can't start server : Bind on unix socket: No space left on device
131223 19:03:25 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
131223 19:03:25 [ERROR] Aborting
131223 19:03:25 InnoDB: Starting shutdown...
131223 19:03:30 InnoDB: Shutdown completed; log sequence number 55 4050118616
131223 19:03:30 [Note] /usr/sbin/mysqld: Shutdown complete
When I'm trying to do
当我试着去做的时候。
sudo mkfifo /var/run/mysqld/mysqld.sock
I've got
我有
mkfifo: cannot create fifo `/var/run/mysqld/mysqld.sock': No space left on device
Result of df -h:
df - h的结果:
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/system-root
473M 131M 318M 30% /
tmpfs 5.9G 0 5.9G 0% /lib/init/rw
udev 5.9G 168K 5.9G 1% /dev
tmpfs 5.9G 0 5.9G 0% /dev/shm
/dev/md0 472M 27M 422M 6% /boot
/dev/mapper/system-usr
9.2G 772M 8.0G 9% /usr
/dev/mapper/system-var
13G 4.5G 7.7G 37% /var
/dev/mapper/system-home
591G 280G 282G 50% /home
/dev/mapper/system-logs
15G 7.7G 6.1G 57% /logs
So... I have free space, but I have no free space? Which to do to start mysql?
所以…我有*空间,但我没有*空间?如何开始mysql?
2 个解决方案
#1
0
Line 4 says to you Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
第4行告诉您,您已经有另一个mysqld服务器运行在套接字上:/var/run/mysqld/mysqld。袜子吗?
If /var/run/mysqld/mysqld.sock
already exists, this will fail.
如果/var/run/mysqld/mysqld.sock已经存在,这将会失败。
#2
0
What are the permissions on that directory? /var/run/mysqld ? They should be owned by mysql but in some cases I've found that it may not run as mysql either. If not, run a chown USER /var/run/mysqld
where USER is you. :P
该目录的权限是什么?/var/run/mysqld吗?它们应该由mysql拥有,但在某些情况下,我发现它可能也不是mysql。如果不是,运行一个chown用户/var/run/mysqld,其中用户是您。:P
Hope this helps.
希望这个有帮助。
#1
0
Line 4 says to you Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
第4行告诉您,您已经有另一个mysqld服务器运行在套接字上:/var/run/mysqld/mysqld。袜子吗?
If /var/run/mysqld/mysqld.sock
already exists, this will fail.
如果/var/run/mysqld/mysqld.sock已经存在,这将会失败。
#2
0
What are the permissions on that directory? /var/run/mysqld ? They should be owned by mysql but in some cases I've found that it may not run as mysql either. If not, run a chown USER /var/run/mysqld
where USER is you. :P
该目录的权限是什么?/var/run/mysqld吗?它们应该由mysql拥有,但在某些情况下,我发现它可能也不是mysql。如果不是,运行一个chown用户/var/run/mysqld,其中用户是您。:P
Hope this helps.
希望这个有帮助。