Wich User Have More Mysql Process?
How can see wich user have more mysql process?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Why User Root Is Running Process Httpd All Time
I 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
View Replies!
View Related
Heavy Mysql Process
on 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?
View Replies!
View Related
Mysql And EOPNOTSUPP Process
I 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
View Replies!
View Related
MySQL Process List - State = Locked
When 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.
View Replies!
View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
Nobody Process
We 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):
View Replies!
View Related
What Does This Process Mean
i 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
View Replies!
View Related
Process Tracking
How 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
View Replies!
View Related
What Is Kacpid Process
I 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
View Replies!
View Related
8 Apache Process
Ive 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.
View Replies!
View Related
Process Restarter
write 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
View Replies!
View Related
Business Process
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?
View Replies!
View Related
Httpd Process
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 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
View Replies!
View Related
Frozen Process
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.
View Replies!
View Related
Perl Process
How 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
View Replies!
View Related
Httpd Process
I 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
View Replies!
View Related
Perl Process
We are using FreeBsd with Cpanel. Some one has upload some scripts,they are running and attacking to other systems. last pid: 64017; load averages: 59.59, 60.75, 63.04 up 19+22:52:28 12:03:45 457 processes: 61 running, 315 sleeping, 81 zombie CPU states: 52.4% user, 0.0% nice, 47.6% system, 0.0% interrupt, 0.0% idle Mem: 465M Active, 212M Inact, 236M Wired, 22M Cache, 111M Buf, 62M Free Swap: 2048M Total, 458M Used, 1590M Free, 22% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 3282 root 128 0 37536K 30520K RUN 3:49 4.79% 4.79% perl 62953 root 128 0 30284K 25248K RUN 0:05 1.90% 1.90% perl 49249 root 128 0 33720K 28876K RUN 0:46 1.86% 1.86% perl 2981 root 128 0 40928K 30724K RUN 3:56 1.56% 1.56% perl 76809 nobody 127 0 4148K 2080K RUN 13:52 1.42% 1.42% perl5.8.8 19633 nobody 127 0 4148K 2128K RUN 2:34 1.42% 1.42% perl5.8.8 57451 nobody 126 0 4148K 2072K RUN 39:24 1.22% 1.22% perl5.8.8 76599 nobody 126 0 4148K 2080K RUN 13:53 1.22% 1.22% perl5.8.8 76966 nobody 126 0 4148K 2080K RUN 14:01 1.17% 1.17% perl5.8.8 60286 nobody 126 0 4148K 2072K RUN 38:42 1.12% 1.12% perl5.8.8 77488 nobody 126 0 4148K 2080K RUN 13:48 1.12% 1.12% perl5.8.8 77697 nobody 126 0 4148K 2080K RUN 13:47 1.12% 1.12% perl5.8.8 56573 nobody 126 0 4148K 2096K RUN 39:55 1.07% 1.07% perl5.8.8 58126 nobody 126 0 4148K 2072K RUN 39:11 1.07% 1.07% perl5.8.8 76513 nobody 126 0 4148K 2080K RUN 13:58 1.07% 1.07% perl5.8.8 76807 nobody 126 0 4148K 2080K RUN 13:57 1.07% 1.07% perl5.
View Replies!
View Related
How To Watch/trace A Process?
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?
View Replies!
View Related
Assign IP To Java Process
I'm running centOS 5 and I have a java process, it runs from the main IP. The Java process communicates with an external server, this server only allows 2 connections per IP. I have this process running twice on the main IP, therefore using both the single IP connections. My server has multiple IPs and I want to run another copy of this java process from another IP.
View Replies!
View Related
32004 Owner Process
Whats following process (owner: 32004) 18689 32004 0 1.6 0.1 /usr/local/cpanel/3rdparty/bin/php-cgi -c /usr/local/cpanel/3rdparty/etc/phpmyadmin /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php
View Replies!
View Related
Background Process Killer
can anybody tell me more about Background Process Killer on cpanel? BitchX bnc eggdrop generic-sniffers guardservices ircd psyBNC ptlink services what are them and which of them must enable in Background Process Killer option?
View Replies!
View Related
|
TRACKER
