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
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
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
Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a
little better under very high load.
Steve Meyers
-Original Message-
From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:34 AM
To: [EMAIL PROTECTED]
Cc: Peter Taphouse;
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
Hi!
Well, for one, I believe that Slashdot uses InnoDB tables, which tend to
handle
a little better under very high load.
Steve Meyers
-Original Message-
From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:34 AM To: [EMAIL PROTECTED]
Cc: Peter Taphouse;
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
.
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
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
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?
Hi Matthew,
We had a similar problem that caused us to need to run myisamchk much more
than we wanted to.
It turned out that MySQL was not being shutdown when Unix was.
Symptom: The MySQL server error log did NOT show normal shutdown messages.
Cause 1: The normal method of shutting down MySQL
11 matches
Mail list logo