RE: Hanging processes in MySQL 3.23.53

2003-10-28 Thread Dathan Vance Pattishall
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

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
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

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Chris Nolan
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

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Chris Nolan
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

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
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

Re: Hanging processes in MySQL 3.23.53

2003-10-27 Thread Chris Nolan
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

Hanging processes in MySQL 3.23.53

2003-10-27 Thread Dan Goodes
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 select statement every 10 minutes - up until a few days ago it was all find and dandy. A few days ago I did a massi