The confusing thing is, I run the query across the EXACT same code on a different database (old copy of same database), and it works just fine. Are there any ways to peak into what mysql is doing besides "mysqladmin showprocesses"?
Thanks, Chad -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:05 PM To: Chad Arimura Cc: [EMAIL PROTECTED] Subject: Re: Process Sleeping In the last episode (Aug 27), Chad Arimura said: > The search function for our ecommerce site has worked great up until > the other day, but now when a search is ran the whole system just > hangs. Here is what I have found: > > A process is started (search.cgi) that stays open until all of the > memory is used up (sometimes two same-named processes). Then, it > fills up ALL of the swap space until the system is basically unsable. > After about 30 seconds of filling up space and hanging the system, > the process dies and the memory and swap are released, returning the > system to normal condition. > > I ran "mysqladmin processlist" while the system was still responding > (before all swap filled), and all I found was a new mysql process > sleeping, but not doing anything. > > I tried the exact same code with a backed-up version of the database > from a week ago, and the search worked fine. Something in our DB > changed and messed stuff up, but so much is going on it's tough to > figure out. > > My question is, does anyone have a suggestion for pinpointing the > problem? Sounds like a problem in the CGI, where a particular field value or error condition is not handled correctly, and it starts allocating memory out of control. Add some printf()s to your code, or attach to the process with gdb and get a stack trace, or kill -9 the CGI and gdb the corefile. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
