Re: myisamchk Error 22 WinServer 2003 Large table
Hello, Further searching for this problem reveals that it was reported as a bug: http://bugs.mysql.com/bug.php?id=779 but for Version 3. Does this mean that the fix was not implemented in Version 4? What is the workaround for this? Do I have to load the table while creating the indices? This runs for a VERY long time. The table I loaded is marked as broken - do I need to start over or can I fix it? The recommendation from myisamchk (use the -f to fix the table) resulted in the same Error 22. Unless I have missed something (likely ), this seems like a pretty major bug - is MySQL just not the right RDB to be using for tables this size? -Jim Gallagher >Hello, >I am following the advice of the manual when bulk loading a large table by turning >off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The >>mysamchk build of the indices fails: >myisamchk: warning: Can't change size of indexfile, error: 22 >myisamchk: error: 22 for record at pos 121201294124 >myISAM-table 'mytable' is not fixed because of errors >This process works successfully on "small" tables (37 GB) on another 2003 machine. >What am I doing wrong? I'm new to MySQL, and am just finding my way. The command >I'm issuing is: >myisamchk -O sort_buffer_size=512M -O key_buffer_size=768M -O read_buffer_size=512M >-O write_buffer_size=512M -rq d:\mysql\data\mydb\mytable >I have 4GB of memory on the machine. >I searched for this problem with Google and found several others with the same >problem, but didn't find a solution. >Thanks, >Jim Gallagher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk Error 22 WinServer 2003 Large table
Hello, I am following the advice of the manual when bulk loading a large table by turning off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk build of the indices fails: myisamchk: warning: Can't change size of indexfile, error: 22 myisamchk: error: 22 for record at pos 121201294124 myISAM-table 'mytable' is not fixed because of errors This process works successfully on "small" tables (37 GB) on another 2003 machine. What am I doing wrong? I'm new to MySQL, and am just finding my way. The command I'm issuing is: myisamchk -O sort_buffer_size=512M -O key_buffer_size=768M -O read_buffer_size=512M -O write_buffer_size=512M -rq d:\mysql\data\mydb\mytable I have 4GB of memory on the machine. I searched for this problem with Google and found several others with the same problem, but didn't find a solution. Thanks, Jim Gallagher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk Error 22 WinServer 2003 Large table
Hello, I am following the advice of the manual when bulk loading a large table by turning off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk build of the indices fails: myisamchk: warning: Can't change size of indexfile, error: 22 myisamchk: error: 22 for record at pos 121201294124 myISAM-table 'mytable' is not fixed because of errors This process works successfully on "small" tables (37 GB) on another 2003 machine. What am I doing wrong? I'm new to MySQL, and am just finding my way. The command I'm issuing is: myisamchk -O sort_buffer_size=512M -O key_buffer_size=768M -O read_buffer_size=512M -O write_buffer_size=512M -rq d:\mysql\data\mydb\mytable I have 4GB of memory on the machine. I searched for this problem with Google and found several others with the same problem, but didn't find a solution. Thanks, Jim Gallagher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]