MySQLTuner Audit Report

8.4.8 (MySQL Community Server - GPL) at 127.0.0.1:3306 • Tuner 2.9.0
Generated On
Sun Jul 5 17:37:03 2026
Overall Health Score

80 out of 100
Good Health
Category Scores

Performance 40 / 40
Security 15 / 30
Resilience 25 / 30
Sectional Indicators & KPIs Dashboard

Phase 13 Unified View
General Stats 40%
Storage & Perf 100%
Security 55%
Replication & HA 100%
SQL Modeling 0%
Resource Saturation Heatmap

CPU Load Saturation 100%
Memory Saturation 11%
Connections Saturation 0%
Disk I/O Pressure 0%
Throughput Efficiency Index

Logical Work 6.515 QPS
Buffer Logical Reads 691357.606/s
Efficiency Ratio Queries completed per logical page read
1e-05
Prioritized Executive Summary Findings

General Stats⚠️ Action Required

CriticalRemove unused indexes.
Critical20 CVE(s) found for your MySQL release. Consider upgrading your version !
CriticalUnused indexes found: 2 index(es) should be reviewed and potentially removed.
Storage & Performance⚠️ Action Required

FindingDON'T APPLY SETTINGS BECAUSE THERE ARE TOO MANY PROCESSES RUNNING ON THIS SERVER. OOM KILL CAN OCCUR!
Findingvm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness) or vm.swappiness=10 in /etc/sysctl.conf
Findingfs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr) or fs.aio-max-nr=1048576 in /etc/sysctl.conf
Security & Compliance⚠️ Action Required

FindingEnable require_secure_transport to force all connections to use SSL.
FindingEnforce SSL for remote users (ALTER USER ... REQUIRE SSL)
FindingEnable TLS/SSL for encrypted connections.
Replication & HA⚠️ Action Required

FindingIncrease binlog_cache_size (current value: 32768)
FindingSet gtid_mode = ON to enable global transaction identifier replication.
FindingSet enforce_gtid_consistency = ON to prevent unsafe replication operations.
SQL Modeling⚠️ Action Required

FindingTable employees.departments: Primary key 'dept_no' does not follow naming convention (id or departments_id)
FindingTable employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
FindingTable employees.dept_emp: Primary key 'dept_no' does not follow naming convention (id or dept_emp_id)
Full Console Output Trace

Show Logs
 >>  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:36:49
ℹ  Skipped version check for MySQLTuner script
ℹ  Performing tests on 127.0.0.1:3306
✔  Logged in using credentials passed on the command line
 
-------- Audit Snapshot Summary --------------------------------------------------------------------
ℹ  MySQLTuner Version : 2.9.0
ℹ  Audit Start Time   : 2026-07-05 17:36:49
ℹ  Server Connection  : 127.0.0.1:3306
ℹ  Database User      : root@%
ℹ  Database Version   : 8.4.8
ℹ  System Physical RAM: 15.3G
ℹ  System Swap Memory : 4.0G
ℹ  Database Uptime    : 33s
✔  Operating on 64-bit architecture
ℹ  Audit Snapshot Summary execution time: 0.207s
 
-------- 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.4.8(LTS)
ℹ  Storage Engine Statistics execution time: 0.212s
 
-------- System Linux Recommendations --------------------------------------------------------------
Look for related Linux system recommendations
ℹ  Ubuntu 24.04.4 LTS
ℹ  Machine type          : Virtual machine
ℹ  Internet              : Connected
ℹ  Number of Core CPU : 10
ℹ  Operating System Type : Linux
ℹ  Kernel Release        : 6.18.33.2-microsoft-standard-WSL2
ℹ  Hostname              : Ligthpath-Main
ℹ  Network Cards         : 
ℹ  	1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
ℹ  	    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
ℹ  	--
ℹ  	2: loopback0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
ℹ  	    link/ether 00:15:5d:44:c4:13 brd ff:ff:ff:ff:ff:ff
ℹ  	4: eth1: <BROADCAST,MULTICAST> mtu 1500 qdisc mq state DOWN group default qlen 1000
ℹ  	    link/ether 00:15:5d:30:a3:69 brd ff:ff:ff:ff:ff:ff
ℹ  	6: eth3: <BROADCAST,MULTICAST> mtu 1500 qdisc mq state DOWN group default qlen 1000
ℹ  	    link/ether 00:15:5d:3a:79:cc brd ff:ff:ff:ff:ff:ff
ℹ  	7: eth4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
ℹ  	    link/ether 7c:fa:80:ef:db:58 brd ff:ff:ff:ff:ff:ff
ℹ  	--
ℹ  	9: docker0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default 
ℹ  	    link/ether 6e:65:e9:4e:4f:c7 brd ff:ff:ff:ff:ff:ff
ℹ  	--
ℹ  	12: eth0: <BROADCAST,MULTICAST> mtu 1500 qdisc mq state DOWN group default qlen 1000
ℹ  	    link/ether 7e:fa:80:ef:db:58 brd ff:ff:ff:ff:ff:ff
ℹ  	13: eth2: <BROADCAST,MULTICAST> mtu 1500 qdisc mq state DOWN group default qlen 1000
ℹ  	    link/ether 00:e0:4c:36:0d:ee brd ff:ff:ff:ff:ff:ff
ℹ  	14: eth5: <BROADCAST,MULTICAST> mtu 1500 qdisc mq state DOWN group default qlen 1000
ℹ  	    link/ether 72:fa:80:ef:db:58 brd ff:ff:ff:ff:ff:ff
ℹ  	15: br-7d23bdfc02da: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default 
ℹ  	    link/ether 4a:16:44:36:33:d5 brd ff:ff:ff:ff:ff:ff
ℹ  	--
ℹ  	16: veth4b70d79@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-7d23bdfc02da state UP group default 
ℹ  	    link/ether 72:c3:b6:5b:27:ef brd ff:ff:ff:ff:ff:ff link-netnsid 0
ℹ  	17: veth1662833@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-7d23bdfc02da state UP group default 
ℹ  	    link/ether 7a:b5:d7:ee:83:f8 brd ff:ff:ff:ff:ff:ff link-netnsid 1
ℹ  Internal IP           : 192.168.1.148 172.17.0.1 172.18.0.1 2a01:e0a:ed9:46a0:4ef0:c96d:9db7:b542 2a01:e0a:ed9:46a0:ed9d:d8c:74df:2fd8 

ℹ  HTTP client found: /usr/bin/curl
ℹ  External IP           : 2a01:e0a:ed9:46a0:ed9d:d8c:74df:2fd8
ℹ  Name Servers          : 10.255.255.254
ℹ  Logged In users       : 
ℹ  	jmren    pts/1        2026-07-01 10:23
ℹ  Ram Usages in MB      : 
ℹ  	               total        used        free      shared  buff/cache   available
ℹ  	Mem:           15630        3679       10489           4        1705       11951
ℹ  	Swap:           4096           0        4096
ℹ  Load Average          : 
ℹ  	top - 17:36:50 up 4 days,  5:07,  1 user,  load average: 1.55, 0.51, 0.23
ℹ  System Uptime         : 
ℹ  	 17:36:48 up 4 days,  5:07,  1 user,  load average: 1.55, 0.51, 0.23
ℹ  Database Uptime       : 33s
✔  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 2G RAM.
✘  Other user process except mysqld used more than 15% of total physical memory 17.52% (2G / 15G)
ℹ  System Linux Recommendations execution time: -1.979s
 
-------- Filesystem Linux Recommendations ----------------------------------------------------------
ℹ  mount point /mnt/wsl is using 1 % total space (4.00 KB / 7.63 GB)
ℹ  mount point /usr/lib/wsl/drivers is using 76 % total space (718.30 GB / 951.65 GB)
ℹ  mount point / is using 14 % total space (131.82 GB / 1006.85 GB)
ℹ  mount point /mnt/wslg is using 1 % total space (124.00 KB / 7.63 GB)
ℹ  mount point /usr/lib/wsl/lib is using 0 % total space (0.00 bytes / 7.63 GB)
ℹ  mount point /mnt/wslg/versions.txt is using 1 % total space (104.00 KB / 7.63 GB)
ℹ  mount point /mnt/wslg/doc is using 1 % total space (104.00 KB / 7.63 GB)
ℹ  mount point /mnt/c is using 76 % total space (718.30 GB / 951.65 GB)
ℹ  mount point /usr/lib/modules/6.18.33.2-microsoft-standard-WSL2 is using 1 % of max allowed inodes
ℹ  mount point /mnt/wsl is using 1 % of max allowed inodes
ℹ  mount point / is using 3 % of max allowed inodes
ℹ  mount point /mnt/wslg is using 1 % of max allowed inodes
ℹ  mount point /usr/lib/wsl/lib is using 1 % of max allowed inodes
ℹ  mount point /init is using 1 % of max allowed inodes
ℹ  mount point /mnt/wslg/versions.txt is using 1 % of max allowed inodes
ℹ  mount point /mnt/wslg/doc is using 1 % of max allowed inodes
ℹ  Filesystem Linux Recommendations execution time: 0.036s
 
