MySQLTuner Audit Report

 >>  MySQLTuner 2.9.0
	 * Jean-Marie Renouard <jmrenouard@gmail.com>
	 * Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.pl/
 >>  Run with '--help' for additional options and output filtering
 >>  Started at: 2026-07-05 17:37:04
ℹ  Skipped version check for MySQLTuner script
✔  Logged in using credentials passed on the command line
 
-------- Audit Snapshot Summary --------------------------------------------------------------------
ℹ  MySQLTuner Version : 2.9.0
ℹ  Audit Start Time   : 2026-07-05 17:37:04
ℹ  Server Connection  : 127.0.0.1:3306
ℹ  Database User      : root@localhost
ℹ  Database Version   : 8.4.8
ℹ  System Physical RAM: 15.3G
ℹ  System Swap Memory : 4.0G
ℹ  Database Uptime    : 50s
ℹ  Skipping architecture check on remote host
ℹ  Using default 64 bits as target architecture
ℹ  Audit Snapshot Summary execution time: 1.108s
 
-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ  Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM -ndbcluster -ndbinfo +PERFORMANCE_SCHEMA 
ℹ  Data in InnoDB tables: 51.2M (Tables: 7)
✔  Total fragmented tables: 0
 
✔  Currently running supported MySQL/MariaDB version 8.4.8(LTS)
ℹ  Storage Engine Statistics execution time: 1.108s
 
-------- System Linux Recommendations --------------------------------------------------------------
Look for related Linux system recommendations
ℹ  Ubuntu 24.04.4 LTS
ℹ  Machine type          : Container
✘  Internet              : Disconnected
ℹ  Number of Core CPU : 10
ℹ  Operating System Type : GNU/Linux

ℹ  Kernel Release        : 6.18.33.2-microsoft-standard-WSL2

ℹ  Hostname              : Ligthpath-Main
ℹ  Network Cards         : 
ℹ  	sh: line 1: ip: command not found
ℹ  Internal IP           : sh: line 1: hostname: command not found
ℹ  HTTP client found: /usr/bin/curl
ℹ  External IP           : 82.67.192.129
ℹ  Name Servers          : 127.0.0.11
ℹ  Logged In users       : 
ℹ  Ram Usages in MB      : 
ℹ  	sh: line 1: free: command not found
ℹ  Load Average          : 
ℹ  	sh: line 1: top: command not found
ℹ  System Uptime         : 
ℹ  	sh: line 1: uptime: command not found
ℹ  Database Uptime       : 50s
✔  There is at least one CPU dedicated to database server.
✔  There is at least 1.5 Gb of RAM dedicated to Linux server.
ℹ  User process except mysqld used 0B RAM.
ℹ  Other user process except mysqld used less than 15% of total physical memory 0.00% (0B / 15G)
ℹ  System Linux Recommendations execution time: 4.533s
 
-------- Filesystem Linux Recommendations ----------------------------------------------------------
ℹ  mount point /etc/hosts is using 14 % total space (131.82 GB / 1006.85 GB)
ℹ  mount point / is using 3 % of max allowed inodes
ℹ  mount point /etc/hosts is using 3 % of max allowed inodes
ℹ  Filesystem Linux Recommendations execution time: 0.764s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Performance Schema error_log table detected
ℹ  Performance Schema error_log: 10 entries detected
✔  performance_schema.error_log doesn't contain any warning.
✔  performance_schema.error_log doesn't contain any error.
ℹ  2 start(s) detected in performance_schema.error_log
ℹ  1) X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
ℹ  2) /usr/sbin/mysqld: ready for connections. Version: '8.4.8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
ℹ  0 shutdown(s) detected in performance_schema.error_log
ℹ  Log file Recommendations execution time: 0.242s
 
-------- Analysis Performance Metrics --------------------------------------------------------------
ℹ  innodb_stats_on_metadata: OFF
✔  No stat updates during querying INFORMATION_SCHEMA.
ℹ  Analysis Performance Metrics execution time: 0.000s
 
-------- Database Metrics --------------------------------------------------------------------------
ℹ  There is 1 Database(s).
ℹ  All User Databases:
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3916999
ℹ   +-- DATA  : 45.6M(89.16%)
ℹ   +-- INDEX : 5.5M(10.84%)
ℹ   +-- SIZE  : 51.2M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3916999
ℹ   +-- DATA  : 45.6M(89.16%)
ℹ   +-- INDEX : 5.5M(10.84%)
ℹ   +-- TOTAL : 51.2M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ   +-- ENGINE InnoDB : 6 TABLE(s)
✔  1 collation for employees database.
✔  1 engine for employees database.
ℹ  Charsets for employees database table column: utf8mb4
✔  employees table column(s) has same charset defined for all text like column(s).
ℹ  Collations for employees database table column: utf8mb4_0900_ai_ci
✔  employees table column(s) has same collation defined for all text like column(s).
ℹ  Database Metrics execution time: 3.631s
 
-------- Table Column Metrics ----------------------------------------------------------------------
ℹ  MySQL and Percona version 8.0 and greater have removed PROCEDURE ANALYSE feature
ℹ  Disabling colstat parameter
ℹ  Database: employees
ℹ   +-- TABLE: departments
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_name - Cols: dept_name - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: dept_no - Type: BTREE
ℹ       +-- Column departments.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column departments.dept_name: VARCHAR(40) NOT NULL
ℹ   +-- TABLE: dept_emp
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_no - Cols: dept_no - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE
ℹ       +-- Column dept_emp.emp_no: INT NOT NULL
ℹ       +-- Column dept_emp.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column dept_emp.from_date: DATE NOT NULL
ℹ       +-- Column dept_emp.to_date: DATE NOT NULL
ℹ   +-- TABLE: dept_manager
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_no - Cols: dept_no - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE
ℹ       +-- Column dept_manager.emp_no: INT NOT NULL
ℹ       +-- Column dept_manager.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column dept_manager.from_date: DATE NOT NULL
ℹ       +-- Column dept_manager.to_date: DATE NOT NULL
ℹ   +-- TABLE: employees
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no - Type: BTREE
ℹ       +-- Column employees.emp_no: INT NOT NULL
ℹ       +-- Column employees.birth_date: DATE NOT NULL
ℹ       +-- Column employees.first_name: VARCHAR(14) NOT NULL
ℹ       +-- Column employees.last_name: VARCHAR(16) NOT NULL
ℹ       +-- Column employees.gender: ENUM('M','F') NOT NULL
ℹ       +-- Column employees.hire_date: DATE NOT NULL
ℹ   +-- TABLE: salaries
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no,from_date - Type: BTREE
ℹ       +-- Column salaries.emp_no: INT NOT NULL
ℹ       +-- Column salaries.salary: INT NOT NULL
ℹ       +-- Column salaries.from_date: DATE NOT NULL
ℹ       +-- Column salaries.to_date: DATE NOT NULL
ℹ   +-- TABLE: titles
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no,title,from_date - Type: BTREE
ℹ       +-- Column titles.emp_no: INT NOT NULL
ℹ       +-- Column titles.title: VARCHAR(50) NOT NULL
ℹ       +-- Column titles.from_date: DATE NOT NULL
ℹ       +-- Column titles.to_date: DATE NULL
ℹ  Table Column Metrics execution time: -0.174s
 
-------- Table structures analysis -----------------------------------------------------------------
✔  All tables get a primary key
✘  Table employees.departments: Primary key 'dept_no' does not follow 'id' or 'departments_id' naming convention
✘  Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'dept_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'dept_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'emp_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.employees: Primary key 'emp_no' does not follow 'id' or 'employees_id' naming convention
✘  Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'from_date' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'title' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✔  All tables are InnoDB tables
✔  All columns are UTF-8 compliant
ℹ  Table structures analysis execution time: 1.545s
 
-------- Naming conventions analysis ---------------------------------------------------------------
✘  Table employees.departments: Plural name detected (prefer singular)
✘  Table employees.employees: Plural name detected (prefer singular)
✘  Table employees.salaries: Plural name detected (prefer singular)
✘  Table employees.titles: Plural name detected (prefer singular)
ℹ  Naming conventions analysis execution time: 0.702s
 
-------- Foreign Key analysis ----------------------------------------------------------------------
ℹ  Constraint on employees.dept_manager.emp_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Constraint on employees.dept_manager.dept_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Constraint on employees.dept_emp.emp_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Constraint on employees.dept_emp.dept_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Constraint on employees.titles.emp_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Constraint on employees.salaries.emp_no uses ON DELETE CASCADE; ensure this is intended.
ℹ  Foreign Key analysis execution time: 0.592s
 
-------- MySQL 8.0+ Specific Modeling --------------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MySQL 8.0+ Specific Modeling execution time: 0.492s
 
-------- Data Type optimization --------------------------------------------------------------------
✔  No data type optimization recommendations
ℹ  Data Type optimization execution time: 0.192s
 
-------- Schema sanitization -----------------------------------------------------------------------
✔  No empty or view-only schemas detected
ℹ  Schema sanitization execution time: 0.175s
 
