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.

help with my mysqltuner.pl output

Discussion in 'Workarounds and Optimization' started by system1351, Jul 7, 2011.

  1. system1351

    system1351 Member

    Joined:
    May 17, 2010
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    World Wide Web
    cPanel Access Level:
    Root Administrator
    Hi friends



    this is my mysqltuner.pl output​



    How i must modify my /etc/my.conf???


    My machine is:
    Intel Core 2 Quad CPU 2.6 GHz
    8 Gb RAM




    actually my /etc/my.conf is this:

    cat /etc/my.cnf
    [mysqld]
    set-variable = max_connections=500
    query_cache_type=1
    query_cache_size=64M
    table_cache=5000
    safe-show-database
    local-infile=0








    >> 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

    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.0.92-community
    [!!] 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: 363M (Tables: 6254)
    [--] Data in InnoDB tables: 12M (Tables: 135)
    [--] Data in MEMORY tables: 0B (Tables: 1)
    [!!] Total fragmented tables: 435

    -------- Security Recommendations -------------------------------------------
    [OK] All database users have passwords assigned

    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 6h 58m 20s (263K q [10.486 qps], 12K conn, TX: 609M, RX: 44M)
    [--] Reads / Writes: 63% / 37%
    [--] Total buffers: 98.0M global + 2.7M per thread (500 max threads)
    [OK] Maximum possible memory usage: 1.4G (18% of installed RAM)
    [OK] Slow queries: 0% (2/263K)
    [OK] Highest usage of available connections: 1% (9/500)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/136.9M
    [OK] Key buffer hit rate: 99.2% (1M cached / 11K reads)
    [OK] Query cache efficiency: 84.4% (164K cached / 194K selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
    [!!] Joins performed without indexes: 258
    [OK] Temporary tables created on disk: 14% (1K on disk / 7K total)
    [!!] Thread cache is disabled
    [OK] Table cache hit rate: 37% (4K open / 13K opened)
    [!!] Open file limit used: 92% (9K/10K)
    [OK] Table locks acquired immediately: 99% (72K immediate / 72K locks)
    [!!] InnoDB data size / buffer pool: 12.9M/8.0M

    -------- Recommendations -----------------------------------------------------
    General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    Set thread_cache_size to 4 as a starting value
    Variables to adjust:
    join_buffer_size (> 128.0K, or always use indexes with joins)
    thread_cache_size (start at 4)
    open_files_limit (> 10510)
    innodb_buffer_pool_size (>= 12M)
     
Loading...

Share This Page