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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
