Hello
I own a forum 500 users active per 10 minutes and 550.000 posts 48.000 members and is very slow in my server:
It needs 5-8 seconds to open a topic
My server is:
# 2x Intel Xeon Quad 5405
# 12GB DDR2 RAM
# 2x SAS disks in Raid 1 15.000 RPM
# 1.000 Mbit unshared port
I use many php files and one database that is less than 1gb and 2 ajax applications in the forum.
I am using Apache and fcgi.
My results:
top
top - 23:39:24 up 5:42, 1 user, load average: 5.40, 6.24, 8.17
Tasks: 346 total, 4 running, 341 sleeping, 0 stopped, 1 zombie
Cpu0 : 27.9%us, 12.6%sy, 0.1%ni, 58.9%id, 0.5%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu1 : 29.2%us, 12.9%sy, 0.1%ni, 54.1%id, 3.6%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu2 : 31.0%us, 13.3%sy, 0.0%ni, 55.2%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 30.9%us, 13.0%sy, 0.0%ni, 55.4%id, 0.5%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu4 : 27.9%us, 12.1%sy, 0.1%ni, 59.4%id, 0.4%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu5 : 25.7%us, 10.8%sy, 0.0%ni, 63.1%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu6 : 30.3%us, 12.4%sy, 0.1%ni, 56.7%id, 0.3%wa, 0.0%hi, 0.2%si, 0.0%st
Cpu7 : 32.2%us, 8.1%sy, 0.0%ni, 56.9%id, 0.8%wa, 0.2%hi, 1.8%si, 0.0%st
Mem: 12306276k total, 4237576k used, 8068700k free, 175844k buffers
Swap: 15623172k total, 0k used, 15623172k free, 1334500k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28487 mysql 15 0 1093m 419m 3212 S 254.4 3.5 132:22.44 mysqld
30632 amorem 16 0 110m 27m 5884 S 15.1 0.2 0:26.36 php5
29115 amorem 15 0 116m 33m 5892 S 13.9 0.3 0:26.73 php5
30686 amorem 15 0 113m 30m 5876 S 13.9 0.3 0:27.38 php5
28171 amorem 16 0 113m 31m 5916 S 12.6 0.3 0:36.20 php5
28880 amorem 16 0 112m 29m 5476 S 12.6 0.2 0:24.62 php5
30664 amorem 16 0 115m 33m 5884 S 8.8 0.3 0:30.49 php5
29061 amorem 15 0 115m 32m 5468 R 7.6 0.3 0:36.57 php5
28262 amorem 15 0 107m 25m 5912 R 6.3 0.2 0:31.99 php5
30634 amorem 15 0 107m 24m 5904 R 3.8 0.2 0:28.08 php5
8627 root 15 0 12872 1304 820 R 2.5 0.0 0:00.03 top
28247 amorem 15 0 110m 27m 5492 S 2.5 0.2 0:30.79 php5
28872 amorem 16 0 107m 24m 5472 S 2.5 0.2 0:22.88 php5
30680 amorem 16 0 107m 24m 5484 S 2.5 0.2 0:13.30 php5
31798 amorem 16 0 112m 29m 5468 S 2.5 0.2 0:27.40 php5
8101 nobody 15 0 60880 3176 1660 S 1.3 0.0 0:00.11 httpd
netstat -apn | grep :80 |wc -l
7784
mysql
\s
Threads: 44 Questions: 340100 Slow queries: 0 Opens: 568 Flush tables: 1 Open tables: 516 Queries per second avg: 126.337
vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
7 0 0 7863236 176584 1337296 0 0 9 42 244 54 29 12 57 1 0
I was read in the forum that is good to have the database in another hard disk but i think it will not work in my scenario as i use raid.
Also i use mysqltuner and sqlprime scripts and all are ok only one message i got:
Table locks acquired immediately: 68%
Reduce lock wait
It seems more configuration or sql problem.
Can litespeed help for that?
Do i have to select or unselecte something at setup so i do not get my problems in litespeed?
I want to have very fast loading with such a server am i asking a lot?
You are my last hope.
I own a forum 500 users active per 10 minutes and 550.000 posts 48.000 members and is very slow in my server:
It needs 5-8 seconds to open a topic
My server is:
# 2x Intel Xeon Quad 5405
# 12GB DDR2 RAM
# 2x SAS disks in Raid 1 15.000 RPM
# 1.000 Mbit unshared port
I use many php files and one database that is less than 1gb and 2 ajax applications in the forum.
I am using Apache and fcgi.
My results:
top
top - 23:39:24 up 5:42, 1 user, load average: 5.40, 6.24, 8.17
Tasks: 346 total, 4 running, 341 sleeping, 0 stopped, 1 zombie
Cpu0 : 27.9%us, 12.6%sy, 0.1%ni, 58.9%id, 0.5%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu1 : 29.2%us, 12.9%sy, 0.1%ni, 54.1%id, 3.6%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu2 : 31.0%us, 13.3%sy, 0.0%ni, 55.2%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 30.9%us, 13.0%sy, 0.0%ni, 55.4%id, 0.5%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu4 : 27.9%us, 12.1%sy, 0.1%ni, 59.4%id, 0.4%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu5 : 25.7%us, 10.8%sy, 0.0%ni, 63.1%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu6 : 30.3%us, 12.4%sy, 0.1%ni, 56.7%id, 0.3%wa, 0.0%hi, 0.2%si, 0.0%st
Cpu7 : 32.2%us, 8.1%sy, 0.0%ni, 56.9%id, 0.8%wa, 0.2%hi, 1.8%si, 0.0%st
Mem: 12306276k total, 4237576k used, 8068700k free, 175844k buffers
Swap: 15623172k total, 0k used, 15623172k free, 1334500k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28487 mysql 15 0 1093m 419m 3212 S 254.4 3.5 132:22.44 mysqld
30632 amorem 16 0 110m 27m 5884 S 15.1 0.2 0:26.36 php5
29115 amorem 15 0 116m 33m 5892 S 13.9 0.3 0:26.73 php5
30686 amorem 15 0 113m 30m 5876 S 13.9 0.3 0:27.38 php5
28171 amorem 16 0 113m 31m 5916 S 12.6 0.3 0:36.20 php5
28880 amorem 16 0 112m 29m 5476 S 12.6 0.2 0:24.62 php5
30664 amorem 16 0 115m 33m 5884 S 8.8 0.3 0:30.49 php5
29061 amorem 15 0 115m 32m 5468 R 7.6 0.3 0:36.57 php5
28262 amorem 15 0 107m 25m 5912 R 6.3 0.2 0:31.99 php5
30634 amorem 15 0 107m 24m 5904 R 3.8 0.2 0:28.08 php5
8627 root 15 0 12872 1304 820 R 2.5 0.0 0:00.03 top
28247 amorem 15 0 110m 27m 5492 S 2.5 0.2 0:30.79 php5
28872 amorem 16 0 107m 24m 5472 S 2.5 0.2 0:22.88 php5
30680 amorem 16 0 107m 24m 5484 S 2.5 0.2 0:13.30 php5
31798 amorem 16 0 112m 29m 5468 S 2.5 0.2 0:27.40 php5
8101 nobody 15 0 60880 3176 1660 S 1.3 0.0 0:00.11 httpd
netstat -apn | grep :80 |wc -l
7784
mysql
\s
Threads: 44 Questions: 340100 Slow queries: 0 Opens: 568 Flush tables: 1 Open tables: 516 Queries per second avg: 126.337
vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
7 0 0 7863236 176584 1337296 0 0 9 42 244 54 29 12 57 1 0
I was read in the forum that is good to have the database in another hard disk but i think it will not work in my scenario as i use raid.
Also i use mysqltuner and sqlprime scripts and all are ok only one message i got:
Table locks acquired immediately: 68%
Reduce lock wait
It seems more configuration or sql problem.
Can litespeed help for that?
Do i have to select or unselecte something at setup so i do not get my problems in litespeed?
I want to have very fast loading with such a server am i asking a lot?
You are my last hope.