Mysql Table Size Limitations

Problem :

	When an insert is attempted into a large database table mysql reports the
	following error "Insert Error The table 'server_stats' is full".

Possible Solutions :
	
	[] Archive Old Data
		<> archive to multiple db tables
			- e.g. server_stats_after_20091001, server_stats_after_20090901, etc.
		<> archive to filesystem
		<> or simply delete
		
	[] Split db table into several tables.
		<> split based upon fields.
		<> split based upon key.
			- eg. new tables called server_stats_1, server_stats_2, etc.
			
	[] Change filesystem and/or kernel
		- http://dev.mysql.com/doc/refman/5.0/en/full-table.html
		<> Install Large File Support Patch 
			- http://www.suse.de/~aj/linux_lfs.html
			
	[] Table Operations
		<> Run OPTIMIZE TABLE
			- http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html

Sources :
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
http://www.suse.de/~aj/linux_lfs.html
http://www.devshed.com/c/a/MySQL/Troubleshooting-Problems-with-MySQL-Programs/5/
http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
http://bugs.mysql.com/bug.php?id=12460