Joseph Bueno writes:
> Hello,
>
> I posted message below a few hours ago.
> Since then, I have tried to find how fast indexes become corrupt.
> I have run a CHECK TABLE <table> QUICK
> on different tables in my database and run a
> REPAIR TABLE <table> when an error is reported followed
> by a CHECK TABLE a few seconds later. Here is the output of
> both commands:
>
> mysql> repair table message;
> +-------------------+--------+----------+----------+
> | Table | Op | Msg_type | Msg_text |
> +-------------------+--------+----------+----------+
> | rencontre.message | repair | status | OK |
> +-------------------+--------+----------+----------+
> 1 row in set (1 min 47.13 sec)
>
> mysql> check table message quick;
>
>+-------------------+-------+----------+------------------------------------------------+
> | Table | Op | Msg_type | Msg_text
> |
>
>+-------------------+-------+----------+------------------------------------------------+
> | message | check | error | Key 2 doesn't point at same
> records that key 1 |
> | rencontre.message | check | error | Corrupt |
>
>+-------------------+-------+----------+------------------------------------------------+
> 2 rows in set (1.75 sec)
>
> How is is possible that a table becomes corrupt so fast ?
> What information should I send you in order to help me ?
>
> I am running mysqld Ver 3.23.30-gamma for pc-linux-gnu
> on i686 on a RedHat 6.2 server (bipro PIII 733/2Gb RAM)
>
> We did not have these problems during our integration tests
> so it may be possible that they are related to the high load
> on the production server (between 250 and 300 queries/s).
>
> Thanks for your help
> --
> Joseph Bueno
Hi!
Can you find out commands that will always lead to the table
corruption.
Only if you can make a reproducible test, then we could help you.
Are you using our binary version ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
