How To Find Which Mysql User Is Using All Cpu

Nov 13, 2008

31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql

This is my top process, I have quad core server and because of this server load is over 10

I am using cPanel, is it possible to trace which user is using all this cpu?

View 6 Replies


Find User Bandwidth From SSH (CPanel)

May 11, 2009

Does anyone happen to know how to find the current bandwidth usage for users in CPanel via SSH? I found disk space, which is /scripts/dumpquota, but I can't find the bandwidth.

View 8 Replies View Related

Plesk 11.x / Linux :: Find Spam Relaying User?

Jun 20, 2014

I facing a serious problem with my qmail and plesk 11.0.9.I found the way spammer did with my server by listening everything on port 25. Maybe he know the RCPT hosts of mine, and they send emails with random username but with domain hosted on my Plesk. (, user2@ my, ...

qmail only check domain in RCPT if spammer input:"mail from" - (with out ":") - no email address on my server.then server reply: 550, no mailbox here by that name. (#5.7.17)

But qmail check username and domain if spammer input:""mail from:" - (with ":") - no email address on my server. Then server reply: 250 OK..This is really weird! I tried with all my plesk server, this bug still effected.Click to expand...

View 2 Replies View Related

Plesk 12.x / Linux :: Spamassassin Errors - Unable To Find User

May 24, 2015

I just migrated a bunch of domains from plesk 11.5. Everything appears to be working well however when examining the maillog, I am seeing some strange errors... In this example, the message was delivered and had the spamassassin stuff in the header.

spamd: handle_user unable to find user: ''

View 4 Replies View Related

How To Find Path To MySQL

Sep 1, 2007

How to find path to MySQL ?

I need to know command for check path to MySQL.

View 2 Replies View Related

Mysql Usage: High CPU %, How Do I Find Out Who's Using What

Aug 3, 2008

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...

View 6 Replies View Related

Error Backup, Transfer To New Server "Unable To Find The Cpanel User File."

Jul 11, 2007

I have problem:

Searching /root....
Found cpmove-clanpz.tar.gz!
Moving Packge to /root/cprestore/cpmove-clanpz.tar.gz

Extracting tarball....window.scroll(0,175);...............

Extracting Domain....Done

Sorry, the copy failed. Unable to find the cpanel user file. Is the archive missing (cwd: /root/cprestore loaded cpmove-clanpz/cp/clanpz)?
checked 4 files.....

1. /scripts/pkgacct username...
2. Transfer backup to new server
3. /scripts/restorepkg username
4. this error

View 14 Replies View Related

How To Find Out Which Account Is Making The Biggest Load On Mysql

Apr 26, 2008

My Server Is down nearly every day in the last three days

I think one of my clients is sending emails from his forum to his members.

How can I know who is he, And most important can I stop him from emailing his members?


How can I find out which account is making the biggest load on MySQL?

View 4 Replies View Related

Connect To MySQL DB Only On Certain User

Apr 20, 2009

I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).

View 9 Replies View Related

Wich User Have More Mysql Process?

May 25, 2009

How can see wich user have more mysql process?

View 2 Replies View Related

Allow User To Remote Mysql Connection

Aug 15, 2008

how to allow user to remote mysql connection from his localhost ( in linux server with WHM )

my user wants to connect to the mysql from his localhost

View 7 Replies View Related

MySQL Forgetting User Permissions

Jul 5, 2007

Does anyone know what could be the cause of this issue? I located a few others over at that have this problem, but no solution has been found.


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 -
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.

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 3 Replies View Related

Mysql/user Is Marked As Crashed

Jan 30, 2007

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 7 Replies View Related

What Are Common MySQL User Permissions

Jun 29, 2007

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 3 Replies View Related

Backup Mysql User Privileges

Aug 26, 2007

how do i backup mysql user privileges?

this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql

i would like to backup mysql user privileges too.

View 1 Replies View Related

MySQL Anyway To Log Queries Of Specific User

Jun 5, 2007

I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.

View 0 Replies View Related

Default Host For Mysql User

Aug 7, 2007

By default, mysql will create user with host as 'localhost'. Now, if I want the host is '' by default, how to configure it?

View 3 Replies View Related

Change Mysql User Password Via Shell?

Jun 8, 2005

Anyone know the commands to change a MySQL user's password via ssh?

I found stuff for changing the root password, and tried to adapt it for the user, but it didn't work.

View 12 Replies View Related

MySQL Replication For User On Shared Server

Nov 6, 2008

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';

2. Stop mysql server and Add in my.cnf:
start server[url]

3. execute:
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 5 Replies View Related

Mysql User Privilege Changed By Cpanel Or What

Jun 26, 2008

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 4 Replies View Related

MySQL: Access Denied For Root User

Oct 25, 2007

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 8 Replies View Related

MySQL Overload Server, Wich User

Jul 5, 2007

how check which database / user MySQL overload the server?

View 2 Replies View Related

Plesk Automation :: Set User And Privileges From Mysql

Jul 3, 2014

I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.

View 2 Replies View Related

Weird MySQL: User/pass Stops Working After A While

Mar 29, 2009

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 8 Replies View Related

Granting MySQL Command Line Permissions To A User

Sep 3, 2007

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 7 Replies View Related

Copyrights 2005-15, All rights reserved