List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:September 10 2003 6:34pm
Subject:Re: "ERROR 1030: Got error 127 from table handler"
View as plain text  
On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote:
> Well I don't feel that 4.0.x is mature enough for my environment quite
> yet, although some replication features are actually needed (2 threads
> are better then one).
> 
> I might do a small deploy for some search system and even ratio of write
> / read systems. Yahoo uses 4.0.x right?

Right, we have a lot of 4.0.xx deployed.

> Have any "show stoppers" been experienced since its extensive usage?

None that haven't been fixed by now.  I'm working with one group here
to track down a problem, but we're not sure what the source is yet.
Too many variables have been changed.  It may be FreeBSD, MySQL, or
something else odd going on.

> Can the query cache be disabled with something like
> skip-query-cache?

http://www.mysql.com/doc/en/Query_Cache_Configuration.html

> Are 127 errors less apparent in the 4.0.x environment?

I really can't make a comparison on that.  But 4.0.x is significantly
better and faster in many ways.  I wouldn't think of going back.

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,860,849 queries (452/sec. avg)
Thread
"ERROR 1030: Got error 127 from table handler"Dathan Vance Pattishall10 Sep
  • Re: "ERROR 1030: Got error 127 from table handler"colbey10 Sep
  • Re: "ERROR 1030: Got error 127 from table handler"Jeremy Zawodny10 Sep
    • RE: "ERROR 1030: Got error 127 from table handler"Dathan Vance Pattishall10 Sep
      • Re: "ERROR 1030: Got error 127 from table handler"Jeremy Zawodny10 Sep
  • Re: "ERROR 1030: Got error 127 from table handler"Richard Gabriel10 Sep
RE: "ERROR 1030: Got error 127 from table handler"Tom Roos10 Sep
  • RE: "ERROR 1030: Got error 127 from table handler"Dathan Vance Pattishall10 Sep
    • Re: "ERROR 1030: Got error 127 from table handler"Richard Gabriel10 Sep
      • RE: "ERROR 1030: Got error 127 from table handler"Dathan Vance Pattishall10 Sep