Re: Frequently corrupt tables

2001-10-19 Thread Matthew Bloch
On Thu, 18 Oct 2001, Kyle Hayes wrote: On Thursday 18 October 2001 09:45, Bill Adams wrote: Matthew Bloch wrote: I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause

Re: Frequently corrupt tables

2001-10-19 Thread Bill Adams
Spoiler: You may be right about the bad libs... Kyle Hayes wrote: On Thursday 18 October 2001 12:31, Bill Adams wrote: Hmm, 2.2 doesn't do SMP really well. However, its drawbacks are limited to underuse of the CPUs rather than any kind of corruption or other issue. You would get much

Re: Frequently corrupt tables

2001-10-19 Thread Bill Adams
Bill Adams wrote: Spoiler: You may be right about the bad libs... [snip] *** OMG *** But haha I cannot believe this, I was just looking at the libraries linked by mysqld with ldd and it is using the informix libpthread.so. Hmm, crap. *me slaps head* Small Update: o If there is no call

Frequently corrupt tables

2001-10-18 Thread Matthew Bloch
Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening once every few days and it's becoming a pain.

RE: Frequently corrupt tables

2001-10-18 Thread Steve Meyers
; Alec O'Donnell Subject: Frequently corrupt tables Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk

Re: Frequently corrupt tables

2001-10-18 Thread Bill Adams
Matthew Bloch wrote: I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening once every few days and it's

RE: Frequently corrupt tables

2001-10-18 Thread Heikki Tuuri
; Alec O'Donnell Subject: Frequently corrupt tables Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk

Re: Frequently corrupt tables

2001-10-18 Thread Kyle Hayes
On Thursday 18 October 2001 09:45, Bill Adams wrote: Matthew Bloch wrote: I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with

Re: Frequently corrupt tables

2001-10-18 Thread Heikki Tuuri
. Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 18, 2001 12:53 PM Subject: RE: Frequently corrupt tables Hi! Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a little better under very

Re: Frequently corrupt tables

2001-10-18 Thread Bill Adams
Kyle Hayes wrote: I found yesterday (at the advice of this list) that adding an occasional call to FLUSH TABLES fixed my corruption problems. I would do that right before the disconnect or program exit. What kernel are you using? Some of the 2.4 series have... odd... behavior with

Re: Frequently corrupt tables

2001-10-18 Thread Kyle Hayes
On Thursday 18 October 2001 12:31, Bill Adams wrote: Kyle Hayes wrote: I found yesterday (at the advice of this list) that adding an occasional call to FLUSH TABLES fixed my corruption problems. I would do that right before the disconnect or program exit. What kernel are you using?

Re: Frequently corrupt tables

2001-10-18 Thread Stephen Brownlow
O'Donnell Subject: Frequently corrupt tables Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening