[root@11718 ~]# perl mysqltuner.pl
 >>  MySQLTuner 1.6.15 - Major Hayden <major@mhtx.net>;
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supporte                                                                             d MySQL version 5.1.73-log
[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics ---------------------------------------------                                                                             --------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 33M (Tables: 500)
[--] Data in InnoDB tables: 560K (Tables: 35)
[OK] Total fragmented tables: 0

-------- Security Recommendations ----------------------------------------------                                                                             --------------------
[OK] There are no anonymous accounts for any database users
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (pa                                                                             ssword = '' OR password IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket')
[!!] FAIL Execute SQL / return code: 256
[OK] All database users have passwords assigned
[!!] User 'такойто юзер' hasn't specific host restriction.
[!!] User 'такойто юзер' hasn't specific host restriction.
[--] There are 605 basic passwords in the list.

-------- CVE Security Recommendations ------------------------------------------                                                                             --------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics ---------------------------------------------------                                                                             --------------------
[--] Up for: 28s (1K q [44.893 qps], 12 conn, TX: 347K, RX: 98K)
[--] Reads / Writes: 99% / 1%
[--] Binary logging is disabled
[--] Physical Memory     : 1004.1M
[--] Max MySQL memory    : 181.7M
[--] Other process memory: 318.0M
[--] Total buffers: 59.0M global + 832.0K per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 62.2M (6.20% of installed RAM)
[OK] Maximum possible memory usage: 181.7M (18.10% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory                                                                              available
[OK] Slow queries: 1% (21/1K)
[OK] Highest usage of available connections: 2% (4/151)
[!!] Aborted connections: 16.67%  (2/12)
[!!] name resolution is active : a reverse name resolution is made for each new                                                                              connection and can reduce performance
[!!] Query cache efficiency: 1.7% (20 cached / 1K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 166 sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 0% (0 on disk / 7 total)
[OK] Table cache hit rate: 85% (42 open / 49 opened)
[OK] Open file limit used: 7% (80/1K)
[OK] Table locks acquired immediately: 100% (1K immediate / 1K locks)

-------- Performance schema ----------------------------------------------------                                                                             --------------------
[--] Performance schema is disabled.

-------- ThreadPool Metrics ----------------------------------------------------                                                                             --------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics --------------------------------------------------------                                                                             --------------------
[!!] Key buffer used: 18.9% (198K used / 1M cache)
[OK] Key buffer size / total MyISAM indexes: 1.0M/13.2M
[OK] Read Key buffer hit rate: 98.9% (6K cached / 76 reads)

-------- AriaDB Metrics --------------------------------------------------------                                                                             --------------------
[--] AriaDB is disabled.

-------- InnoDB Metrics --------------------------------------------------------                                                                             --------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 8.0M/560.0K
[!!] InnoDB Used buffer: 4.49% (23 used/ 512 total)
[OK] InnoDB Read buffer efficiency: 94.95% (301 hits/ 317 total)
[!!] InnoDB Write Log efficiency: 0% (2 hits/ 0 total)
[OK] InnoDB log waits: 0.00% (0 waits / 2 writes)

-------- TokuDB Metrics --------------------------------------------------------                                                                             --------------------
[--] TokuDB is disabled.

-------- Galera Metrics --------------------------------------------------------                                                                             --------------------
[--] Galera is disabled.

-------- Replication Metrics ---------------------------------------------------                                                                             --------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.

-------- Recommendations -------------------------------------------------------                                                                             --------------------
General recommendations:
    Restrict Host for user@% to user@SpecificDNSorIp
    MySQL started within last 24 hours - recommendations may be inaccurate
    Reduce or eliminate unclosed connections and network issues
    Configure your accounts with ip or subnets only, then update your configurat                                                                             ion with skip-name-resolve=1
Variables to adjust:
    query_cache_limit (> 1M, or use smaller result sets)

Variables to adjust:
    query_cache_size (> 32M)
    table_open_cache (> 64)

General recommendations:
    Restrict Host for user@% to user@SpecificDNSorIp
    MySQL started within last 24 hours - recommendations may be inaccurate
    Dedicate this server to your database for highest performance.
    Reduce or eliminate persistent connections to reduce connection usage
    Reduce or eliminate unclosed connections and network issues
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (1185) variable
    should be greater than table_open_cache ( 512)
Variables to adjust:
    max_connections (> 151)
    wait_timeout (< 28800)
    interactive_timeout (< 28800)
    table_open_cache (> 512)