On Sat, Mar 10, 2001 at 06:41:20PM -0500, Justin wrote:
>
> Today I was having more index corruption problems.. the fact that it
> typically happens on the *biggest* and *busiest* tables leads me to
> believe that the request rate on my database might be right off the
> scale compared to other users, who are not reporting corruptions
> nearly as often.
>
> My corruption issues on any given table seem to have risen as a
> function of average request ratio times table size.
>
> Please, if you can do a mysqladmin extended-status and report to me
> or the list what your questions/uptime is if it is >= where I am,
> and whether or not you need to to use isamchk frequently, or if you
> have no issues.
>
> Today the ratio is currently 304 (3.7million questions and 12000
> seconds of uptime), but weekdays it is over 500 / sec ..
Hm... I've had numbers higher than that for several hours at a time
without trouble.
What OS are you on? Did you compile your own mysql, or are you using
one of the provided binaraies?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
