Hi,
error 136 = No more room in index file
so I suppose it's a problem with the size needed for your keys, maybe that will help:
http://dev.mysql.com/doc/mysql/en/key-space.html
HTH, Melanie
From: CheHax <[EMAIL PROTECTED]> Reply-To: CheHax <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Getting error 136 during an update Date: Tue, 22 Mar 2005 11:31:06 +0100
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]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
