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:42:31
ℹ  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:42:31
ℹ  Server Connection  : 127.0.0.1:3306
ℹ  Database User      : root@localhost
ℹ  Database Version   : 8.0.45-36
ℹ  System Physical RAM: 15.3G
ℹ  System Swap Memory : 4.0G
ℹ  Database Uptime    : 48s
ℹ  Skipping architecture check on remote host
ℹ  Using default 64 bits as target architecture
ℹ  Audit Snapshot Summary execution time: 1.158s
 
-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ  Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM -ndbcluster -ndbinfo +PERFORMANCE_SCHEMA 
ℹ  Data in InnoDB tables: 31.7M (Tables: 7)
✔  Total fragmented tables: 0
 
✔  Currently running supported MySQL/MariaDB version 8.0.45(LTS)
ℹ  Storage Engine Statistics execution time: 1.117s
 
-------- 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           : 172.18.0.3 
ℹ  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      : 
ℹ  	               total        used        free      shared  buff/cache   available
ℹ  	Mem:           15630        3607        9980           4        2287       12022
ℹ  	Swap:           4096           0        4096
ℹ  Load Average          : 
ℹ  	top - 15:42:41 up 4 days,  5:13,  0 users,  load average: 2.23, 1.35, 0.69
ℹ  System Uptime         : 
ℹ  	 15:42:41 up 4 days,  5:13,  0 users,  load average: 2.05, 1.33, 0.68
ℹ  Database Uptime       : 48s
✔  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 19M RAM.
ℹ  Other user process except mysqld used less than 15% of total physical memory 0.13% (19M / 15G)
ℹ  System Linux Recommendations execution time: 4.510s
 
-------- Filesystem Linux Recommendations ----------------------------------------------------------
ℹ  mount point /etc/hosts is using 14 % total space (131.83 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.779s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Performance Schema error_log table detected
ℹ  Performance Schema error_log: 11 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/lib/mysql/mysqlx.sock
ℹ  2) /usr/sbin/mysqld: ready for connections. Version: '8.0.45-36'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 36, Revision 8fe4a72d.
ℹ  0 shutdown(s) detected in performance_schema.error_log
ℹ  Log file Recommendations execution time: 0.227s
 
-------- 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  : 3918131
ℹ   +-- DATA  : 26.1M(82.47%)
ℹ   +-- INDEX : 5.5M(17.53%)
ℹ   +-- SIZE  : 31.6M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3918131
ℹ   +-- DATA  : 26.1M(82.47%)
ℹ   +-- INDEX : 5.5M(17.53%)
ℹ   +-- TOTAL : 31.6M
ℹ   +-- 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.489s
 
-------- 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: 2.555s
 
-------- Table structures analysis -----------------------------------------------------------------
✔  All tables get a primary key
✘  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.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_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.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.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)
✘  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)
✔  All tables are InnoDB tables
✔  All columns are UTF-8 compliant
ℹ  Table structures analysis execution time: 1.480s
 
-------- Naming conventions analysis ---------------------------------------------------------------
✘  Table employees.employees: Plural name detected (prefer singular)
✘  Table employees.departments: Plural name detected (prefer singular)
✘  Table employees.titles: Plural name detected (prefer singular)
✘  Table employees.salaries: Plural name detected (prefer singular)
ℹ  Naming conventions analysis execution time: 0.772s
 
-------- 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.544s
 
-------- MySQL 8.0+ Specific Modeling --------------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MySQL 8.0+ Specific Modeling execution time: -1.137s
 
-------- 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.210s
 
-------- 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(from_date)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 3 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(from_date) 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: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: PRIMARY(title)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(title) 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.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 299710 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 90.51%
ℹ  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%
ℹ  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: 630853
ℹ   +-- 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: 299600
ℹ   +-- INDEX      : salaries.PRIMARY
ℹ   +-- COLUMNS    : emp_no,from_date
ℹ   +-- CARDINALITY: 2
ℹ   +-- INDEX      : titles.PRIMARY
ℹ   +-- COLUMNS    : emp_no,title,from_date
ℹ   +-- CARDINALITY: 3
ℹ  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: 1.059s
 
-------- 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 ------------------------------------------------------------------
ℹ  Percona Server (GPL), Release 36, Revision 8fe4a72d - 8.0.45
✔  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: 56.094s
 
-------- 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!
✔  SSL support is enabled
✘  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.557s
 
