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 Jeremy 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 16:55:03 PST 2004
16:55:04 up 9:35, 0 users, load average: 1.20, 1.42, 1.24
113 processes: 108 sleeping, 1 running, 4 zombie, 0 stopped
Mem: 1032320k av, 1003632k used, 28688k free, 0k shrd, 37436k buff
154672k active, 810984k inactive
Swap: 2104504k av, 936k used, 2103568k free 823300k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
17311 nobody 13 0 1088 1088 748 R 1.9 0.1 0:00 0 top
Http processes currently running = 36
Mysql processes currently running = 3
Key Reads/Key Read Requests = 0.000096 (Cache hit = 99.999904%)
Key Writes/Key Write Requests = 0.960247
Connections/second = 2.483 (/hour = 8939.866)
KB received/second = 8.783 (/hour = 31619.251)
KB sent/second = 7.370 (/hour = 26531.916)
Temporary Tables Created/second = 0.417 (/hour = 1502.356)
Opened Tables/second = 0.003 (/hour = 10.014)
Slow Queries/second = 0.000 (/hour = 0.104)
% of slow queries = 0.000%
Queries/second = 59.012 (/hour = 212441.723)
MySQL Query Cache hits = 0/1685434(0%)
=========================
Result when site busy (I'll update tonight when the site get busy)
Last edited by Tony; 02/19/2004 7:57 PM.