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)