In the last episode (Aug 27), Chad Arimura said:
> 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"?
If the
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
ning 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
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 muc