-------- Indexes Metrics ---------------------------------------------------------------------------
ℹ  Worst selectivity indexes:
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 8 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  dept_no(dept_no) has a low selectivity
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: PRIMARY(from_date)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(from_date) has a low selectivity
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 9 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 37.50%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 298914 distinct values
ℹ   +-- NB ROWS     : 442486 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 67.55%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 299600 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 90.47%
ℹ  Index: PRIMARY(title)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 441713 distinct values
ℹ   +-- NB ROWS     : 442486 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 99.83%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 331143 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Indexes per database:
ℹ  Database: employees
ℹ   +-- INDEX      : departments.dept_name
ℹ   +-- COLUMNS    : dept_name
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : departments.PRIMARY
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_emp.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 8
ℹ   +-- INDEX      : dept_emp.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 630743
ℹ   +-- INDEX      : dept_manager.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_manager.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 48
ℹ   +-- INDEX      : employees.PRIMARY
ℹ   +-- COLUMNS    : emp_no
ℹ   +-- CARDINALITY: 299290
ℹ   +-- INDEX      : salaries.PRIMARY
ℹ   +-- COLUMNS    : emp_no,from_date
ℹ   +-- CARDINALITY: 2
ℹ   +-- INDEX      : titles.PRIMARY
ℹ   +-- COLUMNS    : emp_no,title,from_date
ℹ   +-- CARDINALITY: 1183113
ℹ  Unused indexes:
✘  Index: dept_name on employees.departments is not used.
✘  Index: dept_no on employees.dept_emp is not used.
✘  Index: dept_no on employees.dept_manager is not used.
ℹ  Indexes Metrics execution time: 0.869s
 
-------- Views Metrics -----------------------------------------------------------------------------
ℹ  Views Metrics execution time: 0.000s
 
-------- Triggers Metrics --------------------------------------------------------------------------
ℹ  Triggers Metrics execution time: 0.000s
 
-------- Routines Metrics --------------------------------------------------------------------------
ℹ  Routines Metrics execution time: 0.000s
 
-------- Security Recommendations ------------------------------------------------------------------
ℹ  MySQL Community Server - GPL - 8.4.8
✔  No Role user detected
✔  There are no anonymous accounts for any database users
✔  All database users have passwords assigned
✘  User 'root'@% does not specify hostname restrictions.
ℹ  There are 620 basic passwords in the list.
ℹ  Security Recommendations execution time: 54.313s
 
-------- Authentication Plugin Security ------------------------------------------------------------
✔  No users found using insecure or deprecated authentication plugins
ℹ  Authentication Plugin Security execution time: 0.198s
 
-------- SSL/TLS Security Recommendations ----------------------------------------------------------
✘  Current connection is NOT encrypted!
✘  require_secure_transport is OFF
✔  Only secure TLS versions enabled: TLSv1.2,TLSv1.3
✘  Public Certificate file not found: server-cert.pem
✘  CA Certificate file not found: ca.pem
✘  1 users can connect remotely without SSL enforcement
ℹ  SSL/TLS Security Recommendations execution time: 0.573s
 