-------- Kernel Information Recommendations --------------------------------------------------------
ℹ  Information about kernel tuning:
ℹ  	fs.aio-max-nr = 65536
ℹ  	fs.aio-nr = 3841
ℹ  	fs.nr_open = 1048576
ℹ  	fs.file-max = 9223372036854775807
ℹ  	vm.swappiness = 60
✘  Swappiness is > 10, please consider having a value lower than 10
✘  Max running total of the number of max. events is < 1M, please consider having a value greater than 1M
ℹ  Max Number of open file requests is > 1M.
ℹ  Kernel Information Recommendations execution time: 0.091s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Performance Schema error_log table detected
ℹ  Performance Schema error_log: 10 entries detected
✔  performance_schema.error_log doesn't contain any warning.
✔  performance_schema.error_log doesn't contain any error.
ℹ  2 start(s) detected in performance_schema.error_log
ℹ  1) X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
ℹ  2) /usr/sbin/mysqld: ready for connections. Version: '8.4.8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
ℹ  0 shutdown(s) detected in performance_schema.error_log
ℹ  Log file Recommendations execution time: 0.075s
 
-------- Analysis Performance Metrics --------------------------------------------------------------
ℹ  innodb_stats_on_metadata: OFF
✔  No stat updates during querying INFORMATION_SCHEMA.
ℹ  Analysis Performance Metrics execution time: 0.000s
 
-------- Database Metrics --------------------------------------------------------------------------
ℹ  There is 1 Database(s).
ℹ  All User Databases:
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3916999
ℹ   +-- DATA  : 45.6M(89.16%)
ℹ   +-- INDEX : 5.5M(10.84%)
ℹ   +-- SIZE  : 51.2M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3916999
ℹ   +-- DATA  : 45.6M(89.16%)
ℹ   +-- INDEX : 5.5M(10.84%)
ℹ   +-- TOTAL : 51.2M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ   +-- ENGINE InnoDB : 6 TABLE(s)
✔  1 collation for employees database.
✔  1 engine for employees database.
ℹ  Charsets for employees database table column: utf8mb4
✔  employees table column(s) has same charset defined for all text like column(s).
ℹ  Collations for employees database table column: utf8mb4_0900_ai_ci
✔  employees table column(s) has same collation defined for all text like column(s).
ℹ  Database Metrics execution time: 0.659s
 
-------- Table Column Metrics ----------------------------------------------------------------------
ℹ  MySQL and Percona version 8.0 and greater have removed PROCEDURE ANALYSE feature
ℹ  Disabling colstat parameter
ℹ  Database: employees
ℹ   +-- TABLE: departments
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_name - Cols: dept_name - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: dept_no - Type: BTREE
ℹ       +-- Column departments.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column departments.dept_name: VARCHAR(40) NOT NULL
ℹ   +-- TABLE: dept_emp
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_no - Cols: dept_no - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE
ℹ       +-- Column dept_emp.emp_no: INT NOT NULL
ℹ       +-- Column dept_emp.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column dept_emp.from_date: DATE NOT NULL
ℹ       +-- Column dept_emp.to_date: DATE NOT NULL
ℹ   +-- TABLE: dept_manager
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index dept_no - Cols: dept_no - Type: BTREE
ℹ       +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE
ℹ       +-- Column dept_manager.emp_no: INT NOT NULL
ℹ       +-- Column dept_manager.dept_no: CHAR(4) NOT NULL
ℹ       +-- Column dept_manager.from_date: DATE NOT NULL
ℹ       +-- Column dept_manager.to_date: DATE NOT NULL
ℹ   +-- TABLE: employees
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no - Type: BTREE
ℹ       +-- Column employees.emp_no: INT NOT NULL
ℹ       +-- Column employees.birth_date: DATE NOT NULL
ℹ       +-- Column employees.first_name: VARCHAR(14) NOT NULL
ℹ       +-- Column employees.last_name: VARCHAR(16) NOT NULL
ℹ       +-- Column employees.gender: ENUM('M','F') NOT NULL
ℹ       +-- Column employees.hire_date: DATE NOT NULL
ℹ   +-- TABLE: salaries
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no,from_date - Type: BTREE
ℹ       +-- Column salaries.emp_no: INT NOT NULL
ℹ       +-- Column salaries.salary: INT NOT NULL
ℹ       +-- Column salaries.from_date: DATE NOT NULL
ℹ       +-- Column salaries.to_date: DATE NOT NULL
ℹ   +-- TABLE: titles
ℹ       +-- TYPE: InnoDB
ℹ       +-- Index PRIMARY - Cols: emp_no,title,from_date - Type: BTREE
ℹ       +-- Column titles.emp_no: INT NOT NULL
ℹ       +-- Column titles.title: VARCHAR(50) NOT NULL
ℹ       +-- Column titles.from_date: DATE NOT NULL
ℹ       +-- Column titles.to_date: DATE NULL
ℹ  Table Column Metrics execution time: 0.445s
 
-------- Table structures analysis -----------------------------------------------------------------
✔  All tables get a primary key
✘  Table employees.departments: Primary key 'dept_no' does not follow 'id' or 'departments_id' naming convention
✘  Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'dept_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'dept_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'emp_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.employees: Primary key 'emp_no' does not follow 'id' or 'employees_id' naming convention
✘  Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'from_date' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'title' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✔  All tables are InnoDB tables
✔  All columns are UTF-8 compliant
ℹ  Table structures analysis execution time: 0.291s
 
-------- Naming conventions analysis ---------------------------------------------------------------
✘  Table employees.departments: Plural name detected (prefer singular)
✘  Table employees.employees: Plural name detected (prefer singular)
✘  Table employees.salaries: Plural name detected (prefer singular)
✘  Table employees.titles: Plural name detected (prefer singular)
ℹ  Naming conventions analysis execution time: 0.121s
 
-------- 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.123s
 
-------- MySQL 8.0+ Specific Modeling --------------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MySQL 8.0+ Specific Modeling execution time: 0.092s
 
-------- Data Type optimization --------------------------------------------------------------------
✔  No data type optimization recommendations
ℹ  Data Type optimization execution time: 0.031s
 
-------- Schema sanitization -----------------------------------------------------------------------
✔  No empty or view-only schemas detected
ℹ  Schema sanitization execution time: 0.031s
 
-------- Indexes Metrics ---------------------------------------------------------------------------
ℹ  Worst selectivity indexes:
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 8 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  dept_no(dept_no) has a low selectivity
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: PRIMARY(from_date)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(from_date) has a low selectivity
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 9 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 37.50%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 298914 distinct values
ℹ   +-- NB ROWS     : 442486 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 67.55%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 299600 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 90.47%
ℹ  Index: PRIMARY(title)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 441713 distinct values
ℹ   +-- NB ROWS     : 442486 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 99.83%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 331143 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Indexes per database:
ℹ  Database: employees
ℹ   +-- INDEX      : departments.dept_name
ℹ   +-- COLUMNS    : dept_name
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : departments.PRIMARY
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_emp.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 8
ℹ   +-- INDEX      : dept_emp.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 630743
ℹ   +-- INDEX      : dept_manager.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_manager.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 48
ℹ   +-- INDEX      : employees.PRIMARY
ℹ   +-- COLUMNS    : emp_no
ℹ   +-- CARDINALITY: 299290
ℹ   +-- INDEX      : salaries.PRIMARY
ℹ   +-- COLUMNS    : emp_no,from_date
ℹ   +-- CARDINALITY: 2
ℹ   +-- INDEX      : titles.PRIMARY
ℹ   +-- COLUMNS    : emp_no,title,from_date
ℹ   +-- CARDINALITY: 1183113
ℹ  Unused indexes:
✘  Index: dept_name on employees.departments is not used.
✘  Index: dept_no on employees.dept_emp is not used.
✘  Index: dept_no on employees.dept_manager is not used.
ℹ  Indexes Metrics execution time: 0.321s
 
-------- Views Metrics -----------------------------------------------------------------------------
ℹ  Views Metrics execution time: 0.000s
 
-------- Triggers Metrics --------------------------------------------------------------------------
ℹ  Triggers Metrics execution time: 0.000s
 
-------- Routines Metrics --------------------------------------------------------------------------
ℹ  Routines Metrics execution time: 0.000s
 
-------- Security Recommendations ------------------------------------------------------------------
ℹ  MySQL Community Server - GPL - 8.4.8
✔  No Role user detected
✔  There are no anonymous accounts for any database users
✔  All database users have passwords assigned
✘  User 'root'@% does not specify hostname restrictions.
ℹ  There are 620 basic passwords in the list.
ℹ  Security Recommendations execution time: 9.305s
 
-------- Authentication Plugin Security ------------------------------------------------------------
✔  No users found using insecure or deprecated authentication plugins
ℹ  Authentication Plugin Security execution time: 0.031s
 
-------- SSL/TLS Security Recommendations ----------------------------------------------------------
✔  Current connection is encrypted (TLS_AES_256_GCM_SHA384)
✘  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.092s
 
-------- CVE Security Recommendations --------------------------------------------------------------
✘  CVE-2026-21998(<= 8.4.8) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

✘  20 CVE(s) found for your MySQL release.
ℹ  CVE Security Recommendations execution time: 0.006s
 
-------- Plugin Information ------------------------------------------------------------------------
ℹ  Plugin                         | Version    | Status     | Type                
ℹ  --------------------------------------------------------------------------------
ℹ  mysqlx_cache_cleaner           | 1.0        | ACTIVE     | AUDIT               
ℹ  sha2_cache_cleaner             | 1.0        | ACTIVE     | AUDIT               
ℹ  caching_sha2_password          | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  sha256_password                | 1.1        | ACTIVE     | AUTHENTICATION      
ℹ  daemon_keyring_proxy_plugin    | 1.0        | ACTIVE     | DAEMON              
ℹ  mysqlx                         | 1.0        | ACTIVE     | DAEMON              
ℹ  ngram                          | 0.1        | ACTIVE     | FTPARSER            
ℹ  ARCHIVE                        | 3.0        | ACTIVE     | STORAGE ENGINE      
ℹ  binlog                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  BLACKHOLE                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  CSV                            | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  InnoDB                         | 8.4        | ACTIVE     | STORAGE ENGINE      
ℹ  MEMORY                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MRG_MYISAM                     | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MyISAM                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  PERFORMANCE_SCHEMA             | 0.1        | ACTIVE     | STORAGE ENGINE      
ℹ  TempTable                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  Plugin Information execution time: 0.032s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 33s (215 q [6.515 qps], 20 conn, TX: 72K, RX: 164M)
ℹ  Reads / Writes: 8% / 92%
ℹ  Binary logging is enabled (GTID MODE: OFF)
ℹ  Physical Memory     : 15.3G
ℹ  Max MySQL memory    : 1.8G
ℹ  Other process memory: 2.7G
ℹ  Total buffers: 200.0M global + 1.0G temptable + 1.9M per thread (151 max threads)
ℹ  Performance_schema Max memory usage: 354M
ℹ  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: 572.5M (3.66% of installed RAM)
✔  Maximum possible memory usage: 1.8G (11.94% of installed RAM)
✔  Overall possible memory usage with other process is compatible with memory available
✔  Slow queries: 0% (0/215)
✔  Highest usage of available connections: 0% (1/151)
✔  Aborted connections: 0.00% (0/20)
ℹ  Query cache has been removed since MySQL 8.0
✔  Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
✘  Joins performed without indexes: 1
✔  Temporary tables created on disk: 0% (0 on disk / 4 total)
✔  Thread cache hit rate: 95% (1 created / 20 connections)
✔  Table cache hit rate: 95% (4K hits / 4K requests)
✔  table_definition_cache (2000) is greater than number of tables (338)
✔  Open file limit used: 0% (2/8K)
✔  Table locks acquired immediately: 100% (4 immediate / 4 locks)
✘  Binlog cache memory access: 6.21% (11 Memory / 177 Total)
ℹ  Performance Metrics execution time: 0.127s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 354.7M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 2.1.3
ℹ  Performance schema execution time: 0.091s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	415 conn(s)
ℹ   +-- 2: background	53 conn(s)
ℹ   +-- 3: event_scheduler	1 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.041s
 
-------- Performance schema: Top 5 user per statement ----------------------------------------------
ℹ   +-- 1: root	418 stmt(s)
ℹ   +-- 2: background	0 stmt(s)
ℹ   +-- 3: event_scheduler	0 stmt(s)
ℹ  Performance schema: Top 5 user per statement execution time: 0.034s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	65582726033.3333
ℹ   +-- 2: background	0.0000
ℹ   +-- 3: event_scheduler	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.037s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	1766000000
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.031s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	37
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.031s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	2595
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.030s
 
-------- 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.031s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: background	97361
ℹ   +-- 2: root	14284
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO execution time: 0.034s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: background	20642659834036
ℹ   +-- 2: root	3847884389922
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.033s
 
-------- Performance schema: Top 5 host per connection ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	424 conn(s)
ℹ   +-- 2: localhost	1 conn(s)
ℹ  Performance schema: Top 5 host per connection execution time: 0.041s
 
-------- Performance schema: Top 5 host per statement ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	436 stmt(s)
ℹ   +-- 2: localhost	0 stmt(s)
ℹ  Performance schema: Top 5 host per statement execution time: 0.034s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	62965842575.3425
ℹ   +-- 2: localhost	NULL
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.034s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	1803000000
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.029s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	46
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.033s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	2619
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.032s
 
-------- Performance schema: Top 5 host per rows modified ------------------------------------------
ℹ   +-- 1: 172.18.0.2	3919016
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per rows modified execution time: 0.031s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	14285
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per io execution time: 0.033s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	3853083868282
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per io latency execution time: 0.034s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	83131 i/o
ℹ   +-- 2: innodb/innodb_data_file	14875 i/o
ℹ   +-- 3: sql/binlog	8838 i/o
ℹ   +-- 4: sql/io_cache	4529 i/o
ℹ   +-- 5: innodb/innodb_dblwr_file	138 i/o
ℹ   +-- 6: innodb/innodb_temp_file	57 i/o
ℹ   +-- 7: sql/binlog_index	41 i/o
ℹ   +-- 8: sql/casetest	15 i/o
ℹ   +-- 9: sql/misc	6 i/o
ℹ   +-- 10: sql/ERRMSG	5 i/o
ℹ   +-- 11: mysys/cnf	5 i/o
ℹ   +-- 12: sql/pid	3 i/o
ℹ   +-- 13: mysys/charset	3 i/o
ℹ  Performance schema: Top IO type order by total io execution time: 0.034s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	18390010514712
ℹ   +-- 2: innodb/innodb_data_file	4220143119332
ℹ   +-- 3: sql/binlog	1255920322368
ℹ   +-- 4: innodb/innodb_dblwr_file	288660923292
ℹ   +-- 5: sql/io_cache	161513691286
ℹ   +-- 6: innodb/innodb_temp_file	124803578772
ℹ   +-- 7: sql/binlog_index	52088172488
ℹ   +-- 8: sql/casetest	1353455240
ℹ   +-- 9: sql/pid	816198228
ℹ   +-- 10: sql/ERRMSG	321020840
ℹ   +-- 11: mysys/cnf	43455760
ℹ   +-- 12: mysys/charset	34868760
ℹ   +-- 13: sql/misc	34381240
ℹ  Performance schema: Top IO type order by total latency execution time: 0.030s
 
-------- Performance schema: Top IO type order by max latency --------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	202802479732
ℹ   +-- 2: sql/io_cache	61534929520
ℹ   +-- 3: sql/binlog_index	49806600494
ℹ   +-- 4: sql/binlog	44984257080
ℹ   +-- 5: innodb/innodb_data_file	34658638326
ℹ   +-- 6: innodb/innodb_dblwr_file	24087720006
ℹ   +-- 7: innodb/innodb_temp_file	23072105600
ℹ   +-- 8: sql/casetest	1208207520
ℹ   +-- 9: sql/pid	742125658
ℹ   +-- 10: sql/ERRMSG	275227200
ℹ   +-- 11: mysys/cnf	28242920
ℹ   +-- 12: mysys/charset	19534040
ℹ   +-- 13: sql/misc	8797520
ℹ  Performance schema: Top IO type order by max latency execution time: 0.032s
 
-------- 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.038s
 
-------- Performance schema: Top Stages order by total latency -------------------------------------
ℹ   +-- 1: innodb/buffer pool load	77063895000
ℹ  Performance schema: Top Stages order by total latency execution time: 0.032s
 
