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

[--] Skipped version check for MySQLTuner script
[--] Performing tests on 127.0.0.1:xx
[OK] Logged in using credentials from Debian maintenance account.
[OK] Currently running supported MySQL version 8.0.26-0ubuntu0.20.04.2
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[OK] Log file /var/log/mysql/error.log exists
[--] Log file: /var/log/mysql/error.log(2K)
[OK] Log file /var/log/mysql/error.log is readable.
[OK] Log file /var/log/mysql/error.log is not empty
[OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
[!!] /var/log/mysql/error.log contains 14 warning(s).
[OK] /var/log/mysql/error.log doesn't contain any error.
[--] 2 start(s) detected in /var/log/mysql/error.log
[--] 1) 2021-08-09T10:07:01.107487Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.26-0ubuntu0.20.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: xxx  (Ubuntu).
[--] 2) 2021-08-09T10:07:01.107433Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: 'xxx' port: xxx, socket: /var/run/mysqld/mysqlx.sock
[--] 1 shutdown(s) detected in /var/log/mysql/error.log
[--] 1) 2021-08-09T10:06:55.061381Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-0ubuntu0.20.04.2)  (Ubuntu).

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
[--] Data in InnoDB tables: 155.8G (Tables: 50)
[!!] Total fragmented tables: 1

-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[OK] No stat updates during querying INFORMATION_SCHEMA.

-------- Security Recommendations ------------------------------------------------------------------
[--] Skipped due to unsupported feature for MySQL 8

-------- CVE Security Recommendations --------------------------------------------------------------
[OK] NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 1m 7s (318 q [4.746 qps], 20 conn, TX: 18M, RX: 33K)
[--] Reads / Writes: 13% / 87%
[--] Binary logging is enabled (GTID MODE: OFF)
[--] Physical Memory     : 25.5G
[--] Max MySQL memory    : 24.4G
[--] Other process memory: 0B
[--] Total buffers: 9.0G global + 224.4M per thread (70 max threads)
[--] P_S Max memory usage: 72B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 10.6G (41.57% of installed RAM)
[!!] Maximum possible memory usage: 24.4G (95.80% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/318)
[OK] Highest usage of available connections: 10% (7/70)
[OK] Aborted connections: 0.00%  (0/20)
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
[--] Query cache have been removed in MySQL 8
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 6 sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 0% (0 on disk / 13 total)
[OK] Thread cache hit rate: 65% (7 created / 20 connections)
[OK] Table cache hit rate: 69% (187 open / 268 opened)
[OK] table_definition_cache(2000) is upper than number of tables(376)
[OK] Open file limit used: 0% (2/10K)
[OK] Table locks acquired immediately: 100% (24 immediate / 24 locks)
[OK] Binlog cache memory access: 100.00% (47 Memory / 47 Total)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 72B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[--] MyISAM Metrics are disabled on last MySQL versions.

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 9.0G/155.8G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 1.0G * 2/9.0G should be equal to 25%
[!!] InnoDB buffer pool instances: 6
[--] Number of InnoDB Buffer Pool Chunk : 72 for 6 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[!!] InnoDB Read buffer efficiency: 49.97% (144791 hits/ 289752 total)
[!!] InnoDB Write Log efficiency: 49.66% (3615 hits/ 7279 total)
[OK] InnoDB log waits: 0.00% (0 waits / 3664 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
[--] XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] Binlog format: ROW
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/log/mysql/error.log file
    Run OPTIMIZE TABLE to defragment tables for better performance
      OPTIMIZE TABLE `xxx`.`xxx`; -- can free 839 MB
    Total freed space after theses OPTIMIZE TABLE : 839 Mb
    Reduce your overall MySQL memory footprint for system stability
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    innodb_buffer_pool_size (>= 155.8G) if possible.
    innodb_buffer_pool_instances(=9)






Aborted_clients 32
Aborted_connects    2
Acl_cache_items_count   0
Binlog_cache_disk_use   225
Binlog_cache_use    6740688
Binlog_stmt_cache_disk_use  0
Binlog_stmt_cache_use   6
Bytes_received  4028027875
Bytes_sent  28886052088
Caching_sha2_password_rsa_public_key    "xxx
""xxx
"
Secondary_engine_execution_count    0
Select_full_join    27
Select_full_range_join  0
Select_range    168
Select_range_check  0
Select_scan 45028
Slave_open_temp_tables  0
Slow_launch_threads 0
Slow_queries    0
Sort_merge_passes   38
Sort_range  0
Sort_rows   272888935
Sort_scan   10089
Ssl_accept_renegotiates 0
Ssl_accepts 912
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates    0
Ssl_ctx_verify_depth    18446744073709551615
Ssl_ctx_verify_mode 5
Ssl_default_timeout 0
Ssl_finished_accepts    912
Ssl_finished_connects   0
Ssl_server_not_after    Dec 19 11:52:45 2030 GMT
Ssl_server_not_before   Dec 21 11:52:45 2020 GMT
Ssl_session_cache_hits  0
Ssl_session_cache_misses    0
Ssl_session_cache_mode  SERVER
Ssl_session_cache_overflows 0
Ssl_session_cache_size  128
Ssl_session_cache_timeouts  0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries  0
Ssl_verify_depth    0
Ssl_verify_mode 0
Ssl_version
Table_locks_immediate   30657
Table_locks_waited  0
Table_open_cache_hits   9475305
Table_open_cache_misses 1112
Table_open_cache_overflows  0
Tc_log_max_pages_used   0
Tc_log_page_size    0
Tc_log_page_waits   0
Threads_cached  5
Threads_connected   9
Threads_created 161
Threads_running 2
Uptime  94329
Uptime_since_flush_status   94329
validate_password.dictionary_file_last_parsed   2021-08-09 10:07:01
validate_password.dictionary_file_words_count   0




5   event_scheduler localhost       Daemon  94352   Waiting on empty queue
9   xxx xxx:45606   twitch  Sleep   1
10  yyy xxx:45608       Sleep   7
11  yyy xxx:45610       Sleep   7
2754    yyy yyy:37228   twitch  Sleep   10413
2827    xxxnode1    xxx:45644   twitch  Sleep   7950
3043    xxx11   zzz:51272   twitch  Sleep   2
3099    xxx mydesktop:39520     Query   0   init    /* ApplicationName=DBeaver 21.1.3 - SQLEditor <test.sql> */ SHOW FULL PROCESSLIST
3100    xxx mydesktop:39530     Sleep   46
3103    xxx mydesktop:39544     Sleep   40