MySQL Error : The table 'taggregate_temp_1306655760' is full

[postcd]

Hello,

when i click "Run Now" button in Scheduled task (AdminCP) next to Thread views update,
i got this error

Invalid SQL:

	INSERT INTO taggregate_temp_1306655760
		SELECT threadid, COUNT(*) AS views
		FROM threadviews
		GROUP BY threadid;

MySQL Error   : The table 'taggregate_temp_1306655760' is full
Error Number  : 1114

Im on dedicated server

df -h

Filesystem            Size  Used Avail Use% Mounted on
/dev/simfs            157G   52G  105G  33% /
/dev/simfs            157G   52G  105G  33% /var/named/chroot/var/run/dbus

The mentioned table is in this status:

523,842 	MEMORY 	latin1_swedish_ci 	16.1 MiB

# cat /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

tmpdir = /home/mysqltemp
max_allowed_packet = 256M
max_connections = 200
innodb_data_file_path = ibdata1:10M:autoextend:max:50000M


# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Please how can i fix this?

When i add "key_buffer_size = 3.5G" to /etc/my.cnf as recommended by MysqlTuner 1.3, mysql fails to start with "Timeout error occurred trying to start MySQL Daemon."

[ozzy47]

Hmmm, try Repair / Optimize your threadviews table, via the ACP

[postcd]

Thx, i tried to optimise it:

Table Action Message
threadviews Check Warning: 8 clients are using or haven't closed the table properly
threadviews Check Status: OK
threadviews Optimize Status: OK

And tried to run scheduled task again, but result is the same:

MySQL Error : The table 'taggregate_temp_1306655760' is full
Error Number : 1114

I dont want to empty that table if possible, i rather want to prevent this in future..