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.

high number of aborted connections

Discussion in 'Workarounds and Optimization' started by jimlongo, Oct 18, 2013.

  1. jimlongo

    jimlongo Well-Known Member

    Joined:
    Mar 20, 2008
    Messages:
    145
    Likes Received:
    2
    Trophy Points:
    18
    Hi, I wonder if anyone would be so kind to offer any advice.

    This has just started happening in the last week or so without any new applications that I can point to.
    The number of aborted clients and connections has become very high. Since I flushed the STATUS yesterday there are over 300 (20%) aborted clients and 1.1k aborted connections.

    This is not a super busy server (I don't think) about 30 dbs most with pretty low traffic. Drupal, wordpress, eCommerce, phplist.

    The mysql server is currently using about 40% of available memory.
    7736 mysql 18 0 983m 425m 8352 S 0.0 41.6 1:01.78 /usr/sbin/mysqld --basedir=/usr --datad


    When I had the general log enabled I couldn't see any reference to dropped connections or clients, also nothing in the error.log

    I've been tuning my.cnf over the last month or so and i'm wondering if I've set something that is causing this?

    here is the most recent mysqltuner report.
    Code:
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.33a-MariaDB
    [OK] Operating on 32-bit architecture with less than 2GB RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables: 95M (Tables: 24)
    [--] Data in InnoDB tables: 104M (Tables: 1297)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [!!] Total fragmented tables: 1297
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 2h 45m 2s (228K q [2.370 qps], 7K conn, TX: 279M, RX: 41M)
    [--] Reads / Writes: 57% / 43%
    [--] Total buffers: 498.0M global + 2.8M per thread (50 max threads)
    [OK] Maximum possible memory usage: 637.3M (62% of installed RAM)
    [OK] Slow queries: 0% (1/228K)
    [OK] Highest usage of available connections: 12% (6/50)
    [OK] Key buffer size / total MyISAM indexes: 128.0M/17.6M
    [!!] Key buffer hit rate: 88.0% (292K cached / 35K reads)
    [OK] Query cache efficiency: 77.6% (134K cached / 173K selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts)
    [OK] Temporary tables created on disk: 20% (1K on disk / 7K total)
    [OK] Thread cache hit rate: 99% (10 created / 7K connections)
    [OK] Table cache hit rate: 25% (1K open / 7K opened)
    [OK] Open file limit used: 1% (106/5K)
    [OK] Table locks acquired immediately: 99% (71K immediate / 71K locks)
    [!!] Connections aborted: 20%
    [OK] InnoDB data size / buffer pool: 104.8M/256.0M
    
    
    and here is the my.cnf file
    Code:
    [mysqld]
    default-storage-engine=INNODB
    character-set-server=utf8
    collation-server=utf8_general_ci
    local-infile=0
    max_connections=50
    max_allowed_packet=32M
    wait_timeout=300
    
    innodb_buffer_pool_size=256M
    open_files_limit=5698
    thread_cache_size=4
    table_open_cache=1800
    query_cache_size=32M
    query_cache_limit=32M
    
    tmp_table_size=66M
    max_heap_table_size=66M
    
    join_buffer_size=132k
    
    general_log=0
    general_log_file=/var/lib/mysql/general.log
    #slow_query_log_file=/var/lib/mysql/slow.log
    
    [mysqld safe]
    log-error=/var/lib/mysql/vps.domain.com.err
    
     
    #1 jimlongo, Oct 18, 2013
    Last edited: Oct 18, 2013
  2. jimlongo

    jimlongo Well-Known Member

    Joined:
    Mar 20, 2008
    Messages:
    145
    Likes Received:
    2
    Trophy Points:
    18
    Found that the aborted connections where coming from the stats collection in CSF.
    The user password for 'root' was not recognized from /root/.my.cnf since I had changed 'pass' to 'password'
    Supplying the password cleared that up.

    Why password is not recognized is another issue.

    Thanks.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page