Re: Frequently corrupt tables

2001-10-22 Thread Bill Adams
I realized that I was using an older version of libmysqlclient. So I recompiled and linked the msql-mysql-modules against mysql-3.23.41... Bill Adams wrote: > o If there is no call to 'flush tables', even a small data load will cause > myisamcheck to report "warning: 1 clients is using or hasn

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 c

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-18 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

Re: Frequently corrupt tables

2001-10-18 Thread Stephen Brownlow
] > Cc: Peter Taphouse; 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

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

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

Re: Frequently corrupt tables

2001-10-18 Thread Heikki Tuuri
vice to other users about what OS versions are the most stable. Regards, Heikki >- Original Message - >From: "Heikki Tuuri" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, October 18, 2001 12:53 PM >Subject: RE: Frequently corrupt table

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 Patrick Sherrill
hat I have experience table corruption has been with MS (NT and 98) due to OS freezes and blue screens. --flush cured those. - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 18, 2001 12:53 PM Subject: RE:

RE: Frequently corrupt tables

2001-10-18 Thread Heikki Tuuri
To: [EMAIL PROTECTED] >> Cc: Peter Taphouse; 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 wo

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'

RE: Frequently corrupt tables

2001-10-18 Thread Steve Meyers
> Cc: Peter Taphouse; 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

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.