Which Command To See What Is Causing High Server Load.
May 18, 2007Which command do we type to see what is causing a high server load?
I've restarted the VPS numerous of times, and I wish to found out the problem
Which command do we type to see what is causing a high server load?
I've restarted the VPS numerous of times, and I wish to found out the problem
It's been a while since I've posted in this area of the forum, but was just wondering if by now someone or some company has developed a script/software that you can install on your server that will tell you the exact area where the high CPU load is coming from, such as from someone sending email, a certain users account, and etc?
Most times, you have to be mointoring your server at the time of the high load to be exactly sure of what is causing the high load, so, I'm talking about something that will email you right on the spot of the high load in case you are away and will know what caused it.
Most I've seen only tell you that you have a high load, but don't tell you what exactly caused it.
In my server iowait is causing high load, how do we find out which are all users taking memory that could cause my server to use swap memory.
server : linux centos/Cpanel
I have tried the below commands, but how do we locate user specific,
ps aux --sort -vsz | head -25
vmstat 1
I just got a new hard drive installed, and am copying files from another drive to that one.
When using the cp command, load spikes to around 20-30. Before that it was at around 0.5.
Is it normal that simply copying files creates such a high load?
i have 10 web sites running on my server, but they are really small talking about traffic, according to statistics, my "star web site" have 300 visits per day
I also have a few shoutcast services running on my server, but i think ther are fine
According to cpanel, yesterday I had this cpu usage (only showing the top process)
User Domain %CPU %MEM MySQL Processes
nobody 79.10 25.07 0.0
and here you go a copy op "top" command in shell
Cpu(s): 39.5%us, 57.8%sy, 0.0%ni, 20.6%id, 0.0%wa, 0.0%hi, 1.2%si, 0.0%st
Mem: 2065856k total, 1464804k used, 601052k free, 71616k buffers
Swap: 2048276k total, 0k used, 2048276k free, 955020k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
10345 nobody 20 0 29484 16m 3360 R 21 0.8 0:41.87 httpd
10874 nobody 20 0 20416 9792 2852 R 20 0.5 0:10.19 httpd
10340 nobody 20 0 25748 12m 2928 R 14 0.6 0:28.20 httpd
4309 sc_dieg2 20 0 44288 4116 1788 S 1 0.2 0:18.59 sc_serv
4176 sc_maxi 20 0 37004 2816 1064 S 1 0.1 0:14.76 sc_serv
4244 sc_salme 20 0 37004 2688 1080 S 1 0.1 0:12.73 sc_serv
4316 sc_dieg3 20 0 44288 4392 1752 S 1 0.2 0:17.48 sc_serv
4352 sc_sergi 20 0 39684 3264 1320 S 1 0.2 0:19.24 sc_serv
4413 sc_eddyo 20 0 39684 2892 1368 S 1 0.1 0:16.68 sc_serv
4420 mexicanr 20 0 38524 1916 588 S 1 0.1 0:11.28 sc_serv
4534 sc_entor 20 0 38680 2720 1264 S 1 0.1 0:13.05 sc_serv
9547 root 20 0 2388 1076 796 R 1 0.1 0:09.37 top
4116 sc_jocuh 20 0 36848 1988 576 S 0 0.1 0:11.25 sc_serv
4553 sc_aleja 20 0 89004 8332 6864 S 0 0.4 0:11.94 sc_serv
6829 120 20 0 5988 2156 1664 S 0 0.1 0:01.64 glftpd
11166 root 20 0 7044 2332 1868 S 0 0.1 0:00.01 sshd
1 root 20 0 2136 644 556 S 0 0.0 0:00.82 init
2 root 15 -5 0 0 0 S 0 0.0 0:00.00 kthreadd
3 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/0
4 root 15 -5 0 0 0 S 0 0.0 0:00.18 ksoftirqd/0
5 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
6 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/1
7 root 15 -5 0 0 0 S 0 0.0 0:00.13 ksoftirqd/1
8 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/1
9 root 15 -5 0 0 0 S 0 0.0 0:00.02 events/0
10 root 15 -5 0 0 0 S 0 0.0 0:00.02 events/1
11 root 15 -5 0 0 0 S 0 0.0 0:00.00 khelper
62 root 15 -5 0 0 0 S 0 0.0 0:00.08 kblockd/0
63 root 15 -5 0 0 0 S 0 0.0 0:00.17 kblockd/1
66 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid
67 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify
196 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue/0
197 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue/1
199 root 15 -5 0 0 0 S 0 0.0 0:00.00 ksuspend_usbd
205 root 15 -5 0 0 0 S 0 0.0 0:00.00 khubd
I tried to kill all "nobody" process, and then is everythin OK but after 5 minutes is happening again, the worst thing is that every minute this cpu usage is increasing untillall my web sites crashes (just website , shoutcast service works fine)
the process os "nobody" is: /usr/local/apache/bin/httpd -k start -DSSL
For the past few days, one of the server is causing a bandwidth utilization surge for the entire rack on almost daily basis. It happen for a few minutes and it went off then it will be the same thing again the next day. When the surge is happening, most of the servers on the same segment will be inaccessible for the few minutes.
The bandwidth utilization graph for my rack is recording an abnormal surge from (6mbps --> 90mbps) for the few minutes. My MRTG is showing 2 of the Plesk servers giving the problem but the NOC guys said it the Cpanel that causing the problem.
I tried logging in to both servers but could not find what's the cause for this.
I have a cPanel server with 4GB RAM
My server hangs time to time, once or twice a day. This is the last status when it happens.
Server Load 75.90 (2 cpus)
Memory Used 92 %
Swap Used 65.78 %
When I was still inside SSH when it happens, the processes I can see inside "top" are a lot of httpd processes.
So I "killall -9 httpd", I had to do it 30~40 times
#killall -9 httpd
#killall -9 httpd
#killall -9 httpd
x 30~40 times until no pid process found & the server load is back to normal.
Before that, I check httpd fullstatus, they look very normal, same goes to what I see inside WHM Apache status & cpu usage status.
At first I thought it was a memory problem after consulting with a server admin, so I replaced all 4GB new ram stick (such a waste)
My server is very slow, High CPU, High Apache load....
I got a new server and i had setup a script on it.
No server tweaks has been done.
I run a filehosting site so it gets very slow when traffic is high.
Here is some info:
Code:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4135 filedip 19 0 12812 8892 2212 R 18.9 0.4 0:00.74 index.cgi
3140 apache 15 0 22624 9604 2768 S 17.3 0.5 1:54.45 httpd
3556 apache 15 0 22792 9592 2768 S 17.3 0.5 0:43.53 httpd
3739 apache 15 0 22672 9556 2744 S 17.3 0.5 1:09.67 httpd
3884 apache 15 0 22664 9560 2744 S 17.3 0.5 0:23.98 httpd
3474 apache 15 0 22672 9572 2756 R 16.1 0.5 1:34.09 httpd
3548 apache 15 0 22792 9560 2740 S 16.1 0.5 1:33.67 httpd
3991 apache 15 0 22640 9588 2756 S 15.1 0.5 0:22.44 httpd
3475 apache 15 0 22672 9580 2756 S 13.2 0.5 1:31.42 httpd
3493 apache 15 0 22664 9592 2768 S 12.9 0.5 1:15.52 httpd
3769 apache 15 0 22664 9580 2756 S 12.9 0.5 0:45.19 httpd
3638 apache 15 0 22664 9576 2756 S 12.3 0.5 0:32.82 httpd
3724 apache 16 0 22664 9580 2756 R 12.3 0.5 0:34.25 httpd
3626 apache 15 0 22672 9580 2756 S 11.7 0.5 0:52.54 httpd
4023 apache 16 0 22792 9560 2740 R 11.3 0.5 0:13.16 httpd
3882 apache 15 0 22664 9576 2756 S 10.1 0.5 0:38.56 httpd
3005 apache 15 0 22672 9588 2768 R 9.1 0.5 2:06.61 httpd
I dont know much about server managment...
how to fix this so server doesnt go slow?
I have a site that is eating up my server resources and need to know what the best solution for this is. I'm thinking of getting another server just for mysql but do not know what specs the server should be to handle the current traffic/database load and have the site run smoothly without slowing down to a snail's pace.
An alternative is to get another server just for the videos being served and leave the database and html on the current server. This is where I'm stuck and don't know what route to take with this.
My current server stats:
Dual Xeon 5130
4GB RAM
250GB
50 Mbit/sec
CentOS 3.9
Website traffic stats:
15,000 visitors/day
150,000 pageviews/day
Serving videos
I've attached screenshots of top and bandwidth usage per day. Hopefully with this information you could tell me if I need another server or if there are any things I can do to the current server to help things move faster.
Server is Xeon 3060, 3GB Ram, 250GB SATA-II HDD. I followed the recommendations made by mysqlprimer tuner script.
top - 11:54:33 up 237 days, 15:01, 1 user, load average: 6.06, 2.80, 1.65
Tasks: 133 total, 2 running, 131 sleeping, 0 stopped, 0 zombie
Cpu(s): 13.0% us, 4.9% sy, 0.0% ni, 24.3% id, 57.8% wa, 0.0% hi, 0.0% si
Mem: 3114144k total, 3096468k used, 17676k free, 30220k buffers
Swap: 2096440k total, 32348k used, 2064092k free, 2515412k cached
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
8610 nobody 16 0 28 1:37.73 0.7 78908 20m 16m S lsphp4
10520 nobody 16 0 3 0:01.97 0.4 78788 10m 6884 S lsphp4
26474 nobody 15 0 2 15:04.07 0.4 14196 11m 3216 S lshttpd
28275 mysql 22 6 1 131:28.83 7.4 733m 224m 2700 S /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pi
Code:
[mysqld]
max_connections=500
max_user_connections=300
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=64M
query_cache_type=1
interactive_timeout=60
wait_timeout=60
connect_timeout=6
thread_cache_size=128
key_buffer_size=640M
max_allowed_packet=16M
table_cache=2048
join_buffer=1M
sort_buffer=2M
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
safe-show-database
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#log_slow_queries=/var/log/mysql/mysql_slow-queries.log
long_query_time=3
tmp_table_size=32M
max_heap_table_size=32M
#log-queries-not-using-indexes=/var/log/mysql/mysql_queries_no-indexes.log
join_buffer_size=2M
low_priority_updates=1
read_rnd_buffer_size=2M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Whenever there are a lot of members online on my forum, the iowait shoot up, >30% and often times hovering at 60%. It'll eventually drop down to normal levels. However, during the high iowait, there are over 2.5GB of free memory according to the command, free -m
is it due to mysql not optimized or other processes? I don't think the bottleneck is on the cpu or ram.
Can someone figure out by the screenshot, if my CPU is really
97% iddle, and what can be causing these average load numbers?
How to find what Perl script is causing high CPU usage?
I logged into my CentOS box tonight and notice after viewing the output of the "top" command that there are the following lines of output that have me concerned. What command can I use to find the source of the Perl script that is causing the CPU spike?
It seems it's been running for some time too.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30120 apache 25 0 6908 4544 1216 R 99.8 0.2 13416:07 perl
30654 apache 25 0 8028 4508 1212 R 99.4 0.2 13417:22 perl
21273 apache 25 0 7584 4528 1200 R 98.1 0.2 2225:12 perl
20516 apache 25 0 6760 4540 1232 R 96.8 0.2 2221:30 perl
do you know what my server having very strange problem my server load suddenly increas after every 2 or 3 days some time after 1 days but when we talk about those days in which server load is fine then that time server load very low almost 0.4 to 0.1 .
But on that high load day server load reached upto 500.
when i try to find out what wrong then i only get that there is too much connection of http when i kill httpd through this killall -KILL httpd then server load suddenly decrease and then stable.
I have a couple of sites that are generating errors because the server load is too high and when I check service status I am seeing the following: Server Load 21.49 (8 cpus)
How can I tell if the problem is one of my sites in my VPS or a different site on a different VPS on the same server?
server load is too high, can you suggest why too many process of qmail-smtpd even i stopped qmail and there is no more 25 emails in queue.
top - 22:26:03 up 8 days, 5:56, 0 users, load average: 150.96, 150.27, 142.68
Tasks: 183 total, 150 running, 33 sleeping, 0 stopped, 0 zombie
Cpu(s): 99.0% us, 1.0% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4167500k total, 146416k used, 4021084k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20168 qmaild 25 0 3468 1432 1168 R 3.3 0.0 2:55.27 qmail-smtpd
20208 qmaild 25 0 3468 1432 1168 R 3.3 0.0 2:43.98 qmail-smtpd
20320 qmaild 25 0 3468 1432 1168 R 3.3 0.0 2:38.56 qmail-smtpd
20425 qmaild 25 0 3468 1432 1168 R 3.3 0.0 2:31.09 qmail-smtpd
20444 qmaild 25 0 3468 1432 1168 R 3.3 0.0 2:27.97 qmail-smtpd
5413 qmaild 25 0 3468 1432 1168 R 3.3 0.0 1:00.38 qmail-smtpd
5705 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:57.91 qmail-smtpd
5763 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:57.40 qmail-smtpd
5806 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:56.99 qmail-smtpd
5999 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:55.98 qmail-smtpd
7318 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:53.39 qmail-smtpd
7639 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:51.43 qmail-smtpd
7866 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:50.29 qmail-smtpd
7980 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:49.59 qmail-smtpd
8023 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:49.29 qmail-smtpd
8101 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:48.48 qmail-smtpd
9253 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:47.40 qmail-smtpd
9355 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:46.78 qmail-smtpd
9386 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:46.48 qmail-smtpd
9525 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:45.84 qmail-smtpd
9611 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:45.81 qmail-smtpd
9854 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:44.89 qmail-smtpd
9974 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:44.08 qmail-smtpd
11272 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:42.29 qmail-smtpd
11331 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:42.09 qmail-smtpd
11482 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:41.69 qmail-smtpd
11652 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:40.99 qmail-smtpd
12040 qmaild 25 0 3468 1432 1168 R 3.3 0.0 0:39.41 qmail-smtpd
3530 qmaild 25 0 3468 1432 1168 R 3.0 0.0 1:08.48 qmail-smtpd
12246 qmaild 25 0 3468 1432 1168 R 2.0 0.0 0:38.79 qmail-smtpd
I know there are thousands of topics about this and yes i did use search function to try doing some changes myself and didnt wanna hijack someone else's topic so started my own
well my problem is i run a torrent site which puts a lot of load on my server. Just got upgraded to P4 2.8 ghz with 2GB ram , iam running fedora with WHM/Cpanel
i will do anything with server to put load down cos of load i have turned off my 4 other big sites ...
there are lot of sessions /task running of httpd by user nobody.
Due to this my server load going very high.
I am use opreting system fadora and cpanel latest version.
the site is running fine..
i have increased my maxclients from 256 to 320 ( reset all same ) my load has increased from avg 3 to 8.. is it a prob?
I've got a server that suddenly over the last three days has exploded as far as server load. Watching top I have some httpd processes that are using up all of the cpu and lasting for quite some time. How can I find out more about these hanging processes? I need to track this down as quickly as possible and find out what the cause is.
View 13 Replies View RelatedWe have an abnormal server load because of clamd.
View 4 Replies View Relatedif upgrading to that new server that I'll mention will probably solve my problems. Whatever help you can provide would be greatly appreciated. Below are the details:
In the GMT evenings and nights my current server gets so loaded that every page load takes 10 - 30 seconds. Even the pure html pages will be so slow to load. It seems that after a certain treshold it just suddenly becomes that much slower. Not much middleground there. I have high MaxClients and ServerLimit values now and the error log doesn't say that they are exceeded anymore but that didn't help enough.
I have a high traffic website that is using latest version of apache (2.2.x) with the prefork MPM and apache is optimized, PHP 5.2.5 and APC 3.0.15.
I get 160,000 - 210,000 pageloads per day. 32,000 - 45,000 visits per day.
Most of its pages are PHP but shouldn't be too CPU or databes intensive. Mysql isn't used and I mostly used sharedmem (php's shm functions) for databases. 2 semaphores are quite heavily used but that can't explain how a few more users would make the server serve pages so much slower.
Swap usage is practically 0 and CPU user % usage is like 1 - 2 % and CPU system % is also about the same even during peak times. However the Average Load or whatever that "top" reports is 6 - 9.
My current server scecs: 1 GB Ram, Pentium D 3 ghz, CentOS 5 32bit fully updated.
I load all pictures and even the stylesheet from a secondary server by using href="$secondaryserverIP..." in the html code, so the main server practically just serves the pages.
My new server will have apache with the worker MPM and latest versions of every software. Also its specs are: 2 GB of RAM, Intel Dual Core Xeon 2.40GHz, CentOS 5.1 32bit fully updated.
I have a sophisticated netstat based ddos script that is an improved version of DDoS Deflate and while some of these slowdowns seem to have been caused by attacks that it then was able to defend me from, most of them are not. I am even protected from users who constantly have 7+ connections to my site and if someone has a way too high number of connections, the script won't even check if it constantly has it and the script just bans that user outright. It probably is banning a bunch of innocent proxy users too but that is a small price to pay.
Alright we just bought a new customer aboard with a ChatBox on the site it seems as if this chatbox is causing higher load we went from 0.00 to 0.68-1.12 now this happened on our old server before too with another chatbox. They use vBulletin any ideas as to what would be causing this?
View 5 Replies View RelatedWhen i check the server status is shows a high server load.
How do I lower the server load? it looks like for mysql activity.
MySQL the last few days seems to be constantly the most demanding process in top, which it never was before. As far as I can tell, nothing has substantially changed with regards to traffic to MySQL driven sites on the server. Is there anything that might be wrong with the databases, etc., that might throw MySQL into a tizzy?
View 8 Replies View RelatedI would like to know how to check load via ssh and check files causing load?
I want the ssh codes for 2 different set of control panels, one with cpanel+whm and other with kloxo+hypervm
and I would also know how to check the files causing the load, such as some files could have been interrupted while processing, so they could be causing load some times, so I want to stop such processes if any are running on the vps on my friends accounts
I have two quad core processors and load is like 15.
May it be caused by switch if it doesnt let traffic trough properly?
if dmesg grep eth shows 100 full duplex is it normal or should it be 1000 full duplex?
how can I make it 1000 full duplex on centos 5?
Quote:
0000:0a:02.0: eth0: (PCI Express:2.5GB/s:Width x4)
0000:0a:02.0: eth0: Intel(R) PRO/1000 Network Connection
0000:0a:02.0: eth0: MAC: 3, PHY: 5, PBA No: ffffff-0ff
0000:0a:02.0: eth1: (PCI Express:2.5GB/s:Width x4)
0000:0a:02.0: eth1: Intel(R) PRO/1000 Network Connection
0000:0a:02.0: eth1: MAC: 3, PHY: 5, PBA No: ffffff-0ff
ADDRCONF(NETDEV_UP): eth0: link is not ready
0000:0a:02.0: eth0: Link is Up 100 Mbps Full Duplex, Flow Control: RX/TX
0000:0a:02.0: eth0: 10/100 speed: disabling TSO
ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
ADDRCONF(NETDEV_UP): eth1: link is not ready
0000:0a:02.0: eth1: Link is Up 100 Mbps Full Duplex, Flow Control: RX/TX
0000:0a:02.0: eth1: 10/100 speed: disabling TSO
ADDRCONF(NETDEV_CHANGE): eth1: link becomes ready
eth0: no IPv6 routers present
eth1: no IPv6 routers present
ADDRCONF(NETDEV_UP): eth0: link is not ready
0000:0a:02.0: eth0: Link is Up 100 Mbps Full Duplex, Flow Control: RX/TX
0000:0a:02.0: eth0: 10/100 speed: disabling TSO
ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
ADDRCONF(NETDEV_UP): eth1: link is not ready
0000:0a:02.0: eth1: Link is Up 100 Mbps Full Duplex, Flow Control: RX/TX
0000:0a:02.0: eth1: 10/100 speed: disabling TSO
ADDRCONF(NETDEV_CHANGE): eth1: link becomes ready
eth0: no IPv6 routers present
eth1: no IPv6 routers present
I am currently hosting my website on one server with the specs:
2.8ghz Dual Quad-Core processor + 8 gigs of ram + two 500 hard drives with a 50 mbps unmetered bandwidth package.
My current problem lies in high server loads and very slow server performance throughout the day.
I am considering migrating over to The Planet onto server with the specs:
3.0ghz Dual Quad-Core + 18 gigs of ram + two 50gb hard drives with 2TB of monthly bandwidth transfer.
In an attempt to have great bandwidth pricing and server performance, I plan on downgrading my current server with my current host to a lowe-end server and keeping it only to host my VIDEO and MUSIC files with the 50mbps unmetered package. The Planet will then host my database and all other web related files on their new server.
Is this a good idea as an attempt to save money in bandwidth costs and eliminating my server lag issues?
I was offered a setup of a separate web and database server at my current host but from what I have read, no one touches the performance and reliability The Planet has to offer.
I have server load like 40.
Nothing lags.
Server has RAM usage 20% and CPU usage goes up to 25%
Swap isnt used at all.
Should I be afraid of server crash incase server load goes up to 60 or 80 without ram and cpu usage rising that much?
So the site got featured on [url]and now the server is drowning...
The Coppermine Gallery usually hovers around 30~50 users daily and now, 1800, and im at a lost as how I should configure mysql to take on such a load. right now it takes about 10 secs or more to load a page and sometimes it would time out. Because it si coppermine, all pages are dynamic and can't be cached -_-"
Here's the my.cnf right now after i played around with the numbers
server spec
Opteron 170 (2ghz)
2gb ram
250 7200rpm
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#skip-networking
back_log = 75
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
max_connections = 600
connect_timeout = 100
wait_timeout = 12000
tmp_table_size = 100M
max_heap_table_size = 64M
max_allowed_packet = 15M
max_connect_errors = 9999999
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 40M
query_cache_size = 150M
query_cache_type = 1
query_prealloc_size = 65536
tmp_table_size = 64M
query_alloc_block_size = 131072
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
httpd.conf
Timeout 20
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
##
## Server-Pool Size Regulation (MPM specific)
##
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 200
MaxClients 200
MaxRequestsPerChild 1500
</IfModule>
# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>