Stop 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.
ADVERTISEMENT
I Should Stop Rebuilding Process And Run Fsck Now?
Feb 28, 2008Today I noticed that my server becames unavailable.
I made remote reboot, and server did not back. I asked my host to connect remote console to this server. After that I get information, that fsck failed to complete and I need to run it manually.
I put my root password and then noticed that RAID-1 array is rebuilding.
Do I have to wait untill RAID-1 (HARDWARE) array completes rebuild and then run
fsck -r /dev/sda1
?
or I should stop rebuilding process and run fsck now?
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 ?
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 View RelatedHeavy 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 RelatedMySQL 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.
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).
Anyone Good With Mysql
Oct 2, 2007Anyone know how to kill or prevent a bunch of sleeping mysql processes on a shared linux box? I'm getting up past my max php/mysql connections limit and it's now taking my entire arcade script down (which is onarcade, btw)
I've tried adding a mysql_close at the end of each script, but this hasn't helped. BTW -I use mysql_connect, not mysql_pconnect.
URL ->>
[url]
| 11351210 | gameofte_games | localhost | gameofte_onarcade | Sleep | 69 | | |
| 11351223 | gameofte_games | localhost | gameofte_onarcade | Sleep | 65 | | |
| 11351225 | gameofte_games | localhost | gameofte_onarcade | Sleep | 65 | | |
| 11351239 | gameofte_games | localhost | gameofte_onarcade | Sleep | 60 | | |
| 11351265 | gameofte_games | localhost | gameofte_onarcade | Sleep | 50 | | |
| 11351269 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 50 | | |
| 11351277 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 48 | | |
| 11351280 | gameofte_games | localhost | gameofte_onarcade | Sleep | 47 | | |
| 11351285 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 46 | | |
| 11351323 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 36 | | |
| 11351331 | gameofte_games | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351332 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351335 | gameofte_games | localhost | gameofte_onarcade | Sleep | 34 | | |
| 11351356 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 28 | | |
| 11351358 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 27 | | |
| 11351380 | gameofte_games | localhost | gameofte_onarcade | Sleep | 20 | | |
| 11351384 | gameofte_games | localhost | gameofte_onarcade | Sleep | 20 | | |
| 11351387 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 19 | | |
| 11351394 | gameofte_games | localhost | gameofte_onarcade | Sleep | 18 | | |
| 11351401 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 16 | | |
| 11351408 | gameofte_games | localhost | gameofte_onarcade | Sleep | 15 | | |
| 11351416 | gameofte_games | localhost | gameofte_onarcade | Sleep | 9 | | |
| 11351417 | gameofte_games | localhost | gameofte_onarcade | Sleep | 9 | | |
| 11351434 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 4 | | |
| 11351454 | gameofte_games | localhost | gameofte_onarcade | Sleep | 1 | | |
| 11351459 | gameofte_ko | localhost | gameofte_onarcade | Sleep | 0 | | |
Shared Hosting With Good Mysql Performance
Jun 7, 2008I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
List Of Good Hosters With Good TELEPHONE Tech Support
May 6, 2008I'd like to start an ongoing thread here listing the 'Good Hosters with Good TELEPHONE tech support'. In other words, out of the 1,000s of host companies, this may cut it down to less than a dozen.
( And for all you Hosters out there who really want your company to grow, and want to know how, - it's easy: just read here.)
Good telephone support is the #1 ultimate requirement, because:
-It's a lot faster and easier for both the user and the host company, because you can state and answer all questions and clarifications on the spot, you don't need to continually pass new emails with new questions and clarifications, back and forth for days on end, until the issue is solved. It saves tech time and user's time. And saves a lot of nerves.
- It's the best way to sort the good guys from the bad. A bad company isn't going to bother to answer the phone, - or will make you wait way too long, - because they are likely getting endless complaints. The good guys are always ready to answer the phones, with a friendly voice, - because they really WANT to please the customer.
- If a company can't be bothered to pick up the phone, we can't be bothered to even consider them. They're a joke, and so won't be listed here on this thread. (So, before adding or listing any Hosters here, please verfify that they do have Good, quick, friendly, telephone support,; ideally 24/7, but 9am to 10pm might be acceptable, if it was supplemented by some emergency contact.
AND:
- Hoster ALSO needs good EMAIL support (and preferably, Chat online, extended hour availability). (I spend a lot of time overseas). It sems all emails should get a non-automated response within about an hour, - and then support should jump on fixing any problem.
I only need support a few times a year. To answer some questions, or fix a problem, or do an install. That's lesss than 1 hour total, so any company paying maybe $18/hour tech support should be able to handle this. It IS reasonable to charge a custm for extended calls, beyond say, 90minutes a year, IF you don't count the 80%? Of times an issue is the Hoster;s fault of stmg gone wrong, and don't count the 'hold' times.
ALSO IMPORTANT:
- Uptime
- site Speeds
- Monthly plans, no contract (Only a dishonest host will try to force you into a contract, where they can then ignore you.)
- Reasonable price. (? Maybe $12 to $18/month for a basic business site. We don't need massive bandwitdths, - we all know that's an overselling scam, and can't ever be delivered.)
- a good upgrade plan of bigger options. Maybe even VPS.
- Dedicated IP, and availbility of SSL
-PHP 5, mysql, phpMyAdmin, etc
- cPanel ( Some Hosts are using problematic panels, like Hsphere, which are slow to load, slow in operation, require many more clicks, have too many options, spread apart on many separate pages. Time is money, and this really slows down the ability of a small business to manage his own site in effective time. For example, one WHT user wrote somewhere: "I don't feel that HSphere's interface is nice at all, although I have worked with cPanel and DA all my life... I just found it to include un-necessary features or split features up in to different hard to find pages, such as backups - mysql backups you had to find on a completely different page than file backups, and then there were options to have it in the home directory or server-end backup, in which then you had to wait a good 10 minutes before it was ready. cPanel, just hit backup and hit download and instantly it does everything you need...".
I have used several hosters. Currently on Aplus.net and Godad, which have phone support, and mediocre service.
My LIST So Far:
- Liquidweb: a very impressive company with good, 24 hour support. But to get dedicated IP, you need to go with their $25/month plan. Yikes!
- NewIdeaHosting.com. A very small company. My call was returned, and the owner chatted with me for an hour on the phone! Plans have small bandwidth, but promises No overselling, and personalized attention. Extra $5 for dedi IP. He specializes in Small business sites, and small eCommerce sites. He has only 250 accounts, on 3 servers. He rents servers from the Equinox data center of Chicago. Seems exceptionaly honest.
- MegaHosters. Excellent phone support and WHT reviews. But company was taken over by another company, and so may well go downhill in future. Another problem: uses Hsphere.
- Steadfast. Has a good rep on WHT, and seems impressive. Tech answered the phone immediately, but they say they prefer emails. Sales phone has limited hours. Good price on $20 SSL. But, uses Hshhere.
- JodoHost 24 hour phone. But, uses Hsphere. An Indian company with office in Florida, and good rep. I like the idea of outsourcing phone support, if it makes it more available and affordable. But, the accent on the phone was very hard for me to understand, so maybe this might not work.....
- Hostgator. Yes, it's a big overseller, but seems to get good reviews/results anyway, and good phone support.
- ? ThePrimeHost ?? Mostly good WHT reviews; some dissenters. Site says 24hour phone, but when I called on several nights, no one ever answered...
- Can anyone add to this list? Please list only hosts that meet the above minimum requirements of phone support, etc. Especially useful is hosters you've tried.
TO AVOID:
- Avoid Arvixe. I had a horrid experience with them, here: [WHT forum]:/showthread.php?p=5097822#post5097822
- Avoid WebHostingBuzz. This company never returned my phone msessage inquiries.
Good Avocado Really Good
Oct 20, 2008Any experience with Good Avocado and their reseller plan?
What about Thinkhost, good avocado is partnering with?
Wind and solar energy, it sounds all good, the reseller plan is awesome.
Any real life experience?
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?
What Is This Running Process
Feb 19, 2008I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL
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