Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.73 KB | None | 0 0
  1. -------- Performance Metrics -------------------------------------------------
  2. [--] Up for: 54d 7h 18m 12s (44M q [9.561 qps], 592K conn, TX: 75B, RX: 12B)
  3. [--] Reads / Writes: 78% / 22%
  4. [--] Total buffers: 2.7M per thread and 58.0M global
  5. [OK] Maximum possible memory usage: 463.8M (5% of installed RAM)
  6. [OK] Slow queries: 0% (93/44M)
  7. [OK] Highest usage of available connections: 34% (52/151)
  8. [!!] Cannot calculate MyISAM index size - re-run script as root user
  9. [!!] Query cache efficiency: 17.6%
  10. [!!] Query cache prunes per day: 50886
  11. [OK] Sorts requiring temporary tables: 0%
  12. [!!] Temporary tables created on disk: 89%
  13. [OK] Thread cache hit rate: 99%
  14. [!!] Table cache hit rate: 0%
  15. Use of uninitialized value $myvar{"table_cache"} in concatenation (.) or string
  16.         at /usr/bin/mysqltuner line 661, <> line 2 (#1)
  17.     (W uninitialized) An undefined value was used as if it were already
  18.     defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
  19.     To suppress this warning assign a defined value to your variables.
  20.  
  21.     To help you figure out what was undefined, perl will try to tell you the
  22.     name of the variable (if any) that was undefined. In some cases it cannot
  23.     do this, so it also tells you what operation you used the undefined value
  24.     in.  Note, however, that perl optimizes your program and the operation
  25.     displayed in the warning may not necessarily appear literally in your
  26.     program.  For example, "that $foo" is usually optimized into "that "
  27.     . $foo, and the warning will refer to the concatenation (.) operator,
  28.     even though there is no . in your program.
  29.  
  30. [OK] Open file limit used: 0%
  31. [OK] Table locks acquired immediately: 99%
  32. [!!] InnoDB data size / buffer pool: 482.2M/8.0M
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement