In article [EMAIL PROTECTED], Sinisa
Milivojevic [EMAIL PROTECTED] writes
MattJ wrote:
It's still possible in the mysql client to request the creation
of an index with indexlength NULL on TEXT fields. This apparently
works okay on creation of the index, insert and select operations, but
breaks horribly (marks table as crashed with corrupted indexes) on
update or delete operations.
Hi!
I have tested your case.
The above bug was already fixed in our BK repository.
Fix will come up in 4.0.1, that is scheduled to come out soon.
Just as a followup to this, this past weekend I installed the BK head
version of mysql-4.0.1-alpha (last changeset 1.980) on the server with
the table-marked-as-crashed problems, and since then, having performed
operations which would have caused a crashed table on the previous
server, the tables have remained clean and functioning -- looks like the
bug is fixed. :-)
It's now been up for just over 75 hours, and it's a fairly busy server:
Uptime: 272983 Threads: 6 Questions: 53688790 Slow queries: 505
Opens: 180 Flush tables: 1 Open tables: 174
Queries per second avg: 196.674
...so the 4.0.1 in BK is looking good! Thanks for your help! :-)
Regards,
--
Matt Johnson [EMAIL PROTECTED]
AVSIM Online!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php