Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------- Performance Metrics -------------------------------------------------
- [--] Up for: 54d 7h 18m 12s (44M q [9.561 qps], 592K conn, TX: 75B, RX: 12B)
- [--] Reads / Writes: 78% / 22%
- [--] Total buffers: 2.7M per thread and 58.0M global
- [OK] Maximum possible memory usage: 463.8M (5% of installed RAM)
- [OK] Slow queries: 0% (93/44M)
- [OK] Highest usage of available connections: 34% (52/151)
- [!!] Cannot calculate MyISAM index size - re-run script as root user
- [!!] Query cache efficiency: 17.6%
- [!!] Query cache prunes per day: 50886
- [OK] Sorts requiring temporary tables: 0%
- [!!] Temporary tables created on disk: 89%
- [OK] Thread cache hit rate: 99%
- [!!] Table cache hit rate: 0%
- Use of uninitialized value $myvar{"table_cache"} in concatenation (.) or string
- at /usr/bin/mysqltuner line 661, <> line 2 (#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.
- [OK] Open file limit used: 0%
- [OK] Table locks acquired immediately: 99%
- [!!] InnoDB data size / buffer pool: 482.2M/8.0M
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement