XF 1.1 MySQL database server log file

[xml]

in the past few days around 1pm to 2pm ( peak time of traffic ) i am getting this error in the server error log:

Zend_Db_Adapter_Mysqli_Exception: Lost connection to MySQL server at 'sending authentication information', system error: 32 - library/Zend/Db/Adapter/Mysqli.php:333

when i checked MySQL database server log file i found huge number of lines in MySQL database server log file

Number of processes running now: 0
071004 00:51:31  mysqld restarted
071004  0:51:31  InnoDB: Started; log sequence number 0 45456
071004  0:51:31 [ERROR] /usr/sbin/mysqld: Error writing file '/sdb/mysql/user.theplanet.host.pid' (Errcode: 28)
071004  0:51:31 [ERROR] Can't start server: can't create PID file: No space left on device

what does it mean and how to fix it?

 

[Paul B]

No space left on device

Looks like you need to free up some space on the disk.

 

[Mike]

Looks like one of your drives is out of space -- whatever /sdb is.

 

[xml]

drives still have space


to clerify,
mysql database is located in the sdb drive for performance reasons
all my board tables are MyISAM not InnoDB
InnoDB is enabled on /etc/my.cnf

 

[Adam Howard]

It is possible, depending on how much you've got running and how many users you have.... That your /tmp which only has 109MB free, is filling faster then it is flushing out. I have seen that before, but it's kind of rare as Linux works memory differently.

This is a guess. But if you really do have a busy site, it would be something you should look into and monitor.

/var/log/mysqld log​

Will give your some hints.​