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.

mysqltuner output

Discussion in 'Workarounds and Optimization' started by senwar, Sep 5, 2013.

  1. senwar

    senwar Registered

    Joined:
    Sep 5, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    hello!!

    Why can help me?!!

    mysqltunnel :
    Code:
    >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    Please enter your MySQL administrative login: root
    Please enter your MySQL administrative password:
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.0.96-log
    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: -Archive +BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 7K (Tables: 17)
    [--] Data in InnoDB tables: 385M (Tables: 424)
    [!!] BDB is enabled but isn't being used
    [!!] Total fragmented tables: 1
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 4d 20h 26m 36s (202M q [482.762 qps], 11M conn, TX: 334M, RX: 1B)
    [--] Reads / Writes: 65% / 35%
    [--] Total buffers: 1.6G global + 14.5M per thread (500 max threads)
    [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
    [!!] Maximum possible memory usage: 8.6G (145% of installed RAM)
    [OK] Slow queries: 0% (7K/202M)
    [OK] Highest usage of available connections: 49% (246/500)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/90.0K
    [OK] Key buffer hit rate: 96.4% (5K cached / 217 reads)
    [OK] Query cache efficiency: 23.7% (27M cached / 116M selects)
    [OK] Query cache prunes per day: 12
    [OK] Sorts requiring temporary tables: 0% (830 temp sorts / 23M sorts)
    [OK] Temporary tables created on disk: 0% (1K on disk / 8M total)
    [OK] Thread cache hit rate: 99% (4K created / 11M connections)
    [!!] Table cache hit rate: 1% (256 open / 25K opened)
    [OK] Open file limit used: 0% (1/65K)
    [OK] Table locks acquired immediately: 99% (137M immediate / 137M locks)
    [OK] InnoDB data size / buffer pool: 385.3M/768.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-bdb to MySQL configuration to disable BDB
        Run OPTIMIZE TABLE to defragment tables for better performance
        Increase table_cache gradually to avoid file descriptor limits
    Variables to adjust:
      *** MySQL's maximum memory usage is dangerously high ***
      *** Add RAM before increasing MySQL buffer variables ***
        table_cache (> 32512)
    
    my.cnf :
    Code:
    [mysqld]
    default-storage-engine=innodb
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    log-slow-queries=/var/lib/mysql/slow.log
    user=mysql
    #innen
    skip-name-resolve
    thread_concurrency=4
    max_connections = 500
    innodb_buffer_pool_size = 768M
    #innodb_log_file_size = 128M
    innodb_log_buffer_size = 16M
    innodb_additional_mem_pool_size = 20M
    innodb_flush_method=O_DIRECT
    #innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend
    innodb_flush_log_at_trx_commit = 2
    join_buffer_size=10M
    read_buffer_size=2M
    sort_buffer_size=2M
    table_cache=51200
    #table_definition_cache = 3000
    #table_open_cache = 5000
    thread_cache_size=64
    thread_stack = 256K
    interactive_timeout=20
    wait_timeout=15
    max_allowed_packet=16M
    max_connect_errors=10
    query_cache_limit=1M
    query_cache_size=765M
    query_cache_min_res_unit=756K
    query_cache_type=1
    flush
    flush_time=3600
    long_query_time = 10
    safe-show-database
    collation_server=utf8_unicode_ci
    character_set_server=utf8
    
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    
    # To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
    # these lines and adjust the connectstring as needed.
    #ndbcluster
    #ndb-connectstring="nodeid=4;host=localhost:1186"
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    open_files_limit=8192
    [ndbd]
    # If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
    # adjust its connection to the management daemon here.
    # Note: ndbd init script requires this to include nodeid!
    connect-string="nodeid=2;host=localhost:1186"
    
    [ndb_mgm]
    # connection string for MySQL Cluster management tool
    connect-string="host=localhost:1186"
    
    Who can help? :\
     
  2. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Friendly Moderator Note

    Please do not start multiple threads for the same question or problem.

    You made four (4) almost identical posts for the same problem within just a few minutes. The posts were moderated, so you could not see them until a moderator approved them. I approved all of them. I then merged them all into this thread, and I deleted the other three posts. The single post that is left in this thread should suffice to describe your problem.
     
  3. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Friendly Moderator Note

    I also updated the subject of this thread, because I think you really mean mysqltuner, not mysqltunnel, based on the output you pasted that mentions "MySQLTuner 1.2.0".
     
  4. senwar

    senwar Registered

    Joined:
    Sep 5, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Re: Friendly Moderator Note

    Thanks for edit this post
     
  5. senwar

    senwar Registered

    Joined:
    Sep 5, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Someone can help for me?
     
Loading...

Share This Page