CentOS 4.5 final
Apache 2.0.59
php 4.3.11
MySQL 4.1.20
I have a user who has been importing large sql databases and this causes the cpu to run at 80% - 90% this in turn causes high loads and sometimes causing the server to crash.
Is there a way to automatically limit or control how much the process can use or stop the process to allow the server to recover.
Just trying to put some sort of safe guard in place
So my server is "unresponsive" for abour 18 hours, burst net didnt answer my tickets and I dont know what to do. Ive been with this setup for almost 5 months with no problems, No changes have been made to hardware or software.
top output from my server shows a this user was creating a lot of proccesses, even this process has been running for about 30 mins, how can I limit the time a process can stay alive? I suspect it was causing a high load on the server when started.
I have server in LT, the network is so good, but i got problem with the apache, it keep going down because the process too high ( i think)
when i list the process it show me :
nobody 0.000.250.0 Top Process%CPU 98.9/usr/local/apache/bin/httpd -DSSL Top Process%CPU 98.8/usr/local/apache/bin/httpd -DSSL Top Process%CPU 2.9 Other than that all domain only use not more than 10% process, I use Cpanel X and Cpanel XP skin, please help
Now my domain , will get blank page when try to access, i dont know why, even though all service is running and i already reboot the server
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 ?
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.
I am running in a High load problem lately. I have one of those cheap 1and1 servers which was running fine until 2 weeks ago. Once I rebooted accidentaly, it did not come back with some unrepairable kernel errors and I had to re-image it.
I chose to reimage the server with CentOS 5, for better support. The new re-image worked fine for some days, at least so I thought and now I am having high loads. The server crashes if not monitored every moment as the load is unpredictable.
Just a restart of the Apache will bring the server back to normality, but I am not sure if it is apache or some other script to be blamed. I have beeing monitoring through apache server-status, but I cannot organize something unusual in the high load moments.
12:00:29 AM CPU %user %nice %system %iowait %steal %idle 12:10:01 AM all 9.14 0.00 5.52 44.66 0.00 40.68 12:20:14 AM all 6.83 0.00 3.98 27.88 0.00 61.32 12:30:10 AM all 6.44 0.00 4.20 81.25 0.00 8.11 12:40:09 AM all 5.25 0.00 4.09 81.93 0.00 8.73 12:50:15 AM all 5.11 0.00 3.79 90.74 0.00 0.36 01:00:07 AM all 7.22 0.00 4.52 57.11 0.00 31.15 01:10:13 AM all 6.89 0.00 4.01 55.38 0.00 33.71 01:20:14 AM all 4.37 0.00 3.27 41.88 0.00 50.48 01:30:25 AM all 4.26 0.00 3.29 63.42 0.00 29.03 01:40:06 AM all 27.18 0.00 4.75 58.27 0.00 9.80 01:50:03 AM all 29.64 0.00 6.61 51.50 0.00 12.25 02:00:07 AM all 27.00 0.00 8.48 55.49 0.00 9.03 02:10:10 AM all 19.29 0.00 4.97 73.80 0.00 1.94 02:20:04 AM all 37.85 0.00 6.78 40.70 0.00 14.67 02:30:05 AM all 15.65 0.00 4.80 68.47 0.00 11.08 02:40:08 AM all 9.06 0.00 5.60 37.49 0.00 47.86 02:50:07 AM all 5.36 0.00 3.62 42.29 0.00 48.73 03:00:02 AM all 6.05 0.00 4.08 47.27 0.00 42.60 03:10:02 AM all 4.22 0.00 3.68 38.17 0.00 53.93 03:20:02 AM all 4.06 0.00 3.75 41.37 0.00 50.82 03:30:22 AM all 4.42 0.00 3.93 45.25 0.00 46.41 03:40:11 AM all 4.34 0.00 3.95 39.58 0.00 52.13 03:50:02 AM all 4.67 0.00 4.01 32.53 0.00 58.80 04:00:08 AM all 3.72 0.00 3.87 28.40 0.00 64.02 04:10:02 AM all 13.49 0.00 6.58 20.82 0.00 59.10 04:20:01 AM all 6.70 0.00 4.63 6.06 0.00 82.61 04:30:02 AM all 1.44 0.00 1.21 4.75 0.00 92.59 04:40:01 AM all 12.42 0.00 8.12 7.65 0.00 71.81 04:50:02 AM all 1.43 0.00 1.07 4.02 0.00 93.47 05:00:02 AM all 1.60 0.00 1.40 8.62 0.00 88.38 05:10:10 AM all 3.80 0.00 3.02 17.86 0.00 75.32 05:20:06 AM all 5.10 0.00 4.22 23.34 0.00 67.34 05:30:02 AM all 1.54 0.00 1.40 11.22 0.00 85.85 05:40:05 AM all 1.75 0.00 1.89 13.12 0.00 83.23 05:50:12 AM all 2.15 0.00 2.22 18.92 0.00 76.72 06:00:02 AM all 1.92 0.00 2.01 12.87 0.00 83.20 06:10:02 AM all 2.27 0.00 2.16 11.53 0.00 84.04 06:20:03 AM all 3.56 0.00 3.02 25.26 0.00 68.16 06:30:10 AM all 2.66 0.00 2.05 18.13 0.00 77.16 06:40:02 AM all 2.58 0.00 2.25 22.87 0.00 72.30 06:50:02 AM all 2.68 0.00 1.92 15.77 0.00 79.63 07:00:03 AM all 3.06 0.00 2.48 26.01 0.00 68.46 07:10:03 AM all 3.65 0.00 3.20 36.54 0.00 56.61
07:10:03 AM CPU %user %nice %system %iowait %steal %idle 07:20:03 AM all 4.40 0.00 3.28 43.86 0.00 48.46 07:30:02 AM all 4.10 0.00 3.17 31.30 0.00 61.43 07:40:06 AM all 7.67 0.00 3.95 50.79 0.00 37.59 07:50:02 AM all 4.72 0.00 3.11 44.30 0.00 47.86 08:00:03 AM all 5.57 0.00 3.72 47.15 0.00 43.56 08:10:07 AM all 10.66 0.00 3.59 71.62 0.00 14.13 08:20:17 AM all 5.67 0.00 3.42 58.81 0.00 32.10 08:30:10 AM all 11.12 0.00 3.49 76.71 0.00 8.67 08:40:03 AM all 7.00 0.00 3.36 47.94 0.00 41.71 Average: all 7.53 0.00 3.76 38.90 0.00 49.81 Some configurations: The reimage partittioning looks like this:
processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 3 model name : Intel(R) Pentium(R) 4 CPU 2.80GHz stepping : 4 cpu MHz : 2793.324 cache size : 1024 KB
I'd like to put up here a base question which I hope some will have the goodwill to answer even though it might touch some business secrecies.
We're a gameserver hoster since around ten years, running also vserver products since over two years now. Renting a few Racks in Europe since some time we're a bit in a question mark how rootserver companies deal with the initial hardware costs for every new customer.
Rackspace and today specially power costs are huge cash eaters here in Europe. Dedicated Rootservers are huge space & power consumers per customer ratio. The initial Hw costs for every new rootserver customer might be covered after 4-6 months (if the machine has to be bought newly), adding the bandwidth and power costs it might take up to 8-9 months until a benefit might come in.
Is this the business normality in the rootserver market (waiting 9 months for any benefit, or counting only on the benefit of the 2nd customer using the older Hw), or are the better ways to handle those "initial" costs or keep them affordably low?
In My server i Can see lotz of /usr/local/apache/bin/httpd -k start -DSSL Process also some time it lead to crash of my server,is this caused to improper httpd.con file iam have 200-250 online users here i will give my apachi cofig file
Top Process %CPU 98.9 ./dialog --clear --backtitle Zend Optimizer Installation --title Zend Optimizer 3.2.2 --msgbox ?Welcome to the Zend Optimizer 3.2.2 Installation!??For more information regarding this procedure, please see the?Zend Optimizer Installation Guide.? 0 0
Top Process %CPU 98.8 ./dialog --clear --backtitle Zend Optimizer Installation --title Zend Optimizer 3.2.2 --msgbox ?Welcome to the Zend Optimizer 3.2.2 Installation!??For more information regarding this procedure, please see the?Zend Optimizer Installation Guide.? 0 0
My hosting company is telling me that I have getting frozen processes on my VPS that is causing apache to stop responding.
My VPS is CentOS, with 512 megs of memory and my website is a Vbulletin forum. I have several add-ons installed on vbulletin, and if one of those are causing the problem, how do I figure it out?
When http stops responding, I can access the server with putty on ssh. Running the "top" command, it shows that I still have 100+ megs of memory free and the processor is barely being used.
This has happened twice in just 2 - 3 days. This morning, I asked my hosting company what can be causing this, but no answer so far.
Code: PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 9488 nobody 25 0 1612 1280 1108 S 21.1 0.2 619:37 1 perl bodyb3 200.101.193.42 0 5000 I also ran netstat -n and found this: Code: udp 15184 0 server.host.com:55936 ns1.datacenter.net:domain ESTABLISHED
I can't remember the name of the utility that lets you watch what a process is doing. You call it on a PID and you can see all the memory allocations, file IO, library loading, etc. that the process is doing as it happens. Anyone know what I'm thinking of?
I'd like a brief explanation of the process of creating a web site.
Once I sign up, how do I actually construct/configure the web site. Are there templates that I change the colours, background and text of? I don't want to actually construct my own web pages. I just want to "brand/personalize" some template and then let it operate. (And if I'm using some ambiguous terms, please correct me.)
Also, I wanted to know if hosting companies allow one to experiment with an "offline" web site; one that I can set up and play with (via a password or such) using their templates until I have a better idea of what I want or what I can do in terms of presentation (perhaps a month?). Once that's done, I wanted the ability to cancel the whole idea or put what I have on line.
To provide some other info:
I am looking for a shared account, and I understand that bandwidth and disk space are the key requirements, but thanks for the reminder. I have heard about some tools, but for the time being let's just talk about process.
