This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am showing the installation process of MySQL Tuner in Ubuntu 16.04.
MySQL Tuner is a useful tool that will connect to a running MySQL instance and offer suggestions for how it can be configured for your workload.
You can use this tool for running production server as well, and it will give you different types of Performance Metrics and Server statistics like about the Storage, Security, Performance Parameters, Cache Parameters, InnoDB Settings, MyISAM Settings and more.
Install MySQL Tuner in Ubuntu 16.04:
1 |
sudo apt-get install mysqltuner |
Execute MySQL Tuner:
1 |
mysqltuner |
Here, I am also sharing the sample result of my test server on which I installed and executed MySQL Tuner.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
-------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in InnoDB tables: 16K (Tables: 1) [OK] Total fragmented tables: 0 -------- Security Recommendations ------------------------------------------- [OK] There is no anonymous account in all database users ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause' [OK] All database users have passwords assigned ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause' -------- Performance Metrics ------------------------------------------------- [--] Up for: 4d 17h 35m 56s (26 q [0.000 qps], 32 conn, TX: 21K, RX: 5K) [--] Reads / Writes: 100% / 0% [--] Binary logging is disabled [--] Total buffers: 192.0M global + 1.1M per thread (151 max threads) [OK] Maximum reached memory usage: 194.1M (19.60% of installed RAM) [OK] Maximum possible memory usage: 352.4M (35.58% of installed RAM) [OK] Slow queries: 0% (0/26) [OK] Highest usage of available connections: 1% (2/151) [!!] Aborted connections: 43.75% (14/32) [!!] Query cache is disabled [OK] Temporary tables created on disk: 15% (10 on disk / 64 total) [OK] Thread cache hit rate: 93% (2 created / 32 connections) [OK] Table cache hit rate: 25% (28 open / 109 opened) [OK] Open file limit used: 0% (6/1K) [OK] Table locks acquired immediately: 100% (100 immediate / 100 locks) -------- MyISAM Metrics ----------------------------------------------------- [!!] Key buffer used: 18.2% (3M used / 16M cache) [OK] Key buffer size / total MyISAM indexes: 16.0M/43.0K [!!] Read Key buffer hit rate: 50.0% (6 cached / 3 reads) -------- InnoDB Metrics ----------------------------------------------------- [--] InnoDB is enabled. [OK] InnoDB buffer pool / data size: 128.0M/16.0K [OK] InnoDB buffer pool instances: 1 [!!] InnoDB Used buffer: 3.55% (291 used/ 8191 total) [!!] InnoDB Read buffer efficiency: 81.34% (1120 hits/ 1377 total) [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total) [OK] InnoDB log waits: 0.00% (0 waits / 2 writes) -------- AriaDB Metrics ----------------------------------------------------- [--] AriaDB is disabled. -------- Replication Metrics ------------------------------------------------- [--] No replication slave(s) for this server. [--] This is a standalone server.. |