Can you check you keys_used status var. You may have run out of your key_buffer cache so things might take a much longer amount of time.
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->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 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 note that the database is -->being written to almost-constantly (it's being used as an apache logger -->process via mod_log_sql). --> -->-dan --> --> -->On Tue, 28 Oct 2003, Chris Nolan wrote: --> -->> 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 select statement every 10 -->> > minutes - up until a few days ago it was all find and dandy. -->> > -->> > A few days ago I did a massive delete from one of the tables (getting -->rid -->> > of a lot of old records), and since then things have gone awry. The -->select -->> > statement seems to get "stuck" in the "COPY TO tmp table" stage, and -->> > starts to back up fairly heavily. Each of the cron-run processes gets -->to -->> > this "COPY TO TMP TABLE" stage and locks up, which consumes all -->available -->> > slots on the server and the whole things comes to a grinding halt. -->> > -->> > I've already run an optimize table on the table, and that got rid of -->all -->> > the "empty space" freed up by the delete. -->> > -->> > Any ideas why, after the massive delete, things have started slowing -->right -->> > down (or locking up entirely)? -->> > -->> > THanks for help. -->> > -->> > -Dan -->> --> -->-- -->Regards, --> -->Dan Goodes : Systems Programmer : [EMAIL PROTECTED] --> -->Help support PlanetMirror - Australia's largest Internet archive -->by signing up for PlanetMirror Premium : http://planetmirror.com --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
