Vbulletin - ERROR /usr/libexec/mysqld: The table 'session' is full

Vbulletin Forum - ERROR /usr/libexec/mysqld: The table 'session' is full

Если забилась таблица session - сессиями и появляется ошибка в логе mysql:

150213 15:42:21 [ERROR] /usr/libexec/mysqld: The table 'session' is full
150213 15:42:24 [ERROR] /usr/libexec/mysqld: The table 'session' is full
150213 15:42:25 [ERROR] /usr/libexec/mysqld: The table 'session' is full

изменить в my.cnf:

max_heap_table_size=128M

и перезапустить mysqld

The error you are getting has nothing to with the size of /tmp. The session table is a HEAP table. HEAP tables are stored in memory. The default maximum size for HEAP tables is 16MB. Attempting to use more than this will result in the 'table full' error. You just need to increase the max_heap_table_size parameter in your MySQL configuration.

Также проверьте чтобы у Вас работали задания vbulletin которые раз очищают таблицу session:

# cd includes/cron
# grep session *
cleanup2.php:   DELETE FROM " . TABLE_PREFIX . "session
cleanup.php:    DELETE FROM " . TABLE_PREFIX . "session
cleanup.php:    DELETE FROM " . TABLE_PREFIX . "cpsession