| Hi, | | what table-typ do you use ? | | rg Walter | | -----Originalnachricht----- | Von: Jared Richardson | An: win...@lists.mysql.com; mys...@lists.mysql.com | Cc: Jared Richardson | Gesendet: 04.06.02 14:17 | Betreff: Bug related to large tables and it's indexes on Win2k | | 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! | | | --------------------------------------------------------------------- | Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" | before | posting. To request this thread, e-mail win3...@lists.mysql.com | | To unsubscribe, send a message to the address shown in the | List-Unsubscribe header of this message. If you cannot see it, | e-mail win3...@lists.mysql.com instead. |