Hello.
The manual recommends to use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table options values. See: http://dev.mysql.com/doc/mysql/en/repair.html CheHax <[EMAIL PROTECTED]> wrote: > Hello there, > > I am receiving "Got error 136 from storage engine" and I need some > light on this matter. > > I have a table with 23,000,000 records and I want to update it with > datas from another one with the exact same amount of rows. The 2 > tables can be linked by a primary key. Both tables are myISAM, and > have not other key than the primary one. The server is a test server, > on WinXP Pro. > > I run an UPDATE, like this one : > > UPDATE tbl1 INNER JOIN tbl2 USING (PKEY) SET tbl1.NUM = tbl2.COL1, > tbl1.ADRESSE = tbl2.COL2, tbl1.CITY = tbl2.COL3; > > It actually updates 6 collumns but the problem does not seem to be here. > > When I run this query, it runs for a bit and then I got : > "Got error 136 from storage engine" > > At first, I thought it would be the filesize limit of 2GB, but this > file size is not valid because I have a NTFS file system. > > So I tried an update like that, just after my error : > > UPDATE tbl1 INNER JOIN tbl2 USING (PKEY) SET tbl1.NUM = tbl2.COL1, > tbl1.ADRESSE = tbl2.COL2, tbl1.CITY = tbl2.COL3 WHERE tbl1.PKEY > > 22000000; > > And it worked fine ! > > And the next one too : > UPDATE tbl1 INNER JOIN tbl2 USING (PKEY) SET tbl1.NUM = tbl2.COL1, > tbl1.ADRESSE = tbl2.COL2, tbl1.CITY = tbl2.COL3 WHERE tbl1.PKEY > > 18000000 and tbl1.PKEY <= 22000000; > > So I am wondering where the problem comes from. It is an issue with > the maximum_join_size ? If so, why didn't I get the real > maximum_join_size error like it is described in the doc ? > > Thank you for your help! > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
