keywords: myisam innodb mysql table 4gb
text: Max Table size in MySQL \\It turns out that MySQL  has a terrible upper limit on the max MyISAM table\size.  It appears that innodb doesn't have this problem.\\Jeremy talks about it over on his blog \\"When this happens, the first reaction I hear is "You never told me that MySQL\has a 4GB limit! What am I going to do?" Amusingly, I usually do describe the\limit when I discuss the possibility of using MySQL with various groups--they\often forget or underestimate the impact it will have. Putting that aside, the\problem is easily fixed, as that page explains. You simply need to run an ALTER\TABLE command."\\"And you'll need to wait. That ALTER TABLE is going to take some time. Really."\\Of course Jeremey warns us that ...\\