MySQLTuner Audit Report

8.0.45 (Percona Server (GPL), Release 36, Revision 8fe4a72d) at 127.0.0.1:3306 • Tuner 2.9.0
Generated On
Sun Jul 5 17:42:31 2026
Overall Health Score

85 out of 100
Good Health
Category Scores

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

Phase 13 Unified View
General Stats 40%
Storage & Perf 100%
Security 70%
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.935 QPS
Buffer Logical Reads 662758.806/s
Efficiency Ratio Queries completed per logical page read
1e-05
Prioritized Executive Summary Findings

General Stats⚠️ Action Required

CriticalRemove unused indexes.
Critical22 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)
Replication & HA⚠️ Action Required

CriticalMigration Risk (binlog_transaction_dependency_tracking): Removed in MySQL 8.4.
CriticalMigration Risk (expire_logs_days): Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
FindingIncrease binlog_cache_size (current value: 32768)
SQL Modeling⚠️ Action Required

FindingTable employees.employees: Primary key 'emp_no' does not follow naming convention (id or employees_id)
FindingTable employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
FindingTable employees.departments: Primary key 'dept_no' does not follow naming convention (id or departments_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:42:17
ℹ  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:42:17
ℹ  Server Connection  : 127.0.0.1:3306
ℹ  Database User      : root@%
ℹ  Database Version   : 8.0.45-36
ℹ  System Physical RAM: 15.3G
ℹ  System Swap Memory : 4.0G
ℹ  Database Uptime    : 31s
✔  Operating on 64-bit architecture
ℹ  Audit Snapshot Summary execution time: 0.177s
 
-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ  Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM -ndbcluster -ndbinfo +PERFORMANCE_SCHEMA 
ℹ  Data in InnoDB tables: 31.7M (Tables: 7)
✔  Total fragmented tables: 0
 
✔  Currently running supported MySQL/MariaDB version 8.0.45(LTS)
ℹ  Storage Engine Statistics execution time: 0.265s
 
-------- 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
ℹ  	25: br-8985d99b5d9b: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default 
ℹ  	    link/ether fa:c9:28:97:76:f9 brd ff:ff:ff:ff:ff:ff
ℹ  	--
ℹ  	26: veth47060a8@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-8985d99b5d9b state UP group default 
ℹ  	    link/ether 3a:30:97:53:c7:80 brd ff:ff:ff:ff:ff:ff link-netnsid 0
ℹ  	27: veth19353b2@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-8985d99b5d9b state UP group default 
ℹ  	    link/ether 42:16:f5:2d:1e:ad 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        3361       10237           4        2276       12268
ℹ  	Swap:           4096           0        4096
ℹ  Load Average          : 
ℹ  	top - 17:42:18 up 4 days,  5:13,  1 user,  load average: 2.17, 1.28, 0.65
ℹ  System Uptime         : 
ℹ  	 17:42:18 up 4 days,  5:13,  1 user,  load average: 2.17, 1.28, 0.65
ℹ  Database Uptime       : 31s
✔  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 16.01% (2G / 15G)
ℹ  System Linux Recommendations execution time: 0.713s
 
-------- 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.97 GB / 951.65 GB)
ℹ  mount point / is using 14 % total space (131.83 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.97 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.012s
 
-------- Kernel Information Recommendations --------------------------------------------------------
ℹ  Information about kernel tuning:
ℹ  	fs.aio-max-nr = 65536
ℹ  	fs.aio-nr = 2305
ℹ  	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.064s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Performance Schema error_log table detected
ℹ  Performance Schema error_log: 11 entries detected
✔  performance_schema.error_log doesn't contain any warning.
✔  performance_schema.error_log doesn't contain any error.
ℹ  2 start(s) detected in performance_schema.error_log
ℹ  1) X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
ℹ  2) /usr/sbin/mysqld: ready for connections. Version: '8.0.45-36'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 36, Revision 8fe4a72d.
ℹ  0 shutdown(s) detected in performance_schema.error_log
ℹ  Log file Recommendations execution time: 0.055s
 
-------- Analysis Performance Metrics --------------------------------------------------------------
ℹ  innodb_stats_on_metadata: OFF
✔  No stat updates during querying INFORMATION_SCHEMA.
ℹ  Analysis Performance Metrics execution time: 0.000s
 
-------- Database Metrics --------------------------------------------------------------------------
ℹ  There is 1 Database(s).
ℹ  All User Databases:
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3918131
ℹ   +-- DATA  : 26.1M(82.47%)
ℹ   +-- INDEX : 5.5M(17.53%)
ℹ   +-- SIZE  : 31.6M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3918131
ℹ   +-- DATA  : 26.1M(82.47%)
ℹ   +-- INDEX : 5.5M(17.53%)
ℹ   +-- TOTAL : 31.6M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ   +-- ENGINE InnoDB : 6 TABLE(s)
✔  1 collation for employees database.
✔  1 engine for employees database.
ℹ  Charsets for employees database table column: utf8mb4
✔  employees table column(s) has same charset defined for all text like column(s).
ℹ  Collations for employees database table column: utf8mb4_0900_ai_ci
✔  employees table column(s) has same collation defined for all text like column(s).
ℹ  Database Metrics execution time: 0.550s
 
-------- 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.405s
 
-------- Table structures analysis -----------------------------------------------------------------
✔  All tables get a primary key
✘  Table employees.employees: Primary key 'emp_no' does not follow 'id' or 'employees_id' naming convention
✘  Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.departments: Primary key 'dept_no' does not follow 'id' or 'departments_id' naming convention
✘  Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'dept_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_manager: Primary key 'emp_no' does not follow 'id' or 'dept_manager_id' naming convention
✘  Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'dept_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'from_date' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'title' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✔  All tables are InnoDB tables
✔  All columns are UTF-8 compliant
ℹ  Table structures analysis execution time: 0.258s
 
-------- Naming conventions analysis ---------------------------------------------------------------
✘  Table employees.employees: Plural name detected (prefer singular)
✘  Table employees.departments: Plural name detected (prefer singular)
✘  Table employees.titles: Plural name detected (prefer singular)
✘  Table employees.salaries: Plural name detected (prefer singular)
ℹ  Naming conventions analysis execution time: 0.116s
 
-------- 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.094s
 
-------- MySQL 8.0+ Specific Modeling --------------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MySQL 8.0+ Specific Modeling execution time: 0.088s
 
-------- 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.028s
 
-------- Indexes Metrics ---------------------------------------------------------------------------
ℹ  Worst selectivity indexes:
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 8 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  dept_no(dept_no) has a low selectivity
ℹ  Index: PRIMARY(from_date)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 3 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(from_date) has a low selectivity
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: PRIMARY(from_date)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 2844047 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(from_date) has a low selectivity
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: PRIMARY(title)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 1 distinct values
ℹ   +-- NB ROWS     : 443308 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 0.00%
✘  PRIMARY(title) has a low selectivity
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 9 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 37.50%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 299710 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 90.51%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 331143 distinct values
ℹ   +-- NB ROWS     : 331143 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Indexes per database:
ℹ  Database: employees
ℹ   +-- INDEX      : departments.dept_name
ℹ   +-- COLUMNS    : dept_name
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : departments.PRIMARY
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_emp.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 8
ℹ   +-- INDEX      : dept_emp.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 630853
ℹ   +-- INDEX      : dept_manager.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 9
ℹ   +-- INDEX      : dept_manager.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 48
ℹ   +-- INDEX      : employees.PRIMARY
ℹ   +-- COLUMNS    : emp_no
ℹ   +-- CARDINALITY: 299600
ℹ   +-- INDEX      : salaries.PRIMARY
ℹ   +-- COLUMNS    : emp_no,from_date
ℹ   +-- CARDINALITY: 2
ℹ   +-- INDEX      : titles.PRIMARY
ℹ   +-- COLUMNS    : emp_no,title,from_date
ℹ   +-- CARDINALITY: 3
ℹ  Unused indexes:
✘  Index: dept_name on employees.departments is not used.
✘  Index: dept_no on employees.dept_emp is not used.
✘  Index: dept_no on employees.dept_manager is not used.
ℹ  Indexes Metrics execution time: 0.332s
 
-------- Views Metrics -----------------------------------------------------------------------------
ℹ  Views Metrics execution time: 0.000s
 
-------- Triggers Metrics --------------------------------------------------------------------------
ℹ  Triggers Metrics execution time: 0.000s
 
-------- Routines Metrics --------------------------------------------------------------------------
ℹ  Routines Metrics execution time: 0.000s
 
-------- Security Recommendations ------------------------------------------------------------------
ℹ  Percona Server (GPL), Release 36, Revision 8fe4a72d - 8.0.45
✔  No Role user detected
✔  There are no anonymous accounts for any database users
✔  All database users have passwords assigned
✘  User 'root'@% does not specify hostname restrictions.
ℹ  There are 620 basic passwords in the list.
ℹ  Security Recommendations execution time: 7.333s
 
-------- Authentication Plugin Security ------------------------------------------------------------
✔  No users found using insecure or deprecated authentication plugins
ℹ  Authentication Plugin Security execution time: 0.029s
 
-------- SSL/TLS Security Recommendations ----------------------------------------------------------
✔  Current connection is encrypted (TLS_AES_256_GCM_SHA384)
✔  SSL support is enabled
✘  require_secure_transport is OFF
✔  Only secure TLS versions enabled: TLSv1.2,TLSv1.3
✘  Public Certificate file not found: server-cert.pem
✘  CA Certificate file not found: ca.pem
✘  1 users can connect remotely without SSL enforcement
ℹ  SSL/TLS Security Recommendations execution time: 0.087s
 
-------- CVE Security Recommendations --------------------------------------------------------------
✘  CVE-2026-21998(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer).  Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and  9.0.0-9.6.0. Easily exploitable vulne...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

✘  22 CVE(s) found for your MySQL release.
ℹ  CVE Security Recommendations execution time: 0.002s
 
-------- Plugin Information ------------------------------------------------------------------------
ℹ  Plugin                         | Version    | Status     | Type                
ℹ  --------------------------------------------------------------------------------
ℹ  mysqlx_cache_cleaner           | 1.0        | ACTIVE     | AUDIT               
ℹ  sha2_cache_cleaner             | 1.0        | ACTIVE     | AUDIT               
ℹ  caching_sha2_password          | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  mysql_native_password          | 1.1        | ACTIVE     | AUTHENTICATION      
ℹ  sha256_password                | 1.1        | ACTIVE     | AUTHENTICATION      
ℹ  daemon_keyring_proxy_plugin    | 1.0        | ACTIVE     | DAEMON              
ℹ  mysqlx                         | 1.0        | ACTIVE     | DAEMON              
ℹ  ngram                          | 0.1        | ACTIVE     | FTPARSER            
ℹ  ARCHIVE                        | 3.0        | ACTIVE     | STORAGE ENGINE      
ℹ  binlog                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  BLACKHOLE                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  CSV                            | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  InnoDB                         | 8.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MEMORY                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MRG_MYISAM                     | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MyISAM                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  PERFORMANCE_SCHEMA             | 0.1        | ACTIVE     | STORAGE ENGINE      
ℹ  TempTable                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  Plugin Information execution time: 0.029s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 31s (215 q [6.935 qps], 21 conn, TX: 78K, 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.4G
ℹ  Total buffers: 152.0M global + 1.0G temptable + 1.9M per thread (151 max threads)
ℹ  Performance_schema Max memory usage: 332M
ℹ  Galera GCache Max memory usage: 0B
ℹ  Global Buffers
ℹ   +-- Key Buffer: 8.0M
ℹ   +-- Max Tmp Table: 16.0M
ℹ  Per Thread Buffers
ℹ   +-- Read Buffer: 128.0K
ℹ   +-- Read RND Buffer: 256.0K
ℹ   +-- Sort Buffer: 256.0K
ℹ   +-- Thread stack: 1.0M
ℹ   +-- Join Buffer: 256.0K
ℹ  Binlog Cache Buffers
ℹ   +-- Binlog Cache: 32.0K
✔  Maximum reached memory usage: 501.9M (3.21% of installed RAM)
✔  Maximum possible memory usage: 1.8G (11.49% of installed RAM)
✔  Overall possible memory usage with other process is compatible with memory available
✔  Slow queries: 0% (0/215)
✔  Highest usage of available connections: 0% (1/151)
✔  Aborted connections: 0.00% (0/21)
ℹ  Query cache has been removed since MySQL 8.0
✔  Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
✘  Joins performed without indexes: 3
✔  Temporary tables created on disk: 0% (0 on disk / 4 total)
✔  temptable_max_mmap (1.0G) is compatible with available disk space on /tmp (823.8G)
✔  Thread cache hit rate: 95% (1 created / 21 connections)
✔  Table cache hit rate: 94% (4K hits / 5K requests)
✔  table_definition_cache (2000) is greater than number of tables (349)
✔  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.115s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 332.0M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 2.1.3
ℹ  Performance schema execution time: 0.086s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	415 conn(s)
ℹ   +-- 2: background	12 conn(s)
ℹ   +-- 3: event_scheduler	1 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.033s
 
-------- 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.031s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	47019193161.9048
ℹ   +-- 2: background	0.0000
ℹ   +-- 3: event_scheduler	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.031s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	1660000000
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.029s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	57
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.029s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	2836
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.027s
 
-------- 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.028s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: background	99352
ℹ   +-- 2: root	14285
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO execution time: 0.032s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: background	36273070716840
ℹ   +-- 2: root	2752520240160
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.030s
 
-------- 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.033s
 
-------- 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.030s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	45148108415.5251
ℹ   +-- 2: localhost	NULL
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.030s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	1696000000
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.031s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	66
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.028s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	2860
ℹ   +-- 2: background	0
ℹ   +-- 3: localhost	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.028s
 
-------- 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.028s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	14287
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per io execution time: 0.032s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	2752531619760
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per io latency execution time: 0.031s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	78962 i/o
ℹ   +-- 2: innodb/innodb_data_file	16313 i/o
ℹ   +-- 3: sql/binlog	8473 i/o
ℹ   +-- 4: innodb/innodb_dblwr_file	5232 i/o
ℹ   +-- 5: sql/io_cache	4529 i/o
ℹ   +-- 6: innodb/innodb_temp_file	57 i/o
ℹ   +-- 7: sql/binlog_index	41 i/o
ℹ   +-- 8: sql/casetest	10 i/o
ℹ   +-- 9: sql/misc	6 i/o
ℹ   +-- 10: sql/ERRMSG	5 i/o
ℹ   +-- 11: mysys/cnf	5 i/o
ℹ   +-- 12: sql/pid	3 i/o
ℹ   +-- 13: mysys/charset	3 i/o
ℹ  Performance schema: Top IO type order by total io execution time: 0.030s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	15731387565336
ℹ   +-- 2: innodb/innodb_data_file	12359239108506
ℹ   +-- 3: innodb/innodb_dblwr_file	9604142825490
ℹ   +-- 4: sql/binlog	1150337646774
ℹ   +-- 5: sql/io_cache	91053779094
ℹ   +-- 6: innodb/innodb_temp_file	85197581676
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: sql/pid	227905200
ℹ   +-- 10: sql/ERRMSG	186604560
ℹ   +-- 11: sql/misc	44046360
ℹ   +-- 12: mysys/charset	32343120
ℹ   +-- 13: mysys/cnf	21203640
ℹ  Performance schema: Top IO type order by total latency execution time: 0.033s
 
-------- Performance schema: Top IO type order by max latency --------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	56671552746
ℹ   +-- 2: innodb/innodb_dblwr_file	30125925522
ℹ   +-- 3: innodb/innodb_data_file	25383956418
ℹ   +-- 4: sql/binlog	16887608280
ℹ   +-- 5: innodb/innodb_temp_file	15495414966
ℹ   +-- 6: sql/io_cache	1369399140
ℹ   +-- 7: sql/binlog_index	1276989480
ℹ   +-- 8: sql/casetest	1172046600
ℹ   +-- 9: sql/pid	202358520
ℹ   +-- 10: sql/ERRMSG	142067520
ℹ   +-- 11: mysys/charset	18572760
ℹ   +-- 12: sql/misc	16108920
ℹ   +-- 13: mysys/cnf	13530240
ℹ  Performance schema: Top IO type order by max latency execution time: 0.033s
 
-------- 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.031s
 
-------- Performance schema: Top Stages order by total latency -------------------------------------
ℹ   +-- 1: innodb/buffer pool load	5837754000
ℹ  Performance schema: Top Stages order by total latency execution time: 0.031s
 
-------- Performance schema: Top Stages order by avg latency ---------------------------------------
ℹ   +-- 1: innodb/buffer pool load	5837754000
ℹ  Performance schema: Top Stages order by avg latency execution time: 0.030s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	77
ℹ   +-- 2: localhost	0
ℹ  Performance schema: Top 5 host per table scans execution time: 0.033s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	105152512	96059659	6418 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.100s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	95436800	87205616	5825 page(s)
ℹ   +-- 2: employees	employees	8650752	7932913	528 page(s)
ℹ   +-- 3: employees	titles	1032192	920617	63 page(s)
ℹ   +-- 4: employees	departments	32768	513	2 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.091s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: innodb/dict_stats_thread	NULL	43
ℹ   +-- 2: innodb/srv_master_thread	NULL	43
ℹ   +-- 3: innodb/page_flush_coordinator_thread	NULL	43
ℹ   +-- 4: innodb/fts_optimize_thread	NULL	43
ℹ   +-- 5: sql/main	NULL	42
ℹ   +-- 6: innodb/clone_gtid_thread	NULL	42
ℹ   +-- 7: innodb/srv_purge_thread	NULL	42
ℹ   +-- 8: innodb/srv_worker_thread	NULL	42
ℹ   +-- 9: innodb/srv_worker_thread	NULL	42
ℹ   +-- 10: innodb/srv_worker_thread	NULL	42
ℹ   +-- 11: sql/event_scheduler	Daemon	42
ℹ   +-- 12: sql/compress_gtid_table	Daemon	42
ℹ   +-- 13: root@172.18.0.2	Query	0
ℹ   +-- 14: innodb/io_write_thread	NULL	NULL
ℹ   +-- 15: innodb/io_write_thread	NULL	NULL
ℹ   +-- 16: innodb/io_write_thread	NULL	NULL
ℹ   +-- 17: innodb/io_write_thread	NULL	NULL
ℹ   +-- 18: innodb/buf_resize_thread	NULL	NULL
ℹ   +-- 19: innodb/srv_monitor_thread	NULL	NULL
ℹ   +-- 20: innodb/log_checkpointer_thread	NULL	NULL
ℹ   +-- 21: innodb/log_flush_notifier_thread	NULL	NULL
ℹ   +-- 22: innodb/log_flusher_thread	NULL	NULL
ℹ   +-- 23: innodb/log_write_notifier_thread	NULL	NULL
ℹ   +-- 24: innodb/log_writer_thread	NULL	NULL
ℹ   +-- 25: innodb/log_files_governor_thread	NULL	NULL
ℹ   +-- 26: innodb/srv_lock_timeout_thread	NULL	NULL
ℹ   +-- 27: innodb/io_read_thread	NULL	NULL
ℹ   +-- 28: innodb/io_read_thread	NULL	NULL
ℹ   +-- 29: innodb/io_read_thread	NULL	NULL
ℹ   +-- 30: innodb/io_read_thread	NULL	NULL
ℹ   +-- 31: innodb/io_ibuf_thread	NULL	NULL
ℹ   +-- 32: innodb/buf_lru_manager_thread	NULL	NULL
ℹ   +-- 33: innodb/srv_error_monitor_thread	NULL	NULL
ℹ   +-- 34: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 35: mysqlx/worker	NULL	NULL
ℹ   +-- 36: mysqlx/worker	NULL	NULL
ℹ   +-- 37: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 38: innodb/buf_dump_thread	NULL	NULL
ℹ   +-- 39: mysqlx/acceptor_network	NULL	NULL
ℹ   +-- 40: sql/signal_handler	NULL	NULL
ℹ  Performance schema: Process per time execution time: 0.044s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.032s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: log_flusher_thread	13159998108090	56671552746
ℹ   +-- 2: page_flush_coordinator_thread	10055446260264	30125925522
ℹ   +-- 3: io_write_thread	2677557958794	16996940136
ℹ   +-- 4: io_write_thread	2586424323618	18588747294
ℹ   +-- 5: io_write_thread	2566533972978	10456317720
ℹ   +-- 6: io_write_thread	2499134520528	23521438494
ℹ   +-- 7: log_writer_thread	1656185925906	30150371304
ℹ   +-- 8: log_files_governor_thread	705493964610	10509953742
ℹ   +-- 9: log_checkpointer_thread	121898598318	23511892158
ℹ   +-- 10: buf_lru_manager_thread	44318170098	12049785360
ℹ   +-- 11: main	9038972880	2522867760
ℹ   +-- 12: buf_dump_thread	5305367880	173481480
ℹ   +-- 13: dict_stats_thread	584138880	111582720
ℹ   +-- 14: clone_gtid_thread	223938000	192837240
ℹ   +-- 15: srv_worker_thread	48639960	48639960
ℹ   +-- 16: root@172.18.0.2	9844920	9844920
ℹ  Performance schema: Thread IO Latency execution time: 0.032s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 2: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 3: INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 4: INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 5: INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 8: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 9: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 10: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ   +-- 11: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	47819706000
ℹ   +-- 12: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	46953955000
ℹ   +-- 13: CREATE TABLE `titles` ( `emp_no` INTEGER NOT NULL , `title` VARCHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to_	38099248000
ℹ   +-- 14: SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	29602835000
ℹ   +-- 15: SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	28238058000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.038s
 
-------- Performance schema: Top 15 slower queries -------------------------------------------------
ℹ   +-- 1: INSERT INTO `salaries` VALUES (...) /* , ... */	114 s
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */	21 s
ℹ   +-- 3: INSERT INTO `employees` VALUES (...) /* , ... */	17 s
ℹ   +-- 4: INSERT INTO `dept_emp` VALUES (...) /* , ... */	14 s
ℹ   +-- 5: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	1 s
ℹ   +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	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.035s
 
-------- 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.030s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	19015621905000
ℹ   +-- 2: select	569676351000
ℹ   +-- 3: create_table	291574219000
ℹ   +-- 4: create_view	29234418000
ℹ   +-- 5: drop_db	18940195000
ℹ   +-- 6: flush	15605007000
ℹ   +-- 7: create_db	11178662000
ℹ   +-- 8: drop_table	5240980000
ℹ   +-- 9: show_variables	4025444000
ℹ   +-- 10: show_status	3946341000
ℹ   +-- 11: show_databases	3314297000
ℹ   +-- 12: truncate	1310847000
ℹ   +-- 13: show_engine_status	1264154000
ℹ   +-- 14: Quit	1146810000
ℹ   +-- 15: Init DB	870997000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.031s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: insert	925000000
ℹ   +-- 2: select	633000000
ℹ   +-- 3: create_table	177000000
ℹ   +-- 4: create_view	24000000
ℹ   +-- 5: drop_table	14000000
ℹ   +-- 6: show_databases	13000000
ℹ   +-- 7: show_status	10000000
ℹ   +-- 8: show_variables	9000000
ℹ   +-- 9: truncate	8000000
ℹ   +-- 10: create_db	5000000
ℹ   +-- 11: Init DB	3000000
ℹ   +-- 12: drop_db	3000000
ℹ   +-- 13: show_storage_engines	1000000
ℹ   +-- 14: Ping	0
ℹ   +-- 15: show_grants	0
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.030s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	79
ℹ   +-- 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_slave_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.030s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: show_variables	1410
ℹ   +-- 2: show_status	1092
ℹ   +-- 3: select	539
ℹ   +-- 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_slave_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.030s
 
-------- 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_slave_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.029s
 
-------- 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.030s
 
-------- 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.029s
 
-------- Performance schema: Tables with full table scans ------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Tables with full table scans execution time: 0.029s
 
-------- Performance schema: Latest File IO by latency ---------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Latest File IO by latency execution time: 0.030s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/mysql.ibd	9011200
ℹ   +-- 2: /var/lib/mysql/#ib_16384_1.dblwr	8585216
ℹ   +-- 3: /var/lib/mysql/undo_001	7225344
ℹ   +-- 4: /var/lib/mysql/undo_002	6504448
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	4980736
ℹ   +-- 6: /var/lib/mysql/employees/titles.ibd	1064960
ℹ   +-- 7: /usr/share/percona-server/english/errmsg.sys	399123
ℹ   +-- 8: /var/lib/mysql/ibdata1	229376
ℹ   +-- 9: /var/lib/mysql/#ib_16384_0.dblwr	196608
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	68096
ℹ   +-- 11: /var/lib/mysql/employees/departments.ibd	65536
ℹ   +-- 12: /usr/share/percona-server/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/binlog.000001	360
ℹ  Performance schema: File by IO read bytes execution time: 0.029s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	209158144
ℹ   +-- 2: /var/lib/mysql/#ib_16384_0.dblwr	169836544
ℹ   +-- 3: /var/lib/mysql/binlog.000003	66378596
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	48103424
ℹ   +-- 5: /var/lib/mysql/employees/dept_emp.ibd	43499520
ℹ   +-- 6: /var/lib/mysql/employees/employees.ibd	37896192
ℹ   +-- 7: /var/lib/mysql/ibtmp1	14729216
ℹ   +-- 8: /var/lib/mysql/#innodb_redo/#ib_redo86	11753472
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo83	11664896
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo88	11654656
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo82	11654656
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo89	11650560
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo85	11649024
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo87	11622912
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo91	11474432
ℹ  Performance schema: File by IO written bytes execution time: 0.027s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_0.dblwr	9558889955406
ℹ   +-- 2: /var/lib/mysql/employees/salaries.ibd	6229208626398
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	1610354013750
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	1376463717306
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	1284889596084
ℹ   +-- 6: /var/lib/mysql/binlog.000003	1099078248492
ℹ   +-- 7: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	1041796022562
ℹ   +-- 8: /var/lib/mysql/undo_002	875068650450
ℹ   +-- 9: /var/lib/mysql/undo_001	768935249748
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo82	754629085458
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo91	698565002382
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo103	590105163042
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo88	530572962078
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo86	519282336456
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo102	510819841062
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo87	510054959682
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo89	502920618642
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo94	498581051508
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo96	495948025044
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo85	495342455976
ℹ  Performance schema: File per IO total latency execution time: 0.030s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/undo_002	9319191354
ℹ   +-- 2: /var/lib/mysql/undo_001	7811051922
ℹ   +-- 3: /var/lib/mysql/mysql.ibd	7800876576
ℹ   +-- 4: /var/lib/mysql/#ib_16384_1.dblwr	3379876920
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	412515720
ℹ   +-- 6: /var/lib/mysql/sys/sys_config.ibd	408459258
ℹ   +-- 7: /var/lib/mysql/ibdata1	372092040
ℹ   +-- 8: /var/lib/mysql/employees/titles.ibd	181593360
ℹ   +-- 9: /var/lib/mysql/employees/departments.ibd	179181720
ℹ   +-- 10: /usr/share/percona-server/english/errmsg.sys	163072800
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	126115200
ℹ   +-- 12: /var/lib/mysql/#ib_16384_0.dblwr	79103880
ℹ   +-- 13: /var/lib/mysql/#innodb_temp/temp_10.ibt	26580240
ℹ   +-- 14: /var/lib/mysql/binlog.index	13885200
ℹ   +-- 15: /usr/share/percona-server/charsets/Index.xml	10283400
ℹ   +-- 16: /var/lib/mysql/binlog.000001	8331120
ℹ   +-- 17: /var/lib/mysql/auto.cnf	4426560
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp	0
ℹ   +-- 19: /var/lib/mysql/ibtmp1	0
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo106_tmp	0
ℹ  Performance schema: file per IO read latency execution time: 0.028s
 
-------- Performance schema: file per IO write latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	355740936012
ℹ   +-- 2: /var/lib/mysql/binlog.000003	86594120640
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	84282874812
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	73717665282
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	57416770908
ℹ   +-- 6: /var/lib/mysql/#ib_16384_0.dblwr	48495607686
ℹ   +-- 7: /var/lib/mysql/undo_002	31890796560
ℹ   +-- 8: /var/lib/mysql/undo_001	28352193012
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	17855315370
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo91	16584682284
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo102	16305502590
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo88	16241430222
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo94	15721274970
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo100	15418982682
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo86	15269210442
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo82	14979863232
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo83	14774153994
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo87	14674027086
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo89	14234010840
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo101	13874919210
ℹ  Performance schema: file per IO write latency execution time: 0.029s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	113114091
ℹ   +-- 2: innodb/innodb_data_file	29114368
ℹ   +-- 3: innodb/innodb_dblwr_file	8781824
ℹ   +-- 4: sql/ERRMSG	399123
ℹ   +-- 5: innodb/innodb_log_file	68096
ℹ   +-- 6: mysys/charset	19525
ℹ   +-- 7: innodb/innodb_temp_file	16384
ℹ   +-- 8: sql/binlog	360
ℹ   +-- 9: sql/binlog_index	176
ℹ   +-- 10: mysys/cnf	56
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: Event Wait by read bytes execution time: 0.030s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	372670464
ℹ   +-- 2: innodb/innodb_log_file	356756992
ℹ   +-- 3: innodb/innodb_dblwr_file	170246144
ℹ   +-- 4: sql/io_cache	108781190
ℹ   +-- 5: sql/binlog	66383262
ℹ   +-- 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.028s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	15731387565336
ℹ   +-- 2: innodb/innodb_data_file	12358894202226
ℹ   +-- 3: innodb/innodb_dblwr_file	9604142825490
ℹ   +-- 4: sql/binlog	1150337646774
ℹ   +-- 5: sql/io_cache	134395986672
ℹ   +-- 6: innodb/innodb_temp_file	108455055732
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: sql/pid	227905200
ℹ   +-- 10: sql/ERRMSG	186604560
ℹ   +-- 11: sql/misc	44046360
ℹ   +-- 12: mysys/charset	32343120
ℹ   +-- 13: mysys/cnf	21203640
ℹ  Performance schema: event per wait total latency execution time: 0.030s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	26484961950
ℹ   +-- 2: sql/io_cache	10745551134
ℹ   +-- 3: innodb/innodb_dblwr_file	3458980800
ℹ   +-- 4: sql/ERRMSG	163072800
ℹ   +-- 5: innodb/innodb_log_file	126115200
ℹ   +-- 6: sql/binlog_index	36477360
ℹ   +-- 7: innodb/innodb_temp_file	26580240
ℹ   +-- 8: mysys/charset	10283400
ℹ   +-- 9: sql/binlog	8331120
ℹ   +-- 10: mysys/cnf	4426560
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/misc	0
ℹ   +-- 13: sql/pid	0
ℹ  Performance schema: event per wait read latency execution time: 0.031s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	651425602896
ℹ   +-- 2: innodb/innodb_log_file	422787964860
ℹ   +-- 3: sql/io_cache	119641872258
ℹ   +-- 4: sql/binlog	86910410880
ℹ   +-- 5: innodb/innodb_dblwr_file	48968696286
ℹ   +-- 6: innodb/innodb_temp_file	1127279880
ℹ   +-- 7: sql/pid	19209600
ℹ   +-- 8: sql/binlog_index	0
ℹ   +-- 9: sql/casetest	0
ℹ   +-- 10: sql/ERRMSG	0
ℹ   +-- 11: sql/misc	0
ℹ   +-- 12: mysys/charset	0
ℹ   +-- 13: mysys/cnf	0
ℹ  Performance schema: event per wait write latency execution time: 0.030s
 
-------- 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.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.033s
 
-------- 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.029s
 
-------- 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.030s
 
-------- 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.031s
 
-------- 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.030s
 
-------- 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.032s
 
-------- 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.030s
 
-------- 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.031s
 
-------- Performance schema: Top 15 high insert latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	4623350328252
ℹ   +-- 2: employees	dept_emp	1477569796038
ℹ   +-- 3: employees	titles	1170140603130
ℹ   +-- 4: employees	employees	655020752616
ℹ   +-- 5: employees	dept_manager	172103400
ℹ   +-- 6: employees	departments	87873480
ℹ  Performance schema: Top 15 high insert latency tables execution time: 0.031s
 
-------- 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.031s
 
-------- 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.032s
 
-------- Performance schema: Redundant indexes -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Redundant indexes execution time: 0.031s
 
-------- 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.079s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	94846976
ℹ   +-- 2: employees	employees	8650752
ℹ   +-- 3: employees	titles	1032192
ℹ   +-- 4: employees	departments	32768
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.077s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	8072080
ℹ   +-- 2: employees	employees	693531
ℹ   +-- 3: employees	titles	111575
ℹ   +-- 4: employees	departments	32255
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.078s
 
-------- 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.030s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees`	2026-07-05 15:41:56.283555
ℹ   +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments`	2026-07-05 15:41:56.306044
ℹ   +-- 3: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.749603
ℹ   +-- 4: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.779797
ℹ   +-- 5: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.810156
ℹ   +-- 6: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.957130
ℹ   +-- 7: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.987663
ℹ   +-- 8: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:42:29.208309
ℹ  Performance schema: Latest SQL queries in errors or warnings execution time: 0.029s
 
-------- Performance schema: Top 20 queries with full table scans ----------------------------------
ℹ   +-- 1: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2
ℹ   +-- 2: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	2
ℹ   +-- 3: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	1
ℹ   +-- 4: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	1
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	1
ℹ   +-- 6: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 7: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	1
ℹ   +-- 8: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	1
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	1
ℹ   +-- 10: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	1
ℹ   +-- 11: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	1
ℹ   +-- 12: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...)	1
ℹ   +-- 13: NULL	SELECT SUM ( `TABLE_ROWS` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	1
ℹ   +-- 14: NULL	SELECT COUNT ( * ) FROM `performance_schema` . `error_log`	1
ℹ   +-- 15: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	1
ℹ   +-- 16: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	1
ℹ   +-- 17: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	1
ℹ   +-- 18: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	1
ℹ   +-- 19: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	1
ℹ   +-- 20: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	1
ℹ  Performance schema: Top 20 queries with full table scans execution time: 0.028s
 
-------- 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:42:30.894634
ℹ   +-- 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:42:30.866451
ℹ   +-- 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:42:30.837549
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:42:30.807133
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:42:30.728551
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:42:30.652040
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:42:30.573776
ℹ   +-- 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:42:30.080178
ℹ   +-- 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:42:30.052651
ℹ   +-- 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:42:29.965770
ℹ   +-- 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:42:29.935938
ℹ   +-- 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:42:29.908407
ℹ   +-- 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:42:29.850022
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:42:29.821077
ℹ   +-- 15: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:42:29.580420
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:42:29.545542
ℹ   +-- 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:42:29.507358
ℹ   +-- 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:42:29.475922
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:42:29.443028
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:42:29.398164
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:42:29.307399
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:42:29.208309
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:42:29.049915
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.987663
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.957130
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:42:28.925428
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:42:28.897431
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:42:28.868587
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:42:28.840582
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.810156
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.779797
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.749603
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.716828
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.686268
ℹ   +-- 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:42:28.654588
ℹ   +-- 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:42:28.627007
ℹ   +-- 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:42:28.599349
ℹ   +-- 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:42:28.570017
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.540822
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.509649
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.478609
ℹ   +-- 42: NULL	SELECT COUNT ( * ) FROM `information_schema` . `tables`	2026-07-05 15:42:28.359840
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:42:28.244945
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:42:28.126135
ℹ   +-- 45: NULL	SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:42:21.108268
ℹ   +-- 46: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:42:20.938131
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2026-07-05 15:42:20.904511
ℹ   +-- 48: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:42:20.764831
ℹ   +-- 49: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:42:20.702351
ℹ   +-- 50: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:42:20.642454
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.030s
 
-------- 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 `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	1
ℹ   +-- 4: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 5: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	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.037s
 
-------- 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 `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2
ℹ   +-- 5: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 6: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	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.039s
 
-------- Performance schema: Top 15 total latency queries (95% percentile) -------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	11965437816000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */	2762250421000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	2524458544000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */	1744021238000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 8: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.037s
 
-------- Performance schema: Top 15 max latency queries (95% percentile) ---------------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	525384142000
ℹ   +-- 2: employees	INSERT INTO `employees` VALUES (...) /* , ... */	344248815000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	340699368000
ℹ   +-- 4: employees	INSERT INTO `titles` VALUES (...) /* , ... */	323528181000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 8: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.036s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 4: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 5: employees	INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 8: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.037s
 
-------- 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.030s
 
-------- 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:42:31.138901
ℹ   +-- 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:42:30.923981
ℹ   +-- 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:42:30.894634
ℹ   +-- 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:42:30.866451
ℹ   +-- 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:42:30.837549
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:42:30.807133
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:42:30.728551
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:42:30.652040
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:42:30.573776
ℹ   +-- 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:42:30.080178
ℹ   +-- 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:42:30.052651
ℹ   +-- 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:42:29.965770
ℹ   +-- 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:42:29.935938
ℹ   +-- 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:42:29.908407
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:42:29.821077
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:42:29.580420
ℹ   +-- 17: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:42:29.545542
ℹ   +-- 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:42:29.507358
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:42:29.443028
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:42:29.398164
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:42:29.307399
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:42:29.208309
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:42:29.049915
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.987663
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.957130
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:42:28.925428
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:42:28.897431
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:42:28.868587
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:42:28.840582
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.810156
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.779797
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.749603
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.716828
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.686268
ℹ   +-- 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:42:28.654588
ℹ   +-- 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:42:28.627007
ℹ   +-- 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:42:28.599349
ℹ   +-- 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:42:28.570017
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.540822
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.509649
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.478609
ℹ   +-- 42: NULL	SHOW SCHEMAS	2026-07-05 15:42:28.416546
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:42:28.244945
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:42:20.764831
ℹ   +-- 45: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:42:20.702351
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:42:20.610688
ℹ   +-- 47: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:42:19.817699
ℹ   +-- 48: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	2026-07-05 15:42:19.788299
ℹ   +-- 49: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2026-07-05 15:42:19.470070
ℹ   +-- 50: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2026-07-05 15:42:18.862750
ℹ  Performance schema: Last 50 queries with sort execution time: 0.028s
 
-------- Performance schema: Top 15 row sorting queries with sort ----------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	6587
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	6581
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	6492
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	6426
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	6420
ℹ   +-- 6: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	161
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	120
ℹ   +-- 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 `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	50
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	32
ℹ   +-- 11: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	28
ℹ   +-- 12: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 13: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	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 `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	20
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.031s
 
-------- 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	146582405000
ℹ   +-- 2: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 3: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	48614695000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	46693081000
ℹ   +-- 7: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	29602835000
ℹ   +-- 8: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	28238058000
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	15993072000
ℹ   +-- 10: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	7742957000
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6110279000
ℹ   +-- 12: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	5942951000
ℹ   +-- 13: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	5820946000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	5744143000
ℹ   +-- 15: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	5492884000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.031s
 
-------- 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.031s
 
-------- 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.028s
 
-------- 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.030s
 
-------- 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.031s
 
-------- 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.029s
 
-------- 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:42:30.807133
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:42:30.728551
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:42:30.652040
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:42:30.573776
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:42:29.580420
ℹ   +-- 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:42:29.507358
ℹ   +-- 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:42:29.475922
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:42:29.443028
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:42:29.398164
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:42:29.307399
ℹ   +-- 11: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:42:29.208309
ℹ   +-- 12: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:42:29.049915
ℹ   +-- 13: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.987663
ℹ   +-- 14: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.957130
ℹ   +-- 15: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:42:28.925428
ℹ   +-- 16: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:42:28.897431
ℹ   +-- 17: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:42:28.868587
ℹ   +-- 18: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:42:28.840582
ℹ   +-- 19: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.810156
ℹ   +-- 20: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.779797
ℹ   +-- 21: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.749603
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:42:28.716828
ℹ   +-- 23: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:42:28.686268
ℹ   +-- 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:42:28.654588
ℹ   +-- 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:42:28.627007
ℹ   +-- 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:42:28.599349
ℹ   +-- 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:42:28.570017
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:42:28.540822
ℹ   +-- 29: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:42:28.509649
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:42:28.478609
ℹ   +-- 31: NULL	SELECT `sys_version` FROM `sys` . `version`	2026-07-05 15:42:28.445877
ℹ   +-- 32: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:42:28.244945
ℹ   +-- 33: NULL	SHOW SESSION STATUS LIKE ?	2026-07-05 15:42:28.156066
ℹ   +-- 34: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:42:20.938131
ℹ   +-- 35: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:42:20.702351
ℹ   +-- 36: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:42:20.642454
ℹ   +-- 37: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:42:20.610688
ℹ   +-- 38: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:42:20.433354
ℹ   +-- 39: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:42:20.374050
ℹ   +-- 40: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:42:20.285096
ℹ   +-- 41: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2026-07-05 15:42:20.251993
ℹ   +-- 42: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2026-07-05 15:42:20.162572
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2026-07-05 15:42:19.948666
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	2026-07-05 15:42:19.847524
ℹ   +-- 45: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:42:19.817699
ℹ   +-- 46: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	2026-07-05 15:42:19.788299
ℹ   +-- 47: NULL	SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA	2026-07-05 15:42:19.412669
ℹ   +-- 48: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2026-07-05 15:42:19.384558
ℹ   +-- 49: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2026-07-05 15:42:19.325976
ℹ   +-- 50: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_COLLAT	2026-07-05 15:42:19.270227
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.029s
 
-------- 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	146582405000
ℹ   +-- 2: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	71102433000
ℹ   +-- 3: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	61647499000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	50401098000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	48614695000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	46693081000
ℹ   +-- 7: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	29602835000
ℹ   +-- 8: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	28238058000
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	15993072000
ℹ   +-- 10: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6110279000
ℹ   +-- 11: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	5942951000
ℹ   +-- 12: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	5820946000
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	5744143000
ℹ   +-- 14: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	5492884000
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	4791805000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.030s
 
-------- 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.031s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919015
ℹ   +-- 2: wait/io/file	118732
ℹ   +-- 3: wait/lock/table	168
ℹ  Performance schema: Top 15 class events by number execution time: 0.034s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	3919015
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	78962
ℹ   +-- 3: wait/io/file/innodb/innodb_data_file	16337
ℹ   +-- 4: wait/io/file/sql/io_cache	9573
ℹ   +-- 5: wait/io/file/sql/binlog	8473
ℹ   +-- 6: wait/io/file/innodb/innodb_dblwr_file	5232
ℹ   +-- 7: wait/lock/table/sql/handler	168
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	82
ℹ   +-- 9: wait/io/file/sql/binlog_index	41
ℹ   +-- 10: wait/io/file/sql/casetest	10
ℹ   +-- 11: wait/io/file/sql/misc	6
ℹ   +-- 12: wait/io/file/sql/ERRMSG	5
ℹ   +-- 13: wait/io/file/mysys/cnf	5
ℹ   +-- 14: wait/io/file/sql/pid	3
ℹ   +-- 15: wait/io/file/mysys/charset	3
ℹ  Performance schema: Top 30 events by number execution time: 0.035s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/file	39153902143662
ℹ   +-- 2: wait/io/table	7926341456916
ℹ   +-- 3: wait/lock/table	513783720
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.038s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	15731387565336
ℹ   +-- 2: wait/io/file/innodb/innodb_data_file	12358918068066
ℹ   +-- 3: wait/io/file/innodb/innodb_dblwr_file	9604142825490
ℹ   +-- 4: wait/io/table/sql/handler	7926341456916
ℹ   +-- 5: wait/io/file/sql/binlog	1150337646774
ℹ   +-- 6: wait/io/file/sql/io_cache	172985807592
ℹ   +-- 7: wait/io/file/innodb/innodb_temp_file	131886400680
ℹ   +-- 8: wait/io/file/sql/binlog_index	2440946124
ℹ   +-- 9: wait/io/file/sql/casetest	1290780720
ℹ   +-- 10: wait/lock/table/sql/handler	513783720
ℹ   +-- 11: wait/io/file/sql/pid	227905200
ℹ   +-- 12: wait/io/file/sql/ERRMSG	186604560
ℹ   +-- 13: wait/io/file/sql/misc	44046360
ℹ   +-- 14: wait/io/file/mysys/charset	32343120
ℹ   +-- 15: wait/io/file/mysys/cnf	21203640
ℹ  Performance schema: Top 30 events by total latency execution time: 0.032s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/table	68907554298
ℹ   +-- 2: wait/io/file	56671552746
ℹ   +-- 3: wait/lock/table	5303520
ℹ  Performance schema: Top 15 class events by max latency execution time: 0.033s
 
-------- Performance schema: Top 30 events by max latency ------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	68907554298
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	56671552746
ℹ   +-- 3: wait/io/file/innodb/innodb_dblwr_file	30125925522
ℹ   +-- 4: wait/io/file/innodb/innodb_data_file	25383956418
ℹ   +-- 5: wait/io/file/sql/binlog	16887608280
ℹ   +-- 6: wait/io/file/innodb/innodb_temp_file	15495414966
ℹ   +-- 7: wait/io/file/sql/io_cache	1932736320
ℹ   +-- 8: wait/io/file/sql/binlog_index	1276989480
ℹ   +-- 9: wait/io/file/sql/casetest	1172046600
ℹ   +-- 10: wait/io/file/sql/pid	202358520
ℹ   +-- 11: wait/io/file/sql/ERRMSG	142067520
ℹ   +-- 12: wait/io/file/mysys/charset	18572760
ℹ   +-- 13: wait/io/file/sql/misc	16108920
ℹ   +-- 14: wait/io/file/mysys/cnf	13530240
ℹ   +-- 15: wait/lock/table/sql/handler	5303520
ℹ  Performance schema: Top 30 events by max latency execution time: 0.032s
 
-------- 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 ---------------------------------------------------------------
✘  Found 4 potential migration risks.
ℹ   - [Migration Risk] default_authentication_plugin: Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead.
ℹ   - [Migration Risk] binlog_transaction_dependency_tracking: Removed in MySQL 8.4.
ℹ   - [Migration Risk] avoid_temporal_upgrade: Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade.
ℹ   - [Migration Risk] expire_logs_days: Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
ℹ  InnoDB Buffers
ℹ   +-- InnoDB Buffer Pool: 128.0M
ℹ   +-- InnoDB Buffer Pool Instances: 1
ℹ   +-- InnoDB Buffer Pool Chunk Size: 128.0M
ℹ   +-- InnoDB Redo Log Capacity: 100.0M
ℹ   +-- InnoDB Log Buffer: 16.0M
ℹ   +-- InnoDB Buffer Free: 1011B
ℹ   +-- 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% (20545523 hits / 20546795 total)
✔  InnoDB Write Log efficiency: 99.11% (8110622 hits / 8183382 total)
✔  InnoDB log waits: 0.00% (0 waits / 72760 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.029s
 
-------- 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.5G (Theoretical max usage is 11.49% of physical RAM)
ℹ  Growth forecasting: Insufficient uptime (< 24h) for reliable estimation.
ℹ  Predictive Capacity Planning execution time: 0.000s
 
-------- Cluster & Replication Intelligence --------------------------------------------------------
ℹ  Replication status: Not running as a replica.
✘  gtid_mode is OFF (recommended: ON)
✘  enforce_gtid_consistency is OFF (recommended: ON)
✘  binlog_transaction_dependency_tracking is set to COMMIT_ORDER (recommended: WRITESET for parallel throughput)
ℹ  binlog_transaction_compression is OFF (consider setting to ON to save network/disk space)
✘  Binlog cache disk use ratio is 48.40% (too many disk spills)
✘  source_verify_checksum is disabled (recommended: ON)
ℹ  Cluster & Replication Intelligence execution time: 0.000s
 
-------- Security Hardening 2.0 --------------------------------------------------------------------
ℹ  TLS/SSL is enabled. Minimum supported TLS version: TLSv1.2,TLSv1.3
ℹ  Security Hardening 2.0 execution time: 0.000s
 
-------- Guided Auto-Fix Snippets ------------------------------------------------------------------
Ready-to-Apply SQL Snippets (SET GLOBAL):
    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: 85/100
    - Performance: 40/40
    - Security:    20/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)
    22 CVE(s) found for your MySQL release. Consider upgrading your version !
    MySQL was started within the last 24 hours: recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size
    Increase binlog_cache_size (current value: 32768)
    Unused indexes found: 2 index(es) should be reviewed and potentially removed.
    Migration Risk (default_authentication_plugin): Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead.
    Migration Risk (binlog_transaction_dependency_tracking): Removed in MySQL 8.4.
    Migration Risk (avoid_temporal_upgrade): Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade.
    Migration Risk (expire_logs_days): Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
    Set gtid_mode = ON to enable global transaction identifier replication.
    Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
    Set binlog_transaction_dependency_tracking = WRITESET to improve parallel replication throughput.
    Enable binlog_transaction_compression = ON to reduce replication stream size.
    Increase binlog_cache_size to reduce disk spills for binary log transactions.
    Enable source_verify_checksum = ON (or master_verify_checksum).
Variables to adjust:
    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	1795.81 MB (3% of RAM)
Maximum Memory Used	501.87 MB
OS & System Recommendations

•Consider stopping or dedicate server for additional process other than mysqld (other processes use 16.01% 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.24%
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.
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 16.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	1011 pages (15.8M)
InnoDB Buffer Pool Used Pages	7181 pages (112.2M)
InnoDB Thread Concurrency	0
InnoDB Read Efficiency	99.99% (hit rate)
Total InnoDB OS Log Written	308.6M (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)	3
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	3918131	26.1M	5.5M	31.6M
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.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.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_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.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.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.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.employees: Plural name detected (prefer singular)
•Table employees.departments: Plural name detected (prefer singular)
•Table employees.titles: Plural name detected (prefer singular)
•Table employees.salaries: Plural name detected (prefer singular)
•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
