16GB index file limit
Hello,
I use MyISAM tables, and one the biggest one brakes after the MYI index file reaches 16GB.
The original DB used 3.23 so I migrated to 4.1.11, but the same problem appeared when the index file reached 16GB.
The error is SQLException: "Got error 136 from storage engine".
I tried creating files larger that 16GB with 'dd' and it works with no problem, so the limitation is not from the filesystem. I also tried ext3 and reiserfs and the result is the same.
Anyone please help.
Subject
Views
Written By
Posted
16GB index file limit
3446
February 01, 2006 03:22AM
2128
February 02, 2006 04:14AM
2075
February 07, 2006 03:26AM
2242
February 07, 2006 03:46AM
2162
February 07, 2006 07:12AM
2005
February 08, 2006 01:43PM
2330
February 09, 2006 03:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.