Hi all, When large tables are being addressed, we seem to have encountered a bug related to having large indexes on the table.
We have several tables in our system that have reached 4 gigs in size. We altered the table definition to allow it to get larger... this is our current table creation statement (for the table giving us trouble, not the entire system) CREATE TABLE IcAlias( IcAliasID BIGINT NOT NULL PRIMARY KEY, mID VARCHAR(255) NOT NULL, IcEntityID BIGINT NOT NULL, IcTypeID SMALLINT NOT NULL, IcDupSortID VARCHAR(255) NOT NULL, INDEX mIDIdx (mID), INDEX IcTypeIDIdx (IcTypeID), INDEX IcEntityIDIdx (IcEntityID), INDEX IcDupSortIDIdx (IcDupSortID)) AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295; Before we added the AVG_ROW_LENGTH and MAX_ROWS settings, we generated a table that was 4 gigs in size and an index that was over 6 gigs. Now the table fails when the index file approaches 4 gigs (actually 3.5 something)! We are getting this message when trying to insert data: "Error: Can't change size of indexfile, error: 22, when using table: icalias" We originally saw this in 3.23.36 and have reproduced it in the latest 4.0 alpha download. The platform is a Windows 2000 box running on dual Athlons (1900+ I think) with 4 gigs of ram and a 135 gig raid. I've spent a lot of time looking in Deja and on the MySql site and have not found a solution to this problem. Given that it takes 12 hours or so to build this table, it takes a while to test any attempts at a fix. Any help would be ~greatly~ appreciated! I really don't know what to try next! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