-------- Performance schema: Top Stages order by avg latency ---------------------------------------
ℹ   +-- 1: innodb/buffer pool load	77063895000
ℹ  Performance schema: Top Stages order by avg latency execution time: 0.031s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	57
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per table scans execution time: 0.032s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	109510656	100033725	6684 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.086s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	99713024	91106864	6086 page(s)
ℹ   +-- 2: employees	employees	7208960	6609613	440 page(s)
ℹ   +-- 3: employees	titles	2555904	2316735	156 page(s)
ℹ   +-- 4: employees	departments	32768	513	2 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.110s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: innodb/page_flush_coordinator_thread	NULL	45
ℹ   +-- 2: innodb/srv_worker_thread	NULL	44
ℹ   +-- 3: sql/compress_gtid_table	Daemon	44
ℹ   +-- 4: sql/main	NULL	44
ℹ   +-- 5: sql/event_scheduler	Daemon	44
ℹ   +-- 6: innodb/srv_worker_thread	NULL	44
ℹ   +-- 7: innodb/srv_worker_thread	NULL	44
ℹ   +-- 8: innodb/srv_purge_thread	NULL	44
ℹ   +-- 9: innodb/clone_gtid_thread	NULL	44
ℹ   +-- 10: innodb/srv_master_thread	NULL	44
ℹ   +-- 11: innodb/dict_stats_thread	NULL	44
ℹ   +-- 12: innodb/fts_optimize_thread	NULL	44
ℹ   +-- 13: root@172.18.0.2	Query	0
ℹ   +-- 14: innodb/io_read_thread	NULL	NULL
ℹ   +-- 15: innodb/log_writer_thread	NULL	NULL
ℹ   +-- 16: innodb/io_read_thread	NULL	NULL
ℹ   +-- 17: innodb/io_read_thread	NULL	NULL
ℹ   +-- 18: innodb/io_read_thread	NULL	NULL
ℹ   +-- 19: innodb/io_read_thread	NULL	NULL
ℹ   +-- 20: innodb/io_read_thread	NULL	NULL
ℹ   +-- 21: innodb/srv_lock_timeout_thread	NULL	NULL
ℹ   +-- 22: innodb/io_write_thread	NULL	NULL
ℹ   +-- 23: innodb/io_write_thread	NULL	NULL
ℹ   +-- 24: innodb/io_write_thread	NULL	NULL
ℹ   +-- 25: innodb/io_write_thread	NULL	NULL
ℹ   +-- 26: innodb/log_checkpointer_thread	NULL	NULL
ℹ   +-- 27: innodb/log_flush_notifier_thread	NULL	NULL
ℹ   +-- 28: innodb/log_flusher_thread	NULL	NULL
ℹ   +-- 29: innodb/log_write_notifier_thread	NULL	NULL
ℹ   +-- 30: innodb/io_read_thread	NULL	NULL
ℹ   +-- 31: innodb/io_read_thread	NULL	NULL
ℹ   +-- 32: innodb/io_read_thread	NULL	NULL
ℹ   +-- 33: innodb/io_ibuf_thread	NULL	NULL
ℹ   +-- 34: innodb/io_read_thread	NULL	NULL
ℹ   +-- 35: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 36: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 37: sql/signal_handler	NULL	NULL
ℹ   +-- 38: innodb/buf_dump_thread	NULL	NULL
ℹ   +-- 39: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 40: mysqlx/worker	NULL	NULL
ℹ   +-- 41: mysqlx/worker	NULL	NULL
ℹ   +-- 42: innodb/log_files_governor_thread	NULL	NULL
ℹ   +-- 43: innodb/buf_resize_thread	NULL	NULL
ℹ   +-- 44: innodb/srv_monitor_thread	NULL	NULL
ℹ   +-- 45: innodb/srv_error_monitor_thread	NULL	NULL
ℹ  Performance schema: Process per time execution time: 0.049s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.042s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: log_flusher_thread	16027301650182	202802479732
ℹ   +-- 2: log_writer_thread	1563210168770	73582158120
ℹ   +-- 3: log_files_governor_thread	547571191762	10841625434
ℹ   +-- 4: page_flush_coordinator_thread	440261601174	24087720006
ℹ   +-- 5: io_write_thread	414522715192	12231013668
ℹ   +-- 6: io_write_thread	268085208172	18729289074
ℹ   +-- 7: io_write_thread	251158238434	9989872040
ℹ   +-- 8: io_write_thread	250993508196	17548022574
ℹ   +-- 9: log_checkpointer_thread	100130000442	28582816728
ℹ   +-- 10: main	79770628416	49806600494
ℹ   +-- 11: buf_dump_thread	72268067904	1510525320
ℹ   +-- 12: dict_stats_thread	21076785960	5204220600
ℹ   +-- 13: clone_gtid_thread	794365642	498551802
ℹ  Performance schema: Thread IO Latency execution time: 0.033s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */	244860545000
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */	169618609000
ℹ   +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */	151677769000
ℹ   +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */	139758021000
ℹ   +-- 5: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 6: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 7: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 8: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ   +-- 9: CREATE TABLE `titles` ( `emp_no` INTEGER NOT NULL , `title` VARCHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to_	43256486000
ℹ   +-- 10: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	41136018000
ℹ   +-- 11: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	39177453000
ℹ   +-- 12: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	38483232000
ℹ   +-- 13: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	31837944000
ℹ   +-- 14: SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO	28778595000
ℹ   +-- 15: SELECT `timediff` ( ( SELECT `update_time` FROM `information_schema` . `tables` WHERE `table_schema` = ? AND TABLE_NAME 	28345768000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.044s
 
-------- 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: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	1 s
ℹ   +-- 6: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	1 s
ℹ   +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	1 s
ℹ  Performance schema: Top 15 slower queries execution time: 0.037s
 
-------- Performance schema: Top 15 nb statement type ----------------------------------------------
ℹ   +-- 1: insert	168
ℹ   +-- 2: Quit	143
ℹ   +-- 3: select	140
ℹ   +-- 4: Init DB	7
ℹ   +-- 5: create_table	6
ℹ   +-- 6: show_engine_status	6
ℹ   +-- 7: show_databases	3
ℹ   +-- 8: show_status	3
ℹ   +-- 9: show_variables	2
ℹ   +-- 10: create_view	2
ℹ   +-- 11: truncate	1
ℹ   +-- 12: Ping	1
ℹ   +-- 13: show_grants	1
ℹ   +-- 14: set_option	1
ℹ   +-- 15: create_db	1
ℹ  Performance schema: Top 15 nb statement type execution time: 0.032s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	26668268176000
ℹ   +-- 2: select	793016277000
ℹ   +-- 3: create_table	255050377000
ℹ   +-- 4: create_view	19399330000
ℹ   +-- 5: show_variables	15347947000
ℹ   +-- 6: flush	14911736000
ℹ   +-- 7: show_databases	11275455000
ℹ   +-- 8: create_db	7345983000
ℹ   +-- 9: drop_db	5820449000
ℹ   +-- 10: drop_table	4925669000
ℹ   +-- 11: show_status	4015393000
ℹ   +-- 12: truncate	2352309000
ℹ   +-- 13: show_engine_status	1530914000
ℹ   +-- 14: Quit	1134586000
ℹ   +-- 15: Init DB	1085577000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.032s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: insert	1042000000
ℹ   +-- 2: select	687000000
ℹ   +-- 3: create_table	118000000
ℹ   +-- 4: create_view	16000000
ℹ   +-- 5: show_variables	15000000
ℹ   +-- 6: drop_table	14000000
ℹ   +-- 7: show_databases	14000000
ℹ   +-- 8: show_status	12000000
ℹ   +-- 9: truncate	11000000
ℹ   +-- 10: Init DB	4000000
ℹ   +-- 11: create_db	3000000
ℹ   +-- 12: drop_db	2000000
ℹ   +-- 13: show_storage_engines	1000000
ℹ   +-- 14: Ping	0
ℹ   +-- 15: show_grants	0
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.033s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	59
ℹ   +-- 2: show_databases	3
ℹ   +-- 3: show_status	3
ℹ   +-- 4: show_variables	2
ℹ   +-- 5: show_storage_engines	1
ℹ   +-- 6: create_table	0
ℹ   +-- 7: insert	0
ℹ   +-- 8: truncate	0
ℹ   +-- 9: drop_table	0
ℹ   +-- 10: show_engine_status	0
ℹ   +-- 11: show_replica_status	0
ℹ   +-- 12: show_grants	0
ℹ   +-- 13: set_option	0
ℹ   +-- 14: create_db	0
ℹ   +-- 15: drop_db	0
ℹ  Performance schema: Top 15 statement by full scans execution time: 0.031s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: show_variables	1268
ℹ   +-- 2: show_status	997
ℹ   +-- 3: select	537
ℹ   +-- 4: show_databases	15
ℹ   +-- 5: show_storage_engines	11
ℹ   +-- 6: create_table	0
ℹ   +-- 7: insert	0
ℹ   +-- 8: truncate	0
ℹ   +-- 9: drop_table	0
ℹ   +-- 10: show_engine_status	0
ℹ   +-- 11: show_replica_status	0
ℹ   +-- 12: show_grants	0
ℹ   +-- 13: set_option	0
ℹ   +-- 14: create_db	0
ℹ   +-- 15: drop_db	0
ℹ  Performance schema: Top 15 statement by rows sent execution time: 0.034s
 
-------- Performance schema: Top 15 statement by rows modified -------------------------------------
ℹ   +-- 1: insert	3919015
ℹ   +-- 2: create_db	1
ℹ   +-- 3: select	0
ℹ   +-- 4: create_table	0
ℹ   +-- 5: truncate	0
ℹ   +-- 6: drop_table	0
ℹ   +-- 7: show_databases	0
ℹ   +-- 8: show_variables	0
ℹ   +-- 9: show_status	0
ℹ   +-- 10: show_engine_status	0
ℹ   +-- 11: show_replica_status	0
ℹ   +-- 12: show_grants	0
ℹ   +-- 13: set_option	0
ℹ   +-- 14: drop_db	0
ℹ   +-- 15: flush	0
ℹ  Performance schema: Top 15 statement by rows modified execution time: 0.034s
 
-------- 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 SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?
ℹ   +-- 6: SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?
ℹ   +-- 7: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?
ℹ   +-- 8: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?
ℹ   +-- 9: SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?
ℹ   +-- 10: SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?
ℹ   +-- 11: SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?
ℹ   +-- 12: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?
ℹ   +-- 13: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?
ℹ   +-- 14: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?
ℹ   +-- 15: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?
ℹ  Performance schema: 15 sample queries using temp table execution time: 0.034s
 
-------- 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.041s
 
-------- Performance schema: Tables with full table scans ------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Tables with full table scans execution time: 0.033s
 
-------- Performance schema: Latest File IO by latency ---------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Latest File IO by latency execution time: 0.035s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_1.dblwr	12582912
ℹ   +-- 2: /var/lib/mysql/mysql.ibd	9256960
ℹ   +-- 3: /var/lib/mysql/undo_001	7389184
ℹ   +-- 4: /var/lib/mysql/undo_002	6389760
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	4636672
ℹ   +-- 6: /var/lib/mysql/#ib_16384_0.dblwr	4194304
ℹ   +-- 7: /var/lib/mysql/binlog.000001	3006135
ℹ   +-- 8: /var/lib/mysql/employees/titles.ibd	786432
ℹ   +-- 9: /usr/share/mysql-8.4/english/errmsg.sys	411166
ℹ   +-- 10: /var/lib/mysql/ibdata1	229376
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	68096
ℹ   +-- 12: /usr/share/mysql-8.4/charsets/Index.xml	19525
ℹ   +-- 13: /var/lib/mysql/sys/sys_config.ibd	16384
ℹ   +-- 14: /var/lib/mysql/#innodb_temp/temp_10.ibt	16384
ℹ   +-- 15: /var/lib/mysql/auto.cnf	56
ℹ  Performance schema: File by IO read bytes execution time: 0.033s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	210354176
ℹ   +-- 2: /var/lib/mysql/#ib_16384_0.dblwr	195592192
ℹ   +-- 3: /var/lib/mysql/binlog.000003	66378597
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	48283648
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	44466176
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	37896192
ℹ   +-- 7: /var/lib/mysql/undo_001	19382272
ℹ   +-- 8: /var/lib/mysql/undo_002	19169280
ℹ   +-- 9: /var/lib/mysql/ibtmp1	14729216
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo82	12228608
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo88	12068352
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo84	12021760
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo87	11993088
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo86	11984384
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo89	11939840
ℹ  Performance schema: File by IO written bytes execution time: 0.031s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/binlog.000003	1211471136216
ℹ   +-- 2: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	927417560018
ℹ   +-- 3: /var/lib/mysql/#innodb_redo/#ib_redo82	816130453856
ℹ   +-- 4: /var/lib/mysql/employees/salaries.ibd	813363981174
ℹ   +-- 5: /var/lib/mysql/#innodb_redo/#ib_redo84	810846578028
ℹ   +-- 6: /var/lib/mysql/undo_002	807883232582
ℹ   +-- 7: /var/lib/mysql/#innodb_redo/#ib_redo91	717257325956
ℹ   +-- 8: /var/lib/mysql/undo_001	715243017966
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo90	626818496820
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo86	625207727970
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo87	624673762826
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo88	621280146078
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo89	620844998468
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo103	600638948712
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo83	595788272630
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo93	571625695590
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo96	566587778588
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo101	560295631624
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo99	541118999738
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo85	540982870858
ℹ  Performance schema: File per IO total latency execution time: 0.032s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/undo_002	547892793194
ℹ   +-- 2: /var/lib/mysql/undo_001	479470889126
ℹ   +-- 3: /var/lib/mysql/mysql.ibd	405707515944
ℹ   +-- 4: /var/lib/mysql/ibdata1	39029278948
ℹ   +-- 5: /var/lib/mysql/#innodb_temp/temp_10.ibt	23072105600
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	19230167122
ℹ   +-- 7: /var/lib/mysql/employees/titles.ibd	15181262000
ℹ   +-- 8: /var/lib/mysql/#ib_16384_1.dblwr	5749932760
ℹ   +-- 9: /var/lib/mysql/#ib_16384_0.dblwr	4122207632
ℹ   +-- 10: /var/lib/mysql/sys/sys_config.ibd	1151732760
ℹ   +-- 11: /var/lib/mysql/binlog.000001	474157520
ℹ   +-- 12: /usr/share/mysql-8.4/english/errmsg.sys	294716920
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	106977400
ℹ   +-- 14: /var/lib/mysql/binlog.index	25450760
ℹ   +-- 15: /usr/share/mysql-8.4/charsets/Index.xml	11290520
ℹ   +-- 16: /var/lib/mysql/auto.cnf	9395840
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo108_tmp	0
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	0
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo106_tmp	0
ℹ   +-- 20: /var/lib/mysql/#innodb_temp/temp_1.ibt	0
ℹ  Performance schema: file per IO read latency execution time: 0.037s
 
-------- Performance schema: file per IO write latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_0.dblwr	275534088300
ℹ   +-- 2: /var/lib/mysql/employees/salaries.ibd	127648567104
ℹ   +-- 3: /var/lib/mysql/binlog.000003	102571713892
ℹ   +-- 4: /var/lib/mysql/#innodb_redo/#ib_redo84	89624302326
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	65566285584
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	58857561644
ℹ   +-- 7: /var/lib/mysql/employees/titles.ibd	47735647666
ℹ   +-- 8: /var/lib/mysql/#innodb_redo/#ib_redo82	24157617632
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	23897091930
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo101	21612006468
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo106_tmp	21319160406
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo89	21143669272
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo88	20929028620
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo91	20491753096
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo85	19942177340
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo87	19925569528
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo80	18870916404
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	18824096756
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo81	18546335006
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo97	18526888498
ℹ  Performance schema: file per IO write latency execution time: 0.040s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	114693209
ℹ   +-- 2: innodb/innodb_data_file	28704768
ℹ   +-- 3: innodb/innodb_dblwr_file	16777216
ℹ   +-- 4: sql/binlog	3006135
ℹ   +-- 5: sql/ERRMSG	411166
ℹ   +-- 6: innodb/innodb_log_file	68096
ℹ   +-- 7: mysys/charset	19525
ℹ   +-- 8: innodb/innodb_temp_file	16384
ℹ   +-- 9: sql/binlog_index	176
ℹ   +-- 10: mysys/cnf	56
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: Event Wait by read bytes execution time: 0.037s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	398213120
ℹ   +-- 2: innodb/innodb_log_file	366491648
ℹ   +-- 3: innodb/innodb_dblwr_file	195788800
ℹ   +-- 4: sql/io_cache	110499242
ℹ   +-- 5: sql/binlog	66383264
ℹ   +-- 6: innodb/innodb_temp_file	786432
ℹ   +-- 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.033s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	18390010514712
ℹ   +-- 2: innodb/innodb_data_file	4240546783104
ℹ   +-- 3: sql/binlog	1255920322368
ℹ   +-- 4: innodb/innodb_dblwr_file	288660923292
ℹ   +-- 5: sql/io_cache	207846628126
ℹ   +-- 6: innodb/innodb_temp_file	156666443910
ℹ   +-- 7: sql/binlog_index	52088172488
ℹ   +-- 8: sql/casetest	1353455240
ℹ   +-- 9: sql/pid	816198228
ℹ   +-- 10: sql/ERRMSG	321020840
ℹ   +-- 11: mysys/cnf	43455760
ℹ   +-- 12: mysys/charset	34868760
ℹ   +-- 13: sql/misc	34381240
ℹ  Performance schema: event per wait total latency execution time: 0.037s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	1507663639094
ℹ   +-- 2: innodb/innodb_temp_file	23072105600
ℹ   +-- 3: sql/io_cache	12040824360
ℹ   +-- 4: innodb/innodb_dblwr_file	9872140392
ℹ   +-- 5: sql/binlog	474157520
ℹ   +-- 6: sql/ERRMSG	294716920
ℹ   +-- 7: innodb/innodb_log_file	106977400
ℹ   +-- 8: sql/binlog_index	67842840
ℹ   +-- 9: mysys/charset	11290520
ℹ   +-- 10: mysys/cnf	9395840
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: event per wait read latency execution time: 0.035s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	644174199956
ℹ   +-- 2: innodb/innodb_data_file	346479686184
ℹ   +-- 3: innodb/innodb_dblwr_file	278700608260
ℹ   +-- 4: sql/io_cache	190951013126
ℹ   +-- 5: sql/binlog	102810277372
ℹ   +-- 6: innodb/innodb_temp_file	20733866054
ℹ   +-- 7: sql/pid	61718370
ℹ   +-- 8: sql/binlog_index	0
ℹ   +-- 9: sql/casetest	0
ℹ   +-- 10: sql/ERRMSG	0
ℹ   +-- 11: sql/misc	0
ℹ   +-- 12: mysys/charset	0
ℹ   +-- 13: mysys/cnf	0
ℹ  Performance schema: event per wait write latency execution time: 0.035s
 
-------- 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.033s
 
-------- 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.032s
 
-------- 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.032s
 
-------- 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.032s
 
-------- 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.032s
 
-------- 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.032s
 
-------- 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.035s
 
-------- 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.032s
 
-------- 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.034s
 
-------- Performance schema: Top 15 high insert latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	6871943363492
ℹ   +-- 2: employees	dept_emp	1939481683610
ℹ   +-- 3: employees	titles	1454611607434
ℹ   +-- 4: employees	employees	749320210578
ℹ   +-- 5: employees	dept_manager	159330400
ℹ   +-- 6: employees	departments	88263280
ℹ  Performance schema: Top 15 high insert latency tables execution time: 0.036s
 
-------- 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.034s
 
-------- 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.033s
 
-------- Performance schema: Redundant indexes -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Redundant indexes execution time: 0.034s
 
-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
ℹ   +-- 1: employees	dept_emp
ℹ   +-- 2: employees	dept_manager
ℹ  Performance schema: Table not using InnoDB buffer execution time: 0.106s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	99713024
ℹ   +-- 2: employees	employees	7208960
ℹ   +-- 3: employees	titles	2555904
ℹ   +-- 4: employees	departments	32768
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.089s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	8606160
ℹ   +-- 2: employees	employees	599347
ℹ   +-- 3: employees	titles	239169
ℹ   +-- 4: employees	departments	32255
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.083s
 
-------- Performance schema: Top 15 Most executed queries ------------------------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	114
ℹ   +-- 2: NULL	SELECT SCHEMA ( )	31
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */	21
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	17
ℹ   +-- 5: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	14
ℹ   +-- 6: employees	SELECT ? AS ?	7
ℹ   +-- 7: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 8: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 9: NULL	SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS	6
ℹ   +-- 10: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ?	3
ℹ   +-- 11: NULL	SHOW SCHEMAS	3
ℹ   +-- 12: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2
ℹ   +-- 13: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...)	2
ℹ   +-- 14: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	2
ℹ   +-- 15: NULL	SELECT `VERSION` ( )	2
ℹ  Performance schema: Top 15 Most executed queries execution time: 0.034s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees`	2026-07-05 15:36:20.555047
ℹ   +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments`	2026-07-05 15:36:20.573867
ℹ   +-- 3: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.524042
ℹ   +-- 4: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.558403
ℹ   +-- 5: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.592450
ℹ   +-- 6: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.750982
ℹ   +-- 7: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.784323
ℹ   +-- 8: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:37:01.016047
ℹ  Performance schema: Latest SQL queries in errors or warnings execution time: 0.032s
 
-------- Performance schema: Top 20 queries with full table scans ----------------------------------
ℹ   +-- 1: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	1
ℹ   +-- 2: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	1
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	1
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	1
ℹ   +-- 5: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	1
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	1
ℹ   +-- 7: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	1
ℹ   +-- 8: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `IS_VISIBLE` = ? AND `T	1
ℹ   +-- 9: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	1
ℹ   +-- 10: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	1
ℹ   +-- 11: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO	1
ℹ   +-- 12: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	1
ℹ   +-- 13: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	1
ℹ   +-- 14: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 15: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 16: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...)	1
ℹ   +-- 17: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	1
ℹ   +-- 18: NULL	SELECT COUNT ( * ) FROM `performance_schema` . `error_log`	1
ℹ   +-- 19: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	1
ℹ   +-- 20: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
ℹ  Performance schema: Top 20 queries with full table scans execution time: 0.034s
 
-------- 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:37:02.915021
ℹ   +-- 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:37:02.881200
ℹ   +-- 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:37:02.849720
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:37:02.814352
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:37:02.731801
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:37:02.642079
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:37:02.537641
ℹ   +-- 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:37:01.999667
ℹ   +-- 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:37:01.966401
ℹ   +-- 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:37:01.853203
ℹ   +-- 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:37:01.820170
ℹ   +-- 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:37:01.789466
ℹ   +-- 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:37:01.721953
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:37:01.688737
ℹ   +-- 15: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:37:01.417283
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:37:01.379987
ℹ   +-- 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:37:01.336123
ℹ   +-- 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:37:01.302766
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:37:01.260671
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:37:01.211190
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:37:01.101175
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:37:01.016047
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:37:00.849742
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.784323
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.750982
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:37:00.718355
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.686800
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.654557
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:37:00.622206
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.592450
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.558403
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.524042
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.483621
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.450850
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:37:00.417032
ℹ   +-- 36: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.386026
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.355771
ℹ   +-- 38: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:37:00.325048
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.293214
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.257201
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.221189
ℹ   +-- 42: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:36:59.963893
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:36:59.833834
ℹ   +-- 44: NULL	SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:36:50.841048
ℹ   +-- 45: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:36:50.688830
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2026-07-05 15:36:50.633394
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:36:50.497773
ℹ   +-- 48: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:36:50.414764
ℹ   +-- 49: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:36:50.333005
ℹ   +-- 50: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	2026-07-05 15:36:50.160455
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.032s
 
-------- 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	10
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	4
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	4
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2
ℹ   +-- 5: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	0
ℹ   +-- 6: employees	INSERT INTO `employees` VALUES (...) /* , ... */	0
ℹ   +-- 7: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	0
ℹ   +-- 8: employees	INSERT INTO `titles` VALUES (...) /* , ... */	0
ℹ   +-- 9: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	0
ℹ  Performance schema: Top 15 reader queries (95% percentile) execution time: 0.040s
 
-------- 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	137
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	8
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	8
ℹ   +-- 4: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2
ℹ   +-- 6: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	0
ℹ   +-- 7: employees	INSERT INTO `employees` VALUES (...) /* , ... */	0
ℹ   +-- 8: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	0
ℹ   +-- 9: employees	INSERT INTO `titles` VALUES (...) /* , ... */	0
ℹ   +-- 10: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	0
ℹ  Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.042s
 
-------- Performance schema: Top 15 total latency queries (95% percentile) -------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	17291265685000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	3561990789000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	3428047632000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	2375886368000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 6: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 8: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.042s
 
-------- Performance schema: Top 15 max latency queries (95% percentile) ---------------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	540283574000
ℹ   +-- 2: employees	INSERT INTO `employees` VALUES (...) /* , ... */	384784424000
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */	354934076000
ℹ   +-- 4: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	347318466000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 6: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 8: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.041s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	244860545000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	169618609000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	151677769000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	139758021000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 6: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 8: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	61159244000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.040s
 
-------- 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	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SHOW SCHEMAS	3
ℹ   +-- 4: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	1
ℹ   +-- 5: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	1
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	1
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	1
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	1
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	1
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	1
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	1
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	1
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	1
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	1
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	1
ℹ   +-- 16: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	1
ℹ   +-- 17: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	1
ℹ   +-- 18: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	1
ℹ   +-- 19: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	1
ℹ   +-- 20: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	1
ℹ  Performance schema: Top 20 queries with sort execution time: 0.032s
 
-------- 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:37:03.184619
ℹ   +-- 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:37:02.947425
ℹ   +-- 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:37:02.915021
ℹ   +-- 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:37:02.881200
ℹ   +-- 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:37:02.849720
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:37:02.814352
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:37:02.731801
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:37:02.642079
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:37:02.537641
ℹ   +-- 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:37:01.999667
ℹ   +-- 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:37:01.966401
ℹ   +-- 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:37:01.853203
ℹ   +-- 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:37:01.820170
ℹ   +-- 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:37:01.789466
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:37:01.688737
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:37:01.417283
ℹ   +-- 17: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:37:01.379987
ℹ   +-- 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:37:01.336123
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:37:01.260671
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:37:01.211190
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:37:01.101175
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:37:01.016047
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:37:00.849742
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.784323
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.750982
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:37:00.718355
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.686800
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.654557
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:37:00.622206
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.592450
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.558403
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.524042
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.483621
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.450850
ℹ   +-- 35: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:37:00.417032
ℹ   +-- 36: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.386026
ℹ   +-- 37: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.355771
ℹ   +-- 38: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:37:00.325048
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.293214
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.257201
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.221189
ℹ   +-- 42: NULL	SHOW SCHEMAS	2026-07-05 15:37:00.150847
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:36:59.963893
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:36:50.497773
ℹ   +-- 45: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:36:50.414764
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:36:50.333005
ℹ   +-- 47: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2026-07-05 15:36:50.064560
ℹ   +-- 48: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2026-07-05 15:36:49.979622
ℹ   +-- 49: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:36:49.488301
ℹ   +-- 50: 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:36:49.457412
ℹ  Performance schema: Last 50 queries with sort execution time: 0.031s
 
-------- Performance schema: Top 15 row sorting queries with sort ----------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	6905
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	6905
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	6899
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	6692
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	6686
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	135
ℹ   +-- 7: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	50
ℹ   +-- 8: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT	50
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	28
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	26
ℹ   +-- 11: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 12: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	20
ℹ   +-- 13: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	20
ℹ   +-- 14: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	20
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	18
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.032s
 
-------- Performance schema: Top 15 total latency queries with sort --------------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	51122709000
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	22385788000
ℹ   +-- 8: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	22129761000
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	20740784000
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	18432196000
ℹ   +-- 11: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	13065815000
ℹ   +-- 12: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	11316106000
ℹ   +-- 13: NULL	SHOW SCHEMAS	11275455000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	10186334000
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	9718246000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.033s
 
-------- 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	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 merge queries with sort execution time: 0.034s
 
-------- 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.030s
 
-------- 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	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	6
ℹ   +-- 4: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	6
ℹ   +-- 5: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	6
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	6
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	6
ℹ   +-- 8: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	5
ℹ   +-- 9: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	5
ℹ   +-- 10: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	5
ℹ   +-- 11: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	5
ℹ   +-- 12: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	5
ℹ   +-- 13: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	5
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	4
ℹ   +-- 15: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	4
ℹ  Performance schema: Top 15 scans queries with sort execution time: 0.034s
 
-------- 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.032s
 
-------- 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	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2
ℹ   +-- 4: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2
ℹ   +-- 5: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	1
ℹ   +-- 7: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 8: NULL	SELECT `TABLE_SCHEMA` , SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `I	1
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	1
ℹ   +-- 10: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	1
ℹ   +-- 11: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	1
ℹ   +-- 12: NULL	SHOW VARIABLES	1
ℹ   +-- 13: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	1
ℹ   +-- 14: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	1
ℹ   +-- 15: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
ℹ   +-- 16: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	1
ℹ   +-- 17: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	1
ℹ   +-- 18: NULL	SHOW ENGINES	1
ℹ   +-- 19: NULL	SHOW GLOBAL STATUS	1
ℹ   +-- 20: NULL	SHOW STATUS	1
ℹ  Performance schema: Top 20 queries with temp table execution time: 0.031s
 
-------- 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:37:02.814352
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:37:02.731801
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:37:02.642079
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:37:02.537641
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:37:01.417283
ℹ   +-- 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:37:01.336123
ℹ   +-- 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:37:01.302766
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:37:01.260671
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:37:01.211190
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:37:01.101175
ℹ   +-- 11: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:37:01.016047
ℹ   +-- 12: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:37:00.849742
ℹ   +-- 13: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.784323
ℹ   +-- 14: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.750982
ℹ   +-- 15: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:37:00.718355
ℹ   +-- 16: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.686800
ℹ   +-- 17: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.654557
ℹ   +-- 18: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:37:00.622206
ℹ   +-- 19: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.592450
ℹ   +-- 20: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.558403
ℹ   +-- 21: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.524042
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:37:00.483621
ℹ   +-- 23: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:37:00.450850
ℹ   +-- 24: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:37:00.417032
ℹ   +-- 25: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:37:00.386026
ℹ   +-- 26: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:37:00.355771
ℹ   +-- 27: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:37:00.325048
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:37:00.293214
ℹ   +-- 29: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:37:00.257201
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:37:00.221189
ℹ   +-- 31: NULL	SELECT `sys_version` FROM `sys` . `version`	2026-07-05 15:37:00.182226
ℹ   +-- 32: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:36:59.963893
ℹ   +-- 33: NULL	SHOW SESSION STATUS LIKE ?	2026-07-05 15:36:59.865584
ℹ   +-- 34: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:36:50.688830
ℹ   +-- 35: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:36:50.414764
ℹ   +-- 36: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:36:50.364546
ℹ   +-- 37: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:36:50.333005
ℹ   +-- 38: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:36:50.176922
ℹ   +-- 39: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:36:50.115090
ℹ   +-- 40: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2026-07-05 15:36:50.064560
ℹ   +-- 41: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:36:50.022569
ℹ   +-- 42: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2026-07-05 15:36:49.987910
ℹ   +-- 43: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	2026-07-05 15:36:49.979622
ℹ   +-- 44: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2026-07-05 15:36:49.869388
ℹ   +-- 45: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	2026-07-05 15:36:49.741037
ℹ   +-- 46: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	2026-07-05 15:36:49.712175
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2026-07-05 15:36:49.658484
ℹ   +-- 48: NULL	SHOW ENGINES	2026-07-05 15:36:49.614923
ℹ   +-- 49: NULL	SHOW GLOBAL STATUS	2026-07-05 15:36:49.583506
ℹ   +-- 50: NULL	SHOW STATUS	2026-07-05 15:36:49.552753
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.031s
 
-------- Performance schema: Top 15 total latency queries with temp table --------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	127411329000
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	78375172000
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	73548024000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	56901796000
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	56514758000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	51122709000
ℹ   +-- 7: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	24232971000
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	23882698000
ℹ   +-- 9: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	23159910000
ℹ   +-- 10: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	22385788000
ℹ   +-- 11: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	22129761000
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	18432196000
ℹ   +-- 13: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	13943584000
ℹ   +-- 14: NULL	SHOW VARIABLES	13590436000
ℹ   +-- 15: NULL	SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w	12116437000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.033s
 
-------- 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	1
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	1
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	1
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	1
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	1
ℹ   +-- 6: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	1
ℹ   +-- 7: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	1
ℹ   +-- 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.033s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919015
ℹ   +-- 2: wait/io/file	116673
ℹ   +-- 3: wait/lock/table	168
ℹ  Performance schema: Top 15 class events by number execution time: 0.036s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	3919015
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	83131
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	14893
ℹ   +-- 4: wait/io/file/sql/io_cache	9514
ℹ   +-- 5: wait/io/file/sql/binlog	8838
ℹ   +-- 6: wait/lock/table/sql/handler	168
ℹ   +-- 7: wait/io/file/innodb/innodb_dblwr_file	138
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	81
ℹ   +-- 9: wait/io/file/sql/binlog_index	41
ℹ   +-- 10: wait/io/file/sql/casetest	15
ℹ   +-- 11: wait/io/file/sql/misc	6
ℹ   +-- 12: wait/io/file/sql/ERRMSG	5
ℹ   +-- 13: wait/io/file/mysys/cnf	5
ℹ   +-- 14: wait/io/file/sql/pid	3
ℹ   +-- 15: wait/io/file/mysys/charset	3
ℹ  Performance schema: Top 30 events by number execution time: 0.035s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/file	24707445002612
ℹ   +-- 2: wait/io/table	11015604458794
ℹ   +-- 3: wait/lock/table	681885360
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.035s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	18390010514712
ℹ   +-- 2: wait/io/table/sql/handler	11015604458794
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	4240546783104
ℹ   +-- 4: wait/io/file/sql/binlog	1255920322368
ℹ   +-- 5: wait/io/file/innodb/innodb_dblwr_file	288660923292
ℹ   +-- 6: wait/io/file/sql/io_cache	263614599912
ℹ   +-- 7: wait/io/file/innodb/innodb_temp_file	214000306668
ℹ   +-- 8: wait/io/file/sql/binlog_index	52088172488
ℹ   +-- 9: wait/io/file/sql/casetest	1353455240
ℹ   +-- 10: wait/io/file/sql/pid	816198228
ℹ   +-- 11: wait/lock/table/sql/handler	681885360
ℹ   +-- 12: wait/io/file/sql/ERRMSG	321020840
ℹ   +-- 13: wait/io/file/mysys/cnf	43455760
ℹ   +-- 14: wait/io/file/mysys/charset	34868760
ℹ   +-- 15: wait/io/file/sql/misc	34381240
ℹ  Performance schema: Top 30 events by total latency execution time: 0.035s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/file	202802479732
ℹ   +-- 2: wait/io/table	47070925226
ℹ   +-- 3: wait/lock/table	31644480
ℹ  Performance schema: Top 15 class events by max latency execution time: 0.035s
 
-------- Performance schema: Top 30 events by max latency ------------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	202802479732
ℹ   +-- 2: wait/io/file/sql/io_cache	61534929520
ℹ   +-- 3: wait/io/file/sql/binlog_index	49806600494
ℹ   +-- 4: wait/io/table/sql/handler	47070925226
ℹ   +-- 5: wait/io/file/sql/binlog	44984257080
ℹ   +-- 6: wait/io/file/innodb/innodb_data_file	34658638326
ℹ   +-- 7: wait/io/file/innodb/innodb_dblwr_file	24087720006
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	23072105600
ℹ   +-- 9: wait/io/file/sql/casetest	1208207520
ℹ   +-- 10: wait/io/file/sql/pid	742125658
ℹ   +-- 11: wait/io/file/sql/ERRMSG	275227200
ℹ   +-- 12: wait/lock/table/sql/handler	31644480
ℹ   +-- 13: wait/io/file/mysys/cnf	28242920
ℹ   +-- 14: wait/io/file/mysys/charset	19534040
ℹ   +-- 15: wait/io/file/sql/misc	8797520
ℹ  Performance schema: Top 30 events by max latency execution time: 0.034s
 
-------- 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.030s
 
-------- InnoDB Metrics ----------------------------------------------------------------------------
ℹ  InnoDB is enabled.
ℹ  InnoDB Metrics execution time: 0.000s
 
-------- Smart Migration LTS Advisor ---------------------------------------------------------------
✔  No major migration risks detected for modern LTS versions.
ℹ  InnoDB Buffers
ℹ   +-- InnoDB Buffer Pool: 128.0M
ℹ   +-- InnoDB Buffer Pool Instances: 1
ℹ   +-- InnoDB Buffer Pool Chunk Size: 128.0M
ℹ   +-- InnoDB Redo Log Capacity: 100.0M
ℹ   +-- InnoDB Log Buffer: 64.0M
ℹ   +-- InnoDB Buffer Free: 973B
ℹ   +-- 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% (22814801 hits / 22816006 total)
✔  InnoDB Write Log efficiency: 99.12% (8111077 hits / 8183354 total)
✔  InnoDB log waits: 0.00% (0 waits / 72277 writes)
ℹ  Smart Migration LTS Advisor execution time: 0.000s
 
-------- InnoDB Transactions -----------------------------------------------------------------------
ℹ  Transaction Isolation Level: REPEATABLE-READ
ℹ  Active InnoDB Transactions: 0
ℹ  InnoDB Transactions execution time: 0.000s
 
-------- Infrastructure-Aware InnoDB Tuning --------------------------------------------------------
ℹ  Detected Storage Type: HDD
✘  innodb_flush_neighbors is disabled on HDD
ℹ  Infrastructure-Aware InnoDB Tuning 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.031s
 
-------- 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.030s
 
-------- Aria Metrics ------------------------------------------------------------------------------
ℹ  Aria Storage Engine not available.
ℹ  Aria Metrics execution time: 0.000s
 
-------- TokuDB Metrics ----------------------------------------------------------------------------
ℹ  TokuDB is disabled.
ℹ  TokuDB Metrics execution time: 0.000s
 
-------- XtraDB Metrics ----------------------------------------------------------------------------
ℹ  XtraDB is disabled.
ℹ  XtraDB Metrics execution time: 0.000s
 
-------- Galera Metrics ----------------------------------------------------------------------------
ℹ  Galera is disabled.
ℹ  Galera Metrics execution time: 0.000s
 
-------- Replication Metrics -----------------------------------------------------------------------
ℹ  Galera Synchronous replication: NO
ℹ  No replication replica(s) for this server.
ℹ  Binlog format: ROW
ℹ  XA support enabled: ON
ℹ  Semi synchronous replication Source: Not Activated
ℹ  Semi synchronous replication Replica: Not Activated
ℹ  This is a standalone server
ℹ  Replication Metrics execution time: 0.000s
 
-------- Predictive Capacity Planning --------------------------------------------------------------
✔  Memory headroom: 17.4G (Theoretical max usage is 11.94% of physical RAM)
ℹ  Growth forecasting: Insufficient uptime (< 24h) for reliable estimation.
ℹ  Predictive Capacity Planning execution time: 0.000s
 
-------- Cluster & Replication Intelligence --------------------------------------------------------
ℹ  Replication status: Not running as a replica.
✘  gtid_mode is OFF (recommended: ON)
✘  enforce_gtid_consistency is OFF (recommended: ON)
ℹ  binlog_transaction_compression is OFF (consider setting to ON to save network/disk space)
✘  Binlog cache disk use ratio is 48.40% (too many disk spills)
✘  source_verify_checksum is disabled (recommended: ON)
ℹ  Cluster & Replication Intelligence execution time: 0.000s
 
-------- Security Hardening 2.0 --------------------------------------------------------------------
✘  TLS/SSL is disabled. Connections are unencrypted.
ℹ  Security Hardening 2.0 execution time: 0.000s
 
-------- Guided Auto-Fix Snippets ------------------------------------------------------------------
Ready-to-Apply SQL Snippets (SET GLOBAL):
    SET GLOBAL innodb_flush_neighbors = '1 or 2 (Recommended for HDD)';

Ready-to-Apply Configuration Block ([mysqld]):
    DON'T APPLY SETTINGS BECAUSE THERE ARE TOO MANY PROCESSES RUNNING ON THIS SERVER. OOM KILL CAN OCCUR!
    vm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness) or vm.swappiness=10 in /etc/sysctl.conf
    fs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr) or fs.aio-max-nr=1048576 in /etc/sysctl.conf
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)
    innodb_flush_neighbors = 1 or 2 (Recommended for HDD)
