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

Joseph Frazier | Create Your Badge

This page has been visited 3,221 times since October 06th, 2009

This is an ApogeeInvent Dynamic Website