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
<> Install Large File Support Patch

[] Table Operations

Sources :

Joseph Frazier | Create Your Badge

This page has been visited 4,116 times since October 06th, 2009

This is an ApogeeInvent Dynamic Website