mysql启动:无法启动服务器:绑定unix套接字:设备上没有剩余空间。

时间:2022-10-06 10:33:08

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.

希望这个有帮助。