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? Have any "show stoppers" been experienced since its extensive usage? Can the query cache be disabled with something like skip-query-cache? Are 127 errors less apparent in the 4.0.x environment? -->-----Original Message----- -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 10, 2003 10:48 AM -->To: Dathan Vance Pattishall -->Cc: [EMAIL PROTECTED] -->Subject: Re: "ERROR 1030: Got error 127 from table handler" --> -->On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: -->> -->> /usr/local/mysql/bin/perror 127 -->> Error code 127: Unknown error 127 -->> 127 = Record-file is crashed -->> -->> I've been getting this allot lately from mysql-3.23.54-57. -->> -->> -->> Things that are not the cause: -->> - mySQL has not been improperly shut down -->> - threads are not being killed off -->> -->> -->> Pattern emerged: -->> High Traffic DB up for a month or greater doing a constant 300 -->> queries/sec -->> -->> Question: What is the cause of a Record-file crash? How can this be -->> prevented? Jeremy Zawodny do you have any thoughts on a root cause? --> -->It could be a bug that's been fixed for a while. --> -->Any chance of upgrading to 4.0.xx on that machine? --> -->Jeremy -->-- -->Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --> -->MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,386,790 queries -->(455/sec. avg) --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]