faqts : Computers : Databases : MySQL : General Information

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

53 of 58 people (91%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

Is there a limit on the size of MySQL tables?
Can I create a table greater than 4GB in size?

Jan 27th, 2000 08:35
Nathan Wallace, Sasha Pachev, Sinisa Milivojevic


Versions prior to 3.23 do not support more than 4 GB regardless of the
filesystem limit.

With later versions and the right file system setup many people have
very large tables, some larger then 20 Gb.