On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote: > > This seemed like an ideal case to DISABLE KEYS, insert the data and > then ENABLE KEYS based on the MySQL documentation. And running some time > tests proves that this approach runs much faster. > > However, in doing so, the log table becomes corrupted (or at least the > indecies do). > > mysql> select * from log order by log_id; > ERROR 1030: Got error 124 from table handler > > If I execute the same query without the order by clause things behave as > normal. It seems as though the indecies (I've tried several of them) have > become corrupted.
You should send a test caes into MySQL so they can fix the bug. Have you seen the section of the manual that describes how to report a bug and supply the files necessary to repoduce it? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 2 days, processed 83,341,207 queries (385/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