ℹ  Guided Auto-Fix Snippets execution time: 0.000s
 
-------- 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:
    Consider stopping or dedicate server for additional process other than mysqld.
    setup swappiness lower or equal to 10
    setup Max running number events greater than 1M
    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;
    Enable require_secure_transport to force all connections to use SSL.
    Enforce SSL for remote users (ALTER USER ... REQUIRE SSL)
    20 CVE(s) found for your MySQL release. Consider upgrading your version !
    MySQL was started within the last 24 hours: recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size
    Increase binlog_cache_size (current value: 32768)
    Unused indexes found: 2 index(es) should be reviewed and potentially removed.
    Set gtid_mode = ON to enable global transaction identifier replication.
    Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
    Enable binlog_transaction_compression = ON to reduce replication stream size.
    Increase binlog_cache_size to reduce disk spills for binary log transactions.
    Enable source_verify_checksum = ON (or master_verify_checksum).
    Enable TLS/SSL for encrypted connections.
Variables to adjust:
    DON'T APPLY SETTINGS BECAUSE THERE ARE TOO MANY PROCESSES RUNNING ON THIS SERVER. OOM KILL CAN OCCUR!
    vm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness) or vm.swappiness=10 in /etc/sysctl.conf
    fs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr) or fs.aio-max-nr=1048576 in /etc/sysctl.conf
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)
    innodb_flush_neighbors = 1 or 2 (Recommended for HDD)
