Load Average: 3.49, 3.79, 3.80
Feb 5, 2007
optimize MySql i have load average: 3.49, 3.79, 3.80
my server have more than 200 web site working online i have so many Mysql process ..
my server info:
CPUs:
Quote:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 3.00GHz
Processor #1 speed: 2993.075 MHz
Processor #1 cache size: 2048 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(TM) CPU 3.00GHz
Processor #2 speed: 2993.075 MHz
Processor #2 cache size: 2048 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(TM) CPU 3.00GHz
Processor #3 speed: 2993.075 MHz
Processor #3 cache size: 2048 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(TM) CPU 3.00GHz
Processor #4 speed: 2993.075 MHz
Processor #4 cache size: 2048 KB
Memory Information:
Quote:
Memory: 5190364k/5767168k available (1877k kernel code, 51280k reserved, 759k data, 184k init, 4325120k highmem)
System Information:
Quote:
Linux 2.6.9-42.0.8.ELsmp #1 SMP Tue Jan 23 13:01:26 EST 2007 i686 i686 i386 GNU/Linux
PHP Version: 4.4.4
MySQL Version: 4.1.21-standard
MySql Settings :
Quote:
[mysqld]
skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=500
interactive_timeout=60
wait_timeout=30
connect_timeout=10
thread_cache_size=96
thread_concurrency=2
key_buffer=8M
join_buffer=1M
max_allowed_packet=24M
table_cache=1024
record_buffer=1M
sort_buffer_size=1024K
read_buffer_size=1024K
max_connect_errors=10
read_rnd_buffer_size=1024K
myisam_sort_buffer_size=16M
socket=/var/lib/mysql/mysql.sock
key_buffer_size=16M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
open_files_limit=4096
[mysqldump]
quick
max_allowed_packet=8M
max_allowed_packet=8M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8
write_buffer=8M
[myisamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8M
write_buffer=8M
[mysqlhotcopy]
interactive-timeout
View 13 Replies
ADVERTISEMENT
Apr 29, 2009
If everyone can take a look at this (while all domains were turned off) and give me any advice to what is eating up resources so badly? The load averages are at 1.3+ with only yum trying to run on the box and it has already been running to nearly two hours were this would typically take 10-15 minutes max prior.
Host: FutureHost
Type: VPS
DC: Dallas
Plan: VPS Elite with 1.5GB of memory
top - 11:40:21 up 2:26, 2 users, load average: 1.35, 1.39, 1.37
Tasks: 41 total, 1 running, 40 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1572864k total, 202300k used, 1370564k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 15 0 1988 664 572 S 0 0.0 0:02.57 init
3572 admin 15 0 24488 9308 6072 S 0 0.6 0:00.11 php-cgi
3643 admin 15 0 24488 9324 6088 S 0 0.6 0:00.10 php-cgi
3685 apache 18 0 7940 3688 876 S 0 0.2 0:06.49 lighttpd
3686 admin 25 0 24076 7684 5096 S 0 0.5 0:00.05 php-cgi
3689 admin 25 0 24080 7684 5096 S 0 0.5 0:00.05 php-cgi
3690 admin 25 0 24080 7692 5096 S 0 0.5 0:00.05 php-cgi
3692 admin 20 0 24076 7684 5096 S 0 0.5 0:00.05 php-cgi
3693 admin 20 0 24076 7684 5096 S 0 0.5 0:00.05 php-cgi
3790 admin 20 0 24080 7688 5096 S 0 0.5 0:00.05 php-cgi
3905 admin 20 0 24072 7680 5096 S 0 0.5 0:00.05 php-cgi
4053 admin 20 0 24072 7680 5096 S 0 0.5 0:00.05 php-cgi
5252 admin 20 0 24080 7688 5096 S 0 0.5 0:00.06 php-cgi
5415 admin 15 0 24368 8820 5748 S 0 0.6 0:00.06 php-cgi
5628 admin 20 0 24076 7684 5096 S 0 0.5 0:00.06 php-cgi
5734 root 18 0 9844 2804 2268 S 0 0.2 0:00.52 sshd
5828 root 15 0 2516 1408 1116 S 0 0.1 0:00.02 bash
View 7 Replies
View Related
May 8, 2009
I have a VPS, and i wanted to know if the CPU / Load Average that shows at my Plesk control panel reports only the usage of my part of the server cpu, or if it is the real/complete cpu usage for the entire server?
So in a simple way, is another user with a vps at the same server is doing a high cpu task at is vps, will it show at my plesk cpu load average?
View 9 Replies
View Related
Jul 8, 2007
What Should be load average of a VPS to be called as IDEAL?
View 12 Replies
View Related
Oct 22, 2009
I have to move about 50 GB each night from one server to another.
This is the command I'm using:
Code:
/bin/nice -n +19 scp -c blowfish -l 18000 -P 22222 root@XX.XX.XX.XX:/backup/dailybacks/*.tar.gz ./
There is no private lan so i have to use internet. I'm using blowfish, which will reduce cpu load, and also limiting bandwidth transfer, usign -l 18000. How ever, I still do see some high load averages..
Do you have any other suggestion to optimize CPU performance while running scp?
View 6 Replies
View Related
Jun 20, 2009
Why my server - load average is high?
below is output of top:
top - 13:52:53 up 29 days, 5:39, 3 users, load average: 72.05, 68.90, 67.89
Tasks: 857 total, 2 running, 833 sleeping, 20 stopped, 2 zombie
Cpu(s): 4.2%us, 2.5%sy, 0.0%ni, 26.4%id, 63.6%wa, 0.5%hi, 2.8%si, 0.0%st
Mem: 8181908k total, 8135188k used, 46720k free, 35104k buffers
Swap: 4192956k total, 26624k used, 4166332k free, 7321172k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
337 mysql 15 0 327m 56m 4252 S 4.0 0.7 74:18.53 mysqld
24732 root 15 0 13380 1760 808 R 1.0 0.0 0:10.44 top
313 root 10 -5 0 0 0 S 0.3 0.0 90:25.28 kswapd0
22040 nobody 15 0 63148 3272 1572 S 0.3 0.0 0:00.30 httpd
22136 nobody 15 0 63148 3260 1572 S 0.3 0.0 0:00.21 httpd
22291 nobody 15 0 63148 3280 1580 S 0.3 0.0 0:00.18 httpd
22327 nobody 16 0 63148 3280 1580 D 0.3 0.0 0:00.20 httpd
22406 nobody 15 0 63148 3276 1580 S 0.3 0.0 0:00.18 httpd
22522 nobody 16 0 63148 3268 1580 S 0.3 0.0 0:00.10 httpd
23553 nobody 16 0 63148 3244 1556 S 0.3 0.0 0:00.09 httpd
23556 nobody 15 0 63148 3256 1568 S 0.3 0.0 0:00.09 httpd
26260 nobody 16 0 63148 3296 1608 S 0.3 0.0 0:00.13 httpd
26618 nobody 16 0 63148 3244 1556 S 0.3 0.0 0:00.13 httpd
28849 nobody 16 0 63148 3240 1556 S 0.3 0.0 0:00.04 httpd
28903 nobody 15 0 63148 3208 1532 S 0.3 0.0 0:00.02 httpd
29533 nobody 15 0 0 0 0 Z 0.3 0.0 0:00.02 httpd <defunct>
29558 nobody 15 0 63148 3236 1548 S 0.3 0.0 0:00.01 httpd
29587 nobody 15 0 63148 3216 1536 S 0.3 0.0 0:00.01 httpd
29592 nobody 15 0 63148 3208 1532 S 0.3 0.0 0:00.02 httpd
1 root 15 0 10344 576 544 S 0.0 0.0 0:05.36 init
2 root RT -5 0 0 0 S 0.0 0.0 3:58.90 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 6:15.52 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:12.33 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:30.07 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:02.57 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:02.84 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:11.61 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:01.12 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.22 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.10 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.16 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.09 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
87 root 10 -5 0 0 0 S 0.0 0.0 0:00.03 kthread
94 root 10 -5 0 0 0 S 0.0 0.0 0:00.78
View 14 Replies
View Related
Aug 15, 2008
My site is running really slow at the moment. I checked Virtuozzo for resource usage, and it has been saying this for the past 1/2 hour.
CPU Usage: 0%
Load Average: Varies between 0.88 and 1.3 (anything over 1 is full capacity, and critical)
How can the load average be maxed out when my site hardly uses any CPU usage?
View 6 Replies
View Related
Dec 19, 2008
I have a server with Core2Duo E6600 CPU, 4 gigs of RAM and 2x250 GB HDD's. What is the "normal" load average I can expect having ~50 websites running on it with medium visits. My current load averages (and most of the time ones) are:
load average: 0.24, 0.13, 0.16
Is this "normal"?
View 12 Replies
View Related
Apr 19, 2007
What would you call a high load average? What is the top number?
Does this look unhealthy?....
1:48PM up 562 days, 18:14, 4 users, load averages: 11.15, 9.11, 6.48
2:14PM up 562 days, 18:39, 4 users, load averages: 0.85, 2.38, 3.94
View 9 Replies
View Related
Dec 5, 2007
I have a new Quad core server which has a high load average. Only hosting about 200 sites on it and they are not database sites. Only a few MySQL sites.
Here is the output from top:
top - 15:12:06 up 13 days, 16:38, 1 user, load average: 14.66, 14.21, 12.81
Tasks: 247 total, 4 running, 241 sleeping, 0 stopped, 2 zombie
Cpu(s): 7.9%us, 6.6%sy, 0.0%ni, 79.6%id, 5.9%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3369172k total, 3244620k used, 124552k free, 6296k buffers
Swap: 2096472k total, 5180k used, 2091292k free, 2499476k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29439 apache 18 0 148m 101m 4516 D 13 3.1 19:57.79 httpd
29444 apache 18 0 146m 98m 3668 R 12 3.0 11:15.56 httpd
1883 apache 18 0 147m 99m 3584 D 11 3.0 6:08.36 httpd
30263 apache 18 0 146m 99m 4116 D 11 3.0 14:58.88 httpd
1881 apache 18 0 147m 99m 3656 D 10 3.0 2:43.73 httpd
1884 apache 18 0 147m 99m 3632 D 10 3.0 4:15.96 httpd
4768 apache 18 0 149m 102m 4312 R 10 3.1 0:39.93 httpd
29443 apache 18 0 146m 98m 3620 D 10 3.0 24:53.11 httpd
30209 apache 18 0 147m 100m 4228 D 8 3.1 8:25.29 httpd
2230 apache 17 0 154m 108m 5048 D 8 3.3 0:02.94 httpd
1886 apache 18 0 147m 100m 3984 R 7 3.0 1:27.71 httpd
1882 apache 15 0 153m 106m 5328 S 3 3.3 0:01.68 httpd
8795 root 15 0 0 0 0 D 1 0.0 0:00.08 pdflush
273 root 10 -5 0 0 0 S 1 0.0 0:39.82 kswapd0
1984 root 10 -5 0 0 0 D 0 0.0 2:09.22 kjournald
5113 mysql 15 0 135m 33m 5460 S 0 1.0 15:55.22 mysqld
View 3 Replies
View Related
Nov 6, 2009
i`m using csf + lfd on the server ( CentOS / Cpanel )
i have received the notification from my root user regarding the "High 5 minute load average "
i have just checked my apache but couldn`t find any problem , everything is normal , But what`s the notification for ?
Note : The email included 3 files ( Apache status files )
Time: Sat Nov 7 00:34:48 2009 +0330
1 Min Load Avg: 8.28
5 Min Load Avg: 8.26
15 Min Load Avg: 8.26
Running/Total Processes: 11/171
View 8 Replies
View Related
Apr 4, 2008
how to auto reboot when load average =5. and send an email to me before reboot.
View 3 Replies
View Related
Apr 27, 2007
I am trying just to extract the 5 minute load average from the output of a uptime command.
The output is as follows:
15:30:23 up 5:42, 3 users, load average: 0.03, 0.06, 0.08
So the value I need is 0.06.
View 9 Replies
View Related
Jan 19, 2007
CPU load average is around 2-5% on my box. I'd like to know when I'll have to upgrade the CPU. Can I wait and add more accounts until it reaches 90%
View 12 Replies
View Related
Mar 21, 2008
I use CSF on a VPS with 512 RAM and 1024 Busrt and the other day I received the below notification. My hostsaid it was Mailman and since I don't use mailing lists the recommendationwas to disable it. So I did. I'm curious tho as to why this happened in the first place.
Time: Wed Mar 19 17:53:33 2008
1 Min Load Avg: 11.41
5 Min Load Avg: 6.37
15 Min Load Avg: 2.70
Running/Total Processes: 12/94 ...............
View 0 Replies
View Related
Nov 26, 2008
to display the server load average through HTTP. How may I do that?
Please note that I have all insecure functions disabled, such as exec, system, etc... But I have root access.
View 11 Replies
View Related
May 20, 2014
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
Parallels Plesk Panel 11.5.30 MU #44 CentOS 6.5 (Final) 64bit
2 of our our servers are suddenly experiencing high Wait I/O Times, and high Load Averages during the backup process. During this period the Plesk grinds to a halt, sometimes crashing out completely (although SSh is still possible. We have been in talks with our server suppliers (assuming this would be node related) however they have done a lot of testing etc. and categorically state the node is fine , with no other users affecting it.
STEPS TO REPRODUCE : We backup the server using the scheduled backup service and Wait I/O immediately goes up.
ACTUAL RESULT: Plesk downtime / Website downtime
EXPECTED RESULT: No downtime, successful back up
Some other info :
All other processes (MYSQL, apache, Nginx etc) are all running between 1 - 10%
Partition "/usr" utilization 4.2% used (1.81 GB of 43.3 GB) (?)
Partition "/var" utilization 50.6% used (61.8 GB of 122 GB) (?)
We are struggling to identify what has changed on the server that would cause this sudden change.
View 3 Replies
View Related
Oct 26, 2009
This question is for owners who sell their own VPS services.
Can anyone tell me a 'rough' estimate of what their average setup users purchase from you? Or perhaps a top 3 of your setups?
View 0 Replies
View Related
Feb 26, 2009
Having a reseller account(didn't need it, but was talked into it originally), on the average how many domains should I expect to be hosted on one IP? Right now I show 466 for my IP. This is more for curiosity at this point than anything.
View 14 Replies
View Related
Jan 4, 2007
I am considering adding offsite secondary backup servers in house on a full T1 (multiple? or a fractional T3?). Servers will be located in Ontario Canada. Does anyone know the average, upper, and lower cost for a full or even partial T1? I am trying to go as cheap as possible since the line probably wont be used unless the datacenter looses service.
If anyones had any experience with T1, as far as price, reliability, best providers etc
View 14 Replies
View Related
Feb 24, 2008
What is the average price for a constant 100mb ethernet line into colocation cages in datacenters?
I'm getting a 20x30 cage in a local datacenter and they are offering it at $75/day or $2250/month.
Keep in mind that it is dedicated to me, as well as fully redundant from Verio/NTT and Level3.
View 9 Replies
View Related
May 20, 2009
What would the average person looking for a VPS look for? I know each customer is different but I am talking just the most common. I am looking for specs to look for if I do a review site. That way I will review the type of VPS's most people are looking for.
I am looking for sellers to perhaps post their best selling VPS plan.
Include your guesses/experience with the following
Hard Drive:
RAM:
Bandwidth:
IPs:
View 6 Replies
View Related
Jun 28, 2008
I have a few offers to colocate in Los Angeles and in orange county.
Can you break down what kind of deal it would be in the different aspects of colocation? please fill in the following
Here's a start:
Bandwidth pricing (2+ providers in BGP):
Expensive -
Above average -
Median/Average -
Good -
Excellent -
Half rack:
Expensive -
Above average -
Median/Average -
Good -
Excellent -
Entire cabinet 42U:
Expensive -
Above average -
Median/Average -
Good -
Excellent -
Power, cost per amp:
Expensive -
Above average -
Median/Average -
Good -
Excellent -
IP addresses (ea):
Expensive -
Above average -
Median/Average -
Good -
Excellent -
Cross-connect fees:
Expensive -
Above average -
Median/Average -
Good -
Excellent -
Remote hands/Emergency support (billed per 15 minute increments or hour, please specify):
Expensive -
Above average -
Median/Average -
Good -
Excellent -
for SPLA licensed providers, Windows Server 2003 standard cost:
Expensive -
Above average -
Median/Average -
Good -
Excellent -
View 6 Replies
View Related
May 31, 2007
I would like to know what everyone pays/expects to pay for additional power circuits? How much is your colocation provider charging you, and how much profit do you think they are actually making (assuming they make some profit off of power?)
View 4 Replies
View Related
Apr 25, 2009
My VPS from VPSVille is down more than 6:30h i have immediately open a ticket and have not receive response my ticket status is NOT VIEWED. Usually their response time is way faster. I have open another ticket thinking that there is mabye ticket error and thay have not receive the first one and 1h befora i have open the fist ticket about the problem i have send them another ticket about sales and so far no reply.
I have sugest them multiple times and now i`m vary disapointed.
So what is your average responce time from your VPS provider about ctitical problem and ticket marked with HIGHT priority ?
View 11 Replies
View Related
Aug 14, 2008
tell me what the average usage of the CPU and RAM be from apache?
User 'Nobody' (Which I presume is apache) is using 13% CPU and 38.98% of RAM. Is this normal or is it well overloaded?
View 13 Replies
View Related
Jul 26, 2008
I'm on a vps using Dell PowerEdge Servers and 750 GB of transfer.
I have concurrent users settings to where i now have them at "50" and I'm wondering how much higher i can go without troubles.
My app is a perl cgi script in flat files and 95% of visitors will pass through my domain without seeing my webpage. They are only there approx 1 second, maybe 2 as they are quickly redirected from this platform.
My host has a custom solution installed to check for apache stalls every few minutes and it will restart apache when it sticks - and it will stick from time to time.
Just now i do about 75000 per day but plan to double to 150,000 next week and soon after will triple to 225,000 visitors per day.
Should i increase concurrent users now in prep for the increase to 150k or at what level.
Please give some suggestions for concurrent settings at future traffic levels. This host has a multiple server set up in case one fails - i should be good, i think.
75000
150000
225000
300000
400000
500000
View 2 Replies
View Related
Aug 4, 2008
I have a few vps on different providers and I was shoring up my hostnames to make them more cohesive for the different servers.
I placed a request with a well-known, premium vps provider this morning at 9am EDT and am still awaiting them to complete the host name change. They came back immediately and said an admin would have to handle and then noting for hours. At approx 2p EDT, I asked for an update and I received a response at nearly 4pm EDT saying they were still waiting for their admin to get back.
Keep in mind this is a fully-managed, not cheap, vps with a very good rep here on wht.
Am I expecting too much?
I'd change it myself, but I'm unable to do so with virtuozzo.
View 14 Replies
View Related
Nov 4, 2007
I have some small colo in an a DC that I have actual transfer basis on each server. Now they give me MRTG graphs and they say they go by what the switch reports for when they bill me. I haven't had an issue until this month when one of my servers which I only have one TB with was reported using 1372GB on their switch.
Now on my MRTG graphs it reported the monthly graph as the following:
Average In: 2360.8 kb/s (2.4%) 763.855996 GB
Average Out: 471.7 kb/s (0.5%) 152.6205485 GB
This reports under 1TB, so I thought that I was okay on my usage. Am I wrong in thinking that the average usage and actual usage should be very similar? I figured since MRTG takes how much you transfer every 5 minutes and averages that over 300 seconds to find the rate that it would report basically the same average usage as my actual usage.
View 14 Replies
View Related
Nov 1, 2007
I'm about to move 31 machines into a 42U full cabinet
Previously I was on an uncapped bandwidth provider but we had a lot of problems with them so I decided to find a new provider who charges bandwidth by mbps
I do not have mrtg installed or managed switches, but I may start with 10mbps.
But I'm just curious, what takes a full cabinet with more than 30 machines does the total bandwidth takes you.
Perhaps any colo provider here don't mind to share their stats.
View 11 Replies
View Related