-------- CVE Security Recommendations --------------------------------------------------------------
✘  CVE-2026-21998(<= 8.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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-34267(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privilege...

✘  CVE-2026-34270(<= 8.0.45) : 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.0.45) : 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.0.45) : 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-34278(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privilege...

✘  CVE-2026-34293(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: DML).  Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privileged atta...

✘  CVE-2026-34303(<= 8.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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.0.45) : 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...

✘  22 CVE(s) found for your MySQL release.
ℹ  CVE Security Recommendations execution time: 0.002s
 
-------- 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      
ℹ  mysql_native_password          | 1.1        | 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.0        | 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.174s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 48s (720 q [15.000 qps], 527 conn, TX: 452K, RX: 164M)
ℹ  Reads / Writes: 59% / 41%
ℹ  Binary logging is enabled (GTID MODE: OFF)
ℹ  Physical Memory     : 15.3G
ℹ  Max MySQL memory    : 1.8G
ℹ  Other process memory: 19.9M
ℹ  Total buffers: 152.0M global + 1.0G temptable + 1.9M per thread (151 max threads)
ℹ  Performance_schema Max memory usage: 332M
ℹ  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: 520.5M (3.33% of installed RAM)
✔  Maximum possible memory usage: 1.8G (11.49% of installed RAM)
✔  Overall possible memory usage with other process is compatible with memory available
✔  Slow queries: 0% (0/720)
✔  Highest usage of available connections: 1% (2/151)
✘  Aborted connections: 57.50% (303/527)
ℹ  Query cache has been removed since MySQL 8.0
✘  Sorts requiring temporary tables: 19% (41 temp sorts / 207 sorts)
✘  Joins performed without indexes: 66
✔  Temporary tables created on disk: 2% (8 on disk / 274 total)
✔  temptable_max_mmap (1.0G) is compatible with available disk space on /tmp (823.8G)
✔  Thread cache hit rate: 99% (2 created / 527 connections)
✔  Table cache hit rate: 90% (6K hits / 7K requests)
✔  table_definition_cache (2000) is greater than number of tables (349)
✔  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.837s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 332.7M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 2.1.3
ℹ  Performance schema execution time: 0.510s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	921 conn(s)
ℹ   +-- 2: background	13 conn(s)
ℹ   +-- 3: event_scheduler	1 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.198s
 
-------- Performance schema: Top 5 user per statement ----------------------------------------------
ℹ   +-- 1: root	2044 stmt(s)
ℹ   +-- 2: background	0 stmt(s)
ℹ   +-- 3: event_scheduler	0 stmt(s)
ℹ  Performance schema: Top 5 user per statement execution time: 0.193s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	19881811832.1951
ℹ   +-- 2: background	0.0000
ℹ   +-- 3: event_scheduler	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.199s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	2498000000
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.194s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	199
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.204s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	6793
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.217s
 
-------- 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.189s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: background	99847
ℹ   +-- 2: root	38768
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO execution time: 0.193s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: background	36545716999854
ℹ   +-- 2: root	5845336494948
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.170s
 
-------- 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.201s
 
-------- Performance schema: Top 5 host per statement ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	704 stmt(s)
ℹ   +-- 2: localhost	690 stmt(s)
ℹ  Performance schema: Top 5 host per statement execution time: -1.714s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	28755876992.8977
ℹ   +-- 2: localhost	473616752.8736
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.202s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	2059000000
ℹ   +-- 2: localhost	458000000
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.184s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	150
ℹ   +-- 2: localhost	58
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.208s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	3877
ℹ   +-- 2: localhost	2949
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.176s
 
-------- 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.173s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	19380
ℹ   +-- 2: localhost	8
ℹ  Performance schema: Top 5 host per io execution time: 0.186s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	2880700394382
ℹ   +-- 2: localhost	83935706184
ℹ  Performance schema: Top 5 host per io latency execution time: 0.201s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	78984 i/o
ℹ   +-- 2: innodb/innodb_data_file	16770 i/o
ℹ   +-- 3: sql/io_cache	9573 i/o
ℹ   +-- 4: sql/binlog	8473 i/o
ℹ   +-- 5: innodb/innodb_dblwr_file	5280 i/o
ℹ   +-- 6: innodb/innodb_temp_file	78 i/o
ℹ   +-- 7: sql/binlog_index	41 i/o
ℹ   +-- 8: sql/casetest	10 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.183s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	15822000084258
ℹ   +-- 2: innodb/innodb_data_file	12436438579038
ℹ   +-- 3: innodb/innodb_dblwr_file	9708839311050
ℹ   +-- 4: sql/binlog	1150337646774
ℹ   +-- 5: innodb/innodb_temp_file	173539988892
ℹ   +-- 6: sql/io_cache	172985807592
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: sql/pid	227905200
ℹ   +-- 10: sql/ERRMSG	186604560
ℹ   +-- 11: sql/misc	44046360
ℹ   +-- 12: mysys/charset	32343120
ℹ   +-- 13: mysys/cnf	21203640
ℹ  Performance schema: Top IO type order by total latency execution time: 0.191s
 
-------- Performance schema: Top IO type order by max latency --------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	56671552746
ℹ   +-- 2: innodb/innodb_dblwr_file	39089970000
ℹ   +-- 3: innodb/innodb_temp_file	28644613758
ℹ   +-- 4: innodb/innodb_data_file	25383956418
ℹ   +-- 5: sql/binlog	16887608280
ℹ   +-- 6: sql/io_cache	1932736320
ℹ   +-- 7: sql/binlog_index	1276989480
ℹ   +-- 8: sql/casetest	1172046600
ℹ   +-- 9: sql/pid	202358520
ℹ   +-- 10: sql/ERRMSG	142067520
ℹ   +-- 11: mysys/charset	18572760
ℹ   +-- 12: sql/misc	16108920
ℹ   +-- 13: mysys/cnf	13530240
ℹ  Performance schema: Top IO type order by max latency execution time: 0.205s
 
-------- 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.177s
 
-------- Performance schema: Top Stages order by total latency -------------------------------------
ℹ   +-- 1: innodb/buffer pool load	5837754000
ℹ  Performance schema: Top Stages order by total latency execution time: 0.174s
 
-------- Performance schema: Top Stages order by avg latency ---------------------------------------
ℹ   +-- 1: innodb/buffer pool load	5837754000
ℹ  Performance schema: Top Stages order by avg latency execution time: 0.177s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	150
ℹ   +-- 2: localhost	138
ℹ  Performance schema: Top 5 host per table scans execution time: 0.184s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	100515840	91844979	6135 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.290s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	92454912	84479984	5643 page(s)
ℹ   +-- 2: employees	employees	7028736	6444378	429 page(s)
ℹ   +-- 3: employees	titles	1032192	920617	63 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.249s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: innodb/dict_stats_thread	NULL	128
ℹ   +-- 2: innodb/srv_master_thread	NULL	128
ℹ   +-- 3: innodb/fts_optimize_thread	NULL	128
ℹ   +-- 4: innodb/page_flush_coordinator_thread	NULL	128
ℹ   +-- 5: sql/main	NULL	127
ℹ   +-- 6: sql/compress_gtid_table	Daemon	127
ℹ   +-- 7: sql/event_scheduler	Daemon	127
ℹ   +-- 8: innodb/srv_worker_thread	NULL	127
ℹ   +-- 9: innodb/srv_worker_thread	NULL	127
ℹ   +-- 10: innodb/srv_worker_thread	NULL	127
ℹ   +-- 11: innodb/srv_purge_thread	NULL	127
ℹ   +-- 12: innodb/clone_gtid_thread	NULL	127
ℹ   +-- 13: root@localhost	Query	0
ℹ   +-- 14: innodb/io_read_thread	NULL	NULL
ℹ   +-- 15: innodb/io_write_thread	NULL	NULL
ℹ   +-- 16: innodb/io_write_thread	NULL	NULL
ℹ   +-- 17: innodb/io_write_thread	NULL	NULL
ℹ   +-- 18: innodb/srv_error_monitor_thread	NULL	NULL
ℹ   +-- 19: innodb/buf_lru_manager_thread	NULL	NULL
ℹ   +-- 20: innodb/srv_monitor_thread	NULL	NULL
ℹ   +-- 21: innodb/log_checkpointer_thread	NULL	NULL
ℹ   +-- 22: innodb/log_flush_notifier_thread	NULL	NULL
ℹ   +-- 23: innodb/log_flusher_thread	NULL	NULL
ℹ   +-- 24: innodb/log_write_notifier_thread	NULL	NULL
ℹ   +-- 25: innodb/log_writer_thread	NULL	NULL
ℹ   +-- 26: innodb/log_files_governor_thread	NULL	NULL
ℹ   +-- 27: innodb/io_read_thread	NULL	NULL
ℹ   +-- 28: innodb/io_read_thread	NULL	NULL
ℹ   +-- 29: innodb/io_read_thread	NULL	NULL
ℹ   +-- 30: innodb/io_ibuf_thread	NULL	NULL
ℹ   +-- 31: innodb/io_write_thread	NULL	NULL
ℹ   +-- 32: innodb/buf_resize_thread	NULL	NULL
ℹ   +-- 33: innodb/srv_lock_timeout_thread	NULL	NULL
ℹ   +-- 34: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 35: sql/signal_handler	NULL	NULL
ℹ   +-- 36: innodb/buf_dump_thread	NULL	NULL
ℹ   +-- 37: mysqlx/worker	NULL	NULL
ℹ   +-- 38: mysqlx/worker	NULL	NULL
ℹ   +-- 39: mysqlx/acceptor_network	NULL	NULL
ℹ  Performance schema: Process per time execution time: 0.190s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.185s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: log_flusher_thread	13213462538250	56671552746
ℹ   +-- 2: page_flush_coordinator_thread	10165354924698	39089970000
ℹ   +-- 3: io_write_thread	2704962927474	16996940136
ℹ   +-- 4: io_write_thread	2600368727814	18588747294
ℹ   +-- 5: io_write_thread	2585768443668	10456317720
ℹ   +-- 6: io_write_thread	2509103460420	23521438494
ℹ   +-- 7: log_writer_thread	1656324203706	30150371304
ℹ   +-- 8: log_files_governor_thread	705493964610	10509953742
ℹ   +-- 9: log_checkpointer_thread	158908409280	29966548482
ℹ   +-- 10: buf_lru_manager_thread	44318170098	12049785360
ℹ   +-- 11: main	9038972880	2522867760
ℹ   +-- 12: buf_dump_thread	5305367880	173481480
ℹ   +-- 13: srv_purge_thread	1504706760	64686240
ℹ   +-- 14: dict_stats_thread	667356120	111582720
ℹ   +-- 15: clone_gtid_thread	223938000	192837240
ℹ   +-- 16: srv_worker_thread	48639960	48639960
ℹ  Performance schema: Thread IO Latency execution time: 0.200s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 5: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	79125948000
ℹ   +-- 6: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	74995563000
ℹ   +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	65049337000
ℹ   +-- 8: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 9: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 10: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ   +-- 11: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ   +-- 12: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	48614695000
ℹ   +-- 13: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	47819706000
ℹ   +-- 14: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	46953955000
ℹ   +-- 15: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	46693081000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.187s
 
-------- 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 `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	1 s
ℹ   +-- 9: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	1 s
ℹ   +-- 10: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	1 s
ℹ   +-- 11: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	1 s
ℹ  Performance schema: Top 15 slower queries execution time: 0.229s
 
-------- Performance schema: Top 15 nb statement type ----------------------------------------------
ℹ   +-- 1: select	507
ℹ   +-- 2: Quit	346
ℹ   +-- 3: insert	168
ℹ   +-- 4: Init DB	52
ℹ   +-- 5: show_engine_status	12
ℹ   +-- 6: show_status	6
ℹ   +-- 7: create_table	6
ℹ   +-- 8: show_databases	5
ℹ   +-- 9: show_variables	5
ℹ   +-- 10: truncate	2
ℹ   +-- 11: show_slave_status	2
ℹ   +-- 12: show_grants	2
ℹ   +-- 13: show_slave_hosts	2
ℹ   +-- 14: show_storage_engines	2
ℹ   +-- 15: Statistics	2
ℹ  Performance schema: Top 15 nb statement type execution time: 0.189s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	19015621905000
ℹ   +-- 2: select	1213323915000
ℹ   +-- 3: create_table	291574219000
ℹ   +-- 4: create_view	29234418000
ℹ   +-- 5: drop_db	18940195000
ℹ   +-- 6: flush	15605007000
ℹ   +-- 7: create_db	11178662000
ℹ   +-- 8: show_variables	7222988000
ℹ   +-- 9: show_status	7092294000
ℹ   +-- 10: drop_table	5240980000
ℹ   +-- 11: Init DB	5176363000
ℹ   +-- 12: show_databases	4433616000
ℹ   +-- 13: Quit	2499478000
ℹ   +-- 14: truncate	2470391000
ℹ   +-- 15: show_engine_status	2065718000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.217s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: select	1340000000
ℹ   +-- 2: insert	925000000
ℹ   +-- 3: create_table	177000000
ℹ   +-- 4: create_view	24000000
ℹ   +-- 5: show_databases	20000000
ℹ   +-- 6: show_variables	15000000
ℹ   +-- 7: show_status	15000000
ℹ   +-- 8: truncate	14000000
ℹ   +-- 9: drop_table	14000000
ℹ   +-- 10: create_db	5000000
ℹ   +-- 11: drop_db	3000000
ℹ   +-- 12: Init DB	3000000
ℹ   +-- 13: show_storage_engines	2000000
ℹ   +-- 14: show_engine_status	0
ℹ   +-- 15: Ping	0
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.172s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	212
ℹ   +-- 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_slave_status	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: show_slave_hosts	0
ℹ   +-- 11: Quit	0
ℹ   +-- 12: Init DB	0
ℹ   +-- 13: Statistics	0
ℹ   +-- 14: create_table	0
ℹ   +-- 15: insert	0
ℹ  Performance schema: Top 15 statement by full scans execution time: 0.191s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: show_variables	2821
ℹ   +-- 2: show_status	2184
ℹ   +-- 3: select	2005
ℹ   +-- 4: show_databases	25
ℹ   +-- 5: show_storage_engines	22
ℹ   +-- 6: truncate	0
ℹ   +-- 7: show_engine_status	0
ℹ   +-- 8: show_slave_status	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: show_slave_hosts	0
ℹ   +-- 11: Quit	0
ℹ   +-- 12: Init DB	0
ℹ   +-- 13: Statistics	0
ℹ   +-- 14: create_table	0
ℹ   +-- 15: insert	0
ℹ  Performance schema: Top 15 statement by rows sent execution time: 0.178s
 
-------- 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_slave_status	0
ℹ   +-- 10: show_grants	0
ℹ   +-- 11: show_slave_hosts	0
ℹ   +-- 12: show_storage_engines	0
ℹ   +-- 13: Quit	0
ℹ   +-- 14: Init DB	0
ℹ   +-- 15: Statistics	0
ℹ  Performance schema: Top 15 statement by rows modified execution time: 0.186s
 
-------- 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.173s
 
-------- 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.189s
 
-------- 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.171s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/mysql.ibd	9076736
ℹ   +-- 2: /var/lib/mysql/undo_001	8634368
ℹ   +-- 3: /var/lib/mysql/#ib_16384_1.dblwr	8585216
ℹ   +-- 4: /var/lib/mysql/undo_002	7864320
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	4980736
ℹ   +-- 6: /var/lib/mysql/ibtmp1	2097152
ℹ   +-- 7: /var/lib/mysql/employees/titles.ibd	1064960
ℹ   +-- 8: /usr/share/percona-server/english/errmsg.sys	399123
ℹ   +-- 9: /var/lib/mysql/ibdata1	229376
ℹ   +-- 10: /var/lib/mysql/#ib_16384_0.dblwr	196608
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	68096
ℹ   +-- 12: /var/lib/mysql/employees/departments.ibd	65536
ℹ   +-- 13: /var/lib/mysql/employees/salaries.ibd	32768
ℹ   +-- 14: /usr/share/percona-server/charsets/Index.xml	19525
ℹ   +-- 15: /var/lib/mysql/sys/sys_config.ibd	16384
ℹ  Performance schema: File by IO read bytes execution time: 0.180s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	209158144
ℹ   +-- 2: /var/lib/mysql/#ib_16384_0.dblwr	171360256
ℹ   +-- 3: /var/lib/mysql/binlog.000003	66378596
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	48103424
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	43499520
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	37896192
ℹ   +-- 7: /var/lib/mysql/ibtmp1	14729216
ℹ   +-- 8: /var/lib/mysql/#innodb_redo/#ib_redo86	11753472
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo83	11664896
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo88	11654656
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo82	11654656
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo89	11650560
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo85	11649024
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo87	11622912
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo91	11474432
ℹ  Performance schema: File by IO written bytes execution time: 0.174s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_0.dblwr	9663586440966
ℹ   +-- 2: /var/lib/mysql/employees/salaries.ibd	6229236970998
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	1610354013750
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	1376463717306
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	1284889596084
ℹ   +-- 6: /var/lib/mysql/binlog.000003	1099078248492
ℹ   +-- 7: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	1041796022562
ℹ   +-- 8: /var/lib/mysql/undo_002	922162592088
ℹ   +-- 9: /var/lib/mysql/undo_001	792032644152
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo82	754629085458
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo91	698565002382
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo103	680717681964
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo88	530572962078
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo86	519282336456
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo102	510819841062
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo87	510054959682
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo89	502920618642
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo94	498581051508
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo96	495948025044
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo85	495342455976
ℹ  Performance schema: File per IO total latency execution time: 0.177s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/undo_002	9638843274
ℹ   +-- 2: /var/lib/mysql/undo_001	8197237962
ℹ   +-- 3: /var/lib/mysql/mysql.ibd	7824742416
ℹ   +-- 4: /var/lib/mysql/#ib_16384_1.dblwr	3379876920
ℹ   +-- 5: /var/lib/mysql/ibtmp1	853741440
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	412515720
ℹ   +-- 7: /var/lib/mysql/sys/sys_config.ibd	408459258
ℹ   +-- 8: /var/lib/mysql/ibdata1	372092040
ℹ   +-- 9: /var/lib/mysql/employees/titles.ibd	181593360
ℹ   +-- 10: /var/lib/mysql/employees/departments.ibd	179181720
ℹ   +-- 11: /usr/share/percona-server/english/errmsg.sys	163072800
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	126115200
ℹ   +-- 13: /var/lib/mysql/#ib_16384_0.dblwr	79103880
ℹ   +-- 14: /var/lib/mysql/employees/salaries.ibd	28344600
ℹ   +-- 15: /var/lib/mysql/#innodb_temp/temp_10.ibt	26580240
ℹ   +-- 16: /var/lib/mysql/binlog.index	13885200
ℹ   +-- 17: /usr/share/percona-server/charsets/Index.xml	10283400
ℹ   +-- 18: /var/lib/mysql/binlog.000001	8331120
ℹ   +-- 19: /var/lib/mysql/auto.cnf	4426560
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	0
ℹ  Performance schema: file per IO read latency execution time: 0.192s
 
-------- Performance schema: file per IO write latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	355740936012
ℹ   +-- 2: /var/lib/mysql/binlog.000003	86594120640
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	84282874812
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	73717665282
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	57416770908
ℹ   +-- 6: /var/lib/mysql/#ib_16384_0.dblwr	48977113014
ℹ   +-- 7: /var/lib/mysql/undo_002	35391222594
ℹ   +-- 8: /var/lib/mysql/undo_001	29617990812
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	17855315370
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo91	16584682284
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo102	16305502590
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo88	16241430222
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo94	15721274970
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo100	15418982682
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo86	15269210442
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo82	14979863232
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo83	14774153994
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo87	14674027086
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo89	14234010840
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo101	13874919210
ℹ  Performance schema: file per IO write latency execution time: 0.187s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	251499989
ℹ   +-- 2: innodb/innodb_data_file	34062336
ℹ   +-- 3: innodb/innodb_dblwr_file	8781824
ℹ   +-- 4: sql/ERRMSG	399123
ℹ   +-- 5: innodb/innodb_log_file	68096
ℹ   +-- 6: mysys/charset	19525
ℹ   +-- 7: innodb/innodb_temp_file	16384
ℹ   +-- 8: sql/binlog	360
ℹ   +-- 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.182s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	374194176
ℹ   +-- 2: innodb/innodb_log_file	356764672
ℹ   +-- 3: sql/io_cache	234046315
ℹ   +-- 4: innodb/innodb_dblwr_file	171769856
ℹ   +-- 5: sql/binlog	66383262
ℹ   +-- 6: innodb/innodb_temp_file	1540096
ℹ   +-- 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.186s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	15822000084258
ℹ   +-- 2: innodb/innodb_data_file	12435956240598
ℹ   +-- 3: innodb/innodb_dblwr_file	9708839311050
ℹ   +-- 4: sql/binlog	1150337646774
ℹ   +-- 5: innodb/innodb_temp_file	301388158944
ℹ   +-- 6: sql/io_cache	206304845220
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: sql/pid	227905200
ℹ   +-- 10: sql/ERRMSG	186604560
ℹ   +-- 11: sql/misc	44046360
ℹ   +-- 12: mysys/charset	32343120
ℹ   +-- 13: mysys/cnf	21203640
ℹ  Performance schema: event per wait total latency execution time: 0.173s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	28096751790
ℹ   +-- 2: sql/io_cache	19665618156
ℹ   +-- 3: innodb/innodb_dblwr_file	3458980800
ℹ   +-- 4: sql/ERRMSG	163072800
ℹ   +-- 5: innodb/innodb_log_file	126115200
ℹ   +-- 6: sql/binlog_index	36477360
ℹ   +-- 7: innodb/innodb_temp_file	26580240
ℹ   +-- 8: mysys/charset	10283400
ℹ   +-- 9: sql/binlog	8331120
ℹ   +-- 10: mysys/cnf	4426560
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: event per wait read latency execution time: 0.184s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	656323067970
ℹ   +-- 2: innodb/innodb_log_file	423063831420
ℹ   +-- 3: sql/io_cache	172955817126
ℹ   +-- 4: sql/binlog	86910410880
ℹ   +-- 5: innodb/innodb_dblwr_file	49450201614
ℹ   +-- 6: innodb/innodb_temp_file	1867569840
ℹ   +-- 7: sql/pid	19209600
ℹ   +-- 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.188s
 
-------- 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.183s
 
-------- 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 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.192s
 
-------- 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.184s
 
-------- 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.194s
 
-------- 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.171s
 
-------- 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.175s
 
-------- 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.192s
 
-------- 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.192s
 
-------- Performance schema: Top 15 high insert latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	4623350328252
ℹ   +-- 2: employees	dept_emp	1477569796038
ℹ   +-- 3: employees	titles	1170140603130
ℹ   +-- 4: employees	employees	655020752616
ℹ   +-- 5: employees	dept_manager	172103400
ℹ   +-- 6: employees	departments	87873480
ℹ  Performance schema: Top 15 high insert latency tables execution time: 0.159s
 
-------- 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.184s
 
-------- 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.199s
 
-------- Performance schema: Redundant indexes -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Redundant indexes execution time: 0.169s
 
-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
ℹ   +-- 1: employees	dept_emp
ℹ   +-- 2: employees	dept_manager
ℹ   +-- 3: employees	departments
ℹ  Performance schema: Table not using InnoDB buffer execution time: 0.272s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	92454912
ℹ   +-- 2: employees	employees	7028736
ℹ   +-- 3: employees	titles	1032192
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.245s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	7835536
ℹ   +-- 2: employees	employees	584358
ℹ   +-- 3: employees	titles	111575
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.249s
 
-------- 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.184s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees`	2026-07-05 15:41:56.283555
ℹ   +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments`	2026-07-05 15:41:56.306044
ℹ   +-- 3: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.013359
ℹ   +-- 4: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.215823
ℹ   +-- 5: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.144841
ℹ   +-- 6: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.346725
ℹ   +-- 7: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:52.728392
ℹ   +-- 8: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:43:53.636339
ℹ  Performance schema: Latest SQL queries in errors or warnings execution time: 0.172s
 
-------- Performance schema: Top 20 queries with full table scans ----------------------------------
ℹ   +-- 1: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	4
ℹ   +-- 2: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	4
ℹ   +-- 3: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2
ℹ   +-- 4: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i	2
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	2
ℹ   +-- 6: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 7: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	2
ℹ   +-- 8: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	2
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2
ℹ   +-- 10: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	2
ℹ   +-- 11: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	2
ℹ   +-- 12: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...)	2
ℹ   +-- 13: NULL	SELECT COUNT ( * ) FROM `performance_schema` . `error_log`	2
ℹ   +-- 14: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	2
ℹ   +-- 15: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	2
ℹ   +-- 16: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2
ℹ   +-- 17: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2
ℹ   +-- 18: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	2
ℹ   +-- 19: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	2
ℹ   +-- 20: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2
ℹ  Performance schema: Top 20 queries with full table scans execution time: 0.206s
 
-------- 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:44:02.521747
ℹ   +-- 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:44:02.314982
ℹ   +-- 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:44:02.143832
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:44:01.958110
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:01.710009
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:01.464255
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:01.193698
ℹ   +-- 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:43:58.279098
ℹ   +-- 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:43:58.091896
ℹ   +-- 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:43:57.531467
ℹ   +-- 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:43:57.355078
ℹ   +-- 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:43:57.181348
ℹ   +-- 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:43:56.830869
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:43:56.660439
ℹ   +-- 15: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:43:55.165725
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:43:54.936516
ℹ   +-- 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:43:54.750167
ℹ   +-- 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:43:54.551258
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:43:54.364431
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:43:54.175245
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:43:53.925663
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:43:53.636339
ℹ   +-- 23: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:52.728392
ℹ   +-- 24: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:43:52.719421
ℹ   +-- 25: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.526848
ℹ   +-- 26: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.355996
ℹ   +-- 27: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.346725
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:43:52.164527
ℹ   +-- 29: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.144841
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.975655
ℹ   +-- 31: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:43:51.958757
ℹ   +-- 32: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.785580
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.757373
ℹ   +-- 34: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.608411
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:43:51.553047
ℹ   +-- 36: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:43:51.401141
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.358986
ℹ   +-- 38: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.215823
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.160995
ℹ   +-- 40: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.013359
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:50.967350
ℹ   +-- 42: NULL	SELECT COUNT ( * ) FROM `information_schema` . `tables`	2026-07-05 15:43:50.260380
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:43:49.423188
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:43:48.687528
ℹ   +-- 45: NULL	SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:42:54.288299
ℹ   +-- 46: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:42:53.356910
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2026-07-05 15:42:53.177416
ℹ   +-- 48: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:42:52.397966
ℹ   +-- 49: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `DATA_TYPE` = ? AND `TABLE_	2026-07-05 15:42:52.265372
ℹ   +-- 50: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:42:52.073009
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.170s
 
-------- 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	7
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	7
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	5
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2
ℹ   +-- 6: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 7: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	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.194s
 
-------- 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	14
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	14
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	5
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	4
ℹ   +-- 6: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 7: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	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.205s
 
-------- Performance schema: Top 15 total latency queries (95% percentile) -------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	11965437816000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	2762250421000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	2524458544000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	1744021238000
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	158251896000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	149991126000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	130098674000
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	119882278000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	100583903000
ℹ   +-- 10: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 11: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.210s
 
-------- Performance schema: Top 15 max latency queries (95% percentile) ---------------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	525384142000
ℹ   +-- 2: employees	INSERT INTO `employees` VALUES (...) /* , ... */	344248815000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	340699368000
ℹ   +-- 4: employees	INSERT INTO `titles` VALUES (...) /* , ... */	323528181000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	87149463000
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	69481180000
ℹ   +-- 8: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	68451175000
ℹ   +-- 9: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	53890822000
ℹ   +-- 11: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.200s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	79125948000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	74995563000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	65049337000
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	59941139000
ℹ   +-- 9: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 10: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	50291951000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.199s
 
-------- 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.210s
 
-------- 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:44:03.908171
ℹ   +-- 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:44:02.690934
ℹ   +-- 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:44:02.521747
ℹ   +-- 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:44:02.314982
ℹ   +-- 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:44:02.143832
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:44:01.958110
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:01.710009
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:01.464255
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:01.193698
ℹ   +-- 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:43:58.279098
ℹ   +-- 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:43:58.091896
ℹ   +-- 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:43:57.531467
ℹ   +-- 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:43:57.355078
ℹ   +-- 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:43:57.181348
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:43:56.660439
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:43:55.165725
ℹ   +-- 17: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:43:54.936516
ℹ   +-- 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:43:54.750167
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:43:54.364431
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:43:54.175245
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:43:53.925663
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:43:53.636339
ℹ   +-- 23: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:52.728392
ℹ   +-- 24: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:43:52.719421
ℹ   +-- 25: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.526848
ℹ   +-- 26: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.355996
ℹ   +-- 27: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.346725
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:43:52.164527
ℹ   +-- 29: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.144841
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.975655
ℹ   +-- 31: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:43:51.958757
ℹ   +-- 32: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.785580
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.757373
ℹ   +-- 34: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.608411
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:43:51.553047
ℹ   +-- 36: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:43:51.401141
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.358986
ℹ   +-- 38: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.215823
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.160995
ℹ   +-- 40: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.013359
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:50.967350
ℹ   +-- 42: NULL	SHOW SCHEMAS	2026-07-05 15:43:50.606404
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:43:49.423188
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:42:52.397966
ℹ   +-- 45: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:42:51.977323
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:42:51.559138
ℹ   +-- 47: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:42:49.276530
ℹ   +-- 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:42:49.104716
ℹ   +-- 49: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2026-07-05 15:42:47.062295
ℹ   +-- 50: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2026-07-05 15:42:43.237775
ℹ  Performance schema: Last 50 queries with sort execution time: 0.192s
 
-------- 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	12924
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	12915
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	12730
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	12567
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	12557
ℹ   +-- 6: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	322
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	237
ℹ   +-- 8: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	100
ℹ   +-- 9: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT	100
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	64
ℹ   +-- 11: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	56
ℹ   +-- 12: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_temp_tables` WHERE ( `db` IS NULL OR `db`	50
ℹ   +-- 13: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	48
ℹ   +-- 14: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	40
ℹ   +-- 15: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	40
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.201s
 
-------- Performance schema: Top 15 total latency queries with sort --------------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	158251896000
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	149991126000
ℹ   +-- 3: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	130098674000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	119882278000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	100583903000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	98578648000
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	30921659000
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	30639252000
ℹ   +-- 9: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	30606460000
ℹ   +-- 10: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	16055825000
ℹ   +-- 11: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	13230742000
ℹ   +-- 12: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	11400821000
ℹ   +-- 13: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	10890015000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	10860008000
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	10336136000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.195s
 
-------- 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	17
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	17
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	17
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	17
ℹ   +-- 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.217s
 
-------- 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.177s
 
-------- 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.189s
 
-------- 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.163s
 
-------- 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.180s
 
-------- 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:44:01.958110
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:01.710009
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:01.464255
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:01.193698
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:43:55.165725
ℹ   +-- 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:43:54.750167
ℹ   +-- 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:43:54.551258
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:43:54.364431
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:43:54.175245
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:43:53.925663
ℹ   +-- 11: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:43:53.636339
ℹ   +-- 12: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:52.728392
ℹ   +-- 13: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:43:52.719421
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.526848
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.355996
ℹ   +-- 16: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:43:52.346725
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:43:52.164527
ℹ   +-- 18: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:43:52.144841
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.975655
ℹ   +-- 20: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:43:51.958757
ℹ   +-- 21: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:43:51.785580
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.757373
ℹ   +-- 23: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:43:51.608411
ℹ   +-- 24: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:43:51.553047
ℹ   +-- 25: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:43:51.401141
ℹ   +-- 26: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.358986
ℹ   +-- 27: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:43:51.215823
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.160995
ℹ   +-- 29: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:43:51.013359
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:43:50.967350
ℹ   +-- 31: NULL	SELECT `sys_version` FROM `sys` . `version`	2026-07-05 15:43:50.771075
ℹ   +-- 32: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:43:49.423188
ℹ   +-- 33: NULL	SHOW SESSION STATUS LIKE ?	2026-07-05 15:43:48.896469
ℹ   +-- 34: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:42:53.356910
ℹ   +-- 35: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:42:52.073009
ℹ   +-- 36: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:42:51.977323
ℹ   +-- 37: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2026-07-05 15:42:51.900732
ℹ   +-- 38: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:42:51.773296
ℹ   +-- 39: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:42:51.559138
ℹ   +-- 40: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2026-07-05 15:42:51.348954
ℹ   +-- 41: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:42:51.336401
ℹ   +-- 42: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:42:50.936929
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2026-07-05 15:42:50.010303
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	2026-07-05 15:42:49.453613
ℹ   +-- 45: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:42:49.276530
ℹ   +-- 46: 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:42:49.104716
ℹ   +-- 47: NULL	SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA	2026-07-05 15:42:46.722972
ℹ   +-- 48: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2026-07-05 15:42:46.543911
ℹ   +-- 49: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2026-07-05 15:42:46.183585
ℹ   +-- 50: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_COLLAT	2026-07-05 15:42:45.816170
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.163s
 
-------- Performance schema: Top 15 total latency queries with temp table --------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	158251896000
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	149991126000
ℹ   +-- 3: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	130098674000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	119882278000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	100583903000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	98578648000
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	30921659000
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	30639252000
ℹ   +-- 9: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	30606460000
ℹ   +-- 10: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	16055825000
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	11400821000
ℹ   +-- 12: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	10890015000
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	10860008000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	10336136000
ℹ   +-- 15: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	10290835000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.160s
 
-------- 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.186s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919015
ℹ   +-- 2: wait/io/file	124104
ℹ   +-- 3: wait/lock/table	168
ℹ  Performance schema: Top 15 class events by number execution time: 0.196s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	3919015
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	78984
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	16757
ℹ   +-- 4: wait/io/file/sql/io_cache	14433
ℹ   +-- 5: wait/io/file/sql/binlog	8473
ℹ   +-- 6: wait/io/file/innodb/innodb_dblwr_file	5280
ℹ   +-- 7: wait/lock/table/sql/handler	168
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	104
ℹ   +-- 9: wait/io/file/sql/binlog_index	41
ℹ   +-- 10: wait/io/file/sql/casetest	10
ℹ   +-- 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.179s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/file	39778832711052
ℹ   +-- 2: wait/io/table	7926341456916
ℹ   +-- 3: wait/lock/table	513783720
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.188s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	15822000084258
ℹ   +-- 2: wait/io/file/innodb/innodb_data_file	12435956240598
ℹ   +-- 3: wait/io/file/innodb/innodb_dblwr_file	9708839311050
ℹ   +-- 4: wait/io/table/sql/handler	7926341456916
ℹ   +-- 5: wait/io/file/sql/binlog	1150337646774
ℹ   +-- 6: wait/io/file/innodb/innodb_temp_file	402486588810
ℹ   +-- 7: wait/io/file/sql/io_cache	254969009838
ℹ   +-- 8: wait/io/file/sql/binlog_index	2440946124
ℹ   +-- 9: wait/io/file/sql/casetest	1290780720
ℹ   +-- 10: wait/lock/table/sql/handler	513783720
ℹ   +-- 11: wait/io/file/sql/pid	227905200
ℹ   +-- 12: wait/io/file/sql/ERRMSG	186604560
ℹ   +-- 13: wait/io/file/sql/misc	44046360
ℹ   +-- 14: wait/io/file/mysys/charset	32343120
ℹ   +-- 15: wait/io/file/mysys/cnf	21203640
ℹ  Performance schema: Top 30 events by total latency execution time: 0.199s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/table	68907554298
ℹ   +-- 2: wait/io/file	56671552746
ℹ   +-- 3: wait/lock/table	5303520
ℹ  Performance schema: Top 15 class events by max latency execution time: 0.202s
 
-------- Performance schema: Top 30 events by max latency ------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	68907554298
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	56671552746
ℹ   +-- 3: wait/io/file/innodb/innodb_temp_file	55894494150
ℹ   +-- 4: wait/io/file/innodb/innodb_dblwr_file	39089970000
ℹ   +-- 5: wait/io/file/innodb/innodb_data_file	25383956418
ℹ   +-- 6: wait/io/file/sql/binlog	16887608280
ℹ   +-- 7: wait/io/file/sql/io_cache	1932736320
ℹ   +-- 8: wait/io/file/sql/binlog_index	1276989480
ℹ   +-- 9: wait/io/file/sql/casetest	1172046600
ℹ   +-- 10: wait/io/file/sql/pid	202358520
ℹ   +-- 11: wait/io/file/sql/ERRMSG	142067520
ℹ   +-- 12: wait/io/file/mysys/charset	18572760
ℹ   +-- 13: wait/io/file/sql/misc	16108920
ℹ   +-- 14: wait/io/file/mysys/cnf	13530240
ℹ   +-- 15: wait/lock/table/sql/handler	5303520
ℹ  Performance schema: Top 30 events by max latency execution time: 0.186s
 
-------- 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.185s
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
ℹ  InnoDB is enabled.
ℹ  InnoDB Metrics execution time: 0.001s
 
-------- Smart Migration LTS Advisor ---------------------------------------------------------------
✘  Found 4 potential migration risks.
ℹ   - [Migration Risk] default_authentication_plugin: Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead.
ℹ   - [Migration Risk] binlog_transaction_dependency_tracking: Removed in MySQL 8.4.
ℹ   - [Migration Risk] avoid_temporal_upgrade: Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade.
ℹ   - [Migration Risk] expire_logs_days: Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
ℹ  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: 16.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 / 31.7M
ℹ  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% (20584866 hits / 20586374 total)
✔  InnoDB Write Log efficiency: 99.11% (8110785 hits / 8183644 total)
✔  InnoDB log waits: 0.00% (0 waits / 72859 writes)
ℹ  Smart Migration LTS Advisor execution time: 0.001s
 
-------- 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.185s
 
-------- 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.189s
 
-------- 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.5G (Theoretical max usage is 11.49% 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_dependency_tracking is set to COMMIT_ORDER (recommended: WRITESET for parallel throughput)
ℹ  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 enabled. Minimum supported TLS version: TLSv1.2,TLSv1.3
ℹ  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.181s
 
-------- Health Score KPI --------------------------------------------------------------------------
Overall Weighted Health Score: 80/100
    - Performance: 40/40
    - Security:    15/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)
    22 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.
    Migration Risk (default_authentication_plugin): Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead.
    Migration Risk (binlog_transaction_dependency_tracking): Removed in MySQL 8.4.
    Migration Risk (avoid_temporal_upgrade): Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade.
    Migration Risk (expire_logs_days): Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
    Set gtid_mode = ON to enable global transaction identifier replication.
    Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
    Set binlog_transaction_dependency_tracking = WRITESET to improve parallel replication throughput.
    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).
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)