[root@m2765 tmp]# perl mysqltuner.pl
 >>  MySQLTuner 1.4.4 - 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:
[OK] Currently running supported MySQL version 5.1.73-log
[OK] Operating ON 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 46G (Tables: 100)
[--] Data in InnoDB tables: 960K (Tables: 60)
[!!] Total fragmented TABLES: 66

-------- Security Recommendations  -------------------------------------------
[OK] There IS no anonymous account IN ALL DATABASE users
[OK] ALL DATABASE users have passwords assigned
[!!] USER 'a2bdbuser@%' hasn't specific host restriction.
[!!] User 'kamuser@%' hasn't specific host restriction.
[!!] There IS NOT basic password file list !
-------- Performance Metrics -------------------------------------------------
[--] Up for: 202d 15h 11m 55s (4B q [262.291 qps], 291M conn, TX: 4164B, RX: 730B)
[--] Reads / Writes: 65% / 35%
[--] Total buffers: 98.0M global + 10.6M per thread (100000 max threads)
[!!] Maximum possible memory usage: 1037.7G (823% OF installed RAM)
[OK] Slow queries: 0% (9K/4B)
[OK] Highest usage OF available connections: 1% (1408/100000)
[OK] KEY buffer SIZE / total MyISAM indexes: 8.0M/15.4G
[OK] KEY buffer hit rate: 95.7% (14B cached / 622M reads)
[!!] Query cache efficiency: 6.4% (144M cached / 2B selects)
[!!] Query cache prunes per DAY: 94669
[OK] Sorts requiring TEMPORARY TABLES: 0% (38K temp sorts / 46M sorts)
[!!] Joins performed WITHOUT indexes: 40702085
[OK] TEMPORARY TABLES created ON disk: 0% (36K ON disk / 40M total)
[OK] Thread cache hit rate: 95% (12M created / 291M connections)
[!!] TABLE cache hit rate: 0% (128 OPEN / 695K opened)
[OK] OPEN file LIMIT used: 0% (133/500K)
[OK] TABLE locks acquired immediately: 99% (1B immediate / 1B locks)

-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB BufferPool Size :8.0M
[OK] InnoDB buffer pool / DATA SIZE: 8.0M/960.0K
[OK] InnoDB log waits: 0

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE TO defragment TABLES FOR better performance
    RESTRICT Host FOR USER@% TO USER@SpecificDNSorIp
    Reduce your overall MySQL memory footprint FOR system stability
    Enable the slow query log TO troubleshoot bad queries
    Adjust your JOIN queries TO always utilize indexes
    Increase table_open_cache gradually TO avoid file descriptor limits
    READ this BEFORE increasing table_open_cache OVER 64: http://bit.ly/1mi7c4C
VARIABLES TO adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_limit (> 1M, or use smaller result sets)
    query_cache_size (> 64M)
    join_buffer_size (> 8.0M, or always use indexes with joins)
    table_open_cache (> 128)