Server Optimization Request

[Wings900]

We moved to a new dedicated server, away from our virutal server.

1. is this on dedicated or shared virual server
Dedicated

2. your server specs. For example:
cpu speed/type single or dual cpus): Single 2.4ghz Celeron
how much memory installed: 1GB
hard drive type/configuration: Dual IDE, one mounted for system, other as backup, not configured for RAID
linux distributor or windows version: RH Enterprise3 - 2.4.21-27.0.2.EL
Apache/IIS version: apache 1.3.33
PHP version: php 4.3.10
MySQL version: mysql 4.0.23-standard

3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
Not that we know of

4. if possible how mysql was compiled/installed
Unknown

5. your top stats

13:21:05 up 18 days, 21:36, 1 user, load average: 0.21, 0.35, 0.34
153 processes: 152 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 2.9% 0.0% 1.9% 0.0% 0.9% 2.9% 91.2%
Mem: 1026988k av, 899012k used, 127976k free, 0k shrd, 207076k buff
661192k actv, 145460k in_d, 14480k in_c
Swap: 2040212k av, 104588k used, 1935624k free 490192k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
9228 root 20 0 1192 1192 892 R 1.9 0.1 0:00 0 top
25661 nobody 15 0 43032 41M 36528 S 0.9 4.0 7:08 0 httpd
26091 nobody 15 0 41980 39M 35784 S 0.9 3.9 7:37 0 httpd
9225 nobody 15 0 6368 5228 4088 S 0.9 0.5 0:00 0 httpd
1 root 15 0 116 84 56 S 0.0 0.0 0:06 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:02 0 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:01 0 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
5 root 15 0 0 0 0 SW 0.0 0.0 0:36 0 kswapd
6 root 15 0 0 0 0 SW 0.0 0.0 8:12 0 kscand
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
16 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_0
17 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 scsi_eh_1
20 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
75 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
1463 root 15 0 0 0 0 SW 0.0 0.0 0:05 0 kjournald
1537 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1595 root 15 0 0 0 0 SW 0.0 0.0 0:05 0 kjournald
1621 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1730 root 15 0 0 0 0 SW 0.0 0.0 0:05 0 kjournald
1778 root 15 0 0 0 0 SW 0.0 0.0 0:36 0 kjournald
3371 root 15 0 284 268 200 S 0.0 0.0 0:08 0 syslogd
3375 root 15 0 176 164 116 S 0.0 0.0 0:01 0 klogd
3394 root 15 0 168 152 108 S 0.0 0.0 0:00 0 mdadm
4387 named 25 0 3748 3444 1656 S 0.0 0.3 0:00 0 named
4388 named 15 0 3748 3444 1656 S 0.0 0.3 2:06 0 named
4392 named 15 0 3748 3444 1656 S 0.0 0.3 0:00 0 named
4393 named 15 0 3748 3444 1656 S 0.0 0.3 0:32 0 named
4414 root 15 0 472 424 348 S 0.0 0.0 0:01 0 xinetd
4524 root 15 0 396 368 288 S 0.0 0.0 0:00 0 crond
4535 wnn 24 0 3416 4 0 S 0.0 0.0 0:00 0 jserver
4846 root 15 0 120 108 64 S 0.0 0.0 0:00 0 rhnsd
4874 root 25 0 68 4 0 S 0.0 0.0 0:00 0 portsentry
4913 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4914 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4915 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4916 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4917 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4919 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4920 root 23 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
4933 root 15 0 432 208 132 S 0.0 0.0 0:01 0 pure-ftpd
4938 root 15 0 220 80 36 S 0.0 0.0 0:00 0 pure-authd
27541 mailnull 15 0 1712 1452 1368 S 0.0 0.1 0:03 0 exim
27548 mailnull 15 0 1580 1244 1240 S 0.0 0.1 0:00 0 exim
27575 root 15 0 1428 1324 1060 S 0.0 0.1 0:01 0 antirelayd
32398 root 18 0 3152 2412 1548 S 0.0 0.2 0:14 0 chkservd


6. your mysql configuration variables
http://www.wings900.com/mysql.txt

7. your mysql extended-status output
http://www.wings900.com/mysqlextended.txt

8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
There are two instances of VB, postnuke, photopost and custom written software

9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average between 50-100, cookie time out is 900

10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.wings900.com/phpinfo.php

11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive OFF
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150

12. what version of vB are you running ?
3.07 (both installs)

13. MISC
We have Turckmmcache installed

[eva2000]

try this new /etc/my.cnf below and restart mysql server


[mysqld]
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[Wings900]

Thanks! will give it a try now...

-t