I have a P4 2.4 with 1GB RAM dedicated server 100Mbps net connection
It runs WHM 8.8.0 cPanel 8.8.0-R73 RedHat 9 - WHM X v2.1.2 apache (1.3.29 (Unix)) mysql (4.0.15-standard)
This machine is entirely use for just 1 domain with a vBulletin board. The site has about somewhere from 200+ to 800+ users online concurrent depends on time of the day.
When the number of users about 300- (less than 300) the server seem to react normally (Not Slow)
However, when the number of users increase at night (7mp - 5am PST) the server react extreamly slow (I mean really really slow) and it sometimes refuse to dislay page and not to load images as well.
1. Is this because of MySQL not tuned or Apache not Turned? How do I go about finding what need to fix?
2. I have include the 2 results (when site not busy & busy) of the script Germy provide, with the numbers shown, How I optimize MySQL to be the most efficient for my site?
3. With the hardware I have how many users I could have on the site just to browse the vBulletin board?
Thank you in advance for helping.
Result when site not busy:
Thu Feb 19 15:57:00 PST 2004
15:57:01 up 8:37, 1 user, load average: 0.53, 0.68, 0.72
99 processes: 89 sleeping, 1 running, 9 zombie, 0 stopped
Mem: 1032320k av, 994240k used, 38080k free, 0k shrd, 16036k buff
151248k active, 805548k inactive
Swap: 2104504k av, 936k used, 2103568k free 862944k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
7416 nobody 19 0 1096 1096 752 R 1.9 0.1 0:00 0 top
Http processes currently running = 24
Mysql processes currently running = 3