t;From: Dan Goodes [mailto:[EMAIL PROTECTED]
-->Sent: Monday, October 27, 2003 7:03 PM
-->To: Chris Nolan
-->Cc: [EMAIL PROTECTED]
-->Subject: Re: Hanging processes in MySQL 3.23.53
-->
-->Using Redhat linux 7.3 with an ext3 FS.
-->
-->Incidentally, I've just manual
Haven't looked at InnoDB, but might have to take a look at it... Up until
recently we haven't had any reason to doubt MyISAM, and it's served us
well, in fact better than we need.
As for syslog - our MySQL logs to a .err file (nothing in syslog), and
there's nothing in that file at all. It does
Get it fixed??!?!? And surrender? No, you can't do that! :-)
Out of curiosity, have you guys looked at InnoDB for this purpose, given it
won't serialise writes? I take it you've seen MyISAM allowing readers to
continue while writes happen as adequate for what you need though?
Additionally, and
I just saw your mail address - you're one of the gurus who runs PlanetMirror,
aren't you? All hail he who provides my Mandrake ISOs! Huzzah! :-)
Hmmpersonally, I don't see how you can do "something wrong" during a
DELETE. This is one of those non-descript problems that give me sleepless
nig
Using Redhat linux 7.3 with an ext3 FS.
Incidentally, I've just manually restarted mysql (which drops all
in-progress processes), and it seems that the problem "takes a while to
show" (i.e. there's a period after a restart that things seem to go along
fine, then it all comes undone). I also should
Which platform are you using? Which FS?
Regards,
Chris
On Tue, 28 Oct 2003 01:14 pm, Dan Goodes wrote:
> Hi folks,
>
> I have a bit of a problem. I'm running 3.23.53 which I've compiled up from
> source (because the RPMs are not an option for me).
>
> I have a process that does a fairly large se
