[BioSQL-l] trouble cramming genbank

Tim Henderson tjh@alodar.com
Mon, 14 Oct 2002 11:44:00 -0700


Josiah,

According to the MySQL docs at

http://www.mysql.com/documentation/mysql/bychapter/

(See "1.2.4 How big can MySQL tables be?")

MySQL tables by default have a maximum size of "about 4 GB". You can 
check this using the "SHOW TABLE STATUS" command.

If you're trying to load all of GenBank, or even all of the EST 
division, it wouldn't surprise me if you exceeded 4 GB in one or more 
tables.


-- Tim