Whenever I run the "top" command, I see that some of the user "mysql" records always have very high CPU usage, anywhere from 20-80% on average (I've seen 100%). There are multiple records that show this, which means that the CPU is always above 100%. My cacti monitoring account also shows messed up CPU statistics.
I am not too knowledgeable with servers, but I believe that this is a problem. How much CPU usage is a mysqld command supposed to use on average? Here is a copy of the top part of a sample top command:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21663 mysql 24 6 63032 30m 3004 R 66 1.5 38:24.06 mysqld
28483 mysql 24 6 63032 30m 3004 R 66 1.5 35:52.86 mysqld
20538 mysql 22 6 63032 30m 3004 S 15 1.5 40:29.74 mysqld
20837 mysql 24 6 63032 30m 3004 R 15 1.5 13:44.15 mysqld
1209 mysql 22 6 63032 30m 3004 S 11 1.5 32:46.26 mysqld
20591 mysql 22 6 63032 30m 3004 S 11 1.5 40:02.76 mysqld
20592 mysql 23 6 63032 30m 3004 S 6 1.5 40:48.29 mysqld
15301 apache 19 4 29928 15m 3608 S 3 0.8 0:00.60 httpd
15317 apache 19 4 28380 14m 3640 S 3 0.7 0:00.58 httpd
15249 apache 19 4 28612 14m 3732 S 1 0.7 0:01.49 httpd
15349 apache 19 4 28876 14m 3324 S 1 0.7 0:00.10 httpd
15319 apache 19 4 28368 14m 3528 S 1 0.7 0:00.34 httpd
15334 apache 19 4 28612 14m 3404 S 1 0.7 0:00.35 httpd
12343 root 15 0 2324 1088 804 R 1 0.1 0:03.31 top
15336 apache 19 4 28876 14m 3500 S 0 0.7 0:00.63 httpd
1 root 15 0 2064 588 508 S 0 0.0 1:01.28 init
2 root RT -5 0 0 0 S 0 0.0 0:09.39 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:01.25 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
=================================
I told my system manager about the cpu problem, and he said that he installed the cpulimit function on my server. I'm not sure if this is a good solution.
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.
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.
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?
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
# # 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
# 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>
if I could get some input on this. Currently I'm running an Opteron 246, 2GB RAM with 2TB bandwidth/mo. I run a single site which is currently 99% HTML, along with an invision forum which is fairly popular. I get about 300-400k pageviews per day.
Right now the server is able to handle this stuff without much of a problem, and the average CPU load is between .5 and 3 (after a TON of tweaking!) - the only exception is when the forum db is being backed up/optimized, which isn't a huge problem since it happens during the off hours.
The problem is that I'm running out of bandwidth quickly, and need to come up with some kind of solution soon. My current provider offers bandwidth at $1/GB, which to me seems crazy compared to other providers, so that's not really an option.
I was thinking about switching to a more affordable provider and upgrading hardware, but I'm not sure what the best approach would be. I'm in the process of moving my HTML content over to a PHP-powered CMS, so I need to make sure whatever I do can handle that... What might be a decent setup for a site like mine which consumes a lot of bandwidth and will probably need more CPU power in the near future for PHP/MySQL stuff?
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.
On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:
Load for today High (2:18am): 4.63 Low (3:30am): 1.20 Mean: 1.84 Latest: 1.61
Mem usage for today High (1:36am): 9,192.9 MB Low (1:48am): 7,995.7 MB Mean: 8,683.1 MB Latest: 8,781.7 MB
I have seen it using 20GB RAM before.
I have tried to follow various optimisation guides but these seem tailored to less powerful servers.
The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.
Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.
My video sharing site has high traffic, alexa rate:3,000
My site has 2 servers to split the load. 2 servers share a mysql server. Using rrdns to load the balance.
Server A running mysql 5.0,lighttpd Server B running lighttpd. Server B connect to A's mysql database.
During peak time. B can not connect to A's mysql server. It says server not responding. But A still running fine. When I check mysql log file. /usr/libexec/mysqld: Forcing close of thread .....
And when run top, the load average is 20.
The spec of Server A Intel(R) Xeon(TM) CPU 3.06GHz dual core. 2G Ram.
Here is the my.cnf
Quote:
[mysqld] 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 max_connections = 1000 wait_timeout=60 connect_timeout=10 interactive_timeout=120 join_buffer_size=1M query_cache_size=128M query_cache_limit=2M max_allowed_packet=16M table_cache=1024 sort_buffer_size=2M read_buffer_size=2M
My question, do I need another maching C to run lighttpd, and just keep mysql on A. Or I can do some mysql optimization on A.
Also, if my site keeps going, can I have 1 mysql server and 5 http servers?
cpu speed/type single or dual cpus): Intel Xeon 2x3.6 how much memory installed: 2048MB hard drive type/configuration: 2x160GB SATA linux distributor or windows version: CentOS 4.5 x86_64 apache/IIS version: apache 1.3.37 PHP version: php 4.4.7 MySQL version: 4.1.22-standard
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 19017 teknoloj 16 0 0 0 0 Z 27 0.0 0:00.93 php <defunct> 17751 mysql 15 0 241m 55m 3148 S 25 2.8 0:53.73 mysqld 19025 root 18 0 16204 6104 1392 D 6 0.3 0:00.17 cpcpan_check_in 18968 sohbetgo 16 0 44596 7540 3556 S 5 0.4 0:00.44 php 18552 nobody 15 0 32636 4208 1204 S 2 0.2 0:00.28 httpd 18808 resimsit 17 0 46944 9960 3616 R 1 0.5 0:00.23 php 18896 resimsit 16 0 46944 9984 3616 D 1 0.5 0:00.08 php 18921 resimsit 17 0 46404 9444 3572 R 1 0.5 0:00.09 php 18819 nobody 17 0 32644 4176 1192 S 1 0.2 0:00.06 httpd 18868 haylazt 16 0 0 0 0 Z 1 0.0 0:00.48 php <defunct> 18871 nobody 15 0 32504 4056 1148 S 1 0.2 0:00.06 httpd 18892 root 16 0 6416 1180 756 R 1 0.1 0:00.24 top 18978 nobody 16 0 32504 4028 1132 S 1 0.2 0:00.02 httpd 11 root 5 -10 0 0 0 S 0 0.0 0:24.56 events/1 2638 root 0 -20 0 0 0 S 0 0.0 0:16.96 loop0 2981 named 18 0 88016 2328 1152 S 0 0.1 8:44.12 named 3592 mailman 16 0 50316 2320 1828 S 0 0.1 0:00.78 python2.4
MySQL 4.1.22-standard uptime 0 0:39:9 Sat Jun 30 21:33:29 2007
__ Key __________________________________________________ _______________ Buffer used 19.34M of 80.00M %Used: 24.17 Current 33.70M %Usage: 42.12 Write hit 32.57% Read hit 98.45%
__ Tables __________________________________________________ ____________ Open 486 of 1800 %Cache: 27.00 Opened 702 0.3/s
__ Connections __________________________________________________ _______ Max used 12 of 500 %Max: 2.40 Total 4.33k 1.8/s
__ Created Temp __________________________________________________ ______ Disk table 26 0.0/s Table 2.23k 1.0/s File 428 0.2/s
6-7 vbulletin sites-vbseo and other scripts online avarage; 120 registered user ve 500+ unregistered user cookie timeout : 7200 unique hit : 15000-20000
KeepAlive ON MaxKeepAliveRequests 100 KeepAliveTimeout 2 MinSpareServers 10 MaxSpareServers 15 StartServers 10 MaxClients 180 Maxrequestsperchild value 1000
[root@server ~]# uname -a
Linux server.xxxxx 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
[root@server ~]# ulimit -aH
core file size (blocks, -c) 1000000 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 4096 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 14335 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
[root@server ~]# cat /proc/cpuinfo
processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7207.08 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management:
processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 3 siblings : 2 core id : 3 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7199.29 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management:
processor : 2 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7509.03 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management:
processor : 3 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.60GHz stepping : 10 cpu MHz : 3600.322 cache size : 2048 KB physical id : 3 siblings : 2 core id : 3 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr bogomips : 7199.26 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management:
we have mysql 5 setup and this morning at around 10:07 tables started disappearing as they were being accessed by different clients.
Databases that had 40 tables now had 30, etc. Only the tables that were attempted to be accessed were gone. This is the first time something like this has happened.
The following output was given:
This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.
key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=208 max_connections=500 threads_connected=156 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1096188 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0xaf82930 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong...
Cannot determine thread, fp=0xb143932c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows: 0x816b1a0 0xaf1898 0x20 0x81ac49d 0x8182914 0x8189010 0x8189df1 0x818a738 0x818ae5c 0xaeb371 0x9c4ffe New value of fp=(nil) failed sanity check, terminating stack trace! Please read [url]and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xaf36620 = SELECT * FROM `sessions` WHERE `PHPSESSID` = '5e6775cd3c6f187d8c575127ba73be19' thd->thread_id=113407 The manual page at [url]contains information that should help you find out what is causing the crash. mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `"Pure virtual method called." == "Aborted"' failed.
Number of processes running now: 0 070427 10:07:49 mysqld restarted 070427 10:07:50 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070427 10:07:53 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 227822203. InnoDB: Doing recovery: scanned up to log sequence number 0 227822203 070427 10:07:53 InnoDB: Started; log sequence number 0 227822203 070427 10:07:54 [Note] /usr/sbin/mysqld: ready for connections.
I am just a beginner and it is about a month that the mysql loads on my server is so high , I have checked the mysql processlist via cpanel and there is no account that takes high mysql and make it high , and even I have checked for any possible rotten databases. but still the server load is so high and I can not control it , even when I restart it just after a minute it goes up again.
just the spamd command takes a high CPU usage sometimes. what it should be from? the spamd for a special account!
I need to optimize mysql , and need help. please do not tell me to hire an expert , just help me thanks
and another question is that how can I check which account is sending spam and stop it?
I have a dual xeon server that host around 15 small website, but these days I see that the load generated from mysql is very high as you can see below is consumes 32.6 CPU
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?
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...
it was very fast until mysql upgraded to 5.0.45 it was 4.. i can’t even turn my forum if it is a busy time cos it is so slow i get page not found after a while but when it is quiet it is not too bad... but it was alot more faster with mysql 4 i don't really want to downgrade please give me some ideas to fix this issue ...........
[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.
My server very slow and the is very loaded. How can I fix this problem? My server specialities and loaded softwares which are below. And sometimes there is "mysql connect failed", "Lost connection to MySQL server during query" errors. Thanks for kinds...
-- MYSQL PERFORMANCE TUNING PRIMER -- - By: Matthew Montgomery -
MySQL Version 5.0.41-log i686
Uptime = 3 days 4 hrs 34 min 17 sec Avg. qps = 92 Total Questions = 25406284 Threads Connected = 1
Server has been running for over 48hrs. It should be safe to follow these recommendations
To find out more information on how each of these runtime variables effects performance visit: .............
SLOW QUERIES Current long_query_time = 5 sec. You have 115 out of 25406302 that take longer than 5 sec. to complete The slow query log is enabled. Your long_query_time seems to be fine
WORKER THREADS Current thread_cache_size = 8 Current threads_cached = 7 Current threads_per_sec = 0 Historic threads_per_sec = 0 Your thread_cache_size is fine
MAX CONNECTIONS Current max_connections = 500 Current threads_connected = 2 Historic max_used_connections = 110 The number of used connections is 22% of the configured maximum. Your max_connections variable seems to be fine.
MEMORY USAGE Max Memory Ever Allocated : 835 M Configured Max Per-thread Buffers : 3 G Configured Max Global Buffers : 46 M Configured Max Memory Limit : 3 G Total System Memory : 3.96 G
Max memory limit exceeds 85% of total system memory
KEY BUFFER Current MyISAM index space = 35 M Current key_buffer_size = 32 M Key cache miss rate is 1 : 73658 Key buffer fill ratio = 34.00 % Your key_buffer_size seems to be too high. Perhaps you can use these resources elsewhere
QUERY CACHE Query cache is enabled Current query_cache_size = 4 M Current query_cache_used = 1 M Current query_cach_limit = 1 M Current Query cache fill ratio = 29.83 % MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS Current sort_buffer_size = 2 M Current record/read_rnd_buffer_size = 1 M Sort buffer seems to be fine
JOINS Current join_buffer_size = 1.00 M You have had 14127 queries where a join could not use an index properly You should enable "log-queries-not-using-indexes" Then look for non indexed joins in the slow query log. If you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when ANY joins not using indexes are found.
OPEN FILES LIMIT Current open_files_limit = 2500 files The open_files_limit should typically be set to at least 2x-3x that of table_cache if you have heavy MyISAM usage. Your open_files_limit value seems to be fine
TABLE CACHE Current table_cache value = 256 tables You have a total of 636 tables You have 256 open tables. Current table_cache hit rate is 1% , while 100% of your table cache is in use You should probably increase your table_cache
TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 32 M Of 2271787 temp tables, 3% were created on disk Effective in-memory tmp_table_size is limited to max_heap_table_size. Created disk tmp tables ratio seems fine
TABLE SCANS Current read_buffer_size = 1 M Current table scan ratio = 28 : 1 read_buffer_size seems to be fine
TABLE LOCKING Current Lock Wait ratio =1 : 112 You may benefit from selective use of InnoDB. If you have long running SELECT's against MyISAM tables and perform frequent updates consider setting 'low_priority_updates=1' If you have a high concurrentcy of inserts on Dynamic row-length tables consider setting 'concurrent_insert=2'.
Quad Core server, 4GB ram. MySQL runs at all times between 200 - 300% CPU. Server does only 5K unique per day, and runs zen cart.
I am at a loss, I have experiece with tracking dowen reasons for this but this one has stumpped me. So I was hoping to get new eyes on this and see if anyone had any ideas.
# The following directives should be commented out # but included as they are things that get added # very frequently on tickets. These are more in a # need-this-feature basis.
# The below 2 cannot be set on the fly. If the customer already has # InnoDB tables and wants to change the size of the InnoDB tablespace # and InnoDB logs, then: # 1. Run a full backup with mysqldump # 2. Stop MySQL # 3. Move current ibdata and ib_logfiles out of /var/lib/mysql # 4. Uncomment the below innodb_data_file_path and innodb_log_file_size # 5. Start MySQL (it will recreate new InnoDB files) # 6. Restore data from backup #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_file_size = 100M
I have a single mysql process that never stops and running with 10-200% CPU load: URL....
I restart mysql => process coming back I restart server => process coming back I kill process => process coming back
I have run: # mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist but there was noting that runs >10min.
Code: > SHOW FULL PROCESSLIST; +------+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------+-----------+------+---------+------+-------+-----------------------+ | 328 | admin | localhost | psa | Sleep | 56 | | NULL | | 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST | +------+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) I have strace the PID
Code: # timeout 1m strace -f -c -p 5873 Process 5873 attached with 30 threads - interrupt to quit Process 10499 attached (waiting for parent) Process 10499 resumed (parent 5873 ready) Process 10502 attached (waiting for parent) Process 10502 resumed (parent 5873 ready) Process 10503 attached (waiting for parent)
[code]....
I found with google a hint for high cpu URL....I have deinstalled "health monitor" module, but that was not the reason.I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
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 ?
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 Quad Core Xeon server with 2 GB RAM. The server has some high traffic websites & at peak hours (4-5 hrs a day) the server load remains 10.0 to 50.0.
The sites on the server load very slow at these times. Here's the top result during heavy load
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?
