I have my own server with a few small websites only with html (no php, no mysql) and one busy PhpNuke website with ~ 150-200 users online at teh same time. My server - Pentium4, 2.4 GHz, 1gb RAM.
My problem is MySQL which is eating all CPU and server load only sometimes is under 1.
I know that other people host 100-200 sites wihout any problems and their servers are not overloaded.
I tried to optimize MySQL making changes in my.cnf. I disabled persistent connections, etc, but nothing helps - server load stays at the same level.
I guess these problems is causing PHPNuke (version 6.0) or some modules of PHNuke. My PhPNuke is heavy modified, so, I can't upgrade.
The strange thing is that sometimes at peak time server load is pretty low - about 0.2, but sometimes it starts to grow without any reason and comes back to normal only when I restart MySQL.
Is there any way to detect which script/module is causing problems like this? Are there any tutorials on Internet how to check scripts for most common errors which may cause high usage of MySQL (please do not suggest mysql.com - I am geting lost at this site 🙂 )
I saw many posts in other forums suggesting not to use PHPNuke, but it's too late - as I wrote I have a busy website with more than 5000 registered users, profiles, many thousends pictures in profiles, forums etc - so I can't just change portal software without losing all data.
Here is my MySQL status:
Threads: 1 Questions: 527223 Slow queries: 0 Opens: 255 Flush tables: 1 Open tables: 144 Queries per second avg: 13.052
When I look at processlist, usually there no processes except "show processlist". Sometimes at peak time there are 3-5 processes: "select uid, name, uname, email, femail, url, user_avatar, user_icq, user_occ, user_from..." - this query is from function "getuserinfo". No other queries I can see in the processlist.
I don't know what to do - just a couple months ago I got new, better server thinking that it will help, but nothing. I think it's not that on my server I can hardly host one PHPNuke website and even one site is too much...
Any help would be appreciated.
Thank you.
