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