Mysql Running Process
Apr 10, 2008mysqq has a nice value of 6, is this fine? I read somewhere that it's better at a value of -5.
View 4 Replies
ADVERTISEMENT
Plesk 12.x / Linux :: MySQL Process Running Unlimited With High CPU?
Mar 23, 2015I 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).
What Is This Running Process
Feb 19, 2008I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL
Running A Linux Process In The Background
Nov 23, 2007So ive installed a bit torrent client on a server for a corporate client to server an internal application they use.
When I run the following code, it starts to seed it fine, however as soon as I close the ssh session which started the seed, it stops seeding.
Ive tried adding an & to the end of the command, however the same thing happens.
Anyone got any ideas how I can get the following line to start as soon as the server boots, and keep running 24/7?
The command is;
btdownloadheadless.py --url [url]
Why User Root Is Running Process Httpd All Time
Jul 2, 2009I usually use the "top" command to see what is happening in my server ... Normally everything is OK untill one week ago I start so see this process:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1115 root 20 0 10768 10m 164 R 26 0.5 46:17.27 httpd
Is the number 1 on the top list using a lot of CPU and MEM (as I say before ... I never have seen this command in the past)
So when I kill the process everything goes fine but only for a few minutes and then is comming back
Too Many Mysql Process (because Of Directadmin)
Apr 12, 2009There is a too many mysql process (because of directadmin) but i don't want to. As i read it is related with compile options.
Is there a way turn off that setting to one mysql process ? OR how can i told to directadmin that i want to one mysql process ?
Heavy Mysql Process
Jun 5, 2008on my top process am having this one as shown in the attachement image
its consuming time+ of 746:21:95
on the Process Manager that mysqld process is using the command
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.theplanet.host.pid --skip-external-locking
is that process normal? and what is cousing it? should i kill it?
Mysql And EOPNOTSUPP Process
Apr 3, 2008I have a constant mysql process using 10-20% CPU, its very strange because the process is always present, if I restart apache and mysql and I just open the phpmyadmin or any website connecting to the DB I get this error.
With strace I have seen that the process details are:
futex(0x87326c4, 0x5 /* FUTEX_??? */, 1) = 1
futex(0x8732174, FUTEX_WAKE, 1) = 1
select(15, [13 14], NULL, NULL, NULL) = 1 (in [14])
fcntl64(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(14, {sa_family=AF_FILE, path="ӿ"}, [2]) = 25
fcntl64(14, F_SETFL, O_RDWR) = 0
getsockname(25, {sa_family=AF_FILE, path="/var/run/mysql"}, [30]) = 0
fcntl64(25, F_SETFL, O_RDONLY) = 0
fcntl64(25, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(25, F_SETFL, O_RDWR|O_NONBLOCK) = 0
setsockopt(25, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
The strace show that this piece of code is being repeated everytime that any website or app is using the database.
I have seen that the process call to the path /var/run/mysql in:
getsockname(15, {sa_family=AF_FILE, path="/var/run/mysql "}, [30]) = 0
...but in my system the path doesnt exists, its /var/run/mysqld/ and I cant find a call to "/var/run/mysql" in any file of the server (i have tryed with sudo grep -nr '/var/run/mysql' /)
Server specs:
CENTOS Enterprise 4.6 i686
Linux 2.6.9-67.0.7.ELsmp
Core2Duo E6750
PHP Version 5.2.5
MySQL 5.0.45
Wich User Have More Mysql Process?
May 25, 2009How can see wich user have more mysql process?
View 2 Replies View RelatedStop Mysql Process For Good?
Apr 6, 2009how do I stop mysql process for good?
service mysqld stop & killall mysqld don't do anything, mysqld stop and few minutes latter it restart again.
I run httpd with lxadmin.
MySQL Process List - State = Locked
Aug 18, 2008When i login to the root for the server and go to mysql process list i see a lot of processes that are connected to photo handling and the sate is Locked with over 500 seconds of each one.
I see there is one process that the state says: Copying to tmp table
I read online that if this is taking long it might lock up other queries causing your server to perform slow and only solution is to restart mysql servers.
Right now i have over 100 queries that say Locked and one that says Copying to tmp table....each time i have to restart the mysql services but this happens every 10 minutes as i have enough traffic to cause this problem.
Http Server And MySQL Process Appears All 3 Times
Jan 10, 2008in one of our dedicated servers, when we go to WHM/Service Status / CPU Memory MySQL usage.. http server and MySQL process appears all 3 times...
is that normal?
i attach an email to be more clear.
Only 1 Mysql And 1 Running In Top
Aug 10, 2007I just got a new server and updated the OS etc. Since I am use to seeing the old top information I have questions about the new top data. Some of the differances
1. Many less processes (or task as it is now called) then before.
2. Mysql is only shown once with a long time value. Before I had serveral mysql task and time was short
3. In most cases I have only 1 process running but in the onld system it jumped around from 4 to 10
4. The HTTP task below shows a long time and I see very few. Before had at least 10 shown and the time was very short.
Any ideas if maybe I have a setting wrong that is allows less theads or processes to be created?
Apache 2.2
Plesk 8.2
Fedora Code 6
mysql 5
top - 07:56:45 up 28 days, 11:49, 1 user, load average: 0.18, 0.17, 0.17
Tasks: 121 total, 1 running, 120 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni, 97.0%id, 3.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 1.0%us, 0.3%sy, 0.0%ni, 97.0%id, 1.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 5.3%us, 0.7%sy, 0.0%ni, 94.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3360708k total, 3203700k used, 157008k free, 220304k buffers
Swap: 2031608k total, 4208k used, 2027400k free, 2269484k cached
PID to kill:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1521 mysql 15 0 404m 90m 4576 S 6 2.8 245:28.29 mysqld
13298 apache 15 0 40532 12m 4380 S 0 0.4 0:03.31 httpd
14021 apache 15 0 40616 12m 4416 S 0 0.4 0:02.75 httpd
14462 apache 15 0 41216 13m 4452 S 0 0.4 0:03.05 httpd
16330 apache 15 0 40644 12m 4184 S 0 0.4 0:01.10 httpd
16558 root 15 0 2200 1016 796 R 0 0.0 0:01.68 top
1 root 15 0 2044 604 520 S 0 0.0 0:02.27 init
MySQL Database Service Stops From Running
Jan 4, 2008I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
May 8, 2009Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
Nobody Process
Apr 13, 2009We have many process under nobody user, so our server load is Very high and its not good.
Here is our server log about one of this process:
Code:
Time: Mon Apr 13 11:36:33 2009 +0430
PID: 4415
Account: nobody
Uptime: 25532 seconds
Executable:
/usr/local/lsws/bin/lshttpd.4.0
Command Line (often faked in exploits):
What Does This Process Mean
Jul 9, 2007i have always this process in my server ;
Code:
2 root RT 0 0 0 0 S 0 0.0 0:00.02 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.08 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:06.43 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.31 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:05.22 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.82 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:01.41 migration/3
9 root 34 19 0 0 0 S 0 0.0 0:00.08 ksoftirqd/3
what doeas mean , and for wich application are this proccess
Process Tracking
May 18, 2009How can track and follow a process id.
For example i need to know what is following process:
14764 root 39 15 11712 9.8m 1668 R 20 0.1 0:14.22 perl
I need to know wich/where file used perl with process id 14764
What Is Kacpid Process
Oct 30, 2009I am noticing that the kacpid process causing high cpu load.
What does kacpid do? Is there a way to fix for this problem?
Quote:
# ps aux|grep kacpid
root 29 59.6 0.2 0 0 ? S< 22:13 42:20 [kacpid]
Quote:
# lsof -p 29
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
kacpid 29 root cwd DIR 8,2 4096 2 /
kacpid 29 root rtd DIR 8,2 4096 2 /
kacpid 29 root txt unknown /proc/29/exe
Quote:
# ls -l /proc/29/exe
/bin/ls: cannot read symbolic link /proc/29/exe: No such file or directory
lrwxrwxrwx 1 root root 0 Oct 30 22:13 /proc/29/exe
Quote:
# uname -r
2.6.18-164.el5PAE
8 Apache Process
Mar 17, 2008Ive recently installed installed and configured stuff on my new box but after, I realised abnormal memory usage.
Mysql server is taking 256mb, there are somewhere between 6 and 10 apache process taking up at least 40mb each.
Furthermore, when I do: top, I see that the memory usage is increasing by about 120ko each 3 sec.
I am running centos 5.1 and have a load of 0. Basically, there is no one on the server appart from me.
On the server I have at home running debian, I run all thoose thing and it take up 200mb
max.
Process Restarter
Jan 16, 2008write me a daemon that will run every 10 seconds.
If <process> has failed or run into issues, restart the process and then email me with details.
After installing LiteSpeed on my server with cPanel, a few processes have been having issues.
<process> = /opt/lsws/bin/lshttpd, pureftpd, named
Business Process
May 13, 2008I'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?
Httpd Process
Apr 16, 2008In 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
KeepAlive Off
MaxKeepAliveRequests 200
KeepAliveTimeout 15
StartServers 20
MinSpareServers 30
MaxSpareServers 40
MaxClients 600
MaxRequestsPerChild 250
in correct optimization for my apachi also my processer is dual xenon
Loop0 Process
Aug 12, 2008Whats is following peocess?
2011 root 0 -20 0 0 0 S 1 0.0 0:38.52 loop0
Php Process Cpu Spike
Mar 24, 2008Is it normal for PHP to spike in cpu usage often? Which setting in php.ini can affect the cpu usage?
View 6 Replies View RelatedTop Process - Zend
Nov 1, 2007how to sort this?
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
Frozen Process
Nov 15, 2007My 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.
Process Using High CPU
Sep 4, 2007I run a dedicated server, Running
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
Perl Process
Feb 14, 2007How do I trace what user this is?
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
Httpd Process
Mar 15, 2007I am having only 14 connections, but having many httpd processes.
root@server [~]# pidof httpd
1544 1498 1475 1239 835 686 684 572 570 535 478 32602 32601 32597 32544 32106 32 085 32082 30538 30536 29612 28981 28980 28978 28785 28778 28775 28759 28741 2843 4 28431 28428 28420 28394 28192 28116 27782 27694 27693 27692 27442 27399 27299 27288 27276 27262 27257 27252 27248 27146 27043 26970 26486 26385 26049 26023 25 703 25679 25621 24603 24602 24600 24526 22025 21963 21950 21915 21870 21858 2179 4 21697 21673 21525 21223 21211 21001 20784 20783 20780 20721 20713 20704 20696 20613 20605 20603 20179 19909 19718 19711 19530 19463 19462 19460 19456 19424 19 346 19283 19258 19232 19140 19123 19088 17926 17925 17924 17421 17420 17419 1505 4 15053 15052 14854 14676 14458 14457 14439 14343 14342 14340 14336 14267 14189 13899 13880 10021 10016 10014 10012 10011 10000 9999 9992 9991 9990 9989 9988 99 86 9979 9978 9977 9976 9973 9972 9970 9962 9961 9960 9959 9957 10293
root@server [~]# netstat -n | grep :80 | wc -l
14