mysqltunerdb1

mysqltunerdb1.sh

[--] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.6.31
[OK] Operating on 64-bit architecture
 
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA 
[--] Data in InnoDB tables: 12G (Tables: 779)
[OK] Total fragmented tables: 0
 
-------- Security Recommendations ------------------------------------------------------------------
[!!] User '@localhost' is an anonymous account.
[!!] User '@mumdiadb1v' is an anonymous account.
[!!] User '@localhost' has no password set.
[!!] User '@mumdiadb1v' has no password set.
[!!] User 'AxiataMifeDBUser@mysql.mifeindia.in' has no password set.
[!!] User 'GovCloudUser@mysql.mifeindia.in' has no password set.
[!!] User 'jeffrey@localhost' has no password set.
[!!] User 'root@127.0.0.1' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User 'root@mumdiadb1v' has no password set.
[!!] User '@localhost' has user name as password.
[!!] User '@mumdiadb1v' has user name as password.
[!!] User 'ApiMgtUser@%' hasn't specific host restriction.
[!!] User 'ApiStatsUser@%' hasn't specific host restriction.
[!!] User 'AxiataMifeDBUser@%' hasn't specific host restriction.
[!!] User 'BamStatUser@%' hasn't specific host restriction.
[!!] User 'BpsUser@%' hasn't specific host restriction.
[!!] User 'ConfigDbUser@%' hasn't specific host restriction.
[!!] User 'GovCloudUser@%' hasn't specific host restriction.
[!!] User 'HiveMetaUser@%' hasn't specific host restriction.
[!!] User 'IdentityUser@%' hasn't specific host restriction.
[!!] User 'USSDUser@%' hasn't specific host restriction.
[!!] User 'UserstoreUser@%' hasn't specific host restriction.
[!!] User 'connectdbuser@%' hasn't specific host restriction.
[!!] User 'rep1@%' hasn't specific host restriction.
[!!] User 'replicator@%' hasn't specific host restriction.
[!!] User 'root@%' hasn't specific host restriction.
[!!] User 'sandboxuser@%' hasn't specific host restriction.
[!!] User 'ussdaircel@%' hasn't specific host restriction.
[--] There are 612 basic passwords in the list.
[!!] User 'replicator@%' is using weak password: password in a lower, upper or capitalize derivative version.
 
-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION
 
-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 4d 1h 26m 34s (6K q [0.018 qps], 18 conn, TX: 363K, RX: 5G)
[--] Reads / Writes: 0% / 100%
[--] Binary logging is disabled
[--] Physical Memory     : 7.7G
[--] Max MySQL memory    : 10.7G
[--] Other process memory: 36.7M
[--] Total buffers: 9.2G global + 1.1M per thread (1000 max threads)
[--] P_S Max memory usage: 548M
[--] Galera GCache Max memory usage: 0B
[!!] Maximum reached memory usage: 9.7G (126.20% of installed RAM)
[!!] Maximum possible memory usage: 10.7G (139.67% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (0/6K)
[OK] Highest usage of available connections: 0% (2/1000)
[!!] Aborted connections: 16.67%  (3/18)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[!!] Query cache may be disabled by default due to mutex contention.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4 sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 15% (40 on disk / 256 total)
[OK] Thread cache hit rate: 88% (2 created / 18 connections)
[OK] Table cache hit rate: 91% (807 open / 884 opened)
[OK] Open file limit used: 0% (46/5K)
[OK] Table locks acquired immediately: 100% (79 immediate / 79 locks)
 
-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is enabled.
[--] Memory used by P_S: 548.0M
[--] Sys schema isn't installed.
 
-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.
 
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.3% (1M used / 8M cache)
[OK] Key buffer size / total MyISAM indexes: 8.0M/101.0K
[!!] Read Key buffer hit rate: 50.0% (6 cached / 3 reads)
 
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 9.0G/13.0G
[!!] InnoDB buffer pool instances: 8
[--] InnoDB Buffer Pool Chunk Size not used or defined in your version
[OK] InnoDB Read buffer efficiency: 100.00% (108132581 hits/ 108134823 total)
[OK] InnoDB Write log efficiency: 99.99% (23895516 hits/ 23898899 total)
[OK] InnoDB log waits: 0.00% (0 waits / 3383 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:
    Remove Anonymous User accounts - there are 2 anonymous accounts.
    Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
    Set up a Secure Password for user@host ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
    Restrict Host for user@% to user@SpecificDNSorIp
    1 user(s) used basic or weak password.
    Reduce your overall MySQL memory footprint for system stability
    Dedicate this server to your database for highest performance.
    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
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_type (=0)
    innodb_buffer_pool_size (>= 12G) if possible.
    innodb_buffer_pool_instances(=9)