List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 18 2001 1:13pm
Subject:Re: Help needed on mysql!!
View as plain text  
What do you mean by "better" ?

Next time it hangs, check your disk freespace.
When MySQL runs out of tmp workspace, it waits until some becomes
available.



fidodido@stripped wrote:
> 
> Help!
> I have set up a web server with PHP4, RH7 and MySQL 3.23.32.
> After surfing for sometime, the browser will be in a forever loading
> mode.
> I use mysqladmin processlist to take a look and I saw processes
> with the command "sleep" (it could be just 1 "sleep" process).
> 
> Everytime I encounter this, I have to restart httpd server.
> 
> Qn: How can I optimize apache, or php or mysql so that it won't "sleep"?
>        Where should I modify to have no such problem again?
> 
> With a better machine config with same os/softwareconfiguration,
> it seems to have no such problem...does that mean it is due to hardware?
> 
> Please help.
> TIA!!
> 
> Regards
> 
>
Thread
Help needed on mysql!!fidodido18 Apr
  • Re: Help needed on mysql!!Gerald Clark18 Apr