mysqltuner results

[phppoint@php-pos-web ~]$ ./mysqltuner.pl 

 >>  MySQLTuner 1.3.0 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Currently running supported MySQL version 5.6.17-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM 
[--] Data in MyISAM tables: 6M (Tables: 66)
[--] Data in InnoDB tables: 2G (Tables: 18888)
[!!] Total fragmented tables: 644

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 5d 18h 35m 33s (51M q [102.795 qps], 3M conn, TX: 67B, RX: 7B)
[--] Reads / Writes: 78% / 22%
[--] Total buffers: 2.3G global + 2.7M per thread (410 max threads)
[!!] Maximum possible memory usage: 3.4G (345% of installed RAM) (THIS IS BECAUSE I RAN FROM WEB SERVER AND NOT DATABASE SERVER SINCE I CANNOT)
[OK] Slow queries: 0% (300/51M)
[OK] Highest usage of available connections: 10% (43/410)
[OK] Key buffer size / total MyISAM indexes: 19.1M/6.9M
[OK] Key buffer hit rate: 100.0% (117M cached / 119 reads)
[OK] Query cache efficiency: 76.9% (27M cached / 35M selects)
[!!] Query cache prunes per day: 353013
[OK] Sorts requiring temporary tables: 0% (3K temp sorts / 478K sorts)
[!!] Joins performed without indexes: 28655
[!!] Temporary tables created on disk: 45% (728K on disk / 1M total)
[OK] Thread cache hit rate: 99% (1K created / 3M connections)
[!!] Table cache hit rate: 0% (512 open / 2M opened)
[OK] Open file limit used: 0% (3/1M)
[OK] Table locks acquired immediately: 99% (9M immediate / 9M locks)
[!!] InnoDB  buffer pool / data size: 2.1G/2.5G
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce your overall MySQL memory footprint for system stability
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits
    Read this before increasing table_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_size (> 64M)
    join_buffer_size (> 1.0M, or always use indexes with joins)
    tmp_table_size (> 32M)
    max_heap_table_size (> 32M)
    table_cache (> 512)
    innodb_buffer_pool_size (>= 2G)

[phppoint@php-pos-web ~]$