Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    111

    * mysql sucking too much cpu.. unusual

    [email protected] [~]# ps -fu mysql
    UID PID PPID C STIME TTY TIME CMD
    mysql 2223 1231 0 05:19 ? 00:00:00
    mysql 2244 1231 0 05:19 ? 00:00:01
    mysql 2265 1231 29 05:19 ? 00:20:52
    mysql 2286 1231 0 05:19 ? 00:00:00


    you notice that biggest cpu usage have process with largest C column whatever this is? I got some servers with same configuration (2,4 GHz) and that only one acting like this. CPU usage goes to 50% with only Queries per second avg: 34.047 on this server. servers with same configuration with 400 per second dont use 1/10 of that cpu time

    times mysqladmin processlist does not support usung so much cpu at all

    Anyone can suggest something?
    Last edited by nand; 08-01-2005 at 12:39 AM.

  2. #2
    Join Date
    Aug 2004
    Location
    PA
    Posts
    59
    Two things:

    One how about an example of the output of

    show processlist;

    and also is this a cpanel server? Used for hosting? Thanks.

  3. #3
    Join Date
    Aug 2004
    Location
    PA
    Posts
    59
    Hey while your at it lets have a look at the output of top right after.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •