MySQLTuner Audit Report

 >>  MySQLTuner 2.9.0
	 * Jean-Marie Renouard <jmrenouard@gmail.com>
	 * Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.pl/
 >>  Run with '--help' for additional options and output filtering
 >>  Started at: 2026-07-05 17:44:34
ℹ  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:44:34
ℹ  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    : 2m 48s
✔  Operating on 64-bit architecture
ℹ  Audit Snapshot Summary execution time: 0.182s
 
-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ  Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM -ndbcluster -ndbinfo +PERFORMANCE_SCHEMA 
ℹ  Data in InnoDB tables: 146.8M (Tables: 7)
✔  Total fragmented tables: 0
 
✔  Currently running supported MySQL/MariaDB version 8.0.45(LTS)
ℹ  Storage Engine Statistics execution time: 0.183s
 
-------- 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        3616        9948           4        2310       12014
ℹ  	Swap:           4096           0        4096
ℹ  Load Average          : 
ℹ  	top - 17:44:35 up 4 days,  5:15,  1 user,  load average: 1.34, 1.33, 0.77
ℹ  System Uptime         : 
ℹ  	 17:44:35 up 4 days,  5:15,  1 user,  load average: 1.34, 1.33, 0.77
ℹ  Database Uptime       : 2m 48s
✔  There is at least one CPU dedicated to database server.
✔  There is at least 1.5 Gb of RAM dedicated to Linux server.
ℹ  User process except mysqld used 2G RAM.
✘  Other user process except mysqld used more than 15% of total physical memory 17.46% (2G / 15G)
ℹ  System Linux Recommendations execution time: 0.762s
 
-------- 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.85 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.070s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Performance Schema error_log table detected
ℹ  Performance Schema error_log: 12 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.059s
 
-------- 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  : 3911391
ℹ   +-- DATA  : 141.2M(96.22%)
ℹ   +-- INDEX : 5.5M(3.78%)
ℹ   +-- SIZE  : 146.8M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_0900_ai_ci)
ℹ   +-- ROWS  : 3911391
ℹ   +-- DATA  : 141.2M(96.22%)
ℹ   +-- INDEX : 5.5M(3.78%)
ℹ   +-- TOTAL : 146.8M
ℹ   +-- 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.580s
 
-------- 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
ℹ  Schema documentation for employees generated in /home/jmren/GIT_REPOS/MySQLTuner-perl/examples/20260705_174129_percona80/Schemadir/schemas/employees.md
ℹ  Table Column Metrics execution time: 0.440s
 
-------- 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.122s
 
-------- 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.096s
 
-------- MySQL 8.0+ Specific Modeling --------------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MySQL 8.0+ Specific Modeling execution time: 0.094s
 
-------- Data Type optimization --------------------------------------------------------------------
✔  No data type optimization recommendations
ℹ  Data Type optimization execution time: 0.030s
 
-------- Schema sanitization -----------------------------------------------------------------------
✔  No empty or view-only schemas detected
ℹ  Schema sanitization execution time: 0.033s
 
-------- 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     : 442189 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     : 2838426 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     : 2838426 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     : 442189 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     : 442189 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.156s
 
-------- 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: 9.046s
 
-------- Authentication Plugin Security ------------------------------------------------------------
✔  No users found using insecure or deprecated authentication plugins
ℹ  Authentication Plugin Security execution time: 0.030s
 
-------- 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.093s
 
-------- 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.031s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 2m 48s (2K q [17.095 qps], 1K conn, TX: 9M, RX: 164M)
ℹ  Reads / Writes: 88% / 12%
ℹ  Binary logging is enabled (GTID MODE: OFF)
ℹ  Physical Memory     : 15.3G
ℹ  Max MySQL memory    : 1.8G
ℹ  Other process memory: 2.7G
ℹ  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: 538.5M (3.44% 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/2K)
✔  Highest usage of available connections: 1% (3/151)
✘  Aborted connections: 24.78% (303/1223)
ℹ  Query cache has been removed since MySQL 8.0
✘  Sorts requiring temporary tables: 15% (116 temp sorts / 772 sorts)
✘  Joins performed without indexes: 260
✔  Temporary tables created on disk: 2% (30 on disk / 1K total)
✔  temptable_max_mmap (1.0G) is compatible with available disk space on /tmp (823.8G)
✔  Thread cache hit rate: 99% (3 created / 1K connections)
✔  Table cache hit rate: 90% (13K hits / 15K requests)
✔  table_definition_cache (2000) is greater than number of tables (349)
✔  Open file limit used: 0% (6/8K)
✔  Table locks acquired immediately: 100% (873 immediate / 873 locks)
✘  Binlog cache memory access: 6.21% (11 Memory / 177 Total)
ℹ  Performance Metrics execution time: 0.132s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 332.7M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 2.1.3
ℹ  Performance schema execution time: 0.096s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	2221 conn(s)
ℹ   +-- 2: background	13 conn(s)
ℹ   +-- 3: event_scheduler	1 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.039s
 
-------- Performance schema: Top 5 user per statement ----------------------------------------------
ℹ   +-- 1: root	6186 stmt(s)
ℹ   +-- 2: background	0 stmt(s)
ℹ   +-- 3: event_scheduler	0 stmt(s)
ℹ  Performance schema: Top 5 user per statement execution time: 0.038s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	7385052504.6850
ℹ   +-- 2: background	0.0000
ℹ   +-- 3: event_scheduler	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.037s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	5387000000
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.032s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	764
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.032s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	68220
ℹ   +-- 2: background	0
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.033s
 
-------- 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.033s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: background	100898
ℹ   +-- 2: root	59156
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO execution time: 0.036s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: background	37604822841522
ℹ   +-- 2: root	7739769581424
ℹ   +-- 3: event_scheduler	0
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.036s
 
-------- Performance schema: Top 5 host per connection ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	1725 conn(s)
ℹ   +-- 2: localhost	506 conn(s)
ℹ  Performance schema: Top 5 host per connection execution time: 0.036s
 
-------- Performance schema: Top 5 host per statement ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	2413 stmt(s)
ℹ   +-- 2: localhost	1396 stmt(s)
ℹ  Performance schema: Top 5 host per statement execution time: 0.036s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	9180300591.3043
ℹ   +-- 2: localhost	1020144905.4441
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.035s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	4762000000
ℹ   +-- 2: localhost	648000000
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.034s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	632
ℹ   +-- 2: localhost	141
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.035s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	64199
ℹ   +-- 2: localhost	4045
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.034s
 
-------- Performance schema: Top 5 host per rows modified ------------------------------------------
ℹ   +-- 1: 172.18.0.2	3919016
ℹ   +-- 2: localhost	0
ℹ   +-- 3: background	0
ℹ  Performance schema: Top 5 host per rows modified execution time: 0.033s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	24702
ℹ   +-- 2: localhost	9752
ℹ  Performance schema: Top 5 host per io execution time: 0.036s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	3517692096456
ℹ   +-- 2: localhost	704385388512
ℹ  Performance schema: Top 5 host per io latency execution time: 0.036s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	79481 i/o
ℹ   +-- 2: sql/io_cache	19208 i/o
ℹ   +-- 3: innodb/innodb_data_file	17672 i/o
ℹ   +-- 4: sql/binlog	8473 i/o
ℹ   +-- 5: innodb/innodb_dblwr_file	5420 i/o
ℹ   +-- 6: innodb/innodb_temp_file	138 i/o
ℹ   +-- 7: sql/binlog_index	41 i/o
ℹ   +-- 8: sql/casetest	10 i/o
ℹ   +-- 9: csv/metadata	8 i/o
ℹ   +-- 10: sql/misc	6 i/o
ℹ   +-- 11: sql/ERRMSG	5 i/o
ℹ   +-- 12: mysys/cnf	5 i/o
ℹ   +-- 13: csv/data	4 i/o
ℹ   +-- 14: sql/pid	3 i/o
ℹ   +-- 15: mysys/charset	3 i/o
ℹ  Performance schema: Top IO type order by total io execution time: 0.037s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	16343994885660
ℹ   +-- 2: innodb/innodb_data_file	12687281235774
ℹ   +-- 3: innodb/innodb_dblwr_file	9995594490900
ℹ   +-- 4: sql/binlog	1150337646774
ℹ   +-- 5: innodb/innodb_temp_file	979144678980
ℹ   +-- 6: sql/io_cache	313521280038
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: csv/metadata	617125104
ℹ   +-- 10: sql/pid	227905200
ℹ   +-- 11: sql/ERRMSG	186604560
ℹ   +-- 12: csv/data	55989720
ℹ   +-- 13: sql/misc	44046360
ℹ   +-- 14: mysys/charset	32343120
ℹ   +-- 15: 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	71209415088
ℹ   +-- 2: innodb/innodb_dblwr_file	66975251760
ℹ   +-- 3: innodb/innodb_temp_file	61216977366
ℹ   +-- 4: innodb/innodb_data_file	25383956418
ℹ   +-- 5: sql/binlog	16887608280
ℹ   +-- 6: sql/io_cache	1932736320
ℹ   +-- 7: sql/binlog_index	1276989480
ℹ   +-- 8: sql/casetest	1172046600
ℹ   +-- 9: csv/metadata	291710304
ℹ   +-- 10: sql/pid	202358520
ℹ   +-- 11: sql/ERRMSG	142067520
ℹ   +-- 12: csv/data	24419160
ℹ   +-- 13: mysys/charset	18572760
ℹ   +-- 14: sql/misc	16108920
ℹ   +-- 15: mysys/cnf	13530240
ℹ  Performance schema: Top IO type order by max latency execution time: 0.034s
 
-------- 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.034s
 
-------- 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.036s
 
-------- 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.038s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	643
ℹ   +-- 2: localhost	282
ℹ  Performance schema: Top 5 host per table scans execution time: 0.037s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	91897856	83963997	5609 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.107s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	84819968	77501168	5177 page(s)
ℹ   +-- 2: employees	employees	6045696	5542212	369 page(s)
ℹ   +-- 3: employees	titles	1032192	920617	63 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.104s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: innodb/dict_stats_thread	NULL	182
ℹ   +-- 2: innodb/fts_optimize_thread	NULL	182
ℹ   +-- 3: innodb/page_flush_coordinator_thread	NULL	182
ℹ   +-- 4: innodb/srv_master_thread	NULL	182
ℹ   +-- 5: sql/main	NULL	181
ℹ   +-- 6: innodb/clone_gtid_thread	NULL	181
ℹ   +-- 7: innodb/srv_purge_thread	NULL	181
ℹ   +-- 8: innodb/srv_worker_thread	NULL	181
ℹ   +-- 9: innodb/srv_worker_thread	NULL	181
ℹ   +-- 10: innodb/srv_worker_thread	NULL	181
ℹ   +-- 11: sql/event_scheduler	Daemon	181
ℹ   +-- 12: sql/compress_gtid_table	Daemon	181
ℹ   +-- 13: root@172.18.0.2	Query	0
ℹ   +-- 14: root@172.18.0.2	Sleep	0
ℹ   +-- 15: innodb/srv_lock_timeout_thread	NULL	NULL
ℹ   +-- 16: innodb/log_files_governor_thread	NULL	NULL
ℹ   +-- 17: innodb/log_writer_thread	NULL	NULL
ℹ   +-- 18: innodb/log_write_notifier_thread	NULL	NULL
ℹ   +-- 19: innodb/log_flusher_thread	NULL	NULL
ℹ   +-- 20: innodb/log_flush_notifier_thread	NULL	NULL
ℹ   +-- 21: innodb/log_checkpointer_thread	NULL	NULL
ℹ   +-- 22: innodb/srv_monitor_thread	NULL	NULL
ℹ   +-- 23: innodb/buf_resize_thread	NULL	NULL
ℹ   +-- 24: innodb/io_write_thread	NULL	NULL
ℹ   +-- 25: innodb/io_write_thread	NULL	NULL
ℹ   +-- 26: innodb/io_write_thread	NULL	NULL
ℹ   +-- 27: innodb/io_write_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_read_thread	NULL	NULL
ℹ   +-- 32: innodb/io_ibuf_thread	NULL	NULL
ℹ   +-- 33: innodb/buf_lru_manager_thread	NULL	NULL
ℹ   +-- 34: innodb/srv_error_monitor_thread	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.046s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.034s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: log_flusher_thread	13682853046476	71209415088
ℹ   +-- 2: page_flush_coordinator_thread	10464851719998	66975251760
ℹ   +-- 3: io_write_thread	2760731758476	16996940136
ℹ   +-- 4: io_write_thread	2646515883600	18588747294
ℹ   +-- 5: io_write_thread	2640076971840	10456317720
ℹ   +-- 6: io_write_thread	2590517296386	23521438494
ℹ   +-- 7: log_writer_thread	1658594597292	30150371304
ℹ   +-- 8: log_files_governor_thread	705493964610	10509953742
ℹ   +-- 9: log_checkpointer_thread	209242308870	42166775286
ℹ   +-- 10: buf_lru_manager_thread	44318170098	12049785360
ℹ   +-- 11: main	9038972880	2522867760
ℹ   +-- 12: buf_dump_thread	5305367880	173481480
ℹ   +-- 13: srv_purge_thread	1504706760	64686240
ℹ   +-- 14: dict_stats_thread	667356120	111582720
ℹ   +-- 15: clone_gtid_thread	223938000	192837240
ℹ   +-- 16: srv_worker_thread	48639960	48639960
ℹ  Performance schema: Thread IO Latency execution time: 0.032s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: SELECT * FROM `information_schema` . `STATISTICS` LIMIT ?	302596866000
ℹ   +-- 2: SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	203410445000
ℹ   +-- 3: INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 4: INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 5: INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 6: INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 7: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	72332299000
ℹ   +-- 8: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	64354874000
ℹ   +-- 9: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 10: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	56011476000
ℹ   +-- 11: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 12: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	51078967000
ℹ   +-- 13: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ   +-- 14: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	48113811000
ℹ   +-- 15: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	47819706000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.033s
 
-------- 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	4 s
ℹ   +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	4 s
ℹ   +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	4 s
ℹ   +-- 8: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	3 s
ℹ   +-- 9: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	3 s
ℹ   +-- 10: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	3 s
ℹ   +-- 11: DROP SCHEMA IF EXISTS `employees`	1 s
ℹ   +-- 12: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	1 s
ℹ   +-- 13: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	1 s
ℹ   +-- 14: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	1 s
ℹ   +-- 15: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	1 s
ℹ  Performance schema: Top 15 slower queries execution time: 0.070s
 
-------- Performance schema: Top 15 nb statement type ----------------------------------------------
ℹ   +-- 1: select	1478
ℹ   +-- 2: Quit	1040
ℹ   +-- 3: Init DB	278
ℹ   +-- 4: insert	168
ℹ   +-- 5: set_option	65
ℹ   +-- 6: show_engine_status	24
ℹ   +-- 7: show_create_table	16
ℹ   +-- 8: stmt	15
ℹ   +-- 9: show_status	12
ℹ   +-- 10: show_variables	11
ℹ   +-- 11: show_databases	9
ℹ   +-- 12: create_table	6
ℹ   +-- 13: show_tables	5
ℹ   +-- 14: truncate	4
ℹ   +-- 15: show_storage_engines	4
ℹ  Performance schema: Top 15 nb statement type execution time: 0.031s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	19015621905000
ℹ   +-- 2: select	3629356933000
ℹ   +-- 3: create_table	291574219000
ℹ   +-- 4: create_view	29234418000
ℹ   +-- 5: Init DB	28782384000
ℹ   +-- 6: drop_db	18940195000
ℹ   +-- 7: show_variables	17706240000
ℹ   +-- 8: flush	15605007000
ℹ   +-- 9: show_status	12776278000
ℹ   +-- 10: create_db	11178662000
ℹ   +-- 11: Quit	7692955000
ℹ   +-- 12: show_databases	7322610000
ℹ   +-- 13: set_option	6511048000
ℹ   +-- 14: drop_table	5240980000
ℹ   +-- 15: show_engine_status	4788392000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.032s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: select	4145000000
ℹ   +-- 2: insert	925000000
ℹ   +-- 3: create_table	177000000
ℹ   +-- 4: show_databases	36000000
ℹ   +-- 5: truncate	27000000
ℹ   +-- 6: show_variables	27000000
ℹ   +-- 7: show_status	26000000
ℹ   +-- 8: create_view	24000000
ℹ   +-- 9: show_tables	17000000
ℹ   +-- 10: show_create_table	14000000
ℹ   +-- 11: drop_table	14000000
ℹ   +-- 12: lock_tables	8000000
ℹ   +-- 13: create_db	5000000
ℹ   +-- 14: show_storage_engines	4000000
ℹ   +-- 15: Init DB	3000000
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.032s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	759
ℹ   +-- 2: show_status	12
ℹ   +-- 3: show_variables	11
ℹ   +-- 4: show_databases	9
ℹ   +-- 5: show_storage_engines	4
ℹ   +-- 6: truncate	0
ℹ   +-- 7: show_engine_status	0
ℹ   +-- 8: show_slave_status	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: show_slave_hosts	0
ℹ   +-- 11: Quit	0
ℹ   +-- 12: Init DB	0
ℹ   +-- 13: Statistics	0
ℹ   +-- 14: create_table	0
ℹ   +-- 15: insert	0
ℹ  Performance schema: Top 15 statement by full scans execution time: 0.033s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: select	58038
ℹ   +-- 2: show_variables	5643
ℹ   +-- 3: show_status	4368
ℹ   +-- 4: show_tables	319
ℹ   +-- 5: show_databases	45
ℹ   +-- 6: show_storage_engines	44
ℹ   +-- 7: show_fields	7
ℹ   +-- 8: truncate	0
ℹ   +-- 9: show_engine_status	0
ℹ   +-- 10: show_slave_status	0
ℹ   +-- 11: show_grants	0
ℹ   +-- 12: Ping	0
ℹ   +-- 13: Quit	0
ℹ   +-- 14: Init DB	0
ℹ   +-- 15: Statistics	0
ℹ  Performance schema: Top 15 statement by rows sent execution time: 0.032s
 
-------- Performance schema: Top 15 statement by rows modified -------------------------------------
ℹ   +-- 1: insert	3919015
ℹ   +-- 2: create_db	1
ℹ   +-- 3: select	0
ℹ   +-- 4: truncate	0
ℹ   +-- 5: show_databases	0
ℹ   +-- 6: show_variables	0
ℹ   +-- 7: show_status	0
ℹ   +-- 8: show_engine_status	0
ℹ   +-- 9: show_slave_status	0
ℹ   +-- 10: show_grants	0
ℹ   +-- 11: show_slave_hosts	0
ℹ   +-- 12: show_storage_engines	0
ℹ   +-- 13: Quit	0
ℹ   +-- 14: Init DB	0
ℹ   +-- 15: Statistics	0
ℹ  Performance schema: Top 15 statement by rows modified execution time: 0.034s
 
-------- Performance schema: 15 sample queries using temp table ------------------------------------
ℹ   +-- 1: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER
ℹ   +-- 2: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch
ℹ   +-- 3: SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P
ℹ   +-- 4: SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?
ℹ   +-- 5: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER
ℹ   +-- 6: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 
ℹ   +-- 7: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in
ℹ   +-- 8: SELECT `thread` , FILE , `latency` , `operation` FROM `sys` . `x$latest_file_io` ORDER BY `latency` LIMIT ?
ℹ   +-- 9: SELECT * FROM `information_schema` . `PLUGINS` LIMIT ?
ℹ   +-- 10: SELECT * FROM `information_schema` . `OPTIMIZER_TRACE` LIMIT ?
ℹ   +-- 11: SELECT * FROM `information_schema` . `INNODB_COLUMNS` LIMIT ?
ℹ   +-- 12: SELECT * FROM `sys` . `x$latest_file_io` LIMIT ?
ℹ   +-- 13: SELECT * FROM `information_schema` . `PROCESSLIST` LIMIT ?
ℹ   +-- 14: SELECT * FROM `sys` . `latest_file_io` LIMIT ?
ℹ   +-- 15: SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?
ℹ  Performance schema: 15 sample queries using temp table execution time: 0.033s
 
-------- 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.034s
 
-------- Performance schema: Tables with full table scans ------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Tables with full table scans execution time: 0.033s
 
-------- Performance schema: Latest File IO by latency ---------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Latest File IO by latency execution time: 0.034s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/mysql.ibd	16711680
ℹ   +-- 2: /var/lib/mysql/undo_001	8912896
ℹ   +-- 3: /var/lib/mysql/#ib_16384_1.dblwr	8585216
ℹ   +-- 4: /var/lib/mysql/undo_002	8077312
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	4980736
ℹ   +-- 6: /var/lib/mysql/ibtmp1	2097152
ℹ   +-- 7: /var/lib/mysql/employees/titles.ibd	1064960
ℹ   +-- 8: /usr/share/percona-server/english/errmsg.sys	399123
ℹ   +-- 9: /var/lib/mysql/ibdata1	229376
ℹ   +-- 10: /var/lib/mysql/#ib_16384_0.dblwr	196608
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	68096
ℹ   +-- 12: /var/lib/mysql/employees/departments.ibd	65536
ℹ   +-- 13: /var/lib/mysql/sys/sys_config.ibd	65536
ℹ   +-- 14: /var/lib/mysql/employees/salaries.ibd	32768
ℹ   +-- 15: /usr/share/percona-server/charsets/Index.xml	19525
ℹ  Performance schema: File by IO read bytes execution time: 0.030s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	209158144
ℹ   +-- 2: /var/lib/mysql/#ib_16384_0.dblwr	175734784
ℹ   +-- 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/undo_002	11911168
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo86	11753472
ℹ   +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo83	11664896
ℹ   +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo88	11654656
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo82	11654656
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo89	11650560
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo85	11649024
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo87	11622912
ℹ  Performance schema: File by IO written bytes execution time: 0.032s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/#ib_16384_0.dblwr	9950341620816
ℹ   +-- 2: /var/lib/mysql/employees/salaries.ibd	6229236970998
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	1610354013750
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	1376463717306
ℹ   +-- 5: /var/lib/mysql/employees/employees.ibd	1284889596084
ℹ   +-- 6: /var/lib/mysql/#innodb_redo/#ib_redo103	1202712483366
ℹ   +-- 7: /var/lib/mysql/binlog.000003	1099078248492
ℹ   +-- 8: /var/lib/mysql/undo_002	1056677043006
ℹ   +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	1041796022562
ℹ   +-- 10: /var/lib/mysql/#innodb_temp/temp_10.ibt	896742740340
ℹ   +-- 11: /var/lib/mysql/undo_001	896510502018
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo82	754629085458
ℹ   +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo91	698565002382
ℹ   +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo88	530572962078
ℹ   +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo86	519282336456
ℹ   +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo102	510819841062
ℹ   +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo87	510054959682
ℹ   +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo89	502920618642
ℹ   +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo94	498581051508
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo96	495948025044
ℹ  Performance schema: File per IO total latency execution time: 0.031s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/undo_002	9740278314
ℹ   +-- 2: /var/lib/mysql/mysql.ibd	8956448856
ℹ   +-- 3: /var/lib/mysql/undo_001	8339075802
ℹ   +-- 4: /var/lib/mysql/#ib_16384_1.dblwr	3379876920
ℹ   +-- 5: /var/lib/mysql/ibtmp1	853741440
ℹ   +-- 6: /var/lib/mysql/sys/sys_config.ibd	426708378
ℹ   +-- 7: /var/lib/mysql/employees/employees.ibd	412515720
ℹ   +-- 8: /var/lib/mysql/ibdata1	372092040
ℹ   +-- 9: /var/lib/mysql/employees/titles.ibd	181593360
ℹ   +-- 10: /var/lib/mysql/employees/departments.ibd	179181720
ℹ   +-- 11: /usr/share/percona-server/english/errmsg.sys	163072800
ℹ   +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp	126115200
ℹ   +-- 13: /var/lib/mysql/#ib_16384_0.dblwr	79103880
ℹ   +-- 14: /var/lib/mysql/employees/salaries.ibd	28344600
ℹ   +-- 15: /var/lib/mysql/#innodb_temp/temp_9.ibt	26622000
ℹ   +-- 16: /var/lib/mysql/#innodb_temp/temp_10.ibt	26580240
ℹ   +-- 17: /var/lib/mysql/binlog.index	13885200
ℹ   +-- 18: /var/lib/mysql/mysql/general_log.CSM	12507120
ℹ   +-- 19: /usr/share/percona-server/charsets/Index.xml	10283400
ℹ   +-- 20: /var/lib/mysql/binlog.000001	8331120
ℹ  Performance schema: file per IO read latency execution time: 0.033s
 
-------- 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	50145006582
ℹ   +-- 7: /var/lib/mysql/undo_002	40606395660
ℹ   +-- 8: /var/lib/mysql/undo_001	35822624796
ℹ   +-- 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_redo103	14567352732
ℹ   +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo89	14234010840
ℹ  Performance schema: file per IO write latency execution time: 0.034s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	517780851
ℹ   +-- 2: innodb/innodb_data_file	42237952
ℹ   +-- 3: innodb/innodb_dblwr_file	8781824
ℹ   +-- 4: sql/ERRMSG	399123
ℹ   +-- 5: innodb/innodb_log_file	68096
ℹ   +-- 6: innodb/innodb_temp_file	32768
ℹ   +-- 7: mysys/charset	19525
ℹ   +-- 8: sql/binlog	360
ℹ   +-- 9: sql/binlog_index	176
ℹ   +-- 10: csv/metadata	70
ℹ   +-- 11: mysys/cnf	56
ℹ   +-- 12: sql/casetest	0
ℹ   +-- 13: sql/misc	0
ℹ   +-- 14: sql/pid	0
ℹ   +-- 15: csv/data	0
ℹ  Performance schema: Event Wait by read bytes execution time: 0.031s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: sql/io_cache	473077402
ℹ   +-- 2: innodb/innodb_data_file	378568704
ℹ   +-- 3: innodb/innodb_log_file	357050880
ℹ   +-- 4: innodb/innodb_dblwr_file	176144384
ℹ   +-- 5: sql/binlog	66383262
ℹ   +-- 6: innodb/innodb_temp_file	3588096
ℹ   +-- 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
ℹ   +-- 14: csv/metadata	0
ℹ   +-- 15: csv/data	0
ℹ  Performance schema: Event Wait written bytes execution time: 0.030s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_log_file	16343994885660
ℹ   +-- 2: innodb/innodb_data_file	12686798897334
ℹ   +-- 3: innodb/innodb_dblwr_file	9995594490900
ℹ   +-- 4: innodb/innodb_temp_file	1154544312708
ℹ   +-- 5: sql/binlog	1150337646774
ℹ   +-- 6: sql/io_cache	346780613394
ℹ   +-- 7: sql/binlog_index	2440946124
ℹ   +-- 8: sql/casetest	1290780720
ℹ   +-- 9: csv/metadata	617125104
ℹ   +-- 10: sql/pid	227905200
ℹ   +-- 11: sql/ERRMSG	186604560
ℹ   +-- 12: csv/data	55989720
ℹ   +-- 13: sql/misc	44046360
ℹ   +-- 14: mysys/charset	32343120
ℹ   +-- 15: mysys/cnf	21203640
ℹ  Performance schema: event per wait total latency execution time: 0.031s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: sql/io_cache	36648700236
ℹ   +-- 2: innodb/innodb_data_file	29489980230
ℹ   +-- 3: innodb/innodb_dblwr_file	3458980800
ℹ   +-- 4: sql/ERRMSG	163072800
ℹ   +-- 5: innodb/innodb_log_file	126115200
ℹ   +-- 6: innodb/innodb_temp_file	53202240
ℹ   +-- 7: sql/binlog_index	36477360
ℹ   +-- 8: csv/metadata	20556360
ℹ   +-- 9: mysys/charset	10283400
ℹ   +-- 10: sql/binlog	8331120
ℹ   +-- 11: mysys/cnf	4426560
ℹ   +-- 12: sql/casetest	0
ℹ   +-- 13: sql/misc	0
ℹ   +-- 14: sql/pid	0
ℹ   +-- 15: csv/data	0
ℹ  Performance schema: event per wait read latency execution time: 0.034s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	668081089260
ℹ   +-- 2: innodb/innodb_log_file	425422944126
ℹ   +-- 3: sql/io_cache	278011296180
ℹ   +-- 4: sql/binlog	86910410880
ℹ   +-- 5: innodb/innodb_dblwr_file	50618095182
ℹ   +-- 6: innodb/innodb_temp_file	3726349200
ℹ   +-- 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
ℹ   +-- 14: csv/metadata	0
ℹ   +-- 15: csv/data	0
ℹ  Performance schema: event per wait write latency execution time: 0.033s
 
-------- 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.031s
 
-------- Performance schema: Top 15 most modified indexes ------------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 most modified indexes execution time: 0.032s
 
-------- Performance schema: Top 15 high read latency index ----------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 high read latency index execution time: 0.033s
 
-------- Performance schema: Top 15 most modified indexes ------------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 most modified indexes execution time: 0.031s
 
-------- 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.033s
 
-------- 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.033s
 
-------- 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.033s
 
-------- 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.033s
 
-------- 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.033s
 
-------- 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.036s
 
-------- Performance schema: Top 15 high update latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	0
ℹ   +-- 2: employees	dept_emp	0
ℹ   +-- 3: employees	titles	0
ℹ   +-- 4: employees	employees	0
ℹ   +-- 5: employees	dept_manager	0
ℹ   +-- 6: employees	departments	0
ℹ  Performance schema: Top 15 high update latency tables execution time: 0.035s
 
-------- 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.033s
 
-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
ℹ   +-- 1: employees	dept_emp
ℹ   +-- 2: employees	dept_manager
ℹ   +-- 3: employees	departments
ℹ  Performance schema: Table not using InnoDB buffer execution time: 0.097s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	83345408
ℹ   +-- 2: employees	employees	5980160
ℹ   +-- 3: employees	titles	1032192
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.093s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	7192080
ℹ   +-- 2: employees	employees	498134
ℹ   +-- 3: employees	titles	111575
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.079s
 
-------- Performance schema: Top 15 Most executed queries ------------------------------------------
ℹ   +-- 1: NULL	SELECT SCHEMA ( )	292
ℹ   +-- 2: NULL	SELECT @@`version_comment` LIMIT ?	205
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	114
ℹ   +-- 4: employees	SET SESSION `character_set_results` = ?	52
ℹ   +-- 5: NULL	SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS	24
ℹ   +-- 6: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	24
ℹ   +-- 7: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 8: employees	INSERT INTO `titles` VALUES (...) /* , ... */	21
ℹ   +-- 9: employees	INSERT INTO `employees` VALUES (...) /* , ... */	17
ℹ   +-- 10: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	14
ℹ   +-- 11: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ?	12
ℹ   +-- 12: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	9
ℹ   +-- 13: NULL	SHOW SCHEMAS	9
ℹ   +-- 14: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	8
ℹ   +-- 15: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...)	8
ℹ  Performance schema: Top 15 Most executed queries execution time: 0.034s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees`	2026-07-05 15: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 * FROM `information_schema` . `PROCESSLIST` LIMIT ?	2026-07-05 15:44:29.443446
ℹ   +-- 4: SELECT * FROM `information_schema` . `PROFILING` LIMIT ?	2026-07-05 15:44:29.473330
ℹ   +-- 5: SELECT * FROM `information_schema` . `TABLESPACES` LIMIT ?	2026-07-05 15:44:30.318103
ℹ   +-- 6: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.646210
ℹ   +-- 7: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.681196
ℹ   +-- 8: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.716864
ℹ   +-- 9: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.888944
ℹ   +-- 10: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.924497
ℹ   +-- 11: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:44:48.174216
ℹ  Performance schema: Latest SQL queries in errors or warnings execution time: 0.031s
 
-------- Performance schema: Top 20 queries with full table scans ----------------------------------
ℹ   +-- 1: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	9
ℹ   +-- 2: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN	8
ℹ   +-- 3: employees	SELECT `TRIGGER_NAME` FROM `INFORMATION_SCHEMA` . `TRIGGERS` WHERE `EVENT_OBJECT_SCHEMA` = SCHEMA ( ) AND `EVENT_OBJECT_	8
ℹ   +-- 4: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	4
ℹ   +-- 5: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i	4
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	4
ℹ   +-- 7: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	4
ℹ   +-- 8: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	4
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	4
ℹ   +-- 10: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	4
ℹ   +-- 11: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	4
ℹ   +-- 12: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	4
ℹ   +-- 13: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...)	4
ℹ   +-- 14: NULL	SELECT COUNT ( * ) FROM `performance_schema` . `error_log`	4
ℹ   +-- 15: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	4
ℹ   +-- 16: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	4
ℹ   +-- 17: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	4
ℹ   +-- 18: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	4
ℹ   +-- 19: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	4
ℹ   +-- 20: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	4
ℹ  Performance schema: Top 20 queries with full table scans execution time: 0.032s
 
-------- Performance schema: Last 50 queries with full table scans ---------------------------------
ℹ   +-- 1: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	2026-07-05 15:44:50.039829
ℹ   +-- 2: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	2026-07-05 15:44:50.008163
ℹ   +-- 3: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 	2026-07-05 15:44:49.976723
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:44:49.943463
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:49.863207
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:49.770461
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:49.674672
ℹ   +-- 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:44:49.147350
ℹ   +-- 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:44:49.117435
ℹ   +-- 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:44:49.019965
ℹ   +-- 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:44:48.989185
ℹ   +-- 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:44:48.956962
ℹ   +-- 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:44:48.892778
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:44:48.859570
ℹ   +-- 15: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:44:48.599105
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:44:48.529450
ℹ   +-- 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:44:48.496777
ℹ   +-- 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:44:48.464760
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:44:48.430536
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:44:48.384350
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:44:48.280732
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:44:48.174216
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:44:47.995276
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.924497
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.888944
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:44:47.852475
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:44:47.819399
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:44:47.785581
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:44:47.751057
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.716864
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.681196
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.646210
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.610258
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.574003
ℹ   +-- 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:44:47.538866
ℹ   +-- 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:44:47.505780
ℹ   +-- 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:44:47.473535
ℹ   +-- 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:44:47.441126
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.408833
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.371175
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.333492
ℹ   +-- 42: NULL	SELECT COUNT ( * ) FROM `information_schema` . `tables`	2026-07-05 15:44:47.197986
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:44:47.066036
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:44:46.938723
ℹ   +-- 45: NULL	SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ?	2026-07-05 15:44:38.164349
ℹ   +-- 46: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:44:38.013926
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string`	2026-07-05 15:44:37.983636
ℹ   +-- 48: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:44:37.863332
ℹ   +-- 49: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:44:37.801875
ℹ   +-- 50: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:44:37.771224
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.032s
 
-------- Performance schema: Top 15 reader queries (95% percentile) --------------------------------
ℹ   +-- 1: NULL	SELECT * FROM `information_schema` . `COLUMNS` LIMIT ?	3712
ℹ   +-- 2: NULL	SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	349
ℹ   +-- 3: NULL	SELECT * FROM `information_schema` . `STATISTICS` LIMIT ?	339
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	40
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	13
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	13
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	13
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	11
ℹ   +-- 9: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	4
ℹ   +-- 10: NULL	SELECT SUM ( `TABLE_ROWS` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	1
ℹ   +-- 11: NULL	DROP SCHEMA IF EXISTS `employees`	0
ℹ   +-- 12: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 13: employees	CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	0
ℹ   +-- 14: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	0
ℹ   +-- 15: employees	CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	0
ℹ  Performance schema: Top 15 reader queries (95% percentile) execution time: 0.071s
 
-------- Performance schema: Top 15 most row look queries (95% percentile) -------------------------
ℹ   +-- 1: NULL	SELECT * FROM `information_schema` . `COLUMNS` LIMIT ?	12411
ℹ   +-- 2: NULL	SELECT * FROM `information_schema` . `STATISTICS` LIMIT ?	2782
ℹ   +-- 3: NULL	SELECT SUM ( `TABLE_ROWS` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	743
ℹ   +-- 4: NULL	SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	736
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	584
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	26
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	26
ℹ   +-- 8: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	26
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	11
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	8
ℹ   +-- 11: NULL	DROP SCHEMA IF EXISTS `employees`	0
ℹ   +-- 12: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ   +-- 13: employees	CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	0
ℹ   +-- 14: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	0
ℹ   +-- 15: employees	CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	0
ℹ  Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.076s
 
-------- 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 * FROM `information_schema` . `STATISTICS` LIMIT ?	302596866000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	289329197000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	257419496000
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	233853478000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	213887369000
ℹ   +-- 10: NULL	SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	203410445000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	194761051000
ℹ   +-- 12: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	155430111000
ℹ   +-- 13: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 14: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 15: employees	CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.072s
 
-------- 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 * FROM `information_schema` . `STATISTICS` LIMIT ?	302596866000
ℹ   +-- 6: NULL	SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	203410445000
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	146582405000
ℹ   +-- 8: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	87149463000
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	71705862000
ℹ   +-- 10: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	69481180000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	60650466000
ℹ   +-- 12: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 13: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	50419616000
ℹ   +-- 15: employees	CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.072s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: NULL	SELECT * FROM `information_schema` . `STATISTICS` LIMIT ?	302596866000
ℹ   +-- 2: NULL	SELECT * FROM `information_schema` . `PARTITIONS` LIMIT ?	203410445000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */	180318467000
ℹ   +-- 4: employees	INSERT INTO `titles` VALUES (...) /* , ... */	131535734000
ℹ   +-- 5: employees	INSERT INTO `salaries` VALUES (...) /* , ... */	104959980000
ℹ   +-- 6: employees	INSERT INTO `employees` VALUES (...) /* , ... */	102589484000
ℹ   +-- 7: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	72332299000
ℹ   +-- 8: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	64354874000
ℹ   +-- 9: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	58463369000
ℹ   +-- 10: employees	CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	58002911000
ℹ   +-- 11: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	53471842000
ℹ   +-- 12: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	51315435000
ℹ   +-- 13: employees	CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	49382964000
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	48690262000
ℹ   +-- 15: employees	CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 	47819706000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.072s
 
-------- 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	24
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 3: NULL	SHOW SCHEMAS	9
ℹ   +-- 4: employees	SELECT COLUMN_NAME , `extra` , `generation_expression` , `data_type` FROM `information_schema` . `columns` WHERE `table_	6
ℹ   +-- 5: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	4
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	4
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	4
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	4
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	4
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	4
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	4
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	4
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	4
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	4
ℹ   +-- 15: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	4
ℹ   +-- 16: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	4
ℹ   +-- 17: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	4
ℹ   +-- 18: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	4
ℹ   +-- 19: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	4
ℹ   +-- 20: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	4
ℹ  Performance schema: Top 20 queries with sort execution time: 0.032s
 
-------- Performance schema: Last 50 queries with sort ---------------------------------------------
ℹ   +-- 1: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	2026-07-05 15:44:50.465834
ℹ   +-- 2: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	2026-07-05 15:44:50.071426
ℹ   +-- 3: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	2026-07-05 15:44:50.039829
ℹ   +-- 4: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	2026-07-05 15:44:50.008163
ℹ   +-- 5: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 	2026-07-05 15:44:49.976723
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:44:49.943463
ℹ   +-- 7: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:49.863207
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:49.770461
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:49.674672
ℹ   +-- 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:44:49.147350
ℹ   +-- 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:44:49.117435
ℹ   +-- 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:44:49.019965
ℹ   +-- 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:44:48.989185
ℹ   +-- 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:44:48.956962
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:44:48.859570
ℹ   +-- 16: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:44:48.599105
ℹ   +-- 17: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:44:48.529450
ℹ   +-- 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:44:48.496777
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:44:48.430536
ℹ   +-- 20: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:44:48.384350
ℹ   +-- 21: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:44:48.280732
ℹ   +-- 22: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:44:48.174216
ℹ   +-- 23: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:44:47.995276
ℹ   +-- 24: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.924497
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.888944
ℹ   +-- 26: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:44:47.852475
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:44:47.819399
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:44:47.785581
ℹ   +-- 29: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:44:47.751057
ℹ   +-- 30: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.716864
ℹ   +-- 31: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.681196
ℹ   +-- 32: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.646210
ℹ   +-- 33: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.610258
ℹ   +-- 34: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.574003
ℹ   +-- 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:44:47.538866
ℹ   +-- 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:44:47.505780
ℹ   +-- 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:44:47.473535
ℹ   +-- 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:44:47.441126
ℹ   +-- 39: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.408833
ℹ   +-- 40: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.371175
ℹ   +-- 41: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.333492
ℹ   +-- 42: NULL	SHOW SCHEMAS	2026-07-05 15:44:47.262304
ℹ   +-- 43: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:44:47.066036
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:44:37.863332
ℹ   +-- 45: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:44:37.801875
ℹ   +-- 46: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:44:37.739867
ℹ   +-- 47: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:44:37.074475
ℹ   +-- 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:44:37.042293
ℹ   +-- 49: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2026-07-05 15:44:36.695105
ℹ   +-- 50: NULL	SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ?	2026-07-05 15:44:36.054175
ℹ  Performance schema: Last 50 queries with sort execution time: 0.033s
 
-------- Performance schema: Top 15 row sorting queries with sort ----------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	25397
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	25318
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	25022
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	24224
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	24206
ℹ   +-- 6: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	644
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	474
ℹ   +-- 8: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT	200
ℹ   +-- 9: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	200
ℹ   +-- 10: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_temp_tables` WHERE ( `db` IS NULL OR `db`	150
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	128
ℹ   +-- 12: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	112
ℹ   +-- 13: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	99
ℹ   +-- 14: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	96
ℹ   +-- 15: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ?	80
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.034s
 
-------- Performance schema: Top 15 total latency queries with sort --------------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	289329197000
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	257419496000
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	233853478000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	213887369000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	194761051000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	155430111000
ℹ   +-- 7: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	65919205000
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	57909277000
ℹ   +-- 9: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	33641969000
ℹ   +-- 10: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	33198062000
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	23747604000
ℹ   +-- 12: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	20633904000
ℹ   +-- 13: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	20594800000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	19075545000
ℹ   +-- 15: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	18966028000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.035s
 
-------- 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	33
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	33
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	33
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	33
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	19
ℹ   +-- 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.035s
 
-------- 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	8
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	8
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	8
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	8
ℹ   +-- 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.033s
 
-------- 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	24
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	24
ℹ   +-- 4: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	24
ℹ   +-- 5: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	24
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	24
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	24
ℹ   +-- 8: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	20
ℹ   +-- 9: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	20
ℹ   +-- 10: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	20
ℹ   +-- 11: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	20
ℹ   +-- 12: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	20
ℹ   +-- 13: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	20
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	16
ℹ   +-- 15: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	16
ℹ  Performance schema: Top 15 scans queries with sort execution time: 0.035s
 
-------- 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.036s
 
-------- 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	24
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 3: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	9
ℹ   +-- 4: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	8
ℹ   +-- 5: employees	SELECT COLUMN_NAME , `extra` , `generation_expression` , `data_type` FROM `information_schema` . `columns` WHERE `table_	6
ℹ   +-- 6: NULL	SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST	4
ℹ   +-- 7: NULL	SELECT `TABLE_SCHEMA` , SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `I	4
ℹ   +-- 8: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (.	4
ℹ   +-- 9: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T	4
ℹ   +-- 10: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL	4
ℹ   +-- 11: NULL	SHOW VARIABLES	4
ℹ   +-- 12: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	4
ℹ   +-- 13: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	4
ℹ   +-- 14: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC	4
ℹ   +-- 15: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	4
ℹ   +-- 16: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX`	4
ℹ   +-- 17: NULL	SHOW ENGINES	4
ℹ   +-- 18: NULL	SHOW GLOBAL STATUS	4
ℹ   +-- 19: NULL	SHOW STATUS	4
ℹ   +-- 20: NULL	SHOW GLOBAL VARIABLES	4
ℹ  Performance schema: Top 20 queries with temp table execution time: 0.035s
 
-------- Performance schema: Last 50 queries with temp table ---------------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:44:49.943463
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:44:49.863207
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:44:49.770461
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:44:49.674672
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:44:48.599105
ℹ   +-- 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:44:48.496777
ℹ   +-- 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:44:48.464760
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	2026-07-05 15:44:48.430536
ℹ   +-- 9: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:44:48.384350
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:44:48.280732
ℹ   +-- 11: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ?	2026-07-05 15:44:48.174216
ℹ   +-- 12: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:44:47.995276
ℹ   +-- 13: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.924497
ℹ   +-- 14: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.888944
ℹ   +-- 15: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ?	2026-07-05 15:44:47.852475
ℹ   +-- 16: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ?	2026-07-05 15:44:47.819399
ℹ   +-- 17: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ?	2026-07-05 15:44:47.785581
ℹ   +-- 18: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ?	2026-07-05 15:44:47.751057
ℹ   +-- 19: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.716864
ℹ   +-- 20: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.681196
ℹ   +-- 21: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.646210
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ?	2026-07-05 15:44:47.610258
ℹ   +-- 23: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ?	2026-07-05 15:44:47.574003
ℹ   +-- 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:44:47.538866
ℹ   +-- 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:44:47.505780
ℹ   +-- 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:44:47.473535
ℹ   +-- 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:44:47.441126
ℹ   +-- 28: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:44:47.408833
ℹ   +-- 29: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ?	2026-07-05 15:44:47.371175
ℹ   +-- 30: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	2026-07-05 15:44:47.333492
ℹ   +-- 31: NULL	SELECT `sys_version` FROM `sys` . `version`	2026-07-05 15:44:47.294500
ℹ   +-- 32: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:44:47.066036
ℹ   +-- 33: NULL	SHOW SESSION STATUS LIKE ?	2026-07-05 15:44:46.969979
ℹ   +-- 34: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	2026-07-05 15:44:38.013926
ℹ   +-- 35: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:44:37.801875
ℹ   +-- 36: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)	2026-07-05 15:44:37.771224
ℹ   +-- 37: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:44:37.739867
ℹ   +-- 38: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:44:37.707528
ℹ   +-- 39: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:44:37.644824
ℹ   +-- 40: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:44:37.550291
ℹ   +-- 41: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	2026-07-05 15:44:37.515534
ℹ   +-- 42: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME	2026-07-05 15:44:37.424234
ℹ   +-- 43: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	2026-07-05 15:44:37.206105
ℹ   +-- 44: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	2026-07-05 15:44:37.106551
ℹ   +-- 45: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:44:37.074475
ℹ   +-- 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:44:37.042293
ℹ   +-- 47: NULL	SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA	2026-07-05 15:44:36.634389
ℹ   +-- 48: NULL	SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL	2026-07-05 15:44:36.603878
ℹ   +-- 49: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL	2026-07-05 15:44:36.544152
ℹ   +-- 50: NULL	SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_COLLAT	2026-07-05 15:44:36.484256
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.034s
 
-------- Performance schema: Top 15 total latency queries with temp table --------------------------
ℹ   +-- 1: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	289329197000
ℹ   +-- 2: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	257419496000
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	233853478000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	213887369000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	194761051000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	155430111000
ℹ   +-- 7: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	65919205000
ℹ   +-- 8: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC	57909277000
ℹ   +-- 9: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	33641969000
ℹ   +-- 10: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	33198062000
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	23747604000
ℹ   +-- 12: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	20594800000
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ?	19075545000
ℹ   +-- 14: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ?	18966028000
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	18359577000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.031s
 
-------- 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	4
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	4
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	4
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	4
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	4
ℹ   +-- 6: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	4
ℹ   +-- 7: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?	4
ℹ   +-- 8: NULL	SELECT * FROM `information_schema` . `PROCESSLIST` LIMIT ?	1
ℹ   +-- 9: NULL	SELECT * FROM `information_schema` . `PLUGINS` LIMIT ?	1
ℹ   +-- 10: NULL	SELECT * FROM `information_schema` . `OPTIMIZER_TRACE` LIMIT ?	1
ℹ   +-- 11: NULL	SELECT * FROM `information_schema` . `INNODB_COLUMNS` LIMIT ?	1
ℹ   +-- 12: NULL	SHOW VARIABLES	0
ℹ   +-- 13: NULL	SHOW GLOBAL VARIABLES	0
ℹ   +-- 14: NULL	SHOW STATUS	0
ℹ   +-- 15: NULL	SHOW GLOBAL STATUS	0
ℹ  Performance schema: Top 15 queries with temp table to disk execution time: 0.032s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919036
ℹ   +-- 2: wait/io/file	135098
ℹ   +-- 3: wait/lock/table	206
ℹ  Performance schema: Top 15 class events by number execution time: 0.035s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/table/sql/handler	3919036
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	79481
ℹ   +-- 3: wait/io/file/sql/io_cache	23815
ℹ   +-- 4: wait/io/file/innodb/innodb_data_file	17659
ℹ   +-- 5: wait/io/file/sql/binlog	8473
ℹ   +-- 6: wait/io/file/innodb/innodb_dblwr_file	5420
ℹ   +-- 7: wait/lock/table/sql/handler	206
ℹ   +-- 8: wait/io/file/innodb/innodb_temp_file	165
ℹ   +-- 9: wait/io/file/sql/binlog_index	41
ℹ   +-- 10: wait/io/file/sql/casetest	10
ℹ   +-- 11: wait/io/file/csv/metadata	8
ℹ   +-- 12: wait/io/file/sql/misc	6
ℹ   +-- 13: wait/io/file/mysys/cnf	5
ℹ   +-- 14: wait/io/file/sql/ERRMSG	5
ℹ   +-- 15: wait/io/file/csv/data	4
ℹ   +-- 16: wait/io/file/mysys/charset	3
ℹ   +-- 17: wait/io/file/sql/pid	3
ℹ  Performance schema: Top 30 events by number execution time: 0.034s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/file	41877450483372
ℹ   +-- 2: wait/io/table	7926911480916
ℹ   +-- 3: wait/lock/table	551211642
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.036s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_log_file	16343994885660
ℹ   +-- 2: wait/io/file/innodb/innodb_data_file	12686798897334
ℹ   +-- 3: wait/io/file/innodb/innodb_dblwr_file	9995594490900
ℹ   +-- 4: wait/io/table/sql/handler	7926911480916
ℹ   +-- 5: wait/io/file/innodb/innodb_temp_file	1299237652962
ℹ   +-- 6: wait/io/file/sql/binlog	1150337646774
ℹ   +-- 7: wait/io/file/sql/io_cache	396569965194
ℹ   +-- 8: wait/io/file/sql/binlog_index	2440946124
ℹ   +-- 9: wait/io/file/sql/casetest	1290780720
ℹ   +-- 10: wait/io/file/csv/metadata	617125104
ℹ   +-- 11: wait/lock/table/sql/handler	551211642
ℹ   +-- 12: wait/io/file/sql/pid	227905200
ℹ   +-- 13: wait/io/file/sql/ERRMSG	186604560
ℹ   +-- 14: wait/io/file/csv/data	55989720
ℹ   +-- 15: wait/io/file/sql/misc	44046360
ℹ   +-- 16: wait/io/file/mysys/charset	32343120
ℹ   +-- 17: wait/io/file/mysys/cnf	21203640
ℹ  Performance schema: Top 30 events by total latency execution time: 0.035s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/file	78267300876
ℹ   +-- 2: wait/io/table	68907554298
ℹ   +-- 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/file/innodb/innodb_temp_file	78267300876
ℹ   +-- 2: wait/io/file/innodb/innodb_log_file	71209415088
ℹ   +-- 3: wait/io/table/sql/handler	68907554298
ℹ   +-- 4: wait/io/file/innodb/innodb_dblwr_file	66975251760
ℹ   +-- 5: wait/io/file/innodb/innodb_data_file	25383956418
ℹ   +-- 6: wait/io/file/sql/binlog	16887608280
ℹ   +-- 7: wait/io/file/sql/io_cache	1932736320
ℹ   +-- 8: wait/io/file/sql/binlog_index	1276989480
ℹ   +-- 9: wait/io/file/sql/casetest	1172046600
ℹ   +-- 10: wait/io/file/csv/metadata	291710304
ℹ   +-- 11: wait/io/file/sql/pid	202358520
ℹ   +-- 12: wait/io/file/sql/ERRMSG	142067520
ℹ   +-- 13: wait/io/file/csv/data	24419160
ℹ   +-- 14: wait/io/file/mysys/charset	18572760
ℹ   +-- 15: wait/io/file/sql/misc	16108920
ℹ   +-- 16: wait/io/file/mysys/cnf	13530240
ℹ   +-- 17: 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.031s
 
-------- 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: 1.0K
ℹ   +-- 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 / 146.8M
ℹ  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% (20751143 hits / 20753196 total)
✔  InnoDB Write Log efficiency: 99.11% (8111117 hits / 8184246 total)
✔  InnoDB log waits: 0.00% (0 waits / 73129 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.030s
 
-------- 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.032s
 
-------- 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
    sort_buffer_size (> 256K)
    read_rnd_buffer_size (> 256K)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)
    innodb_buffer_pool_size (>= 146.8M) if possible.
    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
    Reduce or eliminate unclosed connections and network issues
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size
    Increase binlog_cache_size (current value: 32768)
    Unused indexes found: 2 index(es) should be reviewed and potentially removed.
    Migration Risk (default_authentication_plugin): Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead.
    Migration Risk (binlog_transaction_dependency_tracking): Removed in MySQL 8.4.
    Migration Risk (avoid_temporal_upgrade): Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade.
    Migration Risk (expire_logs_days): Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead.
    Set gtid_mode = ON to enable global transaction identifier replication.
    Set enforce_gtid_consistency = ON to prevent unsafe replication operations.
    Set binlog_transaction_dependency_tracking = WRITESET to improve parallel replication throughput.
    Enable binlog_transaction_compression = ON to reduce replication stream size.
    Increase binlog_cache_size to reduce disk spills for binary log transactions.
    Enable source_verify_checksum = ON (or master_verify_checksum).
Variables to adjust:
    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
    sort_buffer_size (> 256K)
    read_rnd_buffer_size (> 256K)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    binlog_cache_size (16.0M)
    innodb_buffer_pool_size (>= 146.8M) if possible.
    innodb_flush_neighbors = 1 or 2 (Recommended for HDD)