PHP / MYSQL Overloading!? What to do!?
Hi, there!
I have been reading for a while now, and i can`t find any info about what the problem could be.
I running a forum + few other sites that use MYSQL to get their info from.
When i run the forum it had about 60000hits per day and the server run PERFECTLY GOOD!
Now + those other sites and much less hits on the forum im getting a very slow MYSQL + the server keeps overloading!
I have read that not closing a connection wood do some damage, im not sure if i added that on those other sites.. and btw how does one close a connection!?
Thx
Any help is apprisiated!
:::::::::::::::::::: INFO :::::::::::::::::::::
USER: %CPU %MEM Mysql Processes
mysql 38.54 12.24 0.0
Top Process: %CPU 99.9
/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/main.XXXXX.ws.pid --skip-locking
Top Process: %CPU 99.5
/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/main.XXXXX.ws.pid --skip-locking
This is what im getting..!?
I dont know how to edit any of those files and what to do, or how to fix this im willing to pay for help! :)
Subject
Written By
Posted
PHP / MYSQL Overloading!? What to do!?
April 21, 2005 02:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.