SHARE
TWEET

Untitled

a guest Jun 20th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Storage Engine Statistics
  2. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  3. [--] Data in MyISAM tables: 765.7K (Tables: 136)
  4. [--] Data in InnoDB tables: 475.0M (Tables: 437)
  5. [OK] Total fragmented tables: 0
  6.  
  7. -------- Analysis Performance Metrics --------------------------------------------------------------
  8. [--] innodb_stats_on_metadata: OFF
  9. [OK] No stat updates during querying INFORMATION_SCHEMA.
  10.  
  11. -------- Security Recommendations ------------------------------------------------------------------
  12. [OK] There are no anonymous accounts for any database users
  13. [!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE (IF(plugin='mysql_native_password', authentication_string, password) = '' OR IF(plugin='mysql_native_password', authentication_string, password) IS NULL) AND plugin NOT IN ('unix_socket', 'win_socket', 'auth_pam_compat')
  14. [!!] FAIL Execute SQL / return code: 256
  15. [OK] All database users have passwords assigned
  16. [!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE CAST(IF(plugin='mysql_native_password', authentication_string, password) as Binary) = PASSWORD(user) OR CAST(IF(plugin='mysql_native_password', authentication_string, password) as Binary) = PASSWORD(UPPER(user)) OR CAST(IF(plugin='mysql_native_password', authentication_string, password) as Binary) = PASSWORD(CONCAT(UPPER(LEFT(User, 1)), SUBSTRING(User, 2, LENGTH(User))))
  17. [!!] FAIL Execute SQL / return code: 256
  18. [!!] User 'exampple@%' does not specify hostname restrictions.
  19. [!!] User 'example1@%' does not specify hostname restrictions.
  20. [!!] User 'example2@%' does not specify hostname restrictions.
  21. [!!] There is no basic password file list!
  22.  
  23. -------- CVE Security Recommendations --------------------------------------------------------------
  24. [--] Skipped due to --cvefile option undefined
  25.  
  26. -------- Performance Metrics -----------------------------------------------------------------------
  27. [--] Up for: 6d 15h 57m 4s (2M q [3.652 qps], 262K conn, TX: 1G, RX: 348M)
  28. [--] Reads / Writes: 70% / 30%
  29. [--] Binary logging is disabled
  30. [--] Physical Memory     : 3.7G
  31. [--] Max MySQL memory    : 875.1M
  32. [--] Other process memory: 0B
  33. [--] Total buffers: 592.0M global + 1.9M per thread (151 max threads)
  34. [--] P_S Max memory usage: 72B
  35. [--] Galera GCache Max memory usage: 0B
  36. [OK] Maximum reached memory usage: 620.1M (16.18% of installed RAM)
  37. [OK] Maximum possible memory usage: 875.1M (22.84% of installed RAM)
  38. [OK] Overall possible memory usage with other process is compatible with memory available
  39. [OK] Slow queries: 0% (24/2M)
  40. [OK] Highest usage of available connections: 9% (15/151)
  41. [!!] Aborted connections: 10.64%  (27929/262400)
  42. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  43. [!!] Query cache may be disabled by default due to mutex contention.
  44. [!!] Query cache efficiency: 15.1% (318K cached / 2M selects)
  45. [OK] Query cache prunes per day: 0
  46. [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 121K sorts)
  47. [!!] Joins performed without indexes: 128955
  48. [!!] Temporary tables created on disk: 37% (156K on disk / 416K total)
  49. [OK] Thread cache hit rate: 99% (18 created / 262K connections)
  50. [OK] Table cache hit rate: 92% (11K open / 12K opened)
  51. [OK] Open file limit used: 5% (2K/48K)
  52. [OK] Table locks acquired immediately: 99% (15K immediate / 15K locks)
  53.  
  54. -------- Performance schema ------------------------------------------------------------------------
  55. [--] Memory used by P_S: 72B
  56. [--] Sys schema is installed.
  57.  
  58. -------- ThreadPool Metrics ------------------------------------------------------------------------
  59. [--] ThreadPool stat is disabled.
  60.  
  61. -------- MyISAM Metrics ----------------------------------------------------------------------------
  62. [!!] Key buffer used: 18.5% (3M used / 16M cache)
  63. [OK] Key buffer size / total MyISAM indexes: 16.0M/425.0K
  64. [OK] Read Key buffer hit rate: 100.0% (90K cached / 39 reads)
  65. [!!] Write Key buffer hit rate: 94.2% (904 cached / 852 writes)
  66.  
  67. -------- InnoDB Metrics ----------------------------------------------------------------------------
  68. [--] InnoDB is enabled.
  69. [--] InnoDB Thread Concurrency: 0
  70. [OK] InnoDB File per table is activated
  71. [OK] InnoDB buffer pool / data size: 512.0M/475.0M
  72. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (18.75 %): 48.0M * 2/512.0M should be equal to 25%
  73. [OK] InnoDB buffer pool instances: 1
  74. [--] Number of InnoDB Buffer Pool Chunk : 4 for 1 Buffer Pool Instance(s)
  75. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  76. [OK] InnoDB Read buffer efficiency: 99.98% (83734371 hits/ 83750851 total)
  77. [!!] InnoDB Write Log efficiency: 38.7% (221735 hits/ 573015 total)
  78. [OK] InnoDB log waits: 0.00% (0 waits / 794750 writes)
  79.  
  80. -------- AriaDB Metrics ----------------------------------------------------------------------------
  81. [--] AriaDB is disabled.
  82.  
  83. -------- TokuDB Metrics ----------------------------------------------------------------------------
  84. [--] TokuDB is disabled.
  85.  
  86. -------- XtraDB Metrics ----------------------------------------------------------------------------
  87. [--] XtraDB is disabled.
  88.  
  89. -------- Galera Metrics ----------------------------------------------------------------------------
  90. [--] Galera is disabled.
  91.  
  92. -------- Replication Metrics -----------------------------------------------------------------------
  93. [--] Galera Synchronous replication: NO
  94. [--] No replication slave(s) for this server.
  95. [--] Binlog format: ROW
  96. [--] XA support enabled: ON
  97. [--] Semi synchronous replication Master: Not Activated
  98. [--] Semi synchronous replication Slave: Not Activated
  99. [--] This is a standalone server
  100.  
  101. -------- Recommendations ---------------------------------------------------------------------------
  102. General recommendations:
  103.     Control warning line(s) into /var/log/mysqld.log file
  104.     Control error line(s) into /var/log/mysqld.log file
  105.     Restrict Host for user@% to user@SpecificDNSorIp
  106.     Reduce or eliminate unclosed connections and network issues
  107.     Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  108.     Adjust your join queries to always utilize indexes
  109.     When making adjustments, make tmp_table_size/max_heap_table_size equal
  110.     Reduce your SELECT DISTINCT queries which have no LIMIT clause
  111.     Before changing innodb_log_file_size and/or innodb_log_files_in_group read this:
  112. Variables to adjust:
  113.     query_cache_size (=0)
  114.     query_cache_type (=0)
  115.     query_cache_limit (> 2M, or use smaller result sets)
  116.     join_buffer_size (> 1.0M, or always use indexes with JOINs)
  117.     tmp_table_size (> 128M)
  118.     max_heap_table_size (> 16M)
  119.     innodb_log_file_size should be (=64M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
  120.      
  121. max_tmp_tables=128
  122. tmp_table_size=128M
  123. table_open_cache=24000
  124. sql_mode=''
  125. key_buffer_size=16M
  126. slow_query_log = 1
  127. long_query_time = 2
  128. innodb_buffer_pool_size = 512M
  129. join_buffer_size = 1M
  130. query_cache_type = 1
  131. query_cache_size = 32M
  132. query_cache_limit = 2M
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top