ini tampilan mysqltuner
- For help, type '/script/restart-mysql [--help|-h]'
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[OK] Logged in using credentials passed on the command line
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[!!] Your MySQL version 10.0.24-MariaDB is EOL software! Upgrade soon!
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 13K (Tables: 4)
[--] Data in CSV tables: 0B (Tables: 2)
[--] Data in InnoDB tables: 7M (Tables: 325)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[OK] Total fragmented tables: 0
-------- Security Recommendations -------------------------------------------
[!!] User '' has no password set.
[!!] User '' has no password set.
Use of uninitialized value in addition (+) at /usr/bin/mysqltuner line 547 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.
To help you figure out what was undefined, perl will try to tell you the
name of the variable (if any) that was undefined. In some cases it cannot
do this, so it also tells you what operation you used the undefined value
in. Note, however, that perl optimizes your program and the operation
displayed in the warning may not necessarily appear literally in your
program. For example, "that $foo" is usually optimized into "that "
. $foo, and the warning will refer to the concatenation (.) operator,
even though there is no . in your program.
Use of uninitialized value $myvar{"have_innodb"} in string eq at
/usr/bin/mysqltuner line 665 (#1)
-------- Performance Metrics -------------------------------------------------
[--] Up for: 3s (9 q [3.000 qps], 7 conn, TX: 17K, RX: 1K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 288.0M global + 416.0K per thread (151 max threads)
[OK] Maximum possible memory usage: 349.3M (34% of installed RAM)
[OK] Slow queries: 0% (0/9)
[OK] Highest usage of available connections: 0% (1/151)
[OK] Key buffer size / total MyISAM indexes: 128.0M/21.0K
[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 100% (63 open / 0 opened)
[OK] Open file limit used: 0% (10/20K)
[OK] Table locks acquired immediately: 100% (73 immediate / 73 locks)
[!!] Connections aborted: 14%
-------- Recommendations -----------------------------------------------------
General recommendations:
MySQL started within last 24 hours - recommendations may be inaccurate
Upgrade MySQL to version 4+ to utilize query caching
Set thread_cache_size to 4 as a starting value
Your applications are not closing MySQL connections properly
Variables to adjust:
thread_cache_size (start at 4)