OS & Memory Allocation

Resource	Allocated Value
Physical RAM	15.26 GB
Swap Space	4.00 GB
Max Peak Memory Calculation	1866.41 MB (3% of RAM)
Maximum Memory Used	572.48 MB
OS & System Recommendations

•Consider stopping or dedicate server for additional process other than mysqld (other processes use 17.52% of RAM).
•vm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness) or vm.swappiness=10 in /etc/sysctl.conf
•fs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr) or fs.aio-max-nr=1048576 in /etc/sysctl.conf
•Consider stopping or dedicate server for additional process other than mysqld.
•setup swappiness lower or equal to 10
•setup Max running number events greater than 1M
•Restrict Host for 'root'@'%' to 'root'@LimitedIPRangeOrLocalhost
•RENAME USER 'root'@'%' TO 'root'@LimitedIPRangeOrLocalhost;
•Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
•Increase binlog_cache_size to reduce disk spills for binary log transactions.
Max Connections Limit 151
Max Connections Used 1 (0%)
Thread Cache Hit Rate
95.00%
Connection & Thread Variables

Variable Name	Value
max_connections	151
thread_cache_size	9
Threads_cached	0
Threads_created	1
Aborted_connects	0
Connection & Network Recommendations

•Enable require_secure_transport to force all connections to use SSL.
•Enable TLS/SSL for encrypted connections.
InnoDB Buffer Pool Hit Rate

Indicates how frequently pages are read directly from cache memory vs disk
99.99%
InnoDB Memory Configuration

innodb_buffer_pool_size 128.00 MB
innodb_log_buffer_size 64.00 MB
innodb_file_per_table ON
Enabled Storage Engines Status

+ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA -ndbcluster -ndbinfo
Storage Engine Data Distribution

Storage Engine	Tables Count	Data Size	Index Size	Total Size
InnoDB	7	26.1M	5.5M	31.7M
Total	7	26.1M	5.5M	31.7M
InnoDB Engine Detailed Diagnostics

Diagnostic Parameter	Value / Status
InnoDB Buffer Pool Instances	1
innodb_buffer_pool_chunk_size	128.0M
InnoDB Buffer Pool Chunks	1 (instances: 1)
Chunk Alignment Status	Aligned
innodb_redo_log_capacity	100.0M
InnoDB Buffer Pool Total Pages	8192 pages (128.0M)
InnoDB Buffer Pool Free Pages	973 pages (15.2M)
InnoDB Buffer Pool Used Pages	7219 pages (112.8M)
InnoDB Thread Concurrency	0
InnoDB Read Efficiency	99.99% (hit rate)
Total InnoDB OS Log Written	308.4M (uptime < 1h)
Variables to Adjust (Storage Recommendations)

•DON'T APPLY SETTINGS BECAUSE THERE ARE TOO MANY PROCESSES RUNNING ON THIS SERVER. OOM KILL CAN OCCUR!
•vm.swappiness <= 10 (echo 10 > /proc/sys/vm/swappiness) or vm.swappiness=10 in /etc/sysctl.conf
•fs.aio-max-nr > 1M (echo 1048576 > /proc/sys/fs/aio-max-nr) or fs.aio-max-nr=1048576 in /etc/sysctl.conf
•join_buffer_size (> 256.0K, or always use indexes with JOINs)
•binlog_cache_size (16.0M)
•innodb_flush_neighbors = 1 or 2 (Recommended for HDD)
Temporary Tables Location Split

Shows ratio of temporary tables created in memory (optimal) vs written to disk (suboptimal)
RAM: 100.0%
Disk: 0.0%
Created_tmp_tables: 4 Created_tmp_disk_tables: 0
Joins & Sort Variables

Metric	Value
Select_full_join (Joins without index)	1
Select_range_check	0
Sort_merge_passes (Sorts that touched disk)	0
Slow_queries	0
tmp_table_size	16.00 MB
max_heap_table_size	16.00 MB
Query & Performance Recommendations

•MySQL was started within the last 24 hours: recommendations may be inaccurate
•Enable the slow query log to troubleshoot bad queries
•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)
•Increase binlog_cache_size to reduce disk spills for binary log transactions.
Database Schema Modeling Findings

Highlights potential schema issues, indexes anomalies, PK casing problems, and naming conventions deviations.
Modeling Quality Score 0%
User Databases 5
Total Tables 7
Fragmented Tables 0
Tables w/o PK 0
Redundant Indexes 0
Unused Indexes 2
User Databases Size Distribution

Database Name	Tables	Rows	Data Size	Index Size	Total Size
employees	8	3916999	45.6M	5.5M	51.2M
Fragmented Tables Details (>100MB data & >10% free space)

Table Name	Engine	Free Space	Suggested Defragmentation SQL
No fragmented tables found.
Tables Without Primary Key Details

Table Name	Status / Hardening Advice
All base tables have a primary key or unique index.
Redundant Indexes Details

Table Name	Redundant Index	Status	Suggested Drop SQL
No redundant indexes detected.
Unused Indexes Details

Table Name	Unused Index	Suggested Drop SQL
employees.dept_emp	dept_no	ALTER TABLE employees.dept_emp DROP INDEX dept_no
employees.dept_manager	dept_no	ALTER TABLE employees.dept_manager DROP INDEX dept_no
SQL Schema & Modeling Recommendations

•Table employees.departments: Primary key 'dept_no' does not follow naming convention (id or departments_id)
•Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.dept_emp: Primary key 'dept_no' does not follow naming convention (id or dept_emp_id)
•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 naming convention (id or dept_emp_id)
•Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.dept_manager: Primary key 'dept_no' does not follow naming convention (id or dept_manager_id)
•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 naming convention (id or dept_manager_id)
•Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.employees: Primary key 'emp_no' does not follow naming convention (id or employees_id)
•Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.salaries: Primary key 'emp_no' does not follow naming convention (id or salaries_id)
•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 naming convention (id or salaries_id)
•Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.titles: Primary key 'emp_no' does not follow naming convention (id or titles_id)
•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 naming convention (id or titles_id)
•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 naming convention (id or titles_id)
•Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
•Table employees.departments: Plural name detected (prefer singular)
•Table employees.employees: Plural name detected (prefer singular)
•Table employees.salaries: Plural name detected (prefer singular)
•Table employees.titles: Plural name detected (prefer singular)
•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.
•Unused index: employees.dept_emp (dept_no) (suggested SQL: ALTER TABLE employees.dept_emp DROP INDEX dept_no)
•Unused index: employees.dept_manager (dept_no) (suggested SQL: ALTER TABLE employees.dept_manager DROP INDEX dept_no)
Overall Health Score

Category Scores

Sectional Indicators & KPIs Dashboard

Resource Saturation Heatmap

Throughput Efficiency Index

Prioritized Executive Summary Findings

General Stats⚠️ Action Required

Storage & Performance⚠️ Action Required

Security & Compliance⚠️ Action Required

Replication & HA⚠️ Action Required

SQL Modeling⚠️ Action Required

Full Console Output Trace

OS & Memory Allocation

OS & System Recommendations

Connection & Thread Variables

Connection & Network Recommendations

InnoDB Buffer Pool Hit Rate

InnoDB Memory Configuration

Enabled Storage Engines Status

Storage Engine Data Distribution

InnoDB Engine Detailed Diagnostics

Variables to Adjust (Storage Recommendations)

Temporary Tables Location Split

Joins & Sort Variables

Query & Performance Recommendations

Security Indicators & Configuration

Security Findings & Hardening Advice

Database Schema Modeling Findings

User Databases Size Distribution

Fragmented Tables Details (>100MB data & >10% free space)

Tables Without Primary Key Details

Redundant Indexes Details

Unused Indexes Details

SQL Schema & Modeling Recommendations

Replication Status Dashboard

Replication Recommendations

Queries & Execution Analytics

Query Distribution

Query Ratios

Locks & Latency

Table Locks

Row Locks

Temporary Tables & Spills

Temp Table Ratios

Events & Log Summary

CSV Data Export Center

JSON Data Export Center
