Untitled

 >>  MySQLTuner 1.7.3 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

[[0;34m--[0m] Skipped version check for MySQLTuner script
[[0;32mOK[0m] Logged in using credentials from debian maintenance account.
[[0;32mOK[0m] Currently running supported MySQL version 10.2.7-MariaDB-10.2.7+maria~jessie-log
[[0;32mOK[0m] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[[0;34m--[0m] Log file: /var/lib/mysql/mysql-error.log(9M)
[[0;32mOK[0m] Log file /var/lib/mysql/mysql-error.log exists
[[0;32mOK[0m] Log file /var/lib/mysql/mysql-error.log is readable.
[[0;32mOK[0m] Log file /var/lib/mysql/mysql-error.log is not empty
[[0;32mOK[0m] Log file /var/lib/mysql/mysql-error.log is smaller than 32 Mb
[[0;31m!![0m] /var/lib/mysql/mysql-error.log contains 9145 warning(s).
[[0;31m!![0m] /var/lib/mysql/mysql-error.log contains 1241 error(s).
[[0;34m--[0m] 21 start(s) detected in /var/lib/mysql/mysql-error.log
[[0;34m--[0m] 1) 2017-08-09 11:30:23 140359067707136 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 2) 2017-08-09 11:29:14 140358959879936 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 3) 2017-08-09 11:29:14 140544984819584 [Note] /usr/sbin/mysqld: ready for connections.
[[0;34m--[0m] 4) 2017-08-09 10:54:52 140365505582848 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 5) 2017-08-09 10:51:38 140185952925440 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 6) 2017-08-09 10:51:36 140371969177472 [Note] /usr/sbin/mysqld: ready for connections.
[[0;34m--[0m] 7) 2017-08-09 10:36:55 140384880781056 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 8) 2017-08-09 10:36:53 140571566520192 [Note] /usr/sbin/mysqld: ready for connections.
[[0;34m--[0m] 9) 2017-08-09 10:35:10 139830927935232 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 10) 2017-08-09 10:32:17 139830932784896 [Note] WSREP: Synchronized with group, ready for connections
[[0;34m--[0m] 6 shutdown(s) detected in /var/lib/mysql/mysql-error.log
[[0;34m--[0m] 1) 2017-08-09 11:28:39 140185921402624 [Note] /usr/sbin/mysqld: Shutdown complete
[[0;34m--[0m] 2) 2017-08-09 10:51:01 140384866232064 [Note] /usr/sbin/mysqld: Shutdown complete
[[0;34m--[0m] 3) 2017-08-09 10:36:16 139830178424576 [Note] /usr/sbin/mysqld: Shutdown complete
[[0;34m--[0m] 4) 2017-08-09 10:26:14 140206811657984 [Note] /usr/sbin/mysqld: Shutdown complete
[[0;34m--[0m] 5) 2017-08-08 13:47:29 139746829362944 [Note] /usr/sbin/mysqld: Shutdown complete
[[0;34m--[0m] 6) 2017-08-08 13:33:22 140406307497728 [Note] /usr/sbin/mysqld: Shutdown complete

-------- Storage Engine Statistics -----------------------------------------------------------------
[[0;34m--[0m] Status: [0;32m+Aria [0m[0;32m+CSV [0m[0;32m+InnoDB [0m[0;32m+MEMORY [0m[0;32m+MRG_MyISAM [0m[0;32m+MyISAM [0m[0;32m+PERFORMANCE_SCHEMA [0m[0;32m+SEQUENCE [0m
[[0;34m--[0m] Data in MEMORY tables: 0B (Tables: 1)
[[0;34m--[0m] Data in InnoDB tables: 52G (Tables: 146)
[[0;32mOK[0m] Total fragmented tables: 0

-------- Security Recommendations ------------------------------------------------------------------
[[0;32mOK[0m] There are no anonymous accounts for any database users
[[0;32mOK[0m] All database users have passwords assigned
[[0;31m!![0m] User 'a2test2@%' hasn't specific host restriction.
[[0;31m!![0m] User 'a2test@%' hasn't specific host restriction.
[[0;31m!![0m] There is no basic password file list!

-------- CVE Security Recommendations --------------------------------------------------------------
[[0;34m--[0m] Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------------------
[[0;34m--[0m] Up for: 52m 53s (3M q [1K qps], 1K conn, TX: 41G, RX: 332M)
[[0;34m--[0m] Reads / Writes: 95% / 5%
[[0;34m--[0m] Binary logging is enabled (GTID MODE: OFF)
[[0;34m--[0m] Physical Memory     : 189.3G
[[0;34m--[0m] Max MySQL memory    : 174.2G
[[0;34m--[0m] Other process memory: 159.5M
[[0;34m--[0m] Total buffers: 162.2G global + 13.4M per thread (500 max threads)
[[0;34m--[0m] P_S Max memory usage: 463M
[[0;34m--[0m] Galera GCache Max memory usage: 5G
[[0;31m!![0m] Maximum reached memory usage: 168.2G (88.85% of installed RAM)
[[0;31m!![0m] Maximum possible memory usage: 174.2G (92.02% of installed RAM)
[[0;32mOK[0m] Overall possible memory usage with other process is compatible with memory available
[[0;32mOK[0m] Slow queries: 0% (4K/3M)
[[0;32mOK[0m] Highest usage of available connections: 8% (42/500)
[[0;31m!![0m] Aborted connections: 40.43%  (729/1803)
[[0;32mOK[0m] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[[0;32mOK[0m] Sorts requiring temporary tables: 0% (0 temp sorts / 40K sorts)
[[0;32mOK[0m] No joins without indexes
[[0;32mOK[0m] Temporary tables created on disk: 8% (3K on disk / 42K total)
[[0;31m!![0m] Thread cache hit rate: 38% (1K created / 1K connections)
[[0;32mOK[0m] Table cache hit rate: 98% (441 open / 447 opened)
[[0;32mOK[0m] Open file limit used: 0% (61/16K)
[[0;32mOK[0m] Table locks acquired immediately: 100% (52 immediate / 52 locks)
[[0;32mOK[0m] Binlog cache memory access: 100.00% (111289 Memory / 111289 Total)

-------- Performance schema ------------------------------------------------------------------------
[[0;34m--[0m] Memory used by P_S: 463.3M
[[0;34m--[0m] Sys schema isn't installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[[0;34m--[0m] ThreadPool stat is enabled.
[[0;34m--[0m] Thread Pool Size: 32 thread(s).
[[0;34m--[0m] Using default value is good enough for your version (10.2.7-MariaDB-10.2.7+maria~jessie-log)

-------- MyISAM Metrics ----------------------------------------------------------------------------
[[0;31m!![0m] Key buffer used: 18.3% (6M used / 33M cache)
[[0;32mOK[0m] Key buffer size / total MyISAM indexes: 32.0M/129.0K
[[0;31m!![0m] Read Key buffer hit rate: 81.0% (42 cached / 8 reads)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] InnoDB is enabled.
[[0;34m--[0m] InnoDB Thread Concurrency: 0
[[0;32mOK[0m] InnoDB File per table is activated
[[0;32mOK[0m] InnoDB buffer pool / data size: 160.0G/52.5G
[[0;31m!![0m] Ratio InnoDB log file size / InnoDB Buffer pool size (0.3125 %): 256.0M * 2/160.0G should be equal 25%
[[0;31m!![0m] InnoDB buffer pool instances: 2
[[0;34m--[0m] Number of InnoDB Buffer Pool Chunk : 1280 for 2 Buffer Pool Instance(s)
[[0;32mOK[0m] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[[0;32mOK[0m] InnoDB Read buffer efficiency: 99.96% (295670319 hits/ 295799243 total)
[[0;32mOK[0m] InnoDB Write log efficiency: 98.19% (192428 hits/ 195977 total)
[[0;32mOK[0m] InnoDB log waits: 0.00% (0 waits / 3549 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] AriaDB is enabled.
[[0;32mOK[0m] Aria pagecache size / total Aria indexes: 128.0M/1B
[[0;32mOK[0m] Aria pagecache hit rate: 98.6% (273K cached / 3K reads)

-------- TokuDB Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] XtraDB is disabled.

-------- RocksDB Metrics ---------------------------------------------------------------------------
[[0;34m--[0m] RocksDB is disabled.

-------- Spider Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] Spider is disabled.

-------- Connect Metrics ---------------------------------------------------------------------------
[[0;34m--[0m] Connect is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[[0;34m--[0m] Galera is enabled.
[[0;34m--[0m] GCache is using 0B
[[0;32mOK[0m] wsrep_slave_threads is equal to 2, 3 or 4 times number of CPU(s)
[[0;31m!![0m] gcs.limit should be equal to 5 * wsrep_slave_threads
[[0;34m--[0m] wsrep parallel slave can cause frequent inconsistency crash.
[[0;31m!![0m] gcs.fc_limit should be equal to 5 * wsrep_slave_threads
[[0;31m!![0m] gcs.fc_factor should be equal to 0.8
[[0;32mOK[0m] Flow control fraction seems to be OK (wsrep_flow_control_paused<=0.02)
[[0;31m!![0m] Following table(s) don't have primary key:
[[0;31m!![0m] 	a2billing.card_repair
[[0;31m!![0m] 	a2billing.cc_version
[[0;31m!![0m] 	a2billing.qiwi_customers
[[0;31m!![0m] Following table(s) are not InnoDB table:
[[0;31m!![0m] 	a2billing.cc_exten_state
[[0;32mOK[0m] Binlog format is in ROW mode.
[[0;32mOK[0m] InnoDB flush log at each commit is disabled for Galera.
[[0;34m--[0m] Read consistency mode :OFF
[[0;32mOK[0m] Galera WsREP is enabled.
[[0;32mOK[0m] Galera Cluster address is defined: gcomm://172.31.254.55,172.20.71.224
[[0;34m--[0m] There are 2 nodes in wsrep_cluster_address
[[0;32mOK[0m] There are 3 nodes in wsrep_cluster_size.
[[0;32mOK[0m] All cluster nodes detected.
[[0;32mOK[0m] Galera Cluster name is defined: galera-cluster
[[0;32mOK[0m] Galera Node name is defined: galera-node1
[[0;31m!![0m] Galera Notify command is not defined.
[[0;32mOK[0m] SST Method is based on xtrabackup.
[[0;32mOK[0m] TOI is default mode for upgrade.
[[0;34m--[0m] Max WsRep message : 2.0G
[[0;32mOK[0m] Node is connected
[[0;32mOK[0m] Node is ready
[[0;34m--[0m] Cluster status :Primary
[[0;32mOK[0m] Galera cluster is consistent and ready for operations
[[0;32mOK[0m] Node and whole cluster at the same level: ac061580-7921-11e7-9ec5-9ad23d7fc3ea
[[0;32mOK[0m] Node is synced with whole cluster.
[[0;32mOK[0m] There is no certification failures detected.

-------- Replication Metrics -----------------------------------------------------------------------
[[0;34m--[0m] Galera Synchronous replication: YES
[[0;34m--[0m] No replication slave(s) for this server.
[[0;34m--[0m] This is a standalone server.

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/lib/mysql/mysql-error.log file
    Control error line(s) into /var/lib/mysql/mysql-error.log file
    Restrict Host for user@% to user@SpecificDNSorIp
    MySQL started within last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Reduce or eliminate unclosed connections and network issues
    Consider installing Sys schema from https://github.com/mysql/mysql-sys
    Ensure that all table(s) are InnoDB tables for Galera replication
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    thread_cache_size (> 128)
    innodb_log_file_size should be (=20G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
    innodb_buffer_pool_instances(=64)
    gcs.limit= wsrep_slave_threads * 5
    Set wsrep_slave_threads to 1 in case of HA_ERR_FOUND_DUPP_KEY crash on slave
    gcs.fc_limit= wsrep_slave_threads * 5
    gcs.fc_factor=0.8
    set up parameter wsrep_notify_cmd to be notify