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 output

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

  1. system1351

    system1351 Member

    May 17, 2010
    Likes Received:
    Trophy Points:
    World Wide Web
    cPanel Access Level:
    Root Administrator
    Hi friends

    this is my 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
    set-variable = max_connections=500

    >> MySQLTuner 1.2.0 - Major Hayden <>
    >> Bug reports, feature requests, and downloads at
    >> 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)

Share This Page