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:40:09
ℹ  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:40:09
ℹ  Server Connection  : 127.0.0.1:3306
ℹ  Database User      : root@%
ℹ  Database Version   : 11.4.10-MariaDB-ubu2404
ℹ  System Physical RAM: 15.3G
ℹ  System Swap Memory : 4.0G
ℹ  Database Uptime    : 26s
✔  Operating on 64-bit architecture
ℹ  Audit Snapshot Summary execution time: 0.252s
 
-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ  Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE 
ℹ  Data in Aria tables: 32.0K (Tables: 1)
ℹ  Data in InnoDB tables: 122.8M (Tables: 6)
✔  Total fragmented tables: 0
 
✔  Currently running supported MySQL/MariaDB version 11.4.10-MariaDB(LTS)
ℹ  Storage Engine Statistics execution time: 0.231s
 
-------- 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
ℹ  	20: br-cbdf899c945d: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP group default 
ℹ  	    link/ether aa:7e:83:96:b4:13 brd ff:ff:ff:ff:ff:ff
ℹ  	--
ℹ  	21: veth278a25f@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-cbdf899c945d state UP group default 
ℹ  	    link/ether 52:dd:10:db:51:2b brd ff:ff:ff:ff:ff:ff link-netnsid 0
ℹ  	22: veth3f936c5@if2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue master br-cbdf899c945d state UP group default 
ℹ  	    link/ether d6:8a:52:55:79:19 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        3559       10669           4        1644       12071
ℹ  	Swap:           4096           0        4096
ℹ  Load Average          : 
ℹ  	top - 17:40:10 up 4 days,  5:10,  1 user,  load average: 1.11, 0.85, 0.44
ℹ  System Uptime         : 
ℹ  	 17:40:11 up 4 days,  5:10,  1 user,  load average: 1.11, 0.85, 0.44
ℹ  Database Uptime       : 26s
✔  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 3G RAM.
✘  Other user process except mysqld used more than 15% of total physical memory 21.35% (3G / 15G)
ℹ  System Linux Recommendations execution time: 0.841s
 
-------- 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.53 GB / 951.65 GB)
ℹ  mount point / is using 14 % total space (131.73 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.53 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.014s
 
-------- Kernel Information Recommendations --------------------------------------------------------
ℹ  Information about kernel tuning:
ℹ  	fs.aio-max-nr = 65536
ℹ  	fs.aio-nr = 2048
ℹ  	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.075s
 
-------- Log file Recommendations ------------------------------------------------------------------
✔  Log file /var/log/syslog (syslog) exists
✔  Log file /var/log/syslog is readable.
✔  /var/log/syslog doesn't contain any warning.
✔  /var/log/syslog doesn't contain any error.
ℹ  0 start(s) detected in /var/log/syslog
ℹ  0 shutdown(s) detected in /var/log/syslog
ℹ  Log file Recommendations execution time: 0.015s
 
-------- 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_uca1400_ai_ci)
ℹ   +-- ROWS  : 3911717
ℹ   +-- DATA  : 117.2M(95.48%)
ℹ   +-- INDEX : 5.5M(4.52%)
ℹ   +-- SIZE  : 122.8M
ℹ   +-- ENGINE: 1 (InnoDB)
ℹ  Database: employees
ℹ   +-- TABLE : 6
ℹ   +-- VIEW  : 2
ℹ   +-- INDEX : 9
ℹ   +-- CHARS : 1 (utf8mb4)
ℹ   +-- COLLA : 1 (utf8mb4_uca1400_ai_ci)
ℹ   +-- ROWS  : 3911717
ℹ   +-- DATA  : 117.2M(95.48%)
ℹ   +-- INDEX : 5.5M(4.52%)
ℹ   +-- TOTAL : 122.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_uca1400_ai_ci
✔  employees table column(s) has same collation defined for all text like column(s).
ℹ  Database Metrics execution time: 0.679s
 
-------- 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(11) 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(11) 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(11) 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(11) NOT NULL
ℹ       +-- Column salaries.salary: INT(11) 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(11) NOT NULL
ℹ       +-- Column titles.title: VARCHAR(50) NOT NULL
ℹ       +-- Column titles.from_date: DATE NOT NULL
ℹ       +-- Column titles.to_date: DATE NULL
ℹ  Table Column Metrics execution time: 0.509s
 
-------- 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.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention
✘  Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.dept_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.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention
✘  Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention
✘  Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT)
✘  Table employees.titles: Primary key '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.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.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 '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_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)
✔  All tables are InnoDB tables
✔  All columns are UTF-8 compliant
ℹ  Table structures analysis execution time: 0.318s
 
-------- Naming conventions analysis ---------------------------------------------------------------
✘  Table employees.employees: Plural name detected (prefer singular)
✘  Table employees.salaries: Plural name detected (prefer singular)
✘  Table employees.titles: Plural name detected (prefer singular)
✘  Table employees.departments: Plural name detected (prefer singular)
ℹ  Naming conventions analysis execution time: 0.135s
 
-------- Foreign Key analysis ----------------------------------------------------------------------
ℹ  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.salaries.emp_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.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.
ℹ  Foreign Key analysis execution time: 0.149s
 
-------- MariaDB 10.x+ Specific Modeling -----------------------------------------------------------
✔  No MySQL 8.0+ specific modeling issues found
ℹ  MariaDB 10.x+ Specific Modeling execution time: 0.104s
 
-------- Data Type optimization --------------------------------------------------------------------
✔  No data type optimization recommendations
ℹ  Data Type optimization execution time: 0.038s
 
