I experience something similar for a long time and try to find
out what's happening. I cannot see any rule, so far. Any ideas
what I could do to find out?
For some days now, I didn't have problems now except for a
duplicate entry error which shouldn't occur at all. Before, this
indicated a corrupted index and/or table. But now the table is
ok. Puzzling.
BTW: I studied the sections in the manual about what to do if
tables keep crashing.
Sie schrieben am Freitag, 20. Juli 2001, 14:32:18:
> This is the feedback from repair:
mysql>> repair table hits
> -> ;
> +--------------+--------+----------+----------------------------------------
> -----+
> | Table | Op | Msg_type | Msg_text
> |
> +--------------+--------+----------+----------------------------------------
> -----+
> | counter.hits | repair | info | Wrong bytesec: 17-0-197 at 1097180;
> Skipped |
> | counter.hits | repair | warning | Number of rows changed from 8628 to
> 8627 |
> | counter.hits | repair | status | OK
> |
> +--------------+--------+----------+----------------------------------------
> -----+
> 3 rows in set (0.71 sec)
> This has happened at least once a day for the past three days (ever since
> the hit counter got popular.
> This is the version:
> mysql Ver 11.15 Distrib 3.23.38, for apple-darwin1.3.3 (powerpc)
> And some other stats:
> Threads: 6 Questions: 2007 Slow queries: 0 Opens: 14 Flush tables: 1
> Open tables: 4 Queries per second avg: 0.055
> As you can see, it's barely ticking over compared to some installs I've
> seen. Any suggestions where to look for trouble here?
> Walter
> ---------------------------------------------------------------------
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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