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
>
>