-------- 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(emp_no)
ℹ   +-- COLUMN      : employees.salaries
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 236645 distinct values
ℹ   +-- NB ROWS     : 2839743 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 8.33%
✘  PRIMARY(emp_no) has a low selectivity
ℹ  Index: dept_no(dept_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 12 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 50.00%
ℹ  Index: PRIMARY(from_date)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 3 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 441951 distinct values
ℹ   +-- NB ROWS     : 441951 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_emp
ℹ   +-- NB SEQS     : 1 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.titles
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 441951 distinct values
ℹ   +-- NB ROWS     : 441951 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.dept_manager
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 2 column(s)
ℹ   +-- CARDINALITY : 24 distinct values
ℹ   +-- NB ROWS     : 24 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(dept_no)
ℹ   +-- COLUMN      : employees.dept_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(title)
ℹ   +-- COLUMN      : employees.titles
ℹ   +-- NB SEQS     : 2 sequence(s)
ℹ   +-- NB COLS     : 3 column(s)
ℹ   +-- CARDINALITY : 441951 distinct values
ℹ   +-- NB ROWS     : 441951 rows
ℹ   +-- TYPE        : BTREE
ℹ   +-- SELECTIVITY : 100.00%
ℹ  Index: PRIMARY(emp_no)
ℹ   +-- COLUMN      : employees.employees
ℹ   +-- NB SEQS     : 1 sequence(s)
ℹ   +-- NB COLS     : 1 column(s)
ℹ   +-- CARDINALITY : 298847 distinct values
ℹ   +-- NB ROWS     : 298847 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: 662286
ℹ   +-- INDEX      : dept_manager.dept_no
ℹ   +-- COLUMNS    : dept_no
ℹ   +-- CARDINALITY: 12
ℹ   +-- INDEX      : dept_manager.PRIMARY
ℹ   +-- COLUMNS    : emp_no,dept_no
ℹ   +-- CARDINALITY: 48
ℹ   +-- INDEX      : employees.PRIMARY
ℹ   +-- COLUMNS    : emp_no
ℹ   +-- CARDINALITY: 298847
ℹ   +-- INDEX      : salaries.PRIMARY
ℹ   +-- COLUMNS    : emp_no,from_date
ℹ   +-- CARDINALITY: 3076388
ℹ   +-- INDEX      : titles.PRIMARY
ℹ   +-- COLUMNS    : emp_no,title,from_date
ℹ   +-- CARDINALITY: 1325853
ℹ  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.186s
 
-------- 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 ------------------------------------------------------------------
ℹ  mariadb.org binary distribution - 11.4.10-MariaDB
✔  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: 0.359s
 
-------- Authentication Plugin Security ------------------------------------------------------------
✘  User 'mariadb.sys'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password
✘  User 'root'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password
✘  User 'root'@'%' uses SHA-1 based insecure plugin: mysql_native_password
✘  User 'healthcheck'@'127.0.0.1' uses SHA-1 based insecure plugin: mysql_native_password
✘  User 'healthcheck'@'::1' uses SHA-1 based insecure plugin: mysql_native_password
✘  User 'healthcheck'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password
ℹ  Authentication Plugin Security execution time: 0.033s
 
-------- 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
✔  TLS is active, but no explicit ssl_cert/ssl_key paths are configured (MariaDB zero-configuration TLS active)
✔  All remote users have SSL enforcement active (or no remote users exist)
ℹ  SSL/TLS Security Recommendations execution time: 0.061s
 
-------- CVE Security Recommendations --------------------------------------------------------------
✘  CVE-2026-49261(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. Versions 10.6.1 through 10.6.26, 10.11.1 through 10.11.17, 11.4.1 through 11.4.11, 11.8.1 through 11.8.7, and 12.3.1 with  `wsrep_notify_c...

✘  CVE-2026-44168(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, during ...

✘  CVE-2026-44169(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, a user getting EXECUTE access to a stored routine via a role,...

✘  CVE-2026-44170(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, MariaDB...

✘  CVE-2026-44171(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, mbstrea...

✘  CVE-2026-44173(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, MariaDB...

✘  CVE-2026-48163(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.27, 10.11.1 to before 10.11.18, 11.4.1 to before 11.4.12, 11.8.1 to before 11.8.8, and 12.3.1, during ...

✘  CVE-2026-48165(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.27, 10.11.1 to before 10.11.18, 11.4.1 to before 11.4.12, 11.8.1 to before 11.8.8, and 12.3.1, a high-...

✘  8 CVE(s) found for your MySQL release.
ℹ  CVE Security Recommendations execution time: 0.003s
 
-------- Plugin Information ------------------------------------------------------------------------
ℹ  Plugin                         | Version    | Status     | Type                
ℹ  --------------------------------------------------------------------------------
ℹ  mysql_native_password          | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  mysql_old_password             | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  unix_socket                    | 1.0        | ACTIVE     | AUTHENTICATION      
ℹ  inet4                          | 1.0        | ACTIVE     | DATA TYPE           
ℹ  inet6                          | 1.0        | ACTIVE     | DATA TYPE           
ℹ  uuid                           | 1.0        | ACTIVE     | DATA TYPE           
ℹ  inet6_aton                     | 1.0        | ACTIVE     | FUNCTION            
ℹ  inet6_ntoa                     | 1.0        | ACTIVE     | FUNCTION            
ℹ  inet_aton                      | 1.0        | ACTIVE     | FUNCTION            
ℹ  inet_ntoa                      | 1.0        | ACTIVE     | FUNCTION            
ℹ  is_ipv4                        | 1.0        | ACTIVE     | FUNCTION            
ℹ  is_ipv4_compat                 | 1.0        | ACTIVE     | FUNCTION            
ℹ  is_ipv4_mapped                 | 1.0        | ACTIVE     | FUNCTION            
ℹ  is_ipv6                        | 1.0        | ACTIVE     | FUNCTION            
ℹ  sys_guid                       | 1.0        | ACTIVE     | FUNCTION            
ℹ  uuid                           | 1.0        | ACTIVE     | FUNCTION            
ℹ  wsrep                          | 1.0        | ACTIVE     | REPLICATION         
ℹ  wsrep_provider                 | 1.0        | ACTIVE     | REPLICATION         
ℹ  Aria                           | 1.5        | ACTIVE     | STORAGE ENGINE      
ℹ  binlog                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  CSV                            | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  InnoDB                         | 11.4       | ACTIVE     | STORAGE ENGINE      
ℹ  MEMORY                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MRG_MyISAM                     | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  MyISAM                         | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  online_alter_log               | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  partition                      | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  PERFORMANCE_SCHEMA             | 0.1        | ACTIVE     | STORAGE ENGINE      
ℹ  SEQUENCE                       | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  SQL_SEQUENCE                   | 1.0        | ACTIVE     | STORAGE ENGINE      
ℹ  Plugin Information execution time: 0.033s
 
-------- Performance Metrics -----------------------------------------------------------------------
ℹ  Up for: 26s (215 q [8.269 qps], 15 conn, TX: 75K, RX: 164M)
ℹ  Reads / Writes: 8% / 92%
ℹ  Binary logging is disabled
ℹ  Physical Memory     : 15.3G
ℹ  Max MySQL memory    : 3.4G
ℹ  Other process memory: 3.3G
ℹ  Total buffers: 401.0M global + 18.9M per thread (151 max threads)
ℹ  Performance_schema Max memory usage: 197M
ℹ  Galera GCache Max memory usage: 0B
ℹ  Global Buffers
ℹ   +-- Key Buffer: 128.0M
ℹ   +-- Max Tmp Table: 16.0M
ℹ  Query Cache Buffers
ℹ   +-- Query Cache: OFF - DISABLED
ℹ   +-- Query Cache Size: 1.0M
ℹ  Per Thread Buffers
ℹ   +-- Read Buffer: 128.0K
ℹ   +-- Read RND Buffer: 256.0K
ℹ   +-- Sort Buffer: 2.0M
ℹ   +-- Thread stack: 292.0K
ℹ   +-- Join Buffer: 256.0K
✔  Maximum reached memory usage: 616.7M (3.95% of installed RAM)
✔  Maximum possible memory usage: 3.4G (22.12% of installed RAM)
✔  Overall possible memory usage with other process is compatible with memory available
✔  Slow queries: 0% (0/215)
✔  Highest usage of available connections: 0% (1/151)
✔  Aborted connections: 0.00% (0/15)
✔  Query cache is disabled by default due to mutex contention on multiprocessor machines.
✔  No Sort requiring temporary tables
✔  No joins without indexes
✔  Temporary tables created on disk: 0% (0 on disk / 9 total)
✔  Thread cache hit rate: 93% (1 created / 15 connections)
✔  Table cache hit rate: 86% (218 hits / 252 requests)
✔  table_definition_cache (400) is greater than number of tables (304)
✔  Open file limit used: 0% (30/32K)
✔  Table locks acquired immediately: 100% (53 immediate / 53 locks)
ℹ  Performance Metrics execution time: 0.131s
 
-------- Performance schema ------------------------------------------------------------------------
ℹ  Performance_schema is activated.
ℹ  Memory used by Performance_schema: 197.3M
ℹ  Sys schema is installed.
ℹ  Sys schema Version: 1.5.2
ℹ  Performance schema execution time: 0.092s
 
-------- Performance schema: Top 5 user per connection ---------------------------------------------
ℹ   +-- 1: root	109 conn(s)
ℹ   +-- 2: background	36 conn(s)
ℹ  Performance schema: Top 5 user per connection execution time: 0.032s
 
-------- Performance schema: Top 5 user per statement ----------------------------------------------
ℹ   +-- 1: root	440 stmt(s)
ℹ   +-- 2: background	0 stmt(s)
ℹ  Performance schema: Top 5 user per statement execution time: 0.032s
 
-------- Performance schema: Top 5 user per statement latency --------------------------------------
ℹ   +-- 1: root	40521956334.0426
ℹ   +-- 2: background	0.0000
ℹ  Performance schema: Top 5 user per statement latency execution time: 0.032s
 
-------- Performance schema: Top 5 user per lock latency -------------------------------------------
ℹ   +-- 1: root	3341140000000
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 user per lock latency execution time: 0.030s
 
-------- Performance schema: Top 5 user per nb full scans ------------------------------------------
ℹ   +-- 1: root	93
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 user per nb full scans execution time: 0.030s
 
-------- Performance schema: Top 5 user per rows sent ----------------------------------------------
ℹ   +-- 1: root	2793
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 user per rows sent execution time: 0.031s
 
-------- Performance schema: Top 5 user per rows modified ------------------------------------------
ℹ   +-- 1: root	3919016
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 user per rows modified execution time: 0.029s
 
-------- Performance schema: Top 5 user per IO -----------------------------------------------------
ℹ   +-- 1: root	11039
ℹ   +-- 2: background	8541
ℹ  Performance schema: Top 5 user per IO execution time: 0.031s
 
-------- Performance schema: Top 5 user per IO latency ---------------------------------------------
ℹ   +-- 1: root	3016199162802
ℹ   +-- 2: background	538903629075
ℹ  Performance schema: Top 5 user per IO latency execution time: 0.032s
 
-------- Performance schema: Top 5 host per connection ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	118 conn(s)
ℹ  Performance schema: Top 5 host per connection execution time: 0.032s
 
-------- Performance schema: Top 5 host per statement ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	486 stmt(s)
ℹ  Performance schema: Top 5 host per statement execution time: 0.031s
 
-------- Performance schema: Top 5 host per statement latency --------------------------------------
ℹ   +-- 1: 172.18.0.2	39056107405.7377
ℹ  Performance schema: Top 5 host per statement latency execution time: 0.031s
 
-------- Performance schema: Top 5 host per lock latency -------------------------------------------
ℹ   +-- 1: 172.18.0.2	3343128000000
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 host per lock latency execution time: 0.031s
 
-------- Performance schema: Top 5 host per nb full scans ------------------------------------------
ℹ   +-- 1: 172.18.0.2	102
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 host per nb full scans execution time: 0.033s
 
-------- Performance schema: Top 5 host per rows sent ----------------------------------------------
ℹ   +-- 1: 172.18.0.2	2808
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 host per rows sent execution time: 0.031s
 
-------- Performance schema: Top 5 host per rows modified ------------------------------------------
ℹ   +-- 1: 172.18.0.2	3919016
ℹ   +-- 2: background	0
ℹ  Performance schema: Top 5 host per rows modified execution time: 0.035s
 
-------- Performance schema: Top 5 host per io -----------------------------------------------------
ℹ   +-- 1: 172.18.0.2	11039
ℹ  Performance schema: Top 5 host per io execution time: 0.037s
 
-------- Performance schema: Top 5 host per io latency ---------------------------------------------
ℹ   +-- 1: 172.18.0.2	3016199162802
ℹ  Performance schema: Top 5 host per io latency execution time: 0.034s
 
-------- Performance schema: Top IO type order by total io -----------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	9032 i/o
ℹ   +-- 2: aria/MAI	7911 i/o
ℹ   +-- 3: aria/MAD	1369 i/o
ℹ   +-- 4: sql/FRM	814 i/o
ℹ   +-- 5: sql/file_parser	228 i/o
ℹ   +-- 6: sql/global_ddl_log	112 i/o
ℹ   +-- 7: sql/misc	25 i/o
ℹ   +-- 8: sql/dbopt	21 i/o
ℹ   +-- 9: myisam/dfile	18 i/o
ℹ   +-- 10: aria/translog	9 i/o
ℹ   +-- 11: csv/metadata	8 i/o
ℹ   +-- 12: partition/ha_partition::parfile	6 i/o
ℹ   +-- 13: myisam/kfile	6 i/o
ℹ   +-- 14: sql/casetest	5 i/o
ℹ   +-- 15: csv/data	4 i/o
ℹ   +-- 16: sql/pid	3 i/o
ℹ   +-- 17: sql/tclog	3 i/o
ℹ   +-- 18: aria/control	3 i/o
ℹ   +-- 19: mysys/charset	3 i/o
ℹ  Performance schema: Top IO type order by total io execution time: 0.036s
 
-------- Performance schema: Top IO type order by total latency ------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	3353398472312.0
ℹ   +-- 2: sql/global_ddl_log	83462353947.0
ℹ   +-- 3: aria/MAI	41792756012.0
ℹ   +-- 4: aria/MAD	26087530574.0
ℹ   +-- 5: sql/FRM	23411090206.0
ℹ   +-- 6: csv/metadata	15542308320.0
ℹ   +-- 7: sql/file_parser	6997911403.0
ℹ   +-- 8: mysys/charset	3310927683.0
ℹ   +-- 9: sql/misc	302557360.0
ℹ   +-- 10: sql/dbopt	129722740.0
ℹ   +-- 11: sql/casetest	107768640.0
ℹ   +-- 12: sql/pid	104273680.0
ℹ   +-- 13: sql/tclog	93578660.0
ℹ   +-- 14: aria/translog	82629260.0
ℹ   +-- 15: aria/control	76513080.0
ℹ   +-- 16: myisam/dfile	74135180.0
ℹ   +-- 17: partition/ha_partition::parfile	51539600.0
ℹ   +-- 18: csv/data	47148780.0
ℹ   +-- 19: myisam/kfile	29574440.0
ℹ  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_data_file	60948020707
ℹ   +-- 2: csv/metadata	14999527760
ℹ   +-- 3: sql/global_ddl_log	10150138040
ℹ   +-- 4: sql/FRM	4029539017
ℹ   +-- 5: mysys/charset	3283996583
ℹ   +-- 6: sql/file_parser	3200161783
ℹ   +-- 7: aria/MAD	2483384197
ℹ   +-- 8: aria/MAI	348246220
ℹ   +-- 9: sql/misc	108299520
ℹ   +-- 10: sql/pid	76756400
ℹ   +-- 11: sql/casetest	71757280
ℹ   +-- 12: aria/control	64568280
ℹ   +-- 13: sql/dbopt	51119320
ℹ   +-- 14: sql/tclog	49637280
ℹ   +-- 15: aria/translog	35148680
ℹ   +-- 16: csv/data	26112660
ℹ   +-- 17: partition/ha_partition::parfile	14300580
ℹ   +-- 18: myisam/dfile	6735540
ℹ   +-- 19: myisam/kfile	6702360
ℹ  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.036s
 
-------- Performance schema: Top Stages order by total latency -------------------------------------
ℹ   +-- 1: innodb/buffer pool load	2707585000.0
ℹ  Performance schema: Top Stages order by total latency execution time: 0.031s
 
-------- Performance schema: Top Stages order by avg latency ---------------------------------------
ℹ   +-- 1: innodb/buffer pool load	2707585000
ℹ  Performance schema: Top Stages order by avg latency execution time: 0.029s
 
-------- Performance schema: Top 5 host per table scans --------------------------------------------
ℹ   +-- 1: 172.18.0.2	113
ℹ  Performance schema: Top 5 host per table scans execution time: 0.031s
 
-------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
ℹ   +-- 1: employees	100990976	92322175	6164 page(s)
ℹ   +-- 2: InnoDB System	98304	8530	6 page(s)
ℹ  Performance schema: InnoDB Buffer Pool by schema execution time: 0.044s
 
-------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
ℹ   +-- 1: employees	salaries	88555520	80915696	5405 page(s)
ℹ   +-- 2: employees	employees	12435456	11406479	759 page(s)
ℹ   +-- 3: InnoDB System	SYS_FOREIGN	32768	640	2 page(s)
ℹ   +-- 4: InnoDB System	SYS_COLUMNS	16384	3772	1 page(s)
ℹ   +-- 5: InnoDB System	SYS_FIELDS	16384	1547	1 page(s)
ℹ   +-- 6: InnoDB System	SYS_INDEXES	16384	1532	1 page(s)
ℹ   +-- 7: InnoDB System	SYS_TABLES	16384	1039	1 page(s)
ℹ  Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.045s
 
-------- Performance schema: Process per time ------------------------------------------------------
ℹ   +-- 1: sql/main	NULL	31
ℹ   +-- 2: root@172.18.0.2	Query	0
ℹ   +-- 3: mysys/statement_timer	NULL	NULL
ℹ   +-- 4: aria/checkpoint_background	NULL	NULL
ℹ   +-- 5: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 6: innodb/page_cleaner_thread	NULL	NULL
ℹ   +-- 7: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 8: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 9: sql/manager	NULL	NULL
ℹ   +-- 10: sql/signal_handler	NULL	NULL
ℹ   +-- 11: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 12: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 13: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 14: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 15: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 16: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 17: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 18: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 19: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 20: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 21: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 22: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 23: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 24: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 25: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 26: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 27: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 28: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 29: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 30: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 31: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 32: innodb/thread_pool_thread	NULL	NULL
ℹ   +-- 33: innodb/thread_pool_thread	NULL	NULL
ℹ  Performance schema: Process per time execution time: 0.040s
 
-------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: InnoDB Lock Waits execution time: 0.030s
 
-------- Performance schema: Thread IO Latency -----------------------------------------------------
ℹ   +-- 1: page_cleaner_thread	277744649819	28295248695
ℹ   +-- 2: main	71109481975	7682519320
ℹ   +-- 3: thread_pool_thread	44698592393	20859646087
ℹ   +-- 4: thread_pool_thread	42124265134	19851109019
ℹ   +-- 5: thread_pool_thread	19757807412	13547484692
ℹ   +-- 6: thread_pool_thread	15030742951	10374848484
ℹ   +-- 7: thread_pool_thread	13075221033	3602412324
ℹ   +-- 8: thread_pool_thread	12904406522	12904406522
ℹ   +-- 9: thread_pool_thread	9257699451	8330650251
ℹ   +-- 10: thread_pool_thread	9134526996	8591259796
ℹ   +-- 11: thread_pool_thread	9014408760	7849602740
ℹ   +-- 12: thread_pool_thread	8062751613	4497580521
ℹ   +-- 13: thread_pool_thread	7159651184	2437015700
ℹ   +-- 14: thread_pool_thread	6533070663	6451846023
ℹ   +-- 15: thread_pool_thread	5592693610	2927685411
ℹ   +-- 16: thread_pool_thread	3683380372	3568743472
ℹ   +-- 17: thread_pool_thread	3439236402	3349628282
ℹ   +-- 18: thread_pool_thread	2196299777	2047299457
ℹ   +-- 19: thread_pool_thread	1986993148	748750940
ℹ   +-- 20: signal_handler	104273680	76756400
ℹ   +-- 21: manager	19233340	15196440
ℹ  Performance schema: Thread IO Latency execution time: 0.030s
 
-------- Performance schema: Top 15 Most latency statements ----------------------------------------
ℹ   +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	154384764000
ℹ   +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */ 	111553432000
ℹ   +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */ 	111087783000
ℹ   +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */ 	84473896000
ℹ   +-- 5: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	49350103000
ℹ   +-- 6: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	39880362000
ℹ   +-- 7: SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	39866921000
ℹ   +-- 8: SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	24617459000
ℹ   +-- 9: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	23588540000
ℹ   +-- 10: SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	17275168000
ℹ   +-- 11: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	15601994000
ℹ   +-- 12: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d	15384918000
ℹ   +-- 13: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to	14841820000
ℹ   +-- 14: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL ,	14728396000
ℹ   +-- 15: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	13523532000
ℹ  Performance schema: Top 15 Most latency statements execution time: 0.030s
 
-------- 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 `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	1 s
ℹ   +-- 6: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	1 s
ℹ   +-- 7: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	1 s
ℹ  Performance schema: Top 15 slower queries execution time: 0.034s
 
-------- Performance schema: Top 15 nb statement type ----------------------------------------------
ℹ   +-- 1: insert	168
ℹ   +-- 2: Quit	140
ℹ   +-- 3: select	138
ℹ   +-- 4: jump_if_not	48
ℹ   +-- 5: freturn	8
ℹ   +-- 6: Init DB	7
ℹ   +-- 7: create_table	6
ℹ   +-- 8: show_engine_status	6
ℹ   +-- 9: show_status	3
ℹ   +-- 10: show_databases	3
ℹ   +-- 11: create_view	2
ℹ   +-- 12: show_variables	2
ℹ   +-- 13: Statistics	1
ℹ   +-- 14: create_db	1
ℹ   +-- 15: flush	1
ℹ  Performance schema: Top 15 nb statement type execution time: 0.032s
 
-------- Performance schema: Top 15 statement by total latency -------------------------------------
ℹ   +-- 1: insert	18606886331000
ℹ   +-- 2: select	351030865000
ℹ   +-- 3: create_table	89178970000
ℹ   +-- 4: drop_table	49350103000
ℹ   +-- 5: create_view	17507493000
ℹ   +-- 6: show_variables	3106604000
ℹ   +-- 7: show_status	2524062000
ℹ   +-- 8: Quit	1398181000
ℹ   +-- 9: show_engine_status	1337741000
ℹ   +-- 10: show_databases	1081136000
ℹ   +-- 11: create_db	808364000
ℹ   +-- 12: Init DB	575995000
ℹ   +-- 13: show_storage_engines	270998000
ℹ   +-- 14: drop_db	177715000
ℹ   +-- 15: show_slave_status	165890000
ℹ  Performance schema: Top 15 statement by total latency execution time: 0.032s
 
-------- Performance schema: Top 15 statement by lock latency --------------------------------------
ℹ   +-- 1: insert	3152505000000
ℹ   +-- 2: select	188013000000
ℹ   +-- 3: create_view	4917000000
ℹ   +-- 4: create_table	720000000
ℹ   +-- 5: drop_table	502000000
ℹ   +-- 6: show_status	263000000
ℹ   +-- 7: show_databases	256000000
ℹ   +-- 8: show_variables	172000000
ℹ   +-- 9: show_storage_engines	90000000
ℹ   +-- 10: Statistics	0
ℹ   +-- 11: create_db	0
ℹ   +-- 12: freturn	0
ℹ   +-- 13: flush	0
ℹ   +-- 14: show_slave_status	0
ℹ   +-- 15: Init DB	0
ℹ  Performance schema: Top 15 statement by lock latency execution time: 0.032s
 
-------- Performance schema: Top 15 statement by full scans ----------------------------------------
ℹ   +-- 1: select	115
ℹ   +-- 2: show_databases	3
ℹ   +-- 3: show_status	3
ℹ   +-- 4: show_variables	2
ℹ   +-- 5: show_storage_engines	1
ℹ   +-- 6: drop_db	0
ℹ   +-- 7: Init DB	0
ℹ   +-- 8: create_table	0
ℹ   +-- 9: show_grants	0
ℹ   +-- 10: jump_if_not	0
ℹ   +-- 11: show_slave_hosts	0
ℹ   +-- 12: Ping	0
ℹ   +-- 13: drop_table	0
ℹ   +-- 14: create_db	0
ℹ   +-- 15: Quit	0
ℹ  Performance schema: Top 15 statement by full scans execution time: 0.032s
 
-------- Performance schema: Top 15 statement by rows sent -----------------------------------------
ℹ   +-- 1: show_variables	1365
ℹ   +-- 2: show_status	1111
ℹ   +-- 3: select	531
ℹ   +-- 4: show_databases	15
ℹ   +-- 5: show_storage_engines	8
ℹ   +-- 6: Statistics	0
ℹ   +-- 7: create_view	0
ℹ   +-- 8: create_db	0
ℹ   +-- 9: create_table	0
ℹ   +-- 10: freturn	0
ℹ   +-- 11: flush	0
ℹ   +-- 12: show_slave_status	0
ℹ   +-- 13: drop_table	0
ℹ   +-- 14: Init DB	0
ℹ   +-- 15: set_option	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: Statistics	0
ℹ   +-- 4: create_view	0
ℹ   +-- 5: show_status	0
ℹ   +-- 6: create_table	0
ℹ   +-- 7: freturn	0
ℹ   +-- 8: flush	0
ℹ   +-- 9: show_slave_status	0
ℹ   +-- 10: drop_table	0
ℹ   +-- 11: Init DB	0
ℹ   +-- 12: show_storage_engines	0
ℹ   +-- 13: set_option	0
ℹ   +-- 14: show_variables	0
ℹ   +-- 15: select	0
ℹ  Performance schema: Top 15 statement by rows modified execution time: 0.031s
 
-------- Performance schema: 15 sample queries using temp table ------------------------------------
ℹ   +-- 1: SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T
ℹ   +-- 2: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?
ℹ   +-- 3: SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`
ℹ   +-- 4: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU
ℹ   +-- 5: SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform
ℹ   +-- 6: SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i
ℹ   +-- 7: SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO
ℹ   +-- 8: SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `
ℹ   +-- 9: SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS
ℹ   +-- 10: SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN
ℹ   +-- 11: SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 
ℹ   +-- 12: SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`
ℹ   +-- 13: SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 
ℹ   +-- 14: SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA
ℹ   +-- 15: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch
ℹ  Performance schema: 15 sample queries using temp table execution time: 0.032s
 
-------- Performance schema: Unused indexes --------------------------------------------------------
ℹ   +-- 1: employees.departments (dept_name)
ℹ   +-- 2: employees.dept_emp (dept_no)
ℹ   +-- 3: employees.dept_manager (dept_no)
✘  Performance schema: 3 unused index(es) found.
ℹ  Performance schema: Unused indexes execution time: 0.030s
 
-------- Performance schema: Tables with full table scans ------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Tables with full table scans execution time: 0.030s
 
-------- Performance schema: Latest File IO by latency ---------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Latest File IO by latency execution time: 0.032s
 
-------- Performance schema: File by IO read bytes -------------------------------------------------
ℹ   +-- 1: /var/lib/mysql/ibdata1	2555904
ℹ   +-- 2: /var/lib/mysql/employees/employees.ibd	1851392
ℹ   +-- 3: /var/lib/mysql/undo001	770048
ℹ   +-- 4: /var/lib/mysql/undo002	753664
ℹ   +-- 5: /var/lib/mysql/undo003	753664
ℹ   +-- 6: /var/lib/mysql/mysql/transaction_registry.ibd	163840
ℹ   +-- 7: /var/lib/mysql/mysql/innodb_index_stats.ibd	49152
ℹ   +-- 8: /var/lib/mysql/mysql/innodb_table_stats.ibd	49152
ℹ   +-- 9: /var/lib/mysql/mysql/proc.MAD	40960
ℹ   +-- 10: /var/lib/mysql/mysql/gtid_slave_pos.ibd	32768
ℹ   +-- 11: /usr/share/mariadb/charsets/Index.xml	23509
ℹ   +-- 12: /var/lib/mysql/mysql/proxies_priv.MAD	16384
ℹ   +-- 13: /var/lib/mysql/mysql/global_priv.MAD	16384
ℹ   +-- 14: /var/lib/mysql/mysql/user.frm	13657
ℹ   +-- 15: /var/lib/mysql/mysql/servers.frm	10279
ℹ  Performance schema: File by IO read bytes execution time: 0.033s
 
-------- Performance schema: File by IO written bytes ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	68386816
ℹ   +-- 2: /var/lib/mysql/employees/titles.ibd	19644416
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	17055744
ℹ   +-- 4: /var/lib/mysql/employees/employees.ibd	14581760
ℹ   +-- 5: /var/lib/mysql/ibdata1	4767744
ℹ   +-- 6: /var/lib/mysql/undo001	4177920
ℹ   +-- 7: /var/lib/mysql/undo003	3588096
ℹ   +-- 8: /var/lib/mysql/undo002	3014656
ℹ   +-- 9: /var/lib/mysql/ibtmp1	2146304
ℹ   +-- 10: /var/lib/mysql/ddl_recovery.log	98406
ℹ   +-- 11: /var/lib/mysql/employees/departments.ibd	81920
ℹ   +-- 12: /var/lib/mysql/employees/dept_manager.ibd	81920
ℹ   +-- 13: /var/lib/mysql/mysql/innodb_index_stats.ibd	32768
ℹ   +-- 14: /var/lib/mysql/mysql/innodb_table_stats.ibd	32768
ℹ   +-- 15: /var/lib/mysql/employees/departments.frm	1619
ℹ  Performance schema: File by IO written bytes execution time: 0.029s
 
-------- Performance schema: File per IO total latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	1445363955014
ℹ   +-- 2: /var/lib/mysql/employees/titles.ibd	572146089319
ℹ   +-- 3: /var/lib/mysql/employees/employees.ibd	546248338391
ℹ   +-- 4: /var/lib/mysql/employees/dept_emp.ibd	522583906719
ℹ   +-- 5: /var/lib/mysql/ibdata1	98115556056
ℹ   +-- 6: /var/lib/mysql/ddl_recovery.log	83441671747
ℹ   +-- 7: /var/lib/mysql/undo002	79130009826
ℹ   +-- 8: /var/lib/mysql/undo003	50881269537
ℹ   +-- 9: /var/lib/mysql/undo001	27025190738
ℹ   +-- 10: /var/lib/mysql/employees/dept_manager.ibd	17987243533
ℹ   +-- 11: /var/lib/mysql/mysql/general_log.CSM	15011450440
ℹ   +-- 12: /var/lib/mysql/employees/departments.ibd	5779566688
ℹ   +-- 13: /var/lib/mysql/mysql/innodb_index_stats.ibd	4211156936
ℹ   +-- 14: /var/lib/mysql/employees/employees.frm	4200404957
ℹ   +-- 15: /var/lib/mysql/employees/salaries.frm	3942115800
ℹ   +-- 16: /var/lib/mysql/employees/departments.frm	3647030023
ℹ   +-- 17: /var/lib/mysql/employees/dept_emp_latest_date.frm	3334319583
ℹ   +-- 18: /usr/share/mariadb/charsets/Index.xml	3310927683
ℹ   +-- 19: /var/lib/mysql/employees/dept_emp.frm	3188359104
ℹ   +-- 20: /var/lib/mysql/employees/current_dept_emp.frm	2779532840
ℹ  Performance schema: File per IO total latency execution time: 0.028s
 
-------- Performance schema: file per IO read latency ----------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/employees.ibd	110433560825
ℹ   +-- 2: /var/lib/mysql/undo002	14641083114
ℹ   +-- 3: /var/lib/mysql/undo003	14615043450
ℹ   +-- 4: /var/lib/mysql/undo001	14491529794
ℹ   +-- 5: /var/lib/mysql/ibdata1	10073816851
ℹ   +-- 6: /var/lib/mysql/mysql/transaction_registry.ibd	1858102120
ℹ   +-- 7: /var/lib/mysql/mysql/innodb_table_stats.ibd	1049589023
ℹ   +-- 8: /var/lib/mysql/mysql/gtid_slave_pos.ibd	734972392
ℹ   +-- 9: /var/lib/mysql/mysql/innodb_index_stats.ibd	659702456
ℹ   +-- 10: /var/lib/mysql/aria_log_control	64568280
ℹ   +-- 11: /var/lib/mysql/mysql/global_priv.MAD	57456700
ℹ   +-- 12: /var/lib/mysql/mysql/event.frm	46330340
ℹ   +-- 13: /var/lib/mysql/sys/x@0024user_summary_by_statement_type.frm	42950404
ℹ   +-- 14: /var/lib/mysql/mysql/proc.MAD	35756980
ℹ   +-- 15: /var/lib/mysql/employees/salaries.frm	28932960
ℹ   +-- 16: /var/lib/mysql/aria_log.00000001	25106200
ℹ   +-- 17: /var/lib/mysql/employees/titles.frm	22617700
ℹ   +-- 18: /var/lib/mysql/mysql/proc.MAI	20626900
ℹ   +-- 19: /var/lib/mysql/mysql/user.frm	19885880
ℹ   +-- 20: /usr/share/mariadb/charsets/Index.xml	19498780
ℹ  Performance schema: file per IO read latency execution time: 0.032s
 
-------- Performance schema: file per IO write latency ---------------------------------------------
ℹ   +-- 1: /var/lib/mysql/employees/salaries.ibd	53298996597
ℹ   +-- 2: /var/lib/mysql/employees/employees.ibd	33978565180
ℹ   +-- 3: /var/lib/mysql/employees/dept_emp.ibd	18198887140
ℹ   +-- 4: /var/lib/mysql/employees/titles.ibd	16396537374
ℹ   +-- 5: /var/lib/mysql/undo001	6151959653
ℹ   +-- 6: /var/lib/mysql/undo003	3817318631
ℹ   +-- 7: /var/lib/mysql/undo002	3396083600
ℹ   +-- 8: /var/lib/mysql/ibtmp1	2573418680
ℹ   +-- 9: /var/lib/mysql/ddl_recovery.log	765960300
ℹ   +-- 10: /var/lib/mysql/employees/departments.ibd	649045040
ℹ   +-- 11: /var/lib/mysql/ibdata1	626095540
ℹ   +-- 12: /var/lib/mysql/employees/dept_manager.ibd	538024760
ℹ   +-- 13: /var/lib/mysql/mysql/innodb_table_stats.ibd	47569060
ℹ   +-- 14: /var/lib/mysql/employees/departments.frm	25725560
ℹ   +-- 15: /var/lib/mysql/mysql/innodb_index_stats.ibd	22197420
ℹ   +-- 16: /run/mysqld/mysqld.pid	22042580
ℹ   +-- 17: /var/lib/mysql/employees/salaries.frm	21390040
ℹ   +-- 18: /var/lib/mysql/employees/employees.frm	19509840
ℹ   +-- 19: /var/lib/mysql/employees/dept_manager.frm	18260060
ℹ   +-- 20: /var/lib/mysql/employees/dept_emp.frm	17773420
ℹ  Performance schema: file per IO write latency execution time: 0.032s
 
-------- Performance schema: Event Wait by read bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	6979584
ℹ   +-- 2: sql/FRM	488413
ℹ   +-- 3: aria/MAI	249112
ℹ   +-- 4: aria/MAD	131072
ℹ   +-- 5: mysys/charset	23509
ℹ   +-- 6: aria/translog	8236
ℹ   +-- 7: sql/file_parser	2063
ℹ   +-- 8: sql/dbopt	204
ℹ   +-- 9: csv/metadata	70
ℹ   +-- 10: aria/control	52
ℹ   +-- 11: sql/misc	0
ℹ   +-- 12: sql/pid	0
ℹ   +-- 13: sql/tclog	0
ℹ   +-- 14: myisam/dfile	0
ℹ   +-- 15: myisam/kfile	0
ℹ  Performance schema: Event Wait by read bytes execution time: 0.030s
 
-------- Performance schema: Event Wait written bytes ----------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	137592832
ℹ   +-- 2: aria/MAI	205163
ℹ   +-- 3: sql/global_ddl_log	98406
ℹ   +-- 4: sql/FRM	8078
ℹ   +-- 5: sql/file_parser	1935
ℹ   +-- 6: sql/dbopt	70
ℹ   +-- 7: sql/pid	2
ℹ   +-- 8: sql/misc	0
ℹ   +-- 9: sql/tclog	0
ℹ   +-- 10: mysys/charset	0
ℹ   +-- 11: myisam/dfile	0
ℹ   +-- 12: myisam/kfile	0
ℹ   +-- 13: csv/metadata	0
ℹ   +-- 14: csv/data	0
ℹ   +-- 15: aria/translog	0
ℹ  Performance schema: Event Wait written bytes execution time: 0.029s
 
-------- Performance schema: event per wait total latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	3377124229472
ℹ   +-- 2: sql/global_ddl_log	83462353947
ℹ   +-- 3: aria/MAI	43563196572
ℹ   +-- 4: aria/MAD	26655815494
ℹ   +-- 5: sql/FRM	24020695286
ℹ   +-- 6: csv/metadata	15542308320
ℹ   +-- 7: sql/file_parser	6388306323
ℹ   +-- 8: mysys/charset	3310927683
ℹ   +-- 9: sql/misc	302557360
ℹ   +-- 10: sql/dbopt	129722740
ℹ   +-- 11: sql/casetest	107768640
ℹ   +-- 12: sql/pid	104273680
ℹ   +-- 13: sql/tclog	93578660
ℹ   +-- 14: aria/translog	82629260
ℹ   +-- 15: aria/control	76513080
ℹ   +-- 16: myisam/dfile	74135180
ℹ   +-- 17: partition/ha_partition::parfile	51539600
ℹ   +-- 18: csv/data	47148780
ℹ   +-- 19: myisam/kfile	29574440
ℹ  Performance schema: event per wait total latency execution time: 0.030s
 
-------- Performance schema: event per wait read latency -------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	168557400025
ℹ   +-- 2: aria/MAI	961956772
ℹ   +-- 3: sql/FRM	784401744
ℹ   +-- 4: aria/MAD	146301680
ℹ   +-- 5: aria/control	64568280
ℹ   +-- 6: aria/translog	25106200
ℹ   +-- 7: mysys/charset	19498780
ℹ   +-- 8: sql/file_parser	19377120
ℹ   +-- 9: sql/dbopt	10805620
ℹ   +-- 10: csv/metadata	5773320
ℹ   +-- 11: sql/casetest	0
ℹ   +-- 12: sql/global_ddl_log	0
ℹ   +-- 13: sql/misc	0
ℹ   +-- 14: sql/pid	0
ℹ   +-- 15: sql/tclog	0
ℹ   +-- 16: myisam/dfile	0
ℹ   +-- 17: myisam/kfile	0
ℹ   +-- 18: csv/data	0
ℹ   +-- 19: partition/ha_partition::parfile	0
ℹ  Performance schema: event per wait read latency execution time: 0.032s
 
-------- Performance schema: event per wait write latency ------------------------------------------
ℹ   +-- 1: innodb/innodb_data_file	139694698675
ℹ   +-- 2: aria/MAI	10759942200
ℹ   +-- 3: sql/global_ddl_log	765960300
ℹ   +-- 4: sql/FRM	120211140
ℹ   +-- 5: sql/file_parser	32638060
ℹ   +-- 6: sql/pid	22042580
ℹ   +-- 7: sql/dbopt	17286780
ℹ   +-- 8: sql/casetest	0
ℹ   +-- 9: sql/misc	0
ℹ   +-- 10: sql/tclog	0
ℹ   +-- 11: mysys/charset	0
ℹ   +-- 12: myisam/dfile	0
ℹ   +-- 13: myisam/kfile	0
ℹ   +-- 14: csv/metadata	0
ℹ   +-- 15: csv/data	0
ℹ   +-- 16: aria/translog	0
ℹ   +-- 17: aria/MAD	0
ℹ   +-- 18: aria/control	0
ℹ   +-- 19: partition/ha_partition::parfile	0
ℹ  Performance schema: event per wait write latency execution time: 0.032s
 
-------- 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.031s
 
-------- 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.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.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.030s
 
-------- Performance schema: Top 15 high delete latency index --------------------------------------
ℹ   +-- 1: employees	employees	PRIMARY	0
ℹ   +-- 2: employees	departments	PRIMARY	0
ℹ   +-- 3: employees	departments	dept_name	0
ℹ   +-- 4: employees	dept_manager	PRIMARY	0
ℹ   +-- 5: employees	dept_manager	dept_no	0
ℹ   +-- 6: employees	dept_emp	PRIMARY	0
ℹ   +-- 7: employees	dept_emp	dept_no	0
ℹ   +-- 8: employees	titles	PRIMARY	0
ℹ   +-- 9: employees	salaries	PRIMARY	0
ℹ  Performance schema: Top 15 high delete latency index execution time: 0.032s
 
-------- Performance schema: Top 15 most read tables -----------------------------------------------
ℹ   +-- 1: employees	dept_manager	0
ℹ   +-- 2: employees	titles	0
ℹ   +-- 3: employees	salaries	0
ℹ   +-- 4: employees	departments	0
ℹ   +-- 5: employees	employees	0
ℹ   +-- 6: employees	dept_emp	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.034s
 
-------- Performance schema: Top 15 high read latency tables ---------------------------------------
ℹ   +-- 1: employees	dept_manager	0
ℹ   +-- 2: employees	titles	0
ℹ   +-- 3: employees	salaries	0
ℹ   +-- 4: employees	departments	0
ℹ   +-- 5: employees	employees	0
ℹ   +-- 6: employees	dept_emp	0
ℹ  Performance schema: Top 15 high read latency tables execution time: 0.034s
 
-------- Performance schema: Top 15 high insert latency tables -------------------------------------
ℹ   +-- 1: employees	salaries	7218141168371
ℹ   +-- 2: employees	dept_emp	1498872346167
ℹ   +-- 3: employees	titles	1370980709721
ℹ   +-- 4: employees	employees	685673502654
ℹ   +-- 5: employees	dept_manager	156797620
ℹ   +-- 6: employees	departments	112535500
ℹ  Performance schema: Top 15 high insert latency tables execution time: 0.033s
 
-------- Performance schema: Top 15 high update latency tables -------------------------------------
ℹ   +-- 1: employees	dept_manager	0
ℹ   +-- 2: employees	titles	0
ℹ   +-- 3: employees	salaries	0
ℹ   +-- 4: employees	departments	0
ℹ   +-- 5: employees	employees	0
ℹ   +-- 6: employees	dept_emp	0
ℹ  Performance schema: Top 15 high update latency tables execution time: 0.033s
 
-------- Performance schema: Top 15 high delete latency tables -------------------------------------
ℹ   +-- 1: employees	dept_manager	0
ℹ   +-- 2: employees	titles	0
ℹ   +-- 3: employees	salaries	0
ℹ   +-- 4: employees	departments	0
ℹ   +-- 5: employees	employees	0
ℹ   +-- 6: employees	dept_emp	0
ℹ  Performance schema: Top 15 high delete latency tables execution time: 0.034s
 
-------- Performance schema: Redundant indexes -----------------------------------------------------
ℹ  No information found or indicators deactivated.
ℹ  Performance schema: Redundant indexes execution time: 0.030s
 
-------- Performance schema: Table not using InnoDB buffer -----------------------------------------
ℹ   +-- 1: employees	dept_emp
ℹ   +-- 2: employees	titles
ℹ   +-- 3: employees	dept_manager
ℹ   +-- 4: employees	departments
ℹ  Performance schema: Table not using InnoDB buffer execution time: 0.046s
 
-------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
ℹ   +-- 1: employees	salaries	88555520
ℹ   +-- 2: employees	employees	12435456
ℹ  Performance schema: Top 15 Tables using InnoDB buffer execution time: -2.885s
 
-------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
ℹ   +-- 1: employees	salaries	7639824
ℹ   +-- 2: employees	employees	1028977
ℹ  Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.044s
 
-------- Performance schema: Top 15 Most executed queries ------------------------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	114
ℹ   +-- 2: NULL	SELECT SCHEMA ( ) 	31
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	21
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	17
ℹ   +-- 5: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	14
ℹ   +-- 6: employees	SELECT ? AS ? 	7
ℹ   +-- 7: NULL	SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS 	6
ℹ   +-- 8: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 9: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 10: NULL	SHOW SCHEMAS 	3
ℹ   +-- 11: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 	3
ℹ   +-- 12: NULL	SELECT `VERSION` ( ) 	2
ℹ   +-- 13: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	2
ℹ   +-- 14: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 	2
ℹ   +-- 15: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 	2
ℹ  Performance schema: Top 15 Most executed queries execution time: 0.030s
 
-------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
ℹ   +-- 1: DROP SCHEMA IF EXISTS `employees` 	2026-07-05 15:39:48
ℹ   +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	2026-07-05 15:39:48
ℹ  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 `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 	3
ℹ   +-- 4: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	2
ℹ   +-- 5: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 	2
ℹ   +-- 6: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 	2
ℹ   +-- 7: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	2
ℹ   +-- 8: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME FROM `information_schema` . `tables` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN	2
ℹ   +-- 9: employees	SELECT `timediff` ( ( SELECT `update_time` FROM `information_schema` . `tables` WHERE `table_schema` = ? AND TABLE_NAME 	1
ℹ   +-- 10: NULL	SELECT SUM ( `TABLE_ROWS` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	1
ℹ   +-- 11: NULL	SELECT `ROUND` ( SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) / ? / ?, ... ) FROM `information_schema` . `TABLES` WHERE `TABLE	1
ℹ   +-- 12: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 	1
ℹ   +-- 13: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	1
ℹ   +-- 14: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	1
ℹ   +-- 15: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	1
ℹ   +-- 16: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	1
ℹ   +-- 17: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	1
ℹ   +-- 18: NULL	SELECT ? FROM `information_schema` . `tables` WHERE `table_schema` = ? AND TABLE_NAME = ? LIMIT ? 	1
ℹ   +-- 19: NULL	SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...) 	1
ℹ   +-- 20: NULL	SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 	1
ℹ  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 `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:40:16
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:40:16
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	2026-07-05 15:40:15
ℹ   +-- 4: NULL	SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w	2026-07-05 15:40:15
ℹ   +-- 5: 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:40:15
ℹ   +-- 6: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:40:15
ℹ   +-- 7: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:40:15
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:40:15
ℹ   +-- 9: 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:40:15
ℹ   +-- 10: NULL	SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ? 	2026-07-05 15:40:15
ℹ   +-- 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:40:15
ℹ   +-- 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:40:15
ℹ   +-- 13: 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:40:15
ℹ   +-- 14: 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:40:15
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 16: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:40:14
ℹ   +-- 18: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:40:14
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 20: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 21: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:40:14
ℹ   +-- 22: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 23: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 24: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 25: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 26: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 27: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 28: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 29: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 30: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 31: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 32: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 33: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:40:14
ℹ   +-- 34: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 35: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:40:14
ℹ   +-- 36: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:40:14
ℹ   +-- 37: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 	2026-07-05 15:40:13
ℹ   +-- 38: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	2026-07-05 15:40:13
ℹ   +-- 39: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:40:13
ℹ   +-- 40: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `DATA_TYPE` = ? AND `TABLE_	2026-07-05 15:40:13
ℹ   +-- 41: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE IGNORED = ? AND `TABLE_	2026-07-05 15:40:13
ℹ   +-- 42: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:40:13
ℹ   +-- 43: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `IS_NULLABLE` = ? AND `TABL	2026-07-05 15:40:13
ℹ   +-- 44: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:40:13
ℹ   +-- 45: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:40:13
ℹ   +-- 46: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:40:13
ℹ   +-- 47: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:40:13
ℹ   +-- 48: NULL	SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? 	2026-07-05 15:40:13
ℹ   +-- 49: NULL	SELECT COUNT ( * ) FROM `information_schema` . `columns` WHERE TABLE_NAME = ? AND `TABLE_SCHEMA` = ? AND COLUMN_NAME = ?	2026-07-05 15:40:13
ℹ   +-- 50: NULL	SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE `IS_ROLE` = ? 	2026-07-05 15:40:13
ℹ  Performance schema: Last 50 queries with full table scans execution time: 0.029s
 
-------- Performance schema: Top 15 reader queries (95% percentile) --------------------------------
ℹ   +-- 1: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	2
ℹ   +-- 2: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	0
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	0
ℹ   +-- 4: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	0
ℹ   +-- 5: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	0
ℹ   +-- 6: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	0
ℹ   +-- 7: employees	DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	0
ℹ   +-- 8: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	0
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ  Performance schema: Top 15 reader queries (95% percentile) execution time: 0.037s
 
-------- Performance schema: Top 15 most row look queries (95% percentile) -------------------------
ℹ   +-- 1: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	444
ℹ   +-- 2: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	87
ℹ   +-- 3: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	18
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	0
ℹ   +-- 5: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	0
ℹ   +-- 6: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	0
ℹ   +-- 7: employees	DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	0
ℹ   +-- 8: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	0
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	0
ℹ  Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.037s
 
-------- Performance schema: Top 15 total latency queries (95% percentile) -------------------------
ℹ   +-- 1: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	12664007343000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	2342622074000
ℹ   +-- 3: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	2161386697000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	1436056239000
ℹ   +-- 5: employees	DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	49350103000
ℹ   +-- 6: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	49234918000
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	39880362000
ℹ   +-- 8: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	39866921000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	23588540000
ℹ  Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.037s
 
-------- Performance schema: Top 15 max latency queries (95% percentile) ---------------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	322412890000
ℹ   +-- 2: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	262360561000
ℹ   +-- 3: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	213981432000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	211810419000
ℹ   +-- 5: employees	DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	49350103000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	39880362000
ℹ   +-- 7: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	39866921000
ℹ   +-- 8: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	38725269000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	23588540000
ℹ   +-- 10: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	17275168000
ℹ  Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.038s
 
-------- Performance schema: Top 15 average latency queries (95% percentile) -----------------------
ℹ   +-- 1: employees	INSERT INTO `dept_emp` VALUES (...) /* , ... */ 	154384764000
ℹ   +-- 2: employees	INSERT INTO `titles` VALUES (...) /* , ... */ 	111553432000
ℹ   +-- 3: employees	INSERT INTO `salaries` VALUES (...) /* , ... */ 	111087783000
ℹ   +-- 4: employees	INSERT INTO `employees` VALUES (...) /* , ... */ 	84473896000
ℹ   +-- 5: employees	DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 	49350103000
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	39880362000
ℹ   +-- 7: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	39866921000
ℹ   +-- 8: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	24617459000
ℹ   +-- 9: employees	CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU	23588540000
ℹ   +-- 10: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	17275168000
ℹ  Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.037s
 
-------- Performance schema: Top 20 queries with sort ----------------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	1
ℹ   +-- 4: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	1
ℹ   +-- 5: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	1
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	1
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	1
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	1
ℹ   +-- 9: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	1
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	1
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	1
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	1
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	1
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	1
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	1
ℹ   +-- 16: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	1
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	1
ℹ   +-- 18: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	1
ℹ   +-- 19: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 	1
ℹ   +-- 20: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 	1
ℹ  Performance schema: Top 20 queries with sort execution time: 0.037s
 
-------- Performance schema: Last 50 queries with sort ---------------------------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:40:16
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:40:16
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	2026-07-05 15:40:15
ℹ   +-- 4: 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:40:15
ℹ   +-- 5: NULL	SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 	2026-07-05 15:40:15
ℹ   +-- 6: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:40:15
ℹ   +-- 7: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER	2026-07-05 15:40:15
ℹ   +-- 8: NULL	SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ? 	2026-07-05 15:40:15
ℹ   +-- 9: NULL	SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ? 	2026-07-05 15:40:15
ℹ   +-- 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:40:15
ℹ   +-- 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:40:15
ℹ   +-- 12: 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:40:15
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:40:14
ℹ   +-- 16: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:40:14
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 18: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 19: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:40:14
ℹ   +-- 20: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 21: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 22: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 23: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 24: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 25: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 26: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 27: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 28: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 29: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 30: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 31: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:40:14
ℹ   +-- 32: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 33: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:40:14
ℹ   +-- 34: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:40:14
ℹ   +-- 35: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:40:13
ℹ   +-- 36: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:40:13
ℹ   +-- 37: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	2026-07-05 15:40:13
ℹ   +-- 38: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:40:13
ℹ   +-- 39: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:40:13
ℹ   +-- 40: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:40:13
ℹ   +-- 41: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 	2026-07-05 15:40:13
ℹ   +-- 42: NULL	SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db`	2026-07-05 15:40:13
ℹ   +-- 43: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O	2026-07-05 15:40:13
ℹ   +-- 44: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	2026-07-05 15:40:13
ℹ   +-- 45: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO	2026-07-05 15:40:13
ℹ   +-- 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:40:12
ℹ   +-- 47: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:40:12
ℹ   +-- 48: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	2026-07-05 15:40:11
ℹ   +-- 49: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	2026-07-05 15:40:10
ℹ   +-- 50: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	2026-07-05 15:40:10
ℹ  Performance schema: Last 50 queries with sort execution time: 0.034s
 
-------- 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` 	6345
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	6345
ℹ   +-- 3: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	6345
ℹ   +-- 4: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	6184
ℹ   +-- 5: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	6174
ℹ   +-- 6: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	282
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	99
ℹ   +-- 8: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR	50
ℹ   +-- 9: NULL	SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT	50
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D	42
ℹ   +-- 11: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	30
ℹ   +-- 12: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	28
ℹ   +-- 13: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	24
ℹ   +-- 14: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	20
ℹ   +-- 15: NULL	SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 	20
ℹ  Performance schema: Top 15 row sorting queries with sort execution time: 0.032s
 
-------- Performance schema: Top 15 total latency queries with sort --------------------------------
ℹ   +-- 1: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	15912575000
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	15775572000
ℹ   +-- 3: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	15601994000
ℹ   +-- 4: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	15557520000
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	13523532000
ℹ   +-- 6: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	13503166000
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	10847599000
ℹ   +-- 8: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	9762419000
ℹ   +-- 9: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	4847153000
ℹ   +-- 10: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	4694534000
ℹ   +-- 11: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	4328237000
ℹ   +-- 12: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	4257295000
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	2987785000
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	2887708000
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	2151087000
ℹ  Performance schema: Top 15 total latency queries with sort execution time: 0.032s
 
-------- Performance schema: Top 15 merge queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	0
ℹ   +-- 2: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 3: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 4: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 5: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ   +-- 9: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	0
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	0
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	0
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	0
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	0
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	0
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	0
ℹ  Performance schema: Top 15 merge queries with sort execution time: 0.032s
 
-------- Performance schema: Top 15 average sort merges queries with sort --------------------------
ℹ   +-- 1: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	0
ℹ   +-- 2: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 3: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 4: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 5: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ   +-- 9: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	0
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	0
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	0
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	0
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	0
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	0
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	0
ℹ  Performance schema: Top 15 average sort merges queries with sort execution time: 0.030s
 
-------- Performance schema: Top 15 scans queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	6
ℹ   +-- 4: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	6
ℹ   +-- 5: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	6
ℹ   +-- 6: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	6
ℹ   +-- 7: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	6
ℹ   +-- 8: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 	5
ℹ   +-- 9: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 	5
ℹ   +-- 10: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 	5
ℹ   +-- 11: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 	5
ℹ   +-- 12: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	5
ℹ   +-- 13: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 	5
ℹ   +-- 14: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	5
ℹ   +-- 15: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	5
ℹ  Performance schema: Top 15 scans queries with sort execution time: 0.032s
 
-------- Performance schema: Top 15 range queries with sort ----------------------------------------
ℹ   +-- 1: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	0
ℹ   +-- 2: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	0
ℹ   +-- 3: NULL	SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T	0
ℹ   +-- 4: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	0
ℹ   +-- 5: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	0
ℹ   +-- 6: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	0
ℹ   +-- 7: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	0
ℹ   +-- 8: NULL	SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_	0
ℹ   +-- 9: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	0
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	0
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	0
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	0
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	0
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	0
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	0
ℹ  Performance schema: Top 15 range queries with sort execution time: 0.031s
 
-------- Performance schema: Top 20 queries with temp table ----------------------------------------
ℹ   +-- 1: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	6
ℹ   +-- 2: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 3: NULL	SHOW SCHEMAS 	3
ℹ   +-- 4: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 	3
ℹ   +-- 5: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	2
ℹ   +-- 6: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 	2
ℹ   +-- 7: NULL	SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 	2
ℹ   +-- 8: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	2
ℹ   +-- 9: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME FROM `information_schema` . `tables` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN	2
ℹ   +-- 10: employees	SELECT `timediff` ( ( SELECT `update_time` FROM `information_schema` . `tables` WHERE `table_schema` = ? AND TABLE_NAME 	1
ℹ   +-- 11: NULL	SELECT SUM ( `TABLE_ROWS` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	1
ℹ   +-- 12: NULL	SELECT `ROUND` ( SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) / ? / ?, ... ) FROM `information_schema` . `TABLES` WHERE `TABLE	1
ℹ   +-- 13: NULL	SHOW VARIABLES 	1
ℹ   +-- 14: NULL	SHOW GLOBAL VARIABLES 	1
ℹ   +-- 15: NULL	SHOW STATUS 	1
ℹ   +-- 16: NULL	SHOW GLOBAL STATUS 	1
ℹ   +-- 17: NULL	SHOW ENGINES 	1
ℹ   +-- 18: NULL	SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 	1
ℹ   +-- 19: NULL	SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . `	1
ℹ   +-- 20: NULL	SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 	1
ℹ  Performance schema: Top 20 queries with temp table execution time: 0.029s
 
-------- Performance schema: Last 50 queries with temp table ---------------------------------------
ℹ   +-- 1: NULL	SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr	2026-07-05 15:40:16
ℹ   +-- 2: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	2026-07-05 15:40:16
ℹ   +-- 3: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	2026-07-05 15:40:15
ℹ   +-- 4: NULL	SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w	2026-07-05 15:40:15
ℹ   +-- 5: 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:40:15
ℹ   +-- 6: NULL	SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU	2026-07-05 15:40:15
ℹ   +-- 7: NULL	SHOW SCHEMAS 	2026-07-05 15:40:14
ℹ   +-- 8: NULL	SELECT `sys_version` FROM `sys` . `version` 	2026-07-05 15:40:14
ℹ   +-- 9: NULL	SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 10: NULL	SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ?	2026-07-05 15:40:14
ℹ   +-- 12: NULL	SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI	2026-07-05 15:40:14
ℹ   +-- 13: NULL	SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 14: NULL	SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 15: NULL	SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI	2026-07-05 15:40:14
ℹ   +-- 16: NULL	SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 17: NULL	SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 18: NULL	SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 19: NULL	SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 20: NULL	SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 21: NULL	SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 22: NULL	SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 23: NULL	SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 24: NULL	SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 25: NULL	SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 26: NULL	SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 27: NULL	SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_	2026-07-05 15:40:14
ℹ   +-- 28: NULL	SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 	2026-07-05 15:40:14
ℹ   +-- 29: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	2026-07-05 15:40:14
ℹ   +-- 30: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	2026-07-05 15:40:14
ℹ   +-- 31: NULL	SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 	2026-07-05 15:40:13
ℹ   +-- 32: NULL	SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 	2026-07-05 15:40:13
ℹ   +-- 33: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	2026-07-05 15:40:13
ℹ   +-- 34: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `DATA_TYPE` = ? AND `TABLE_	2026-07-05 15:40:13
ℹ   +-- 35: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE IGNORED = ? AND `TABLE_	2026-07-05 15:40:13
ℹ   +-- 36: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	2026-07-05 15:40:13
ℹ   +-- 37: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `IS_NULLABLE` = ? AND `TABL	2026-07-05 15:40:13
ℹ   +-- 38: NULL	SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E	2026-07-05 15:40:13
ℹ   +-- 39: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	2026-07-05 15:40:13
ℹ   +-- 40: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	2026-07-05 15:40:13
ℹ   +-- 41: NULL	SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? 	2026-07-05 15:40:13
ℹ   +-- 42: NULL	SELECT COUNT ( * ) FROM `information_schema` . `columns` WHERE TABLE_NAME = ? AND `TABLE_SCHEMA` = ? AND COLUMN_NAME = ?	2026-07-05 15:40:13
ℹ   +-- 43: NULL	SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 	2026-07-05 15:40:13
ℹ   +-- 44: NULL	SHOW SESSION STATUS LIKE ? 	2026-07-05 15:40:13
ℹ   +-- 45: NULL	SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P	2026-07-05 15:40:13
ℹ   +-- 46: NULL	SELECT COUNT ( * ) FROM `information_schema` . `tables` 	2026-07-05 15:40:13
ℹ   +-- 47: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	2026-07-05 15:40:13
ℹ   +-- 48: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	2026-07-05 15:40:13
ℹ   +-- 49: NULL	SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE	2026-07-05 15:40:12
ℹ   +-- 50: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	2026-07-05 15:40:12
ℹ  Performance schema: Last 50 queries with temp table execution time: 0.032s
 
-------- Performance schema: Top 15 total latency queries with temp table --------------------------
ℹ   +-- 1: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	49234918000
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	39880362000
ℹ   +-- 3: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	39866921000
ℹ   +-- 4: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	17275168000
ℹ   +-- 5: NULL	SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 	15912575000
ℹ   +-- 6: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER	15775572000
ℹ   +-- 7: NULL	SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER	15601994000
ℹ   +-- 8: NULL	SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in	15557520000
ℹ   +-- 9: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	13523532000
ℹ   +-- 10: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	13503166000
ℹ   +-- 11: NULL	SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 	10847599000
ℹ   +-- 12: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	10477886000
ℹ   +-- 13: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	9762419000
ℹ   +-- 14: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i	5696450000
ℹ   +-- 15: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	5367273000
ℹ  Performance schema: Top 15 total latency queries with temp table execution time: 0.030s
 
-------- Performance schema: Top 15 queries with temp table to disk --------------------------------
ℹ   +-- 1: NULL	SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T	53
ℹ   +-- 2: NULL	SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ?	40
ℹ   +-- 3: NULL	SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c`	20
ℹ   +-- 4: NULL	SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU	19
ℹ   +-- 5: NULL	SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform	14
ℹ   +-- 6: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i	14
ℹ   +-- 7: NULL	SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO	14
ℹ   +-- 8: NULL	SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . `	13
ℹ   +-- 9: NULL	SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN	13
ℹ   +-- 10: NULL	SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS	13
ℹ   +-- 11: NULL	SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 	12
ℹ   +-- 12: NULL	SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH`	6
ℹ   +-- 13: NULL	SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 	6
ℹ   +-- 14: NULL	SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA	6
ℹ   +-- 15: NULL	SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch	3
ℹ  Performance schema: Top 15 queries with temp table to disk execution time: 0.031s
 
-------- Performance schema: Top 15 class events by number -----------------------------------------
ℹ   +-- 1: wait/io/table	3919015
ℹ   +-- 2: wait/io/file	20327
ℹ   +-- 3: wait/lock/table	171
ℹ  Performance schema: Top 15 class events by number execution time: 0.032s
 
-------- Performance schema: Top 30 events by number -----------------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_data_file	9167
ℹ   +-- 2: wait/io/file/aria/MAI	8417
ℹ   +-- 3: wait/io/file/aria/MAD	1475
ℹ   +-- 4: wait/io/file/sql/FRM	914
ℹ   +-- 5: wait/io/file/sql/file_parser	128
ℹ   +-- 6: wait/io/file/sql/global_ddl_log	112
ℹ   +-- 7: wait/io/file/sql/misc	25
ℹ   +-- 8: wait/io/file/sql/dbopt	21
ℹ   +-- 9: wait/io/file/myisam/dfile	18
ℹ   +-- 10: wait/io/file/aria/translog	9
ℹ   +-- 11: wait/io/file/csv/metadata	8
ℹ   +-- 12: wait/io/file/myisam/kfile	6
ℹ   +-- 13: wait/io/file/partition/ha_partition::parfile	6
ℹ   +-- 14: wait/io/file/sql/casetest	5
ℹ   +-- 15: wait/io/file/csv/data	4
ℹ   +-- 16: wait/io/file/sql/pid	3
ℹ   +-- 17: wait/io/file/sql/tclog	3
ℹ   +-- 18: wait/io/file/mysys/charset	3
ℹ   +-- 19: wait/io/file/aria/control	3
ℹ  Performance schema: Top 30 events by number execution time: 0.032s
 
-------- Performance schema: Top 15 class events by total latency ----------------------------------
ℹ   +-- 1: wait/io/table	10773937060033
ℹ   +-- 2: wait/io/file	3584854766997
ℹ   +-- 3: wait/lock/table	404696460
ℹ  Performance schema: Top 15 class events by total latency execution time: 0.031s
 
-------- Performance schema: Top 30 events by total latency ----------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_data_file	3377925581772
ℹ   +-- 2: wait/io/file/sql/global_ddl_log	83462353947
ℹ   +-- 3: wait/io/file/aria/MAI	45717496552
ℹ   +-- 4: wait/io/file/aria/MAD	27387655694
ℹ   +-- 5: wait/io/file/sql/FRM	24020695286
ℹ   +-- 6: wait/io/file/csv/metadata	15542308320
ℹ   +-- 7: wait/io/file/sql/file_parser	6388306323
ℹ   +-- 8: wait/io/file/mysys/charset	3310927683
ℹ   +-- 9: wait/io/file/sql/misc	302557360
ℹ   +-- 10: wait/io/file/sql/dbopt	129722740
ℹ   +-- 11: wait/io/file/sql/casetest	107768640
ℹ   +-- 12: wait/io/file/sql/pid	104273680
ℹ   +-- 13: wait/io/file/sql/tclog	93578660
ℹ   +-- 14: wait/io/file/aria/translog	82629260
ℹ   +-- 15: wait/io/file/aria/control	76513080
ℹ   +-- 16: wait/io/file/myisam/dfile	74135180
ℹ   +-- 17: wait/io/file/partition/ha_partition::parfile	51539600
ℹ   +-- 18: wait/io/file/csv/data	47148780
ℹ   +-- 19: wait/io/file/myisam/kfile	29574440
ℹ  Performance schema: Top 30 events by total latency execution time: 0.032s
 
-------- Performance schema: Top 15 class events by max latency ------------------------------------
ℹ   +-- 1: wait/io/table	110776402023
ℹ   +-- 2: wait/io/file	60948020707
ℹ   +-- 3: wait/lock/table	4977000
ℹ  Performance schema: Top 15 class events by max latency execution time: 0.031s
 
-------- Performance schema: Top 30 events by max latency ------------------------------------------
ℹ   +-- 1: wait/io/file/innodb/innodb_data_file	60948020707
ℹ   +-- 2: wait/io/file/csv/metadata	14999527760
ℹ   +-- 3: wait/io/file/sql/global_ddl_log	10150138040
ℹ   +-- 4: wait/io/file/sql/FRM	4029539017
ℹ   +-- 5: wait/io/file/mysys/charset	3283996583
ℹ   +-- 6: wait/io/file/sql/file_parser	3200161783
ℹ   +-- 7: wait/io/file/aria/MAD	2483384197
ℹ   +-- 8: wait/io/file/aria/MAI	348246220
ℹ   +-- 9: wait/io/file/sql/misc	108299520
ℹ   +-- 10: wait/io/file/sql/pid	76756400
ℹ   +-- 11: wait/io/file/sql/casetest	71757280
ℹ   +-- 12: wait/io/file/aria/control	64568280
ℹ   +-- 13: wait/io/file/sql/dbopt	51119320
ℹ   +-- 14: wait/io/file/sql/tclog	49637280
ℹ   +-- 15: wait/io/file/aria/translog	35148680
ℹ   +-- 16: wait/io/file/csv/data	26112660
ℹ   +-- 17: wait/io/file/partition/ha_partition::parfile	14300580
ℹ   +-- 18: wait/io/file/myisam/dfile	6735540
ℹ   +-- 19: wait/io/file/myisam/kfile	6702360
ℹ  Performance schema: Top 30 events by max latency execution time: 0.030s
 
-------- MyISAM Metrics ----------------------------------------------------------------------------
ℹ  General MyIsam metrics:
ℹ   +-- Total MyISAM Tables  : 0
ℹ   +-- Total MyISAM indexes : 0B
ℹ   +-- KB Size :128.0M
ℹ   +-- KB Used Size :23.3M
ℹ   +-- 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 variable 'innodb_prefix_index_cluster_optimization' is removed in MariaDB 10.10.0.
ℹ  InnoDB Metrics execution time: 0.000s
 
-------- Smart Migration LTS Advisor ---------------------------------------------------------------
✘  Found 1 potential migration risks.
ℹ   - [Migration Risk] sql_mode: NO_AUTO_CREATE_USER is removed in modern versions. Ensure your scripts do not rely on it.
ℹ  InnoDB Buffers
ℹ   +-- InnoDB Buffer Pool: 128.0M
ℹ   +-- InnoDB Buffer Pool Instances: 1
ℹ   +-- InnoDB Buffer Pool Chunk Size: 0B
ℹ   +-- InnoDB Log File Size: 96.0M
ℹ   +-- InnoDB Log File In Group: 1
ℹ   +-- InnoDB Total Log File Size: 96.0M(75 % of buffer pool)
ℹ   +-- InnoDB Log Buffer: 16.0M
ℹ   +-- InnoDB Buffer Free: 1.4K
ℹ   +-- InnoDB Buffer Used: 7.9K
✔  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 / 122.8M
ℹ  innodb_buffer_pool_chunk_size is set to 'autosize' (0) in MariaDB >= 10.8. Skipping chunk size checks.
✔  InnoDB Read buffer efficiency: 100.00% (22700226 hits / 22700491 total)
✔  InnoDB Write Log efficiency: 100.00% (8178789 hits / 8179031 total)
✔  InnoDB log waits: 0.00% (0 waits / 242 writes)
ℹ  Smart Migration LTS Advisor execution time: 0.000s
 
-------- InnoDB Transactions -----------------------------------------------------------------------
ℹ  Transaction Isolation Level: REPEATABLE-READ
ℹ  InnoDB Snapshot Isolation: OFF
✘  innodb_snapshot_isolation is OFF with REPEATABLE-READ (Stricter snapshot isolation is disabled)
ℹ  Active InnoDB Transactions: 0
ℹ  InnoDB Transactions execution time: 0.000s
 
-------- Infrastructure-Aware InnoDB Tuning --------------------------------------------------------
ℹ  Detected Storage Type: HDD
✔  innodb_flush_neighbors is enabled for HDD: 1
ℹ  Infrastructure-Aware InnoDB Tuning execution time: 0.000s
 
-------- InnoDB Index/Data Ratio Check -------------------------------------------------------------
ℹ  Checked InnoDB tables with > 50,000 rows: 4
✘  Under-indexed tables (ratio < 0.3): 3
ℹ  InnoDB Index/Data Ratio Check execution time: 0.031s
 
-------- Query Cache Information -------------------------------------------------------------------
ℹ  QUERY_CACHE_INFO plugin is not active or not installed.
ℹ  Query Cache Information execution time: 0.030s
 
-------- Query Anti-Pattern Detection (Experimental) -----------------------------------------------
ℹ  Skipped: Performance Schema is disabled.
ℹ  Query Anti-Pattern Detection (Experimental) execution time: 0.032s
 
-------- Aria Metrics ------------------------------------------------------------------------------
ℹ  Aria Storage Engine is enabled.
✔  Aria pagecache size / total Aria indexes: 128.0M/936.0K
✘  Aria pagecache hit rate: 7.7% (13 cached / 12 reads)
ℹ  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: MIXED
ℹ  XA support enabled: ON
ℹ  Semi synchronous replication Source: OFF
ℹ  Semi synchronous replication Replica: OFF
ℹ  This is a standalone server
ℹ  Replication Metrics execution time: 0.000s
 
-------- Predictive Capacity Planning --------------------------------------------------------------
✔  Memory headroom: 15.9G (Theoretical max usage is 22.12% 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.
✘  binlog_format is MIXED (recommended: ROW)
✘  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_snapshot_isolation = ON;

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
    innodb_snapshot_isolation=ON
ℹ  Guided Auto-Fix Snippets execution time: 0.000s
 
-------- Health Score KPI --------------------------------------------------------------------------
Overall Weighted Health Score: 65/100
    - Performance: 40/40
    - Security:    0/30
    - Resilience:  25/30

✘  Your database health is below optimal levels. Refer to the specific findings below.
 
ℹ  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;
    Migrate to 'ed25519', 'parsec' or 'unix_socket' for 6 user(s)
    Enable require_secure_transport to force all connections to use SSL.
    8 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
    Unused indexes found: 3 index(es) should be reviewed and potentially removed.
    Remove 'innodb_prefix_index_cluster_optimization' from your configuration. Always enabled.
    Migration Risk (sql_mode): NO_AUTO_CREATE_USER is removed in modern versions. Ensure your scripts do not rely on it.
    Set binlog_format = ROW for robust GTID and replication consistency.
    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
    innodb_snapshot_isolation=ON