Re[2]: Trouble with mysql
Hi! Peter == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Michael, Peter Thursday, June 28, 2001, 11:41:57 PM, you wrote: Peter I'm getting this again and again with two tables which are used in Peter quite the same fation - some selects, often updates, rare inserts, no Peter deletes: mysql repair table counter.quickstat; Peter +---++--+--+ Peter | Table | Op | Msg_type | Msg_text | Peter +---++--+--+ Peter | counter.quickstat | repair | warning | Number of rows changed from 168034 to 168022 | Peter | counter.quickstat | repair | status | OK | Peter +---++--+--+ Peter 2 rows in set (10.72 sec) Next time the table gets corrupt, please upload a copy to 'secret' before you repair it so that I can take a look at this when I come back. Do you have anything in the logs about the table being automaticly repaired? Regards, Monty - 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
Re[2]: Trouble with mysql
Hello Michael, Thursday, June 28, 2001, 11:41:57 PM, you wrote: I'm getting this again and again with two tables which are used in quite the same fation - some selects, often updates, rare inserts, no deletes: mysql repair table counter.quickstat; +---++--+--+ | Table | Op | Msg_type | Msg_text || +---++--+--+ | counter.quickstat | repair | warning | Number of rows changed from 168034 to 168022 || | counter.quickstat | repair | status | OK || +---++--+--+ 2 rows in set (10.72 sec) mysql check table counter.counterlayers type=EXTENDED; +---+---+--+---+ | Table | Op| Msg_type | Msg_text || +---+---+--+---+ | counter.counterlayers | check | error| Record-count is not ok; is 168138 |Should be: 168181 | | counter.counterlayers | check | warning | Found 43 deleted blocks Should be: |0| | counter.counterlayers | check | error| Corrupt || +---+---+--+---+ 3 rows in set (2.51 sec) mysql repair table counter.counterlayers; +---++--+--+ | Table | Op | Msg_type | Msg_text || +---++--+--+ | counter.counterlayers | repair | warning | Number of rows changed from 168181 to |168138 | | counter.counterlayers | repair | status | OK || +---++--+--+ 2 rows in set (1.55 sec) MW Any change you can start mysqld with --log-bin, so that you can verify MW this if this happens again? It's allready running in such mode. I've checked the logs for delete statements - there are not any of them. Now I've started .38 version to check if it's mysql fault. -- Best regards, Petermailto:[EMAIL PROTECTED] - 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