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?
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.
I run a web counter/tracking service on a dedicated server with 2x SATA discs (RAID1). There are about 100 MySQL queries per second, most of them are served from RAM cache, about 10-20 per second are inserts directly to disc.
My question: is it possible that this load physically damages the discs over time so that the disk crashes sooner or later?
I have a linux server that is only hosting one site , and although the httpd and mysql are working well , then the server load is high and when I restart the server the server load is high till the swap accelerates to 100% and then it uses the memory alot.
View 5 Replies View RelatedI was wondering is someone can shed some light on a curious situation for me. I am running a linux server (Gentoo) and the CPU usage spikes to 90-100% but the load of the server when viewed by top is only 0.4 - 1.5 (max). The memory is OK with .5 gig free and there is no paging going on. So my question is: Is this server over used or not?
Below is the output of top 3 times over aprox 2 min... please enlighten me... :-)
top - 17:39:57 up 3 days, 10 min, 1 user, load average: 0.55, 0.66, 0.66
Tasks: 66 total, 2 running, 64 sleeping, 0 stopped, 0 zombie
Cpu(s): 27.3% us, 0.0% sy, 0.0% ni, 72.0% id, 0.7% wa, 0.0% hi, 0.0% si
Mem: 2058848k total, 2037140k used, 21708k free, 176904k buffers
Swap: 2008116k total, 168k used, 2007948k free, 618380k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5501 sdb 25 0 570m 202m 18m S 26.3 10.1 1076:22 kernel
5579 root 19 0 2107m 729m 33m S 1.0 36.3 188:28.30 java
4814 root 16 0 30336 2360 1832 R 0.3 0.1 0:00.04 sshd
1 root 16 0 2560 556 472 S 0.0 0.0 0:00.20 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
3 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 19 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
5 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
7 root 10 -5 0 0 0 S 0.0 0.0 0:01.20 kblockd/0
10 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
75 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
74 root 15 0 0 0 0 S 0.0 0.0 0:17.43 kswapd0
660 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
716 root 16 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
720 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
737 root 15 0 0 0 0 S 0.0 0.0 0:12.73 kjournald
788 root 21 -4 2560 512 420 S 0.0 0.0 0:00.01 udevd
4944 root 15 0 5024 824 596 S 0.0 0.0 0:00.01 syslog-ng
5357 root 16 0 17124 1772 1396 S 0.0 0.1 0:00.00 sshd
5370 root 16 0 56260 3704 2420 S 0.0 0.2 0:03.88 apache2
5437 ntp 16 0 15848 4656 3548 S 0.0 0.2 0:00.10 ntpd
5473 root 16 0 8956 788 644 S 0.0 0.0 0:00.04 cron
5483 apache 15 0 56120 3512 2236 S 0.0 0.2 0:00.00 apache2
5490 sdb 15 0 16992 1772 1476 S 0.0 0.1 0:00.27 vserver
5491 sdb 20 0 16992 1708 1416 S 0.0 0.1 0:00.00 vserver
5496 sdb 16 0 49444 7232 5928 S 0.0 0.4 0:00.74 kernel
5566 root 18 0 8736 1300 1076 S 0.0 0.1 0:00.00 run.sh
top - 17:40:39 up 3 days, 10 min, 1 user, load average: 0.55, 0.65, 0.65
Tasks: 66 total, 2 running, 64 sleeping, 0 stopped, 0 zombie
Cpu(s): 95.0% us, 0.3% sy, 0.0% ni, 4.7% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2058848k total, 2037264k used, 21584k free, 176908k buffers
Swap: 2008116k total, 168k used, 2007948k free, 618448k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5501 sdb 25 0 570m 202m 18m S 83.6 10.1 1076:44 kernel
5579 root 19 0 2107m 729m 33m S 10.7 36.3 188:29.79 java
3738 sdb 15 0 23660 2056 1628 S 0.3 0.1 0:00.15 vserver
1 root 16 0 2560 556 472 S 0.0 0.0 0:00.20 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0
3 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 19 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
5 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
7 root 10 -5 0 0 0 S 0.0 0.0 0:01.20
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 just moved from a P4 Dual Core (2mb cache) to a Dual Xeon (512k cache) and everything has gone to sh*t.
I had the server optimized/security hardened (for the most part) and last night, I had a RAM upgrade to 4GB.
As soon as the server came back up after the upgrade, CPU usage was into the mid hundreds. RAM usage is fine....
Presently, I'm showing PHP using a ton of CPU. I tweaked mysql a little bit, and that helped slightly.
Also, last night, I had the DC run diagnostics on the RAM and hard drive. Both check out OK.
Here's the specs:
2x Intel Xeon 2.80GHz
4GB RAM
cPanel
CENTOS Enterprise 5.2 i686
PHP 5.x
MySQL 5.x
Exim
When viewing TOP or status in WHM, php scripts use the most CPU. With average CPU load around 60+
a few times, my host contacted me and said that my account is suspended due to high usage of server resources.
I have 3 sites using SMF (a forum script.) I have around 8500 visitors and 3 million page views per month in total.
can this be a reason of high usage?
if it's what's the meaning of terabyte traffic limit ? which you can never use
I asked to my host if they could let me know what's causing high server resources usage. here is the answer:
We do not know which domain or script caused this high usage, it is your responsibility to investigate. I would suggest that you go through your raw access logs to see the most requested pages and then investigate those further. After you find the pages responsible, please optimize them so you are not using so many server resources.
so if a host wants simply to restrict traffic limit, they have a pre-reason under hand.high server usage! yes but how will I know that? how will I trust that it's true?
when I ask why my sites are down, they can easily tell me that it's because of high server usage!
for the last few days, i am facing high memory usage up to 90%.
Memory usage get's high, even if i don't have many visitors online. I have to restart httpd to get the memory to normal. some times, server loads, get's high aswell.
In error logs (only unusual things i see):
Code:
[Sat Jan 6 10:37:04 2007] [error] mod_gzip: TRANSMIT_ERROR:ISMEM:104
[Sat Jan 6 10:37:25 2007] [error] mod_gzip: TRANSMIT_ERROR:ISMEM:104
# top:
Code:
top - 10:42:19 up 10:35, 1 user, load average: 22.95, 10.67, 9.79
Tasks: 318 total, 1 running, 317 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.7% us, 1.3% sy, 0.0% ni, 0.0% id, 61.9% wa, 36.1% hi, 0.0% si
Mem: 2009652k total, 1220736k used, 788916k free, 28756k buffers
Swap: 6224564k total, 135212k used, 6089352k free, 389768k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6365 root 0 -20 0 0 0 D 40 0.0 3:01.33 loop0
4553 root 16 0 3112 1108 760 R 1 0.1 0:00.30 top
327 root 15 0 0 0 0 S 0 0.0 6:33.15 kjournald
3743 nobody 15 0 18592 7260 2320 S 0 0.4 0:00.21 httpd
3833 nobody 15 0 21664 10m 2780 D 0 0.5 0:00.94 httpd
3838 nobody 15 0 20472 9400 2664 S 0 0.5 0:00.18 httpd
3858 nobody 15 0 18876 7616 2388 S 0 0.4 0:00.82 httpd
3919 nobody 16 0 21492 10m 2432 D 0 0.5 0:00.82 httpd
3931 nobody 15 0 18976 8016 2716 D 0 0.4 0:00.45 httpd
4439 nobody 15 0 18892 7612 2368 S 0 0.4 0:00.16 httpd
4913 root 18 0 2512 292 244 D 0 0.0 0:00.24 sync
1 root 16 0 2484 488 456 S 0 0.0 0:06.16 init
2 root RT 0 0 0 0 S 0 0.0 0:00.11 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:06.66 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.16 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.71 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:14.59 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:42.07 events/1
this looks suspisous to me:
6365 root 0 -20 0 0 0 D 40 0.0 3:01.33 loop0
as it's taking alot of memory. i don't see this before.
This is my free -m
total used free shared buffers cached
Mem: 1998 1903 95 0 45 542
-/+ buffers/cache: 1315 683
Swap: 2662 36 2625
Not good ....
I got 5 wordpress and 5 statics website on this server and 100 visitors by 24H00 each day.
Question 1 : Why the memory is so low and the swap so high ?
Question 2 : Why i don't find high usage process in top command ?
Question 3 How can i resolve this problem ?
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.
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 RelatedWhat is an alternative to help reduce the massive amounts of cpu resources a CPanel Backup Wizard causes when doing generating a full backup?
View 9 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 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.
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>
a topic long time ago that my server load is frequently high.
I'm talking about something like this
Server Load 158.86
Memory Used 28.2 %
Swap Used 99.57 %
[url]
The only way to solve this problem is to identify the load earlier and kill all httpd process. What I did was
#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.
On previous thread, I tried to update mysql & php and it works,
Right now again I am experiencing high server load again...
I'm very sure it's caused by httpd but I am still unable to find out the real cause of the problem and which account user is the culprit for causing this high load.
Can someone assist me by telling me where/how to begin with?