-------- CVE Security Recommendations --------------------------------------------------------------
✘  CVE-2026-21998(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-22001(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Information Schema).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploita...

✘  CVE-2026-22002(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-22004(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerability al...

✘  CVE-2026-22005(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-22009(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-22015(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Information Schema).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploita...

✘  CVE-2026-22017(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-34270(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily ex...

✘  CVE-2026-34271(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily ex...

✘  CVE-2026-34276(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily ex...

✘  CVE-2026-34303(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-34304(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerability al...

✘  CVE-2026-34308(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: JSON).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerabil...

✘  CVE-2026-35236(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerability al...

✘  CVE-2026-35237(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerability al...

✘  CVE-2026-35238(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerability al...

✘  CVE-2026-35239(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: DML).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulnerabili...

✘  CVE-2026-35240(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

✘  CVE-2026-46863(<= 8.4.9) : Vulnerability in the MySQL Server, MySQL Cluster product of Oracle MySQL (component: Server: Connection Handling).  Supported versions that are affected are MySQL Server: 8.4.0-8.4.9, 9.0.0-9.7.0  MyS...

✘  20 CVE(s) found for your MySQL release.
ℹ  CVE Security Recommendations execution time: 0.003s
 
-------- Plugin Information ------------------------------------------------------------------------
ℹ  Plugin                         | Version    | Status     | Type                
ℹ  --------------------------------------------------------------------------------
ℹ  mysqlx_cache_cleaner           | 1.0        | ACTIVE     | AUDIT               
ℹ  sha2_cache_cleaner             | 1.0        | ACTIVE     | AUDIT               
ℹ  caching_sha2_password          | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  sha256_password                | 1.1        | ACTIVE     | AUTHENTICATION      
ℹ  daemon_keyring_proxy_plugin    | 1.0        | ACTIVE     | DAEMON              
ℹ  mysqlx                         | 1.0        | ACTIVE     | DAEMON              
ℹ  ngram                          | 0.1        | ACTIVE     | FTPARSER            
ℹ  ARCHIVE                        | 3.0        | ACTIVE     | STORAGE ENGINE      
ℹ  binlog                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  BLACKHOLE                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  CSV                            | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  InnoDB                         | 8.4        | ACTIVE     | STORAGE ENGINE      
ℹ  MEMORY                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MRG_MYISAM                     | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MyISAM                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  PERFORMANCE_SCHEMA             | 0.1        | ACTIVE     | STORAGE ENGINE      
ℹ  TempTable                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  Plugin Information execution time: 0.222s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 50s (727 q [14.540 qps], 526 conn, TX: 437K, RX: 164M)
ℹ  Reads / Writes: 60% / 40%
ℹ  Binary logging is enabled (GTID MODE: OFF)
ℹ  Physical Memory     : 15.3G
ℹ  Max MySQL memory    : 1.8G
ℹ  Other process memory: 0B
ℹ  Total buffers: 200.0M global + 1.0G temptable + 1.9M per thread (151 max threads)
ℹ  Performance_schema Max memory usage: 355M
ℹ  Galera GCache Max memory usage: 0B
ℹ  Global Buffers
ℹ   +-- Key Buffer: 8.0M
ℹ   +-- Max Tmp Table: 16.0M
ℹ  Per Thread Buffers
ℹ   +-- Read Buffer: 128.0K
ℹ   +-- Read RND Buffer: 256.0K
ℹ   +-- Sort Buffer: 256.0K
ℹ   +-- Thread stack: 1.0M
ℹ   +-- Join Buffer: 256.0K
ℹ  Binlog Cache Buffers
ℹ   +-- Binlog Cache: 32.0K
✔  Maximum reached memory usage: 591.2M (3.78% of installed RAM)
✔  Maximum possible memory usage: 1.8G (11.95% of installed RAM)
✔  Overall possible memory usage with other process is compatible with memory available
✔  Slow queries: 0% (0/727)
✔  Highest usage of available connections: 1% (2/151)
✘  Aborted connections: 57.60% (303/526)
ℹ  Query cache has been removed since MySQL 8.0
✘  Sorts requiring temporary tables: 19% (41 temp sorts / 207 sorts)
✘  Joins performed without indexes: 43
✔  Temporary tables created on disk: 2% (8 on disk / 274 total)
✔  Thread cache hit rate: 99% (2 created / 526 connections)
✔  Table cache hit rate: 90% (6K hits / 7K requests)
✔  table_definition_cache (2000) is greater than number of tables (338)
✔  Open file limit used: 0% (2/8K)
✔  Table locks acquired immediately: 100% (184 immediate / 184 locks)
✘  Binlog cache memory access: 6.21% (11 Memory / 177 Total)
ℹ  Performance Metrics execution time: 0.751s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 355.3M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 2.1.3
ℹ  Performance schema execution time: 0.556s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	921 conn(s)
ℹ   +-- 2: background	53 conn(s)
ℹ   +-- 3: event_scheduler	1 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.200s
 
-------- Performance schema: Top 5 user per statement ----------------------------------------------
ℹ   +-- 1: root	2256 stmt(s)
ℹ   +-- 2: background	0 stmt(s)
ℹ   +-- 3: event_scheduler	0 stmt(s)
ℹ  Performance schema: Top 5 user per statement execution time: 0.196s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	24978365348.9399
ℹ   +-- 2: background	0.0000
ℹ   +-- 3: event_scheduler	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.195s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	2742000000
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.197s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	165
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.181s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	6313
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.193s
 
-------- Performance schema: Top 5 user per rows modified ------------------------------------------
ℹ   +-- 1: root	3919016
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows modified execution time: 0.195s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: background	97761
ℹ   +-- 2: root	38628
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO execution time: 0.196s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: background	20744044264988
ℹ   +-- 2: root	8163885768600
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.213s
 
-------- Performance schema: Top 5 host per connection ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	513 conn(s)
ℹ   +-- 2: localhost	418 conn(s)
ℹ  Performance schema: Top 5 host per connection execution time: 0.216s
 
-------- Performance schema: Top 5 host per statement ----------------------------------------------
ℹ   +-- 1: localhost	920 stmt(s)
ℹ   +-- 2: 172.18.0.2	704 stmt(s)
ℹ  Performance schema: Top 5 host per statement execution time: 0.202s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	39972509539.7727
ℹ   +-- 2: localhost	354148293.1034
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.175s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	2232000000
ℹ   +-- 2: localhost	532000000
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.179s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	130
ℹ   +-- 2: localhost	44
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.223s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	3637
ℹ   +-- 2: localhost	2709
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.231s
 
-------- Performance schema: Top 5 host per rows modified ------------------------------------------
ℹ   +-- 1: 172.18.0.2	3919016
ℹ   +-- 2: localhost	0
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per rows modified execution time: 0.266s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	19310
ℹ   +-- 2: localhost	8
ℹ  Performance schema: Top 5 host per io execution time: 0.264s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	4064612841336
ℹ   +-- 2: localhost	34660085928
ℹ  Performance schema: Top 5 host per io latency execution time: 0.238s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	83139 i/o
ℹ   +-- 2: innodb/innodb_data_file	15290 i/o
ℹ   +-- 3: sql/io_cache	9514 i/o
ℹ   +-- 4: sql/binlog	8838 i/o
ℹ   +-- 5: innodb/innodb_dblwr_file	139 i/o
ℹ   +-- 6: innodb/innodb_temp_file	77 i/o
ℹ   +-- 7: sql/binlog_index	41 i/o
ℹ   +-- 8: sql/casetest	15 i/o
ℹ   +-- 9: sql/misc	6 i/o
ℹ   +-- 10: sql/ERRMSG	5 i/o
ℹ   +-- 11: mysys/cnf	5 i/o
ℹ   +-- 12: sql/pid	3 i/o
ℹ   +-- 13: mysys/charset	3 i/o
ℹ  Performance schema: Top IO type order by total io execution time: 0.216s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	18395417355272
ℹ   +-- 2: innodb/innodb_data_file	4335138476570
ℹ   +-- 3: sql/binlog	1255920322368
ℹ   +-- 4: innodb/innodb_dblwr_file	289632550098
ℹ   +-- 5: sql/io_cache	263614599912
ℹ   +-- 6: innodb/innodb_temp_file	231572292512
ℹ   +-- 7: sql/binlog_index	52088172488
ℹ   +-- 8: sql/casetest	1353455240
ℹ   +-- 9: sql/pid	816198228
ℹ   +-- 10: sql/ERRMSG	321020840
ℹ   +-- 11: mysys/cnf	43455760
ℹ   +-- 12: mysys/charset	34868760
ℹ   +-- 13: sql/misc	34381240
ℹ  Performance schema: Top IO type order by total latency execution time: 0.243s
 
-------- Performance schema: Top IO type order by max latency --------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	202802479732
ℹ   +-- 2: sql/io_cache	61534929520
ℹ   +-- 3: sql/binlog_index	49806600494
ℹ   +-- 4: sql/binlog	44984257080
ℹ   +-- 5: innodb/innodb_data_file	34658638326
ℹ   +-- 6: innodb/innodb_dblwr_file	24087720006
ℹ   +-- 7: innodb/innodb_temp_file	23072105600
ℹ   +-- 8: sql/casetest	1208207520
ℹ   +-- 9: sql/pid	742125658
ℹ   +-- 10: sql/ERRMSG	275227200
ℹ   +-- 11: mysys/cnf	28242920
ℹ   +-- 12: mysys/charset	19534040
ℹ   +-- 13: sql/misc	8797520
ℹ  Performance schema: Top IO type order by max latency execution time: 0.239s
 
-------- Performance schema: Top Stages order by total io ------------------------------------------
ℹ   +-- 1: innodb/buffer pool load	1 i/o
ℹ  Performance schema: Top Stages order by total io execution time: 0.231s
 
-------- Performance schema: Top Stages order by total latency -------------------------------------
ℹ   +-- 1: innodb/buffer pool load	77063895000
ℹ  Performance schema: Top Stages order by total latency execution time: 0.236s
 
-------- Performance schema: Top Stages order by avg latency ---------------------------------------
ℹ   +-- 1: innodb/buffer pool load	77063895000
ℹ  Performance schema: Top Stages order by avg latency execution time: 0.210s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	130
ℹ   +-- 2: localhost	110
ℹ  Performance schema: Top 5 host per table scans execution time: 0.201s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	104251392	95230078	6363 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.258s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	96141312	87849584	5868 page(s)
ℹ   +-- 2: employees	employees	7028736	6444236	429 page(s)
ℹ   +-- 3: employees	titles	1048576	935745	64 page(s)
ℹ   +-- 4: employees	departments	32768	513	2 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.263s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: innodb/page_flush_coordinator_thread	NULL	130
ℹ   +-- 2: sql/main	NULL	129
ℹ   +-- 3: innodb/fts_optimize_thread	NULL	129
ℹ   +-- 4: innodb/clone_gtid_thread	NULL	129
ℹ   +-- 5: innodb/srv_purge_thread	NULL	129
ℹ   +-- 6: innodb/srv_worker_thread	NULL	129
ℹ   +-- 7: innodb/srv_worker_thread	NULL	129
ℹ   +-- 8: innodb/srv_worker_thread	NULL	129
ℹ   +-- 9: sql/event_scheduler	Daemon	129
ℹ   +-- 10: innodb/dict_stats_thread	NULL	129
ℹ   +-- 11: innodb/srv_master_thread	NULL	129
ℹ   +-- 12: sql/compress_gtid_table	Daemon	129
ℹ   +-- 13: root@localhost	Query	0
ℹ   +-- 14: innodb/io_read_thread	NULL	NULL
ℹ   +-- 15: innodb/log_writer_thread	NULL	NULL
ℹ   +-- 16: innodb/io_read_thread	NULL	NULL
ℹ   +-- 17: innodb/io_read_thread	NULL	NULL
ℹ   +-- 18: innodb/io_read_thread	NULL	NULL
ℹ   +-- 19: innodb/io_read_thread	NULL	NULL
ℹ   +-- 20: innodb/srv_lock_timeout_thread	NULL	NULL
ℹ   +-- 21: innodb/io_write_thread	NULL	NULL
ℹ   +-- 22: innodb/io_write_thread	NULL	NULL
ℹ   +-- 23: innodb/io_write_thread	NULL	NULL
ℹ   +-- 24: innodb/io_write_thread	NULL	NULL
ℹ   +-- 25: innodb/log_checkpointer_thread	NULL	NULL
ℹ   +-- 26: innodb/log_flush_notifier_thread	NULL	NULL
ℹ   +-- 27: innodb/log_flusher_thread	NULL	NULL
ℹ   +-- 28: innodb/log_write_notifier_thread	NULL	NULL
ℹ   +-- 29: innodb/io_read_thread	NULL	NULL
ℹ   +-- 30: innodb/io_read_thread	NULL	NULL
ℹ   +-- 31: innodb/io_read_thread	NULL	NULL
ℹ   +-- 32: innodb/io_read_thread	NULL	NULL
ℹ   +-- 33: innodb/io_ibuf_thread	NULL	NULL
ℹ   +-- 34: innodb/io_read_thread	NULL	NULL
ℹ   +-- 35: innodb/log_files_governor_thread	NULL	NULL
ℹ   +-- 36: innodb/srv_error_monitor_thread	NULL	NULL
ℹ   +-- 37: innodb/srv_monitor_thread	NULL	NULL
ℹ   +-- 38: innodb/buf_resize_thread	NULL	NULL
ℹ   +-- 39: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 40: sql/signal_handler	NULL	NULL
ℹ   +-- 41: innodb/buf_dump_thread	NULL	NULL
ℹ   +-- 42: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 43: mysqlx/worker	NULL	NULL
ℹ   +-- 44: mysqlx/worker	NULL	NULL
ℹ  Performance schema: Process per time execution time: 0.212s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.175s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: log_flusher_thread	16029075591422	202802479732
ℹ   +-- 2: log_writer_thread	1563241004410	73582158120
ℹ   +-- 3: log_files_governor_thread	547571191762	10841625434
ℹ   +-- 4: page_flush_coordinator_thread	442868768940	24087720006
ℹ   +-- 5: io_write_thread	417237342338	12231013668
ℹ   +-- 6: io_write_thread	268085208172	18729289074
ℹ   +-- 7: io_write_thread	251158238434	9989872040
ℹ   +-- 8: io_write_thread	250993508196	17548022574
ℹ   +-- 9: log_checkpointer_thread	103732064122	28582816728
ℹ   +-- 10: srv_purge_thread	90719239560	5277285998
ℹ   +-- 11: main	79770628416	49806600494
ℹ   +-- 12: buf_dump_thread	72268067904	1510525320
ℹ   +-- 13: dict_stats_thread	21076785960	5204220600
ℹ   +-- 14: clone_gtid_thread	794365642	498551802
ℹ  Performance schema: Thread IO Latency execution time: 0.181s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */	244860545000
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */	169618609000
ℹ   +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */	151677769000
ℹ   +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */	139758021000
ℹ   +-- 5: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	75884466000
ℹ   +-- 6: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 7: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	65001563000
ℹ   +-- 8: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	57520870000
ℹ   +-- 10: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 11: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	51122709000
ℹ   +-- 12: CREATE TABLE `titles` ( `emp_no` INTEGER NOT NULL , `title` VARCHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to_	43256486000
ℹ   +-- 13: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	41136018000
ℹ   +-- 14: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	39177453000
ℹ   +-- 15: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	38483232000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.205s
 
-------- Performance schema: Top 15 slower queries -------------------------------------------------
ℹ   +-- 1: INSERT INTO `salaries` VALUES (...) /* , ... */	114 s
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */	21 s
ℹ   +-- 3: INSERT INTO `employees` VALUES (...) /* , ... */	17 s
ℹ   +-- 4: INSERT INTO `dept_emp` VALUES (...) /* , ... */	14 s
ℹ   +-- 5: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2 s
ℹ   +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2 s
ℹ   +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2 s
ℹ   +-- 8: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	1 s
ℹ   +-- 9: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	1 s
ℹ   +-- 10: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	1 s
ℹ   +-- 11: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	1 s
ℹ  Performance schema: Top 15 slower queries execution time: 0.200s
 
-------- Performance schema: Top 15 nb statement type ----------------------------------------------
ℹ   +-- 1: select	507
ℹ   +-- 2: Quit	346
ℹ   +-- 3: insert	168
ℹ   +-- 4: error	137
ℹ   +-- 5: Init DB	52
ℹ   +-- 6: show_engine_status	12
ℹ   +-- 7: show_status	6
ℹ   +-- 8: create_table	6
ℹ   +-- 9: show_databases	5
ℹ   +-- 10: show_variables	5
ℹ   +-- 11: truncate	2
ℹ   +-- 12: show_replica_status	2
ℹ   +-- 13: show_grants	2
ℹ   +-- 14: show_replicas	2
ℹ   +-- 15: show_storage_engines	2
ℹ  Performance schema: Top 15 nb statement type execution time: 0.215s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	26668268176000
ℹ   +-- 2: select	1473797273000
ℹ   +-- 3: create_table	255050377000
ℹ   +-- 4: create_view	19399330000
ℹ   +-- 5: show_variables	18798431000
ℹ   +-- 6: flush	14911736000
ℹ   +-- 7: show_databases	12541548000
ℹ   +-- 8: error	11576803000
ℹ   +-- 9: create_db	7345983000
ℹ   +-- 10: show_status	7041015000
ℹ   +-- 11: Init DB	6047169000
ℹ   +-- 12: drop_db	5820449000
ℹ   +-- 13: drop_table	4925669000
ℹ   +-- 14: truncate	3701765000
ℹ   +-- 15: Quit	2612784000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.218s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: select	1496000000
ℹ   +-- 2: insert	1042000000
ℹ   +-- 3: create_table	118000000
ℹ   +-- 4: truncate	59000000
ℹ   +-- 5: show_databases	22000000
ℹ   +-- 6: show_variables	22000000
ℹ   +-- 7: show_status	18000000
ℹ   +-- 8: create_view	16000000
ℹ   +-- 9: drop_table	14000000
ℹ   +-- 10: Init DB	4000000
ℹ   +-- 11: create_db	3000000
ℹ   +-- 12: drop_db	2000000
ℹ   +-- 13: show_storage_engines	2000000
ℹ   +-- 14: show_engine_status	0
ℹ   +-- 15: error	0
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.186s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	178
ℹ   +-- 2: show_status	6
ℹ   +-- 3: show_databases	5
ℹ   +-- 4: show_variables	5
ℹ   +-- 5: show_storage_engines	2
ℹ   +-- 6: truncate	0
ℹ   +-- 7: show_engine_status	0
ℹ   +-- 8: show_replica_status	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: show_replicas	0
ℹ   +-- 11: error	0
ℹ   +-- 12: Quit	0
ℹ   +-- 13: Init DB	0
ℹ   +-- 14: Statistics	0
ℹ   +-- 15: create_table	0
ℹ  Performance schema: Top 15 statement by full scans execution time: 0.235s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: show_variables	2537
ℹ   +-- 2: select	2003
ℹ   +-- 3: show_status	1994
ℹ   +-- 4: show_databases	25
ℹ   +-- 5: show_storage_engines	22
ℹ   +-- 6: truncate	0
ℹ   +-- 7: show_engine_status	0
ℹ   +-- 8: show_replica_status	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: show_replicas	0
ℹ   +-- 11: error	0
ℹ   +-- 12: Quit	0
ℹ   +-- 13: Init DB	0
ℹ   +-- 14: Statistics	0
ℹ   +-- 15: create_table	0
ℹ  Performance schema: Top 15 statement by rows sent execution time: 0.207s
 
-------- Performance schema: Top 15 statement by rows modified -------------------------------------
ℹ   +-- 1: insert	3919015
ℹ   +-- 2: create_db	1
ℹ   +-- 3: select	0
ℹ   +-- 4: truncate	0
ℹ   +-- 5: show_databases	0
ℹ   +-- 6: show_variables	0
ℹ   +-- 7: show_status	0
ℹ   +-- 8: show_engine_status	0
ℹ   +-- 9: show_replica_status	0
ℹ   +-- 10: show_grants	0
ℹ   +-- 11: show_replicas	0
ℹ   +-- 12: Ping	0
ℹ   +-- 13: error	0
ℹ   +-- 14: Quit	0
ℹ   +-- 15: Init DB	0
ℹ  Performance schema: Top 15 statement by rows modified execution time: 0.211s
 
-------- Performance schema: 15 sample queries using temp table ------------------------------------
ℹ   +-- 1: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER
ℹ   +-- 2: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch
ℹ   +-- 3: SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P
ℹ   +-- 4: SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?
ℹ   +-- 5: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 
ℹ   +-- 6: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in
ℹ   +-- 7: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER
ℹ   +-- 8: SELECT `thread` , FILE , `latency` , `operation` FROM `sys` . `x$latest_file_io` ORDER BY `latency` LIMIT ?
ℹ   +-- 9: SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?
ℹ   +-- 10: SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?
ℹ   +-- 11: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?
ℹ   +-- 12: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?
ℹ   +-- 13: SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?
ℹ   +-- 14: SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?
ℹ   +-- 15: SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?
ℹ  Performance schema: 15 sample queries using temp table execution time: 0.192s
 
-------- Performance schema: Unused indexes --------------------------------------------------------
ℹ   +-- 1: employees.dept_emp (dept_no)
ℹ   +-- 2: employees.dept_manager (dept_no)
✘  Performance schema: 2 unused index(es) found.
ℹ  Performance schema: Unused indexes execution time: 0.200s
 
-------- Performance schema: Tables with full table scans ------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Tables with full table scans execution time: 0.169s
 
-------- Performance schema: Latest File IO by latency ---------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Latest File IO by latency execution time: 0.200s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_1.dblwr	12582912
ℹ   +-- 2: /var/lib/mysql/mysql.ibd	9256960
ℹ   +-- 3: /var/lib/mysql/undo_001	8667136
ℹ   +-- 4: /var/lib/mysql/undo_002	7880704
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	4636672
ℹ   +-- 6: /var/lib/mysql/#ib_16384_0.dblwr	4194304
ℹ   +-- 7: /var/lib/mysql/binlog.000001	3006135
ℹ   +-- 8: /var/lib/mysql/ibtmp1	2097152
ℹ   +-- 9: /var/lib/mysql/employees/titles.ibd	786432
ℹ   +-- 10: /usr/share/mysql-8.4/english/errmsg.sys	411166
ℹ   +-- 11: /var/lib/mysql/ibdata1	229376
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	68096
ℹ   +-- 13: /usr/share/mysql-8.4/charsets/Index.xml	19525
ℹ   +-- 14: /var/lib/mysql/sys/sys_config.ibd	16384
ℹ   +-- 15: /var/lib/mysql/#innodb_temp/temp_10.ibt	16384
ℹ  Performance schema: File by IO read bytes execution time: 0.189s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	210354176
ℹ   +-- 2: /var/lib/mysql/#ib_16384_0.dblwr	197033984
ℹ   +-- 3: /var/lib/mysql/binlog.000003	66378597
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	48283648
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	44466176
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	37896192
ℹ   +-- 7: /var/lib/mysql/undo_001	20299776
ℹ   +-- 8: /var/lib/mysql/undo_002	19693568
ℹ   +-- 9: /var/lib/mysql/ibtmp1	14729216
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo82	12228608
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo88	12068352
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo84	12021760
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo87	11993088
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo86	11984384
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo89	11939840
ℹ  Performance schema: File by IO written bytes execution time: 0.185s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/binlog.000003	1211471136216
ℹ   +-- 2: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	927417560018
ℹ   +-- 3: /var/lib/mysql/undo_002	834576227336
ℹ   +-- 4: /var/lib/mysql/#innodb_redo/#ib_redo82	816130453856
ℹ   +-- 5: /var/lib/mysql/employees/salaries.ibd	813363981174
ℹ   +-- 6: /var/lib/mysql/#innodb_redo/#ib_redo84	810846578028
ℹ   +-- 7: /var/lib/mysql/undo_001	747819529838
ℹ   +-- 8: /var/lib/mysql/#innodb_redo/#ib_redo91	717257325956
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo90	626818496820
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo86	625207727970
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo87	624673762826
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo88	621280146078
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo89	620844998468
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo103	606045789272
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo83	595788272630
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo93	571625695590
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo96	566587778588
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo101	560295631624
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo99	541118999738
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo85	540982870858
ℹ  Performance schema: File per IO total latency execution time: 0.165s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/undo_002	571930299748
ℹ   +-- 2: /var/lib/mysql/undo_001	510960248572
ℹ   +-- 3: /var/lib/mysql/mysql.ibd	405707515944
ℹ   +-- 4: /var/lib/mysql/ibdata1	39029278948
ℹ   +-- 5: /var/lib/mysql/ibtmp1	35192373560
ℹ   +-- 6: /var/lib/mysql/#innodb_temp/temp_10.ibt	23072105600
ℹ   +-- 7: /var/lib/mysql/employees/employees.ibd	19230167122
ℹ   +-- 8: /var/lib/mysql/employees/titles.ibd	15181262000
ℹ   +-- 9: /var/lib/mysql/#ib_16384_1.dblwr	5749932760
ℹ   +-- 10: /var/lib/mysql/#ib_16384_0.dblwr	4122207632
ℹ   +-- 11: /var/lib/mysql/sys/sys_config.ibd	1151732760
ℹ   +-- 12: /var/lib/mysql/binlog.000001	474157520
ℹ   +-- 13: /usr/share/mysql-8.4/english/errmsg.sys	294716920
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	106977400
ℹ   +-- 15: /var/lib/mysql/binlog.index	25450760
ℹ   +-- 16: /usr/share/mysql-8.4/charsets/Index.xml	11290520
ℹ   +-- 17: /var/lib/mysql/auto.cnf	9395840
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo108_tmp	0
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	0
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo106_tmp	0
ℹ  Performance schema: file per IO read latency execution time: 0.179s
 
-------- Performance schema: file per IO write latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_0.dblwr	276505715106
ℹ   +-- 2: /var/lib/mysql/employees/salaries.ibd	127648567104
ℹ   +-- 3: /var/lib/mysql/binlog.000003	102571713892
ℹ   +-- 4: /var/lib/mysql/#innodb_redo/#ib_redo84	89624302326
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	65566285584
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	58857561644
ℹ   +-- 7: /var/lib/mysql/employees/titles.ibd	47735647666
ℹ   +-- 8: /var/lib/mysql/#innodb_temp/temp_10.ibt	45671386050
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo82	24157617632
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	23897091930
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo101	21612006468
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo106_tmp	21319160406
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo89	21143669272
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo88	20929028620
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo91	20491753096
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo85	19942177340
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo87	19925569528
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo80	18870916404
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	18824096756
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo81	18546335006
ℹ  Performance schema: file per IO write latency execution time: 0.179s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	260247178
ℹ   +-- 2: innodb/innodb_data_file	33570816
ℹ   +-- 3: innodb/innodb_dblwr_file	16777216
ℹ   +-- 4: sql/binlog	3006135
ℹ   +-- 5: sql/ERRMSG	411166
ℹ   +-- 6: innodb/innodb_log_file	68096
ℹ   +-- 7: mysys/charset	19525
ℹ   +-- 8: innodb/innodb_temp_file	16384
ℹ   +-- 9: sql/binlog_index	176
ℹ   +-- 10: mysys/cnf	56
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: Event Wait by read bytes execution time: 0.168s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	399654912
ℹ   +-- 2: innodb/innodb_log_file	366494208
ℹ   +-- 3: sql/io_cache	241716494
ℹ   +-- 4: innodb/innodb_dblwr_file	197230592
ℹ   +-- 5: sql/binlog	66383264
ℹ   +-- 6: innodb/innodb_temp_file	1523712
ℹ   +-- 7: sql/pid	2
ℹ   +-- 8: sql/binlog_index	0
ℹ   +-- 9: sql/casetest	0
ℹ   +-- 10: sql/ERRMSG	0
ℹ   +-- 11: sql/misc	0
ℹ   +-- 12: mysys/charset	0
ℹ   +-- 13: mysys/cnf	0
ℹ  Performance schema: Event Wait written bytes execution time: 0.183s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	18395417355272
ℹ   +-- 2: innodb/innodb_data_file	4335008663290
ℹ   +-- 3: sql/binlog	1255920322368
ℹ   +-- 4: sql/io_cache	301593039472
ℹ   +-- 5: innodb/innodb_dblwr_file	289632550098
ℹ   +-- 6: innodb/innodb_temp_file	260784937990
ℹ   +-- 7: sql/binlog_index	52088172488
ℹ   +-- 8: sql/casetest	1353455240
ℹ   +-- 9: sql/pid	816198228
ℹ   +-- 10: sql/ERRMSG	321020840
ℹ   +-- 11: mysys/cnf	43455760
ℹ   +-- 12: mysys/charset	34868760
ℹ   +-- 13: sql/misc	34381240
ℹ  Performance schema: event per wait total latency execution time: 0.188s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	1598382878654
ℹ   +-- 2: innodb/innodb_temp_file	23072105600
ℹ   +-- 3: sql/io_cache	21569713000
ℹ   +-- 4: innodb/innodb_dblwr_file	9872140392
ℹ   +-- 5: sql/binlog	474157520
ℹ   +-- 6: sql/ERRMSG	294716920
ℹ   +-- 7: innodb/innodb_log_file	106977400
ℹ   +-- 8: sql/binlog_index	67842840
ℹ   +-- 9: mysys/charset	11290520
ℹ   +-- 10: mysys/cnf	9395840
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: event per wait read latency execution time: 0.194s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	644229577796
ℹ   +-- 2: innodb/innodb_data_file	347507699664
ℹ   +-- 3: innodb/innodb_dblwr_file	279672235066
ℹ   +-- 4: sql/io_cache	265438279272
ℹ   +-- 5: sql/binlog	102810277372
ℹ   +-- 6: innodb/innodb_temp_file	53786597434
ℹ   +-- 7: sql/pid	61718370
ℹ   +-- 8: sql/binlog_index	0
ℹ   +-- 9: sql/casetest	0
ℹ   +-- 10: sql/ERRMSG	0
ℹ   +-- 11: sql/misc	0
ℹ   +-- 12: mysys/charset	0
ℹ   +-- 13: mysys/cnf	0
ℹ  Performance schema: event per wait write latency execution time: 0.183s
 
-------- Performance schema: Top 15 most read indexes ----------------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 most read indexes execution time: 0.188s
 
-------- Performance schema: Top 15 most modified indexes ------------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 most modified indexes execution time: 0.181s
 
-------- Performance schema: Top 15 high read latency index ----------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 high read latency index execution time: 0.202s
 
-------- Performance schema: Top 15 most modified indexes ------------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 most modified indexes execution time: 0.177s
 
-------- Performance schema: Top 15 high update latency index --------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 high update latency index execution time: 0.201s
 
-------- Performance schema: Top 15 high delete latency index --------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 high delete latency index execution time: 0.185s
 
-------- Performance schema: Top 15 most read tables -----------------------------------------------
ℹ   +-- 1: employees	salaries	0
ℹ   +-- 2: employees	dept_emp	0
ℹ   +-- 3: employees	titles	0
ℹ   +-- 4: employees	employees	0
ℹ   +-- 5: employees	dept_manager	0
ℹ   +-- 6: employees	departments	0
ℹ  Performance schema: Top 15 most read tables execution time: 0.174s
 
-------- Performance schema: Top 15 most modified tables -------------------------------------------
ℹ   +-- 1: employees	salaries	2844047
ℹ   +-- 2: employees	titles	443308
ℹ   +-- 3: employees	dept_emp	331603
ℹ   +-- 4: employees	employees	300024
ℹ   +-- 5: employees	dept_manager	24
ℹ   +-- 6: employees	departments	9
ℹ  Performance schema: Top 15 most modified tables execution time: 0.181s
 
-------- Performance schema: Top 15 high read latency tables ---------------------------------------
ℹ   +-- 1: employees	salaries	0
ℹ   +-- 2: employees	dept_emp	0
ℹ   +-- 3: employees	titles	0
ℹ   +-- 4: employees	employees	0
ℹ   +-- 5: employees	dept_manager	0
ℹ   +-- 6: employees	departments	0
ℹ  Performance schema: Top 15 high read latency tables execution time: 0.181s
 
-------- Performance schema: Top 15 high insert latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	6871943363492
ℹ   +-- 2: employees	dept_emp	1939481683610
ℹ   +-- 3: employees	titles	1454611607434
ℹ   +-- 4: employees	employees	749320210578
ℹ   +-- 5: employees	dept_manager	159330400
ℹ   +-- 6: employees	departments	88263280
ℹ  Performance schema: Top 15 high insert latency tables execution time: 0.176s
 
-------- Performance schema: Top 15 high update latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	0
ℹ   +-- 2: employees	dept_emp	0
ℹ   +-- 3: employees	titles	0
ℹ   +-- 4: employees	employees	0
ℹ   +-- 5: employees	dept_manager	0
ℹ   +-- 6: employees	departments	0
ℹ  Performance schema: Top 15 high update latency tables execution time: 0.200s
 
-------- Performance schema: Top 15 high delete latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	0
ℹ   +-- 2: employees	dept_emp	0
ℹ   +-- 3: employees	titles	0
ℹ   +-- 4: employees	employees	0
ℹ   +-- 5: employees	dept_manager	0
ℹ   +-- 6: employees	departments	0
ℹ  Performance schema: Top 15 high delete latency tables execution time: 0.184s
 
-------- Performance schema: Redundant indexes -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Redundant indexes execution time: 0.191s
 
-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
ℹ   +-- 1: employees	dept_emp
ℹ   +-- 2: employees	dept_manager
ℹ  Performance schema: Table not using InnoDB buffer execution time: 0.253s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	96141312
ℹ   +-- 2: employees	employees	7028736
ℹ   +-- 3: employees	titles	1048576
ℹ   +-- 4: employees	departments	32768
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.248s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	8291728
ℹ   +-- 2: employees	employees	584500
ℹ   +-- 3: employees	titles	112831
ℹ   +-- 4: employees	departments	32255
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.238s
 
-------- Performance schema: Top 15 Most executed queries ------------------------------------------
ℹ   +-- 1: NULL	SELECT @@`version_comment` LIMIT ?	174
ℹ   +-- 2: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	114
ℹ   +-- 3: NULL	SELECT SCHEMA ( )	76
ℹ   +-- 4: employees	INSERT INTO `titles` VALUES (...) /* , ... */	21
ℹ   +-- 5: employees	INSERT INTO `employees` VALUES (...) /* , ... */	17
ℹ   +-- 6: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	14
ℹ   +-- 7: NULL	SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS	12
ℹ   +-- 8: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	12
ℹ   +-- 9: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	12
ℹ   +-- 10: employees	SELECT ? AS ?	7
ℹ   +-- 11: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ?	6
ℹ   +-- 12: NULL	SHOW SCHEMAS	5
ℹ   +-- 13: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	4
ℹ   +-- 14: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...)	4
ℹ   +-- 15: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	4
ℹ  Performance schema: Top 15 Most executed queries execution time: 0.191s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees`	2026-07-05 15:36:20.555047
ℹ   +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments`	2026-07-05 15:36:20.573867
ℹ   +-- 3: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:22.072437
ℹ   +-- 4: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:22.274093
ℹ   +-- 5: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:22.449486
ℹ   +-- 6: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:23.612053
ℹ   +-- 7: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:23.849858
ℹ   +-- 8: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:38:25.426746
ℹ  Performance schema: Latest SQL queries in errors or warnings execution time: 0.181s
 
-------- Performance schema: Top 20 queries with full table scans ----------------------------------
ℹ   +-- 1: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	2
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2
ℹ   +-- 4: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2
ℹ   +-- 6: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2
ℹ   +-- 7: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `IS_VISIBLE` = ? AND `T	2
ℹ   +-- 8: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2
ℹ   +-- 9: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2
ℹ   +-- 10: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO	2
ℹ   +-- 11: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2
ℹ   +-- 12: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2
ℹ   +-- 13: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 14: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 15: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...)	2
ℹ   +-- 16: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2
ℹ   +-- 17: NULL	SELECT COUNT ( * ) FROM `performance_schema` . `error_log`	2
ℹ   +-- 18: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	2
ℹ   +-- 19: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2
ℹ   +-- 20: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	2
ℹ  Performance schema: Top 20 queries with full table scans execution time: 0.194s
 
-------- Performance schema: Last 50 queries with full table scans ---------------------------------
ℹ   +-- 1: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	2026-07-05 15:38:34.495645
ℹ   +-- 2: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	2026-07-05 15:38:34.301019
ℹ   +-- 3: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 	2026-07-05 15:38:34.120260
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:38:33.929195
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:38:33.690432
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:38:33.442419
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:38:33.189779
ℹ   +-- 8: NULL	SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ?	2026-07-05 15:38:30.202072
ℹ   +-- 9: NULL	SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ?	2026-07-05 15:38:30.018739
ℹ   +-- 10: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	2026-07-05 15:38:29.492965
ℹ   +-- 11: NULL	SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ?	2026-07-05 15:38:29.326549
ℹ   +-- 12: NULL	SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ?	2026-07-05 15:38:29.142168
ℹ   +-- 13: NULL	SELECT * FROM `sys` . `x$schema_tables_with_full_table_scans` WHERE ( `object_schema` IS NULL OR `object_schema` NOT IN 	2026-07-05 15:38:28.754320
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:38:28.583595
ℹ   +-- 15: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:38:26.920772
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:38:26.721483
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	2026-07-05 15:38:26.516786
ℹ   +-- 18: NULL	SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w	2026-07-05 15:38:26.335622
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:38:26.160298
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:38:25.948741
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:38:25.685127
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:38:25.426746
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:38:24.310182
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:23.849858
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:23.612053
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:38:23.346091
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:23.081218
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:22.838068
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:38:22.629365
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:22.449486
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:22.274093
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:22.072437
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:21.857081
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:21.644036
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:38:21.448627
ℹ   +-- 36: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:21.252927
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:21.060986
ℹ   +-- 38: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:38:20.880172
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:20.682554
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:20.487016
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:20.292253
ℹ   +-- 42: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:38:18.784113
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:38:17.983683
ℹ   +-- 44: NULL	SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:37:25.371166
ℹ   +-- 45: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:37:24.422434
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2026-07-05 15:37:24.241314
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:37:23.475490
ℹ   +-- 48: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:37:23.135240
ℹ   +-- 49: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:37:22.793558
ℹ   +-- 50: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:37:22.240584
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.184s
 
-------- Performance schema: Top 15 reader queries (95% percentile) --------------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	20
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	8
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	8
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	8
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	4
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2
ℹ   +-- 7: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	0
ℹ   +-- 8: employees	INSERT INTO `employees` VALUES (...) /* , ... */	0
ℹ   +-- 9: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	0
ℹ   +-- 10: employees	INSERT INTO `titles` VALUES (...) /* , ... */	0
ℹ   +-- 11: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	0
ℹ  Performance schema: Top 15 reader queries (95% percentile) execution time: 0.208s
 
-------- Performance schema: Top 15 most row look queries (95% percentile) -------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	286
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	16
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	16
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	16
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	4
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	4
ℹ   +-- 7: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	0
ℹ   +-- 8: employees	INSERT INTO `employees` VALUES (...) /* , ... */	0
ℹ   +-- 9: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	0
ℹ   +-- 10: employees	INSERT INTO `titles` VALUES (...) /* , ... */	0
ℹ   +-- 11: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	0
ℹ  Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.179s
 
-------- Performance schema: Top 15 total latency queries (95% percentile) -------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	17291265685000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	3561990789000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	3428047632000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	2375886368000
ℹ   +-- 5: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	151768933000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	132489604000
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	130003127000
ℹ   +-- 8: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	115041740000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	111742850000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	104576478000
ℹ   +-- 11: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.168s
 
-------- Performance schema: Top 15 max latency queries (95% percentile) ---------------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	540283574000
ℹ   +-- 2: employees	INSERT INTO `employees` VALUES (...) /* , ... */	384784424000
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */	354934076000
ℹ   +-- 4: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	347318466000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 6: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 8: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	58526982000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	53453769000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.177s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	244860545000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	169618609000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	151677769000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	139758021000
ℹ   +-- 5: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	75884466000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	66244802000
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	65001563000
ℹ   +-- 8: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	57520870000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	55871425000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	52288239000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.174s
 
-------- Performance schema: Top 20 queries with sort ----------------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	12
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	12
ℹ   +-- 3: NULL	SHOW SCHEMAS	5
ℹ   +-- 4: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2
ℹ   +-- 5: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2
ℹ   +-- 14: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2
ℹ   +-- 16: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2
ℹ   +-- 17: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2
ℹ   +-- 18: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2
ℹ   +-- 19: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2
ℹ   +-- 20: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2
ℹ  Performance schema: Top 20 queries with sort execution time: 0.175s
 
-------- Performance schema: Last 50 queries with sort ---------------------------------------------
ℹ   +-- 1: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	2026-07-05 15:38:35.761910
ℹ   +-- 2: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	2026-07-05 15:38:34.679014
ℹ   +-- 3: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	2026-07-05 15:38:34.495645
ℹ   +-- 4: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	2026-07-05 15:38:34.301019
ℹ   +-- 5: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 	2026-07-05 15:38:34.120260
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:38:33.929195
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:38:33.690432
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:38:33.442419
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:38:33.189779
ℹ   +-- 10: NULL	SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ?	2026-07-05 15:38:30.202072
ℹ   +-- 11: NULL	SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ?	2026-07-05 15:38:30.018739
ℹ   +-- 12: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	2026-07-05 15:38:29.492965
ℹ   +-- 13: NULL	SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ?	2026-07-05 15:38:29.326549
ℹ   +-- 14: NULL	SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ?	2026-07-05 15:38:29.142168
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:38:28.583595
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:38:26.920772
ℹ   +-- 17: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:38:26.721483
ℹ   +-- 18: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	2026-07-05 15:38:26.516786
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:38:26.160298
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:38:25.948741
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:38:25.685127
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:38:25.426746
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:38:24.310182
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:23.849858
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:23.612053
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:38:23.346091
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:23.081218
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:22.838068
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:38:22.629365
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:22.449486
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:22.274093
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:22.072437
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:21.857081
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:21.644036
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:38:21.448627
ℹ   +-- 36: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:21.252927
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:21.060986
ℹ   +-- 38: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:38:20.880172
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:20.682554
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:20.487016
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:20.292253
ℹ   +-- 42: NULL	SHOW SCHEMAS	2026-07-05 15:38:19.902670
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:38:18.784113
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:37:23.475490
ℹ   +-- 45: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:37:23.135240
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:37:22.793558
ℹ   +-- 47: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2026-07-05 15:37:19.521392
ℹ   +-- 48: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:37:18.908657
ℹ   +-- 49: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	2026-07-05 15:37:18.719925
ℹ   +-- 50: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2026-07-05 15:37:15.455572
ℹ  Performance schema: Last 50 queries with sort execution time: 0.169s
 
-------- Performance schema: Top 15 row sorting queries with sort ----------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	13489
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	13489
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	13477
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	13063
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	13051
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	267
ℹ   +-- 7: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	100
ℹ   +-- 8: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT	100
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	56
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	54
ℹ   +-- 11: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_temp_tables` WHERE ( `db` IS NULL OR `db`	50
ℹ   +-- 12: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	48
ℹ   +-- 13: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	40
ℹ   +-- 14: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	40
ℹ   +-- 15: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	40
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.169s
 
-------- Performance schema: Top 15 total latency queries with sort --------------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	151768933000
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	132489604000
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	130003127000
ℹ   +-- 4: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	115041740000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	111742850000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	104576478000
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	33217389000
ℹ   +-- 8: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	23599420000
ℹ   +-- 9: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	23300047000
ℹ   +-- 10: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	21869080000
ℹ   +-- 11: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	20436260000
ℹ   +-- 12: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	16569922000
ℹ   +-- 13: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	16117845000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	15274774000
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	12676726000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.179s
 
-------- Performance schema: Top 15 merge queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	18
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	18
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	18
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	18
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	10
ℹ   +-- 6: NULL	SHOW SCHEMAS	0
ℹ   +-- 7: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
ℹ   +-- 8: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 9: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	0
ℹ   +-- 10: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 12: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 13: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 14: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ  Performance schema: Top 15 merge queries with sort execution time: 0.203s
 
-------- Performance schema: Top 15 average sort merges queries with sort --------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	9
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	9
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	9
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	9
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	5
ℹ   +-- 6: NULL	SHOW SCHEMAS	0
ℹ   +-- 7: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
ℹ   +-- 8: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 9: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	0
ℹ   +-- 10: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 12: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 13: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 14: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ  Performance schema: Top 15 average sort merges queries with sort execution time: 0.187s
 
-------- Performance schema: Top 15 scans queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	12
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	12
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	12
ℹ   +-- 4: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	12
ℹ   +-- 5: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	12
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	12
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	12
ℹ   +-- 8: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	10
ℹ   +-- 9: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	10
ℹ   +-- 10: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	10
ℹ   +-- 11: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	10
ℹ   +-- 12: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	10
ℹ   +-- 13: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	10
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	8
ℹ   +-- 15: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	8
ℹ  Performance schema: Top 15 scans queries with sort execution time: 0.175s
 
-------- Performance schema: Top 15 range queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SHOW SCHEMAS	0
ℹ   +-- 2: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
ℹ   +-- 3: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 4: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	0
ℹ   +-- 5: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 6: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 7: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 9: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 10: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ   +-- 11: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	0
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	0
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	0
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	0
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	0
ℹ  Performance schema: Top 15 range queries with sort execution time: 0.183s
 
-------- Performance schema: Top 20 queries with temp table ----------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	12
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	12
ℹ   +-- 3: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	4
ℹ   +-- 4: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	4
ℹ   +-- 5: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 6: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 7: NULL	SELECT `TABLE_SCHEMA` , SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `I	2
ℹ   +-- 8: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	2
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	2
ℹ   +-- 10: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2
ℹ   +-- 11: NULL	SHOW VARIABLES	2
ℹ   +-- 12: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	2
ℹ   +-- 13: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2
ℹ   +-- 14: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2
ℹ   +-- 15: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	2
ℹ   +-- 16: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	2
ℹ   +-- 17: NULL	SHOW ENGINES	2
ℹ   +-- 18: NULL	SHOW GLOBAL STATUS	2
ℹ   +-- 19: NULL	SHOW STATUS	2
ℹ   +-- 20: NULL	SHOW GLOBAL VARIABLES	2
ℹ  Performance schema: Top 20 queries with temp table execution time: 0.189s
 
-------- Performance schema: Last 50 queries with temp table ---------------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:38:33.929195
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:38:33.690432
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:38:33.442419
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:38:33.189779
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:38:26.920772
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	2026-07-05 15:38:26.516786
ℹ   +-- 7: NULL	SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w	2026-07-05 15:38:26.335622
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:38:26.160298
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:38:25.948741
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:38:25.685127
ℹ   +-- 11: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:38:25.426746
ℹ   +-- 12: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:38:24.310182
ℹ   +-- 13: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:23.849858
ℹ   +-- 14: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:23.612053
ℹ   +-- 15: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:38:23.346091
ℹ   +-- 16: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:23.081218
ℹ   +-- 17: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:22.838068
ℹ   +-- 18: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:38:22.629365
ℹ   +-- 19: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:22.449486
ℹ   +-- 20: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:22.274093
ℹ   +-- 21: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:22.072437
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:38:21.857081
ℹ   +-- 23: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:38:21.644036
ℹ   +-- 24: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:38:21.448627
ℹ   +-- 25: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:38:21.252927
ℹ   +-- 26: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:38:21.060986
ℹ   +-- 27: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:38:20.880172
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:38:20.682554
ℹ   +-- 29: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:38:20.487016
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:38:20.292253
ℹ   +-- 31: NULL	SELECT `sys_version` FROM `sys` . `version`	2026-07-05 15:38:20.090121
ℹ   +-- 32: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:38:18.784113
ℹ   +-- 33: NULL	SHOW SESSION STATUS LIKE ?	2026-07-05 15:38:18.163691
ℹ   +-- 34: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:37:24.422434
ℹ   +-- 35: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:37:23.135240
ℹ   +-- 36: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:37:22.963304
ℹ   +-- 37: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:37:22.793558
ℹ   +-- 38: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:37:22.607548
ℹ   +-- 39: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:37:22.240584
ℹ   +-- 40: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:37:21.747855
ℹ   +-- 41: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2026-07-05 15:37:21.544913
ℹ   +-- 42: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2026-07-05 15:37:20.968456
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2026-07-05 15:37:19.705001
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	2026-07-05 15:37:19.113398
ℹ   +-- 45: NULL	SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA	2026-07-05 15:37:19.081053
ℹ   +-- 46: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:37:18.908657
ℹ   +-- 47: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2026-07-05 15:37:18.879388
ℹ   +-- 48: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	2026-07-05 15:37:18.719925
ℹ   +-- 49: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2026-07-05 15:37:18.468130
ℹ   +-- 50: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_COLLAT	2026-07-05 15:37:18.094948
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.176s
 
-------- Performance schema: Top 15 total latency queries with temp table --------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	151768933000
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	132489604000
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	130003127000
ℹ   +-- 4: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	115041740000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	111742850000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	104576478000
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	33217389000
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	28948059000
ℹ   +-- 9: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	24878245000
ℹ   +-- 10: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	24549218000
ℹ   +-- 11: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	23599420000
ℹ   +-- 12: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	23300047000
ℹ   +-- 13: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	16569922000
ℹ   +-- 14: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	16117845000
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	15274774000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.204s
 
-------- Performance schema: Top 15 queries with temp table to disk --------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2
ℹ   +-- 6: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2
ℹ   +-- 7: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2
ℹ   +-- 8: NULL	SHOW VARIABLES	0
ℹ   +-- 9: NULL	SHOW GLOBAL VARIABLES	0
ℹ   +-- 10: NULL	SHOW STATUS	0
ℹ   +-- 11: NULL	SHOW GLOBAL STATUS	0
ℹ   +-- 12: NULL	SHOW ENGINES	0
ℹ   +-- 13: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	0
ℹ   +-- 14: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	0
ℹ   +-- 15: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	0
ℹ  Performance schema: Top 15 queries with temp table to disk execution time: 0.196s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919015
ℹ   +-- 2: wait/io/file	121788
ℹ   +-- 3: wait/lock/table	168
ℹ  Performance schema: Top 15 class events by number execution time: 0.198s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	3919015
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	83139
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	15280
ℹ   +-- 4: wait/io/file/sql/io_cache	14212
ℹ   +-- 5: wait/io/file/sql/binlog	8838
ℹ   +-- 6: wait/lock/table/sql/handler	168
ℹ   +-- 7: wait/io/file/innodb/innodb_dblwr_file	139
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	102
ℹ   +-- 9: wait/io/file/sql/binlog_index	41
ℹ   +-- 10: wait/io/file/sql/casetest	15
ℹ   +-- 11: wait/io/file/sql/misc	6
ℹ   +-- 12: wait/io/file/sql/ERRMSG	5
ℹ   +-- 13: wait/io/file/mysys/cnf	5
ℹ   +-- 14: wait/io/file/sql/pid	3
ℹ   +-- 15: wait/io/file/mysys/charset	3
ℹ  Performance schema: Top 30 events by number execution time: 0.171s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/file	24962538821036
ℹ   +-- 2: wait/io/table	11015604458794
ℹ   +-- 3: wait/lock/table	681885360
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.185s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	18395417355272
ℹ   +-- 2: wait/io/table/sql/handler	11015604458794
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	4335008663290
ℹ   +-- 4: wait/io/file/sql/binlog	1255920322368
ℹ   +-- 5: wait/io/file/sql/io_cache	342700946918
ℹ   +-- 6: wait/io/file/innodb/innodb_dblwr_file	289632550098
ℹ   +-- 7: wait/io/file/innodb/innodb_temp_file	289167430534
ℹ   +-- 8: wait/io/file/sql/binlog_index	52088172488
ℹ   +-- 9: wait/io/file/sql/casetest	1353455240
ℹ   +-- 10: wait/io/file/sql/pid	816198228
ℹ   +-- 11: wait/lock/table/sql/handler	681885360
ℹ   +-- 12: wait/io/file/sql/ERRMSG	321020840
ℹ   +-- 13: wait/io/file/mysys/cnf	43455760
ℹ   +-- 14: wait/io/file/mysys/charset	34868760
ℹ   +-- 15: wait/io/file/sql/misc	34381240
ℹ  Performance schema: Top 30 events by total latency execution time: 0.212s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/file	202802479732
ℹ   +-- 2: wait/io/table	47070925226
ℹ   +-- 3: wait/lock/table	31644480
ℹ  Performance schema: Top 15 class events by max latency execution time: 0.172s
 
-------- Performance schema: Top 30 events by max latency ------------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	202802479732
ℹ   +-- 2: wait/io/file/sql/io_cache	61534929520
ℹ   +-- 3: wait/io/file/sql/binlog_index	49806600494
ℹ   +-- 4: wait/io/table/sql/handler	47070925226
ℹ   +-- 5: wait/io/file/sql/binlog	44984257080
ℹ   +-- 6: wait/io/file/innodb/innodb_data_file	34658638326
ℹ   +-- 7: wait/io/file/innodb/innodb_dblwr_file	24087720006
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	23072105600
ℹ   +-- 9: wait/io/file/sql/casetest	1208207520
ℹ   +-- 10: wait/io/file/sql/pid	742125658
ℹ   +-- 11: wait/io/file/sql/ERRMSG	275227200
ℹ   +-- 12: wait/lock/table/sql/handler	31644480
ℹ   +-- 13: wait/io/file/mysys/cnf	28242920
ℹ   +-- 14: wait/io/file/mysys/charset	19534040
ℹ   +-- 15: wait/io/file/sql/misc	8797520
ℹ  Performance schema: Top 30 events by max latency execution time: 0.183s
 
-------- MyISAM Metrics ----------------------------------------------------------------------------
ℹ  General MyIsam metrics:
ℹ   +-- Total MyISAM Tables  : 0
ℹ   +-- Total MyISAM indexes : 0B
ℹ   +-- KB Size :8.0M
ℹ   +-- KB Used Size :1.5M
ℹ   +-- KB used :18.2%
ℹ   +-- Read KB hit rate: 0% (0 cached / 0 reads)
ℹ   +-- Write KB hit rate: 0% (0 cached / 0 writes)
ℹ  No MyISAM table(s) detected ....
ℹ  MyISAM Metrics execution time: 0.192s
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
ℹ  InnoDB is enabled.
ℹ  InnoDB Metrics execution time: 0.000s
 
-------- Smart Migration LTS Advisor ---------------------------------------------------------------
✔  No major migration risks detected for modern LTS versions.
ℹ  InnoDB Buffers
ℹ   +-- InnoDB Buffer Pool: 128.0M
ℹ   +-- InnoDB Buffer Pool Instances: 1
ℹ   +-- InnoDB Buffer Pool Chunk Size: 128.0M
ℹ   +-- InnoDB Redo Log Capacity: 100.0M
ℹ   +-- InnoDB Log Buffer: 64.0M
ℹ   +-- InnoDB Buffer Free: 1.1K
ℹ   +-- InnoDB Buffer Used: 8.0K
ℹ  InnoDB Thread Concurrency: 0
✔  InnoDB File per table is activated
✔  InnoDB Buffer Pool size ( 128.0M ) under limit for 64 bits architecture: (17179869184.0G )
✔  InnoDB buffer pool / data size: 128.0M / 51.2M
ℹ  InnoDB Redo Log Capacity is set to 100.0M
ℹ  Server uptime is less than 1 hour. Cannot make a reliable recommendation for innodb_redo_log_capacity.
✔  InnoDB buffer pool instances: 1
ℹ  Number of InnoDB Buffer Pool Chunk: 1 for 1 Buffer Pool Instance(s)
✔  Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
✔  InnoDB Read buffer efficiency: 99.99% (22850040 hits / 22851513 total)
✔  InnoDB Write Log efficiency: 99.12% (8111243 hits / 8183633 total)
✔  InnoDB log waits: 0.00% (0 waits / 72390 writes)
ℹ  Smart Migration LTS Advisor execution time: 0.000s
 
-------- InnoDB Transactions -----------------------------------------------------------------------
ℹ  Transaction Isolation Level: REPEATABLE-READ
ℹ  Active InnoDB Transactions: 0
ℹ  InnoDB Transactions execution time: 0.000s
 
-------- InnoDB Index/Data Ratio Check -------------------------------------------------------------
ℹ  Checked InnoDB tables with > 50,000 rows: 4
✘  Under-indexed tables (ratio < 0.3): 3
ℹ  InnoDB Index/Data Ratio Check execution time: 0.182s
 
-------- Query Cache Information -------------------------------------------------------------------
ℹ  Not a MariaDB server. Skipping Query Cache Info plugin check.
ℹ  Query Cache Information execution time: 0.000s
 
-------- Query Anti-Pattern Detection (Experimental) -----------------------------------------------
ℹ  Skipped: Performance Schema is disabled.
ℹ  Query Anti-Pattern Detection (Experimental) execution time: 0.214s
 
-------- Aria Metrics ------------------------------------------------------------------------------
ℹ  Aria Storage Engine not available.
ℹ  Aria Metrics execution time: 0.000s
 
-------- TokuDB Metrics ----------------------------------------------------------------------------
ℹ  TokuDB is disabled.
ℹ  TokuDB Metrics execution time: 0.000s
 
-------- XtraDB Metrics ----------------------------------------------------------------------------
ℹ  XtraDB is disabled.
ℹ  XtraDB Metrics execution time: 0.000s
 
-------- Galera Metrics ----------------------------------------------------------------------------
ℹ  Galera is disabled.
ℹ  Galera Metrics execution time: 0.000s
 
-------- Replication Metrics -----------------------------------------------------------------------
ℹ  Galera Synchronous replication: NO
ℹ  No replication replica(s) for this server.
ℹ  Binlog format: ROW
ℹ  XA support enabled: ON
ℹ  Semi synchronous replication Source: Not Activated
ℹ  Semi synchronous replication Replica: Not Activated
ℹ  This is a standalone server
ℹ  Replication Metrics execution time: 0.000s
 
-------- Predictive Capacity Planning --------------------------------------------------------------
✔  Memory headroom: 17.4G (Theoretical max usage is 11.95% of physical RAM)
ℹ  Growth forecasting: Insufficient uptime (< 24h) for reliable estimation.
ℹ  Predictive Capacity Planning execution time: 0.000s
 
-------- Cluster & Replication Intelligence --------------------------------------------------------
ℹ  Replication status: Not running as a replica.
✘  gtid_mode is OFF (recommended: ON)
✘  enforce_gtid_consistency is OFF (recommended: ON)
ℹ  binlog_transaction_compression is OFF (consider setting to ON to save network/disk space)
✘  Binlog cache disk use ratio is 48.40% (too many disk spills)
✘  source_verify_checksum is disabled (recommended: ON)
ℹ  Cluster & Replication Intelligence execution time: 0.000s
 
-------- Security Hardening 2.0 --------------------------------------------------------------------
✘  TLS/SSL is disabled. Connections are unencrypted.
ℹ  Security Hardening 2.0 execution time: 0.000s
 
-------- Guided Auto-Fix Snippets ------------------------------------------------------------------
Ready-to-Apply SQL Snippets (SET GLOBAL):

Ready-to-Apply Configuration Block ([mysqld]):
    sort_buffer_size (> 256K)
    read_rnd_buffer_size (> 256K)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)
ℹ  Guided Auto-Fix Snippets execution time: 0.177s
 
-------- Health Score KPI --------------------------------------------------------------------------
Overall Weighted Health Score: 75/100
    - Performance: 40/40
    - Security:    10/30
    - Resilience:  25/30

ℹ  Your database health is good, but there's room for improvement.
 
ℹ  Health Score KPI execution time: 0.000s
 
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Use 'id' or '_<table>_id' for Primary Key naming in 11 table(s)
    Use BIGINT UNSIGNED AUTO_INCREMENT for Primary Keys in 11 table(s)
    Use singular names for table in 4 table(s)
    Remove unused indexes.
    Restrict Host for 'root'@'%' to 'root'@LimitedIPRangeOrLocalhost
    RENAME USER 'root'@'%' TO 'root'@LimitedIPRangeOrLocalhost;
    Current connection is NOT encrypted! Consider using SSL for all connections.
    Enable require_secure_transport to force all connections to use SSL.
    Enforce SSL for remote users (ALTER USER ... REQUIRE SSL)
    20 CVE(s) found for your MySQL release. Consider upgrading your version !
    MySQL was started within the last 24 hours: recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Reduce or eliminate unclosed connections and network issues
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size
    Increase binlog_cache_size (current value: 32768)
    Unused indexes found: 2 index(es) should be reviewed and potentially removed.
    Set gtid_mode = ON to enable global transaction identifier replication.
    Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
    Enable binlog_transaction_compression = ON to reduce replication stream size.
    Increase binlog_cache_size to reduce disk spills for binary log transactions.
    Enable source_verify_checksum = ON (or master_verify_checksum).
    Enable TLS/SSL for encrypted connections.
Variables to adjust:
    sort_buffer_size (> 256K)
    read_rnd_buffer_size (> 256K)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)