just noticed mysql cpu usage has shot up from its usual 5-10% cpu to 30%+. domains are as normal and no extraordinary php processes.
any way i can tell what users are most heavily running mysql? (as in number queries / slow queries etc?) i know mysqladmin processlist but that only gives me a snapshot, whereas i want to see over 24 hours, who used mysql the most...
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
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 need some help my CPU (Intel Core 2 Duo 1.7 Ghz) always gets high usage from mysql sometimes its using 95% cpu etc... How can I modify my.cnf to use less CPU and more ram since I have 3gb ram installed?
here is my.cnf
Code:
[mysqld]
back_log = 5
skip-innodb
max_connections = 400
key_buffer = 190M
myisam_sort_buffer_size = 156M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 5M
table_cache = 1024
record_buffer = 1024
thread_concurrency = 2
long_query_time = 1
thread_cache = 1024
thread_cache_size = 992025
wait_timeout = 13
connect_timeout = 5
tmp_table_size = 64M
max_heap_table_size = 16M
max_allowed_packet = 16M
max_connect_errors = 500
read_rnd_buffer_size = 1024
bulk_insert_buffer_size = 32M
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
low_priority_updates=1
default-storage-engine = MyISAM
[mysqld_safe]
nice = -2
open_files_limit = 4096
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 32M
write_buffer = 32M
on my server i have 104 accounts and the MySQL Usage for th cpus is 25.23
like this pic [url] is that danger? and how can i resolve it?
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 ?
Few of the processes are getting more meory usage and I checked by using top command.
It is displaying as 0.6% for each process. Does it mean that it is using 0.6% of the total memory?
How can I find exact memory usage?
I'm picking up a client who is a video production company and hosts a lot of their work for their clients on the web. They have two sites right now for two different branches of what they do, but they are beginning to scale up a bit and want to switch from a local ISP hosting package to something more commercial. I like the idea of a VPS, but their current budget is rather low. Because of that, I am a bit attracted to hosting packages from site5 and dreamhost (both of which I've heard good and bad things about).
Ideally, I would be looking for a VPS along the lines of:
50-75GB disk space
256-512MB RAM
750GB-1TB Bandwidth
Linux OS with Shell Access
cPanel or Plesk Control panel
It'd be nice to keep their budget around $50/mo, but I know that might be asking a lot. They have two websites currently for their production needs. What would be the advantages of a VPS over multiple hosting accounts at Site5 ($7.50/mo) or Dreamhost ($6/mo)?
i have a vps and its quite a new one since i just ordered it and transfered everything from my previous..
But im getting really high cpu useage and im wanting to know whats best ways to optimize this...
I know about high CPU usage and how it works against a webmaster when his host decides to suspend an account over this.
My question is what kinds of scripts usually cause CPU Usage to bulk up.
Basically what the script is doing, that just makes it happen.
I tried Google, but i guess poor choice of keywords .
I have server with P4 ( 2.4ghz) 2gb ram with cpanel and centos.
When I get more than 300 users online on my forum. Server load remains under 2 but Ram usage get's high upto 90% every 10 to 3 minutes. I have to restart apache in order to keep it down.
Currenty shows 67% ram usage in WHM and here is:
Code:
root@s1 [~]# free -m
total used free shared buffers cached
Mem: 2018 1645 372 0 15 293
-/+ buffers/cache: 1336 681
Swap: 1992 92 1899
Am using Hypervm,my all vms are not using more than 512 MB memory but when i click on server as localhost the there is show maximum memory usage I have total 8 GB it always show 5-6 GB usage and never drop down, How can I fix this matters?
View 7 Replies View Relatedi have a quad core Intel XEON 5130 @ 1.60GHz . with 6giga now of memory . i have about 300 account in it . CENTOS Enterprise 4.6 installed .
the probleme is that the memory server it used in totaly . after i was just 2Gb of ram , but sometimes the server lod arrive at 50% . for that i have added more memory (4Gb) , when i added it the memroy usage is always about 4giga sometimes about 3980Mb . the load is normal , but sometimes the server loas arrive at 50% or 60% (this is just in specific times) . after i have decided to add 2 Gb more , now is 6gb in the server . but also all the 6giag of ram is used , the load is normal but memory is all used , look to the top command
top - 02:55:26 up 1 day, 4:31, 1 user, load average: 0.25, 0.30, 0.45
Tasks: 157 total, 2 running, 154 sleeping, 0 stopped, 1 zombie
Cpu(s): 6.5% us, 1.3% sy, 0.0% ni, 92.1% id, 0.1% wa, 0.0% hi, 0.0% si
Mem: 6229508k total, 5995668k used, 233840k free, 213712k buffers
Swap: 4192824k total, 224k used, 4192600k free, 4353968k cached
PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND ....
I have a Drupal site with around 1000 visitors/day on a basic VPS. (HyperVM with lxadmin) Burstable RAM is 384MB and my site reachs it.
is this normal for a site like this?
anything that I can do to decrease the memory usage?
My server details
Intel 2.4 Ghz P4 Celeron
os-redhat
RAM-2GB DDR
harddisk-160+50Gb
bandwith-3000Gb
now iam haveing more that 0.50-1.20 cpu useage,also cpu useage is also increased i hosted only 6 site out what only one site use MSQL all other site are plain download site,how to reduce the cpu load can u figure me out this issue also give me some tips to reduce the cpu usage
I noticed high cpu usage on my server since a couple of days ago. I neither updated software nor changed the configurations on the server. The server load was about 0.5 ~ 1.0 but now the average CPU load does not go below 5.0
when I stop apache (1.3) the load goes down and as soon as I start it up the load start increasing.
I checked for DoS but it seems nothing exists of this type.
I tried to follow the access_log file but from the first view nothing is strange there.
I don't have any control panel on the server. just Apache, FTP and SSH installed.
Since yesterday named started to use more cpu than usual. Techs "refuse" to work with that issue and saying that its's normal. Though all the time had no problems, haven't added hundreds of domains yesterday and there were no changes from my end.
There was one change from techs side however.
"the MX record for the domain was going to localhost, rather than the domain name. I have changed the MX record to domain..."
Anything I should check? Logs doesn't provide anything valuable, just notices.
I am running a youtube clone on a VPS with 512mb ram at Lunarpages.
Whenever I log into Plesk, I find that my system usage is extremely high. 90%++ even up to 100%. However my CPU usage is often less than 5%.
This problem often occurs when there is slightly more visitors on my site. I am talking about only 30++ visitors and this problem will occur and my site slows to a crawl and I have to restart the VPS.
The script or the server?
i have a problem with my server it is a Xeon with 2Gb ram, i have a igh swap usage and when it reach the size of 4gb that i have set it go in kernel panic, this is the actual value
top - 14:19:47 up 1 day, 23:07, 1 user, load average: 1.74, 1.93, 1.89
Tasks: 223 total, 5 running, 217 sleeping, 1 stopped, 0 zombie
Cpu(s): 39.8% us, 6.6% sy, 14.0% ni, 32.3% id, 7.3% wa, 0.0% hi, 0.0% si
Mem: 2074640k total, 1980804k used, 93836k free, 66200k buffers
Swap: 4192924k total, 1735588k used, 2457336k free, 365136k cached
total used free shared buffers cached
Mem: 2026 1877 148 0 61 306
-/+ buffers/cache: 1509 516
Swap: 4094 1699 2394
maybe i can work on KeepAlaive setting?
Quote:
total used free shared buffers cached
Mem: 1034060 1004864 29196 0 50756 340272
-/+ buffers/cache: 613836 420224
Swap: 1020088 373648 646440
Is there anything I can do to reduce the swap usage?
Running cpanel, Dual Xeon 3.0ghz with 1 gb ram
Quote:
root@****** [~]# uname -a
Linux ****** 2.6.9-42.0.3.EL.cernsmp #1 SMP Fri Oct 6 12:07:54 CEST 2006 i686 i686 i386 GNU/Linux
I purchased a VPS at wiredtree to upload a site that is in the works so that it would be "ready" once it was launched (had it sitting on a shared server before). So I have this domain on there, as well as a small wordpress blog. In total I'm get a very miniscule trickle of visitors to these websites (as they are not officially launched), around 100 visits per day, many of which are only 1 pageview visits.
My problem is, my server is already idling over its memory limit of 256mb. This is causing major slowdowns, and processes like cpanel are constantly be killed and I can't login.
Does anyone have any idea what is causing my high memory usage? I just can't image that the visitors I am getting are doing much, as for the majority of the day I have absolutely no one viewing my domains, yet my memory usage is still over the limit.
Wiredtree support says its up to me to optimize my msql/php scripts etc for low mem usage, but I don't see how this will help when there is no one using them in the first place.
For some reason cpanellogd always had huge memory usage in the realm of 40-90% when running logs for one particular site, which inturn sends the server load to 25-40.
What can cause this? I have delete logs after stats run enabled and all the usuall.
I 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 installed kloxo on a fresh CentOS installation, not the hostinabox template
I have high memory usage though as seen here
[url]
Apache appears to be running 2 or 3 times? How do I remedy this?
[url]
I'm running hypervm on xen a centos 5 64 bit box.
The problem I'm having is that after a couple of hours of uptime Dom0 seems to have used up all of it's available memory i.e:
[root@------ ~]# free -m
total used free shared buffers cached
Mem: 1536 1516 19 0 993 247
-/+ buffers/cache: 275 1260
Swap: 16002 0 16002
I have disabled the memory balloon driver in the xen config and set dom0_mem=1536M in grub.conf, i.e:
default=1
timeout=1
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title CentOS (2.6.18-92.1.18.el5)
root (hd0,0)
kernel /vmlinuz-2.6.18-92.1.18.el5 ro root=LABEL=/
initrd /initrd-2.6.18-92.1.18.el5.img
title CentOS (2.6.18-92.1.18.el5xen)
root (hd0,0)
kernel /xen.gz-2.6.18-92.1.18.el5 dom0_mem=1536M
module /vmlinuz-2.6.18-92.1.18.el5xen ro root=LABEL=/
module /initrd-2.6.18-92.1.18.el5xen.img
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!
I have just moved my sites from shared host to a vps. After several initial problems (cpanel issue, config not set up correctly, memory spikes and sites down every morning due to backup and stats) I thought everything was going to be ok. hmm.
My server load starts off fine first thing (less than 1) then creeps up nearly 1 per hour, ie been 3.5 hours now and it is at 2.57. Sites are ok at the moment but yesterday load got up to nearly 7 and sites were extremely slow.
CPU usage is HIGH for one site and goes up very quickly throughout the day. Yesterday it reached well over 90%. First thing today it was already amber and showing 14%. It is now 70.54% and shows below it :
Top Process %CPU 80.2 spamd child
Top Process %CPU 79.8 spamd child
Top Process %CPU 79.4 spamd child
I have a ticket open and they (Liquid Web) they are not sure what the deal is, but are apparently monitoring it to see if they can isolate the cause of the problem. But that was a couple of days ago and now the ticket is due for closure.
I telephoned them (expensive as I'm in the UK!) and raised my concerns, but was just told that everything looked ok on the vps, cpu usage was in fact not high and to ignore the warnings.
So, I am posting here to see if anybody can help me get to the root of this.
I understand that spamd child is to do with email / spam assassin?
My problem is that this is the first vps I have had and don't have a clue now where to go or what to do.
Anybody understand about spamd child that can explain it to a poor dumb blonde and how to fix it?
I have seen posts that some hosts suspend a user after they so many seconds of high server resource usage... I was wondering how this is done so that I can do this on my dedicated server.
View 1 Replies View RelatedToday I upgraded my dual opteron dedicated server from a 10mbps port to 100mbps. While the number of apache access have dropped by about a quarter my CPU usage has increased also by about a quarter, my CPU is touching on 95-100% now.
What’s most likely to be the cause?
What’s also interesting is my network port is only showing 20mbps usage, nowhere near the 100mbps its been upgraded to.
