Hi, About two weeks ago I received "The table Worklist is full" error. Since then I have been struggling to update the table indexes beyond 32 bits as suggested by the MySQL documentation.
I have tried the following methods (I have two identical MySQL databases on two identical computers): - ALTER TABLE Worklist MAX_ROWS=1000000000. This created a new database file (#sql-50c_2829.*) in about 1.5 days. After this, the file sizes remained constant and nothing seemed to be happening. I let it run for 7 days, after which I killed the MySQL process. - Created a new table and did INSERT INTO Worklist_Temp SELECT * FROM Worklist. This has now been running for about 7 days on one of my servers, and it shows no signs of finishing (MySQL 4.0.14b). - As above, but with ALTER TABLE Worklist_Temp DISABLE KEYS. The INSERT phase went through quickly (a few hours). After that I ran ALTER TABLE Worklist_Temp ENABLE KEYS which is now rebuilding the database. It has now been running for 3 days (MySQL 4.0.12). - SHOW PROCESSLIST shows that during the slow periods, the MySQL server is doing "Repair with keycache". As suggested by the documentation, I tried setting myisam_sort_buffer_size to 180 MB (I have 256 MB of memory in the computer). This didn't change anything so I think the indexes were too large to be repaired by sorting. - I have defragmented the disks on both of the computers. - CHECK TABLE Worklist on the original table returns no errors. During this process, I have been using the following MySQL versions: 3.23.49, 4.0.12 and 4.0.14b. The computers are running Windows XP and using NTFS volumes. Both computers are workstation-grade with 1.0 GHz processor, 256 MB RAM and 40 GB HD. The harddrives have about 20 GB free space. If anyone has any ideas how to get this update done, I'd appreciate them a lot! The servers were in production use, and production has been halted for the past 2 weeks because of these problems... How long has MySQL taken for others when upgrading 4 GB databases after the "The table Worklist is full" error? -- Mikko Noromaa ([EMAIL PROTECTED]) - tel. +358 40 7348034 Noromaa Solutions - see http://www.nm-sol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
