mysql Errcode 28
磁盘还可以但是inode表没有了
dd if=/dev/zero of=tmpforinde count=1024 bs=1024KB mke2fs -N 5000000 -b 1024 -I 128 tmpforinde #格式化成ext2分区（因为ext3有日志系统，会消耗空间），制定inode大小为 mount -o loop tmpforinde /var/tmp root@eccubuntu:/var# df -h Filesystem Size Used Avail Use% Mounted on none 7.9G 184K 7.9G 1% /dev /dev/mapper/eccubuntu-root 129G 100G 22G 82% / none 7.9G 0 7.9G 0% /dev/shm none 7.9G 64K 7.9G 1% /var/run none 7.9G 0 7.9G 0% /var/lock none 7.9G 0 7.9G 0% /lib/init/rw /dev/sda1 228M 113M 103M 53% /boot /dev/loop0 388M 3.3M 334M 1% /var/tmp root@eccubuntu:/var# df -i Filesystem Inodes IUsed IFree IUse% Mounted on none 2055913 641 2055272 1% /dev /dev/mapper/eccubuntu-root 8536064 8534320 1744 100% / none 2057128 1 2057127 1% /dev/shm none 2057128 39 2057089 1% /var/run none 2057128 3 2057125 1% /var/lock none 2057128 1 2057127 1% /lib/init/rw /dev/sda1 124496 243 124253 1% /boot /dev/loop0 5003712 11 5003701 1% /var/tmp
ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_4188_1.MYI' (Errcode: 28),布布扣,bubuko.com
ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_4188_1.MYI' (Errcode: 28)
原文：http://mogfee.blog.51cto.com/9064191/1535160