How To Extend MyISAM Table Size Limitation

By default, MySQL server only allows a 4GB limitation to MyISAM table size. This prevents further increase of MyISAM table size and thus generates a table full MySQL error. To surpass this limit, here's a quick MySQL tweak to increase the default table size limitation.

Increase MyISAM Table Size Limit

Backup and edit /etc/my.cnf and declare the below MySQL conf directive

myisam_data_pointer_size=6

Save and exit. The above directive instructs MySQL to extend the default MyISAM table size limit when creating new tables. With the above MySQL ISAM config, this will now allow up to 256TB MyISAM table size limit.


Restart MySQL daemon service

# service mysqld restart

All is done.