hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Mysql Process using too much CPU
Reply

Forum Jump

Mysql Process using too much CPU

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 08-21-2011, 07:41 AM
rcpkrc rcpkrc is offline
WHT Addict
 
Join Date: Jul 2006
Posts: 166

Mysql Process using too much CPU


hello friends, while l check the mysql process list l see this which causing high page load.

PHP Code:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/servername.pid --skip-external-locking 
what can l do to solve it?

__________________
Breaking News | Video
serversupport.us for sale if u have nice offers..



Sponsored Links
  #2  
Old 08-21-2011, 07:49 AM
fabin fabin is offline
Web Hosting Master
 
Join Date: Mar 2009
Location: Gods Own Country
Posts: 643
use mtop to find the queries that are causing the problem.

__________________
Fabin Mundattil @ Xieles Support
High Quality Server Management | support @ xieles.com
http://xieles.com

  #3  
Old 08-21-2011, 08:41 AM
rcpkrc rcpkrc is offline
WHT Addict
 
Join Date: Jul 2006
Posts: 166
here is the top list of my server....
Quote:
4631 mysql 15 0 195m 93m 3768 S 133.7 1.1 28:12.45 mysqld
8725 nobody 17 0 43184 29m 5388 S 45.2 0.4 0:00.22 php
8728 nobody 18 0 29516 15m 5068 R 14.4 0.2 0:00.07 php
4238 root 15 0 2428 1116 792 R 2.1 0.0 0:01.25 top
7266 dailynew 15 0 389m 375m 5268 S 2.1 4.6 0:00.89 php
7828 nobody 15 0 11532 4664 1744 S 2.1 0.1 0:00.07 httpd
13405 nobody 15 0 38788 33m 844 S 2.1 0.4 8:56.95 nginx
1 root 15 0 2160 644 556 S 0.0 0.0 0:02.60 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.20 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.11 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.23 migration/1
6 root 37 19 0 0 0 S 0.0 0.0 0:00.11 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.28 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.12 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.18 migration/3
12 root 39 19 0 0 0 S 0.0 0.0 0:00.05 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root RT -5 0 0 0 S 0.0 0.0 0:00.24 migration/4
15 root 34 19 0 0 0 S 0.0 0.0 0:00.12 ksoftirqd/4
16 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/4
17 root RT -5 0 0 0 S 0.0 0.0 0:00.18 migration/5
18 root 34 19 0 0 0 S 0.0 0.0 0:00.09 ksoftirqd/5
19 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/5
20 root RT -5 0 0 0 S 0.0 0.0 0:00.25 migration/6
21 root 34 19 0 0 0 S 0.0 0.0 0:00.15 ksoftirqd/6
22 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/6
23 root RT -5 0 0 0 S 0.0 0.0 0:00.15 migration/7
24 root 34 19 0 0 0 S 0.0 0.0 0:00.09 ksoftirqd/7
25 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/7
26 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
27 root 10 -5 0 0 0 S 0.0 0.0 0:00.06 events/1
28 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
29 root 10 -5 0 0 0 S 0.0 0.0 0:00.24 events/3
30 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/4
31 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/5
32 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/6
33 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 events/7
34 root 10 -5 0 0 0 S 0.0 0.0 0:02.51 khelper

__________________
Breaking News | Video
serversupport.us for sale if u have nice offers..

Sponsored Links
  #4  
Old 08-21-2011, 08:45 AM
fabin fabin is offline
Web Hosting Master
 
Join Date: Mar 2009
Location: Gods Own Country
Posts: 643
what you need to look at is the result of "mtop", not top

http://mtop.sourceforge.net/

__________________
Fabin Mundattil @ Xieles Support
High Quality Server Management | support @ xieles.com
http://xieles.com

  #5  
Old 08-21-2011, 09:23 AM
Eminds - GM Eminds - GM is offline
Web Hosting Evangelist
 
Join Date: Oct 2010
Posts: 546
You can try mysqladmin proc command to see the exact queries to exact databases which is causing these issues. It will give you the exact output and an idea of what causing the issues.

  #6  
Old 08-21-2011, 10:14 AM
rcpkrc rcpkrc is offline
WHT Addict
 
Join Date: Jul 2006
Posts: 166
l tried to install mtop but l couldnt manage. and l dont know how to try mysqladmin proc command.

__________________
Breaking News | Video
serversupport.us for sale if u have nice offers..

  #7  
Old 08-21-2011, 10:21 AM
rcpkrc rcpkrc is offline
WHT Addict
 
Join Date: Jul 2006
Posts: 166
here is the mysqladmin proc list for u mate
Quote:
+-------+-------------+-----------+--------------+---------+------+------------- ---+---------------------------------------------------------------------------- --------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------------+-----------+--------------+---------+------+------------- ---+---------------------------------------------------------------------------- --------------------------+
| 28115 | rcpkrc_rk | localhost | rcpkrc_video | Sleep | 0 | | |
| 28410 | rcpkrc_rk | localhost | rcpkrc_video | Query | 0 | Writing to n et | SELECT p.post_title, p.comment_count, p.post_date, p.ID, COUNT(tr.object_id ) AS counter
FROM w |
| 28479 | newstv_rk | localhost | newstv_db | Sleep | 0 | | |
| 28566 | rcpkrc_rk | localhost | rcpkrc_video | Query | 1 | Sending data | SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2011-03-04 07:27:09' AN D p.post_type = 'post' AN |
| 28570 | dailynew_rk | localhost | dailynew_db | Query | 0 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_po sts.post_type = 'post' AN |
| 28572 | euronews_rk | localhost | euronews_db | Sleep | 0 | | |
| 28573 | root | localhost | | Query | 0 | | show processlist

__________________
Breaking News | Video
serversupport.us for sale if u have nice offers..

  #8  
Old 08-22-2011, 12:20 AM
Eminds - GM Eminds - GM is offline
Web Hosting Evangelist
 
Join Date: Oct 2010
Posts: 546
The database in the above post "rcpkrc_video" looks the culprit , however contact your developer who have developed the database and have them to optimize the DB , since its showing sleep status.

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Kiling a process that is using too much cpu captain_squash Hosting Security and Technology 4 11-14-2011 02:06 PM
100% CPU PHP Process kokyew Hosting Security and Technology 7 02-12-2010 11:28 AM
mysql process taking up all my CPU BootsSiR Hosting Security and Technology 1 06-16-2006 08:57 PM
Apache process using 100% of CPU k2host Hosting Security and Technology 5 01-12-2006 03:42 PM
process on CPU queue Lem0nHead Hosting Security and Technology 1 03-22-2005 08:18 AM

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
Web Hosting Sales and Promos Roundup - September 20, 2013 Web Hosting News 2013-09-20 18:35:29
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00
Disruption and Opportunities in this New Era, with Tod Nielsen Web Hosting News 2013-02-05 15:43:57


Tags
mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?