I am hoping you can help me figure out where my problems with my Redhat 9 box are occuring.
Its become frequent that about 10 minutes after startup of the machine the mysqld process consumes 99% of the CPU for extended periods of time, ususally until i reboot then it runs normal for a while again.
The network connections are good to the machine and there are only a few users using the box. I think it could be a problem with the php pages and the sql contained in them but do not know how to troubleshoot. Is it possible theres a recursive query running?
I have looked in the mysqld.log file and theres nothing in there as in most other log files i've looked at. I can post at request.
Can someone possibly advise?
Thanks Alot for any and all suggestions.