Mysql Got Error 28 From Storage Engine


Got error 28 from storage engine Checked, the disk where the database file is located should be fine, it should be the temporary directory space used by the database is not enough Reference Insufficient temporary space on the disk. Solution: Empty the /tmp directory, or modify the tmpdir parameter in my.cnf to point to a directory with enough space The above statement should be clearer, and there is a similar one: Reference Mysql reported the following wrong solution ERROR 1030 (HY000): Got error 28 from storage engine This problem occurs: Temporary space is not enough to execute this SQL statement Solution: Point tmpdir to a directory with a large hard disk space.


[root@xxxxx logs]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda2 112G 25G 81G 24% / /dev/sda6 965M 18M 898M 2% /tmp /dev/sda3 29G 25G 0 100% /var /dev/sda1 190M 11M 170M 7% /boot tmpfs 1.7G 0 1.7G 0% /dev/shm /home 112G 25G 81G 24% /home

どのMYSQL一時ディレクトリであるかに関係なく、varディレクトリが占有されていることを確認するだけで、いくつか探す価値があります。 / var / log / httpdディレクトリ、多数のWebサイトアクセスログファイル、アクセス、エラーなど、数年間のログファイルのバックログにあります。

[root@xxxxx logs]# find /var/ -size +100000000c You can also execute the above command to find files over 100M under a file.


Number of processes running now: 0 141031 22:17:21 mysqld restarted 141031 Number of processes running now: 0 141031 22:17:21 mysqld restarted 141031 22:17:21 InnoDB: Started log sequence number 4 1212960744 141031 22:17:21 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/' (Errcode: 28) 141031 22:17:21 [ERROR] Can't start server: can't create PID file: No space left on device



service mysqld start