Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unanswered: URGENT - SQL is eating my CPU

    Hello,

    i have a dedicated server which is:
    AMD Athlon(tm) II X4 605e Processor
    16GB Rams
    1.5TB
    ---

    Now i have SQL which is sometimes using up to 390% of my CPU & causing a HUGEEEEEEEEEEE server load.

    that's my my.cnf:

    [mysqld]
    max_connections = 1000
    table_cache = 4096
    thread_cache_size = 64
    key_buffer = 64M
    query_cache_size = 128M
    join_buffer_size = 256K
    myisam_sort_buffer_size = 64M
    thread_concurrency = 5

    [isamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M

    Need help to fix it ASAP please server will bomb soon :/

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i don't know if i'll be able to help, i just wanted to say that nobody is going to be able to help you if you don't show the SQL that's causing the problem

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2011
    Posts
    2
    Quote Originally Posted by r937 View Post
    i don't know if i'll be able to help, i just wanted to say that nobody is going to be able to help you if you don't show the SQL that's causing the problem

    i have no idea i checked the biggest sql status by phpmyadmin all looks fine!!!
    so not even sure which one or i would stop it for now.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    check the log files
    examine the applications, look at the SQL being used
    check the indexes
    EXPLAIN queries
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by M4r5h4ll View Post
    i have SQL which is sometimes using up to 390% of my CPU
    I assume in your universe that the rules of maths are slightly different to our own?

  6. #6
    Join Date
    Apr 2011
    Location
    Pakistan
    Posts
    28
    is this MYSQL ?

    is this on Windows or Linix ?

  7. #7
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    Quote Originally Posted by M4r5h4ll View Post
    i have no idea i checked the biggest sql status by phpmyadmin all looks fine!!!
    so not even sure which one or i would stop it for now.
    we all need some clarity regarding your question then some one can help u from it try to elaborate it
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

Posting Permissions

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