Professional Web Applications Themes

CPU usage - MySQL

Hello, I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM and noticed that CPU is used at 90%. RAM usage is ok. Approx 50% free. I have approx 40 queries per second and I wonder if there isa anything I can do in my database config to improve performance apart from changing CPU. Do you suggest more CPU? Any suggestions? Thanks!...

  1. #1

    Default CPU usage

    Hello,

    I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
    and noticed that CPU is used at 90%.

    RAM usage is ok. Approx 50% free.

    I have approx 40 queries per second and I wonder if there isa anything
    I can do in my database config to improve performance apart from
    changing CPU. Do you suggest more CPU?

    Any suggestions? Thanks!

    ROB Guest

  2. #2

    Default Re: CPU usage

    "ROB" <robsia> wrote:
    >
    > I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
    > and noticed that CPU is used at 90%.
    >
    > RAM usage is ok. Approx 50% free.
    50% unused RAM is *not* OK.
    > I have approx 40 queries per second and I wonder if there isa anything
    > I can do in my database config to improve performance apart from
    > changing CPU. Do you suggest more CPU?
    40 qps is *nothing*

    A server that big should be able to handle 4000 qps. Probably your
    database schema and/or queries are not optimized (missing indexes,
    denormalized schema).

    You should turn on the slow-query-log and identify those queries.
    Then you can use EXPLAIN to find out, what to optimize.


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    MySQL User Forums: [url]http://forums.mysql.com/[/url]
    Axel Schwenke Guest

  3. #3

    Default Re: CPU usage

    "ROB" <robsia> wrote in message
    news:1141740572.523537.73410v46g2000cwv.googlegro ups.com...
    > I'm running mysql / innodb tables on a dual 2.8 xeon box with 2GB RAM
    > and noticed that CPU is used at 90%.
    What operating system brand and version? e.g. FreeBSD 4.4, Windows XP Pro
    sp2.
    What MySQL version? e.g. 4.0, 4.1, 5.0.

    There are certain combinations of OS and MySQL that have been reported to
    cause spurious increases in CPU load.

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. CPU usage is 99%
    By Twinlife in forum Macromedia Contribute Connection Administrtion
    Replies: 3
    Last Post: January 31st, 05:31 PM
  2. Hi cpu usage ?
    By Zack Whittaker \(R2 Mentor\) in forum Windows Vista
    Replies: 10
    Last Post: May 13th, 06:05 AM
  3. FCS CPU Usage 100%
    By video conferencing in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: October 12th, 09:04 PM
  4. OID Usage
    By Bo Lorentsen in forum PostgreSQL / PGSQL
    Replies: 42
    Last Post: January 15th, 10:30 PM
  5. pod::usage example help
    By Paul Kraus in forum PERL Beginners
    Replies: 2
    Last Post: January 10th, 05:20 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139