Hello In a forum i have: top top - 22:24:04 up 9 days, 17:11, 1 user, load average: 18.37, 18.19, 18.52 Tasks: 715 total, 1 running, 620 sleeping, 47 stopped, 47 zombie Cpu(s): 19.0%us, 7.3%sy, 0.0%ni, 72.4%id, 1.1%wa, 0.0%hi, 0.2%si, 0.0%st Mem: 8181620k total, 7292876k used, 888744k free, 243748k buffers Swap: 16386260k total, 35040k used, 16351220k free, 2417060k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 30039 mysql 15 0 2965m 1.8g 3400 S 255.1 23.3 495:58.45 mysqld 10614 root 15 0 13136 1496 732 R 5.5 0.0 0:00.05 top 8728 nobody 15 0 67100 3700 1916 S 1.8 0.0 0:00.07 httpd 10015 nobody 15 0 67100 3656 1880 S 1.8 0.0 0:00.02 httpd 1 root 15 0 10348 700 584 S 0.0 0.0 0:10.96 init netstat -apn | grep :80 |wc -l 5784 mysql \s Threads: 90 Questions: 1502363 Slow queries: 81 Opens: 888 Flush tables: 1 Open tables: 763 Queries per second avg: 160.853 Server is: # 2x Intel Xeon Quad 5405 # 8192 MB FB DDR2 RAM # 500 GB 7.200 RPM Sata2 # 1.000mbit Unshared What i must do to do it a lot faster as it is very slow?
what server OS? list memory usage by proc, whats taking most of mem? what apache you use? apache worker or prefork,that is. you run php right? check your IO, your disk sounds slow. did you install some php caching and acceleration modules? deal with your slow queries in mysql. better, hire somebody who knows how to fine tune LAMP.
Hello, You should optimize your apache and mysql that really helps to improve performance. However, before you you should know what exactly causing slowness. Thanks
@wgcom i am using Centos 64bit latest Apache 2.2.12 Prefork Php 5 and i was test xcache and it was great super speed but the statistics and shoutbox messages was not acurate... I was thinking also about my HD I/O but i don't know how to check my disk if it is my problem? Please give me some info about this... Thank you
consider to install worker, its optimized for high performance and lots of memory check out memcache or memcached for some caching for php check IOwaits with sysstat, vmstat check your syslog and messages for errors check whats going on with your memory usage, WTF, 8 Gigs RAM almost all used? you have like half mil uniques per day or something? looks like mysql eating CPU, fine tune it , query/key caches , buffers, etc. DEAL WITH SLOW QUERIES!
vmstat: [root@server ~]: vmstat procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 15 0 209616 921956 326008 3610160 0 0 1 148 4 3 20 8 71 1 0