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