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.
[EMAIL PROTECTED] 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
>
>
---------------------------------------------------------------------
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