The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql queries won't die off. Screenshot attached.

Discussion in 'General Discussion' started by gundamz, Mar 30, 2008.

  1. gundamz

    gundamz Well-Known Member

    Joined:
    Mar 27, 2002
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    Hi guys,

    A picture speak a thousand words. These mysql queries won't die off. Now, other accounts are taking forever to access mysql on the server. Any ideas what is the cause of the problem?

    http://i29.tinypic.com/2ninnet.jpg
     
    #1 gundamz, Mar 30, 2008
    Last edited by a moderator: Mar 30, 2008
  2. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    559
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
    ouch ... mysql

    There are a few solutions here.

    What do you have in your my.cnf file?

    (normally in /etc/my.cnf )

    WARNING Here is one of ours... DO NOT COPY UNLESS YOU HAVE 16GB RAM and 8 Processors



    skip-locking
    skip-innodb
    #skip-networking
    safe-show-database
    query_cache_limit=1M
    query_cache_size=512M ## 32MB for every 1GB of RAM
    query_cache_type=1
    max_user_connections=200
    max_connections=1500
    interactive_timeout=10
    wait_timeout=20
    connect_timeout=20
    thread_cache_size=128
    key_buffer=2048M ## 128MB for every 1GB of RAM
    join_buffer=1M
    max_connect_errors=20
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=16M ## 1MB for every 1GB of RAM
    read_buffer_size=16M ## 1MB for every 1GB of RAM
    read_rnd_buffer_size=16M ## 1MB for every 1GB of RAM
    thread_concurrency=8 ## Number of CPUs x 1
    myisam_sort_buffer_size=64M
    server-id=1
    log_slow_queries=/var/log/mysql-slow-queries.log
    long_query_time=2
    collation-server=latin1_general_ci
    old-passwords = 1

    [mysqldump]
    quick
    max_allowed_packet=16M

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M




    --

    Turn on logging and take a peek @ what is sitting there.
    Are there any Apache Processes Hanging ?


    We have a few python scripts that might be able to help the hanging httpd processes worse case...
     
  3. hostmedic

    hostmedic Well-Known Member

    Joined:
    Apr 30, 2003
    Messages:
    559
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Washington Court House, Ohio, United States
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page