>> MySQLTuner 2.9.0 * Jean-Marie Renouard * Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.pl/ >> Run with '--help' for additional options and output filtering >> Started at: 2026-07-05 17:42:31 ℹ Skipped version check for MySQLTuner script ✔ Logged in using credentials passed on the command line -------- Audit Snapshot Summary -------------------------------------------------------------------- ℹ MySQLTuner Version : 2.9.0 ℹ Audit Start Time : 2026-07-05 17:42:31 ℹ Server Connection : 127.0.0.1:3306 ℹ Database User : root@localhost ℹ Database Version : 8.0.45-36 ℹ System Physical RAM: 15.3G ℹ System Swap Memory : 4.0G ℹ Database Uptime : 48s ℹ Skipping architecture check on remote host ℹ Using default 64 bits as target architecture ℹ Audit Snapshot Summary execution time: 1.158s -------- Storage Engine Statistics ----------------------------------------------------------------- ℹ Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM -ndbcluster -ndbinfo +PERFORMANCE_SCHEMA ℹ Data in InnoDB tables: 31.7M (Tables: 7) ✔ Total fragmented tables: 0 ✔ Currently running supported MySQL/MariaDB version 8.0.45(LTS) ℹ Storage Engine Statistics execution time: 1.117s -------- System Linux Recommendations -------------------------------------------------------------- Look for related Linux system recommendations ℹ Ubuntu 24.04.4 LTS ℹ Machine type : Container ✘ Internet : Disconnected ℹ Number of Core CPU : 10 ℹ Operating System Type : GNU/Linux ℹ Kernel Release : 6.18.33.2-microsoft-standard-WSL2 ℹ Hostname : Ligthpath-Main ℹ Network Cards : ℹ sh: line 1: ip: command not found ℹ Internal IP : 172.18.0.3 ℹ HTTP client found: /usr/bin/curl ℹ External IP : 82.67.192.129 ℹ Name Servers : 127.0.0.11 ℹ Logged In users : ℹ Ram Usages in MB : ℹ total used free shared buff/cache available ℹ Mem: 15630 3607 9980 4 2287 12022 ℹ Swap: 4096 0 4096 ℹ Load Average : ℹ top - 15:42:41 up 4 days, 5:13, 0 users, load average: 2.23, 1.35, 0.69 ℹ System Uptime : ℹ 15:42:41 up 4 days, 5:13, 0 users, load average: 2.05, 1.33, 0.68 ℹ Database Uptime : 48s ✔ There is at least one CPU dedicated to database server. ✔ There is at least 1.5 Gb of RAM dedicated to Linux server. ℹ User process except mysqld used 19M RAM. ℹ Other user process except mysqld used less than 15% of total physical memory 0.13% (19M / 15G) ℹ System Linux Recommendations execution time: 4.510s -------- Filesystem Linux Recommendations ---------------------------------------------------------- ℹ mount point /etc/hosts is using 14 % total space (131.83 GB / 1006.85 GB) ℹ mount point / is using 3 % of max allowed inodes ℹ mount point /etc/hosts is using 3 % of max allowed inodes ℹ Filesystem Linux Recommendations execution time: 0.779s -------- Log file Recommendations ------------------------------------------------------------------ ✔ Performance Schema error_log table detected ℹ Performance Schema error_log: 11 entries detected ✔ performance_schema.error_log doesn't contain any warning. ✔ performance_schema.error_log doesn't contain any error. ℹ 2 start(s) detected in performance_schema.error_log ℹ 1) X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock ℹ 2) /usr/sbin/mysqld: ready for connections. Version: '8.0.45-36' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 36, Revision 8fe4a72d. ℹ 0 shutdown(s) detected in performance_schema.error_log ℹ Log file Recommendations execution time: 0.227s -------- Analysis Performance Metrics -------------------------------------------------------------- ℹ innodb_stats_on_metadata: OFF ✔ No stat updates during querying INFORMATION_SCHEMA. ℹ Analysis Performance Metrics execution time: 0.000s -------- Database Metrics -------------------------------------------------------------------------- ℹ There is 1 Database(s). ℹ All User Databases: ℹ +-- TABLE : 6 ℹ +-- VIEW : 2 ℹ +-- INDEX : 9 ℹ +-- CHARS : 1 (utf8mb4) ℹ +-- COLLA : 1 (utf8mb4_0900_ai_ci) ℹ +-- ROWS : 3918131 ℹ +-- DATA : 26.1M(82.47%) ℹ +-- INDEX : 5.5M(17.53%) ℹ +-- SIZE : 31.6M ℹ +-- ENGINE: 1 (InnoDB) ℹ Database: employees ℹ +-- TABLE : 6 ℹ +-- VIEW : 2 ℹ +-- INDEX : 9 ℹ +-- CHARS : 1 (utf8mb4) ℹ +-- COLLA : 1 (utf8mb4_0900_ai_ci) ℹ +-- ROWS : 3918131 ℹ +-- DATA : 26.1M(82.47%) ℹ +-- INDEX : 5.5M(17.53%) ℹ +-- TOTAL : 31.6M ℹ +-- ENGINE: 1 (InnoDB) ℹ +-- ENGINE InnoDB : 6 TABLE(s) ✔ 1 collation for employees database. ✔ 1 engine for employees database. ℹ Charsets for employees database table column: utf8mb4 ✔ employees table column(s) has same charset defined for all text like column(s). ℹ Collations for employees database table column: utf8mb4_0900_ai_ci ✔ employees table column(s) has same collation defined for all text like column(s). ℹ Database Metrics execution time: 3.489s -------- Table Column Metrics ---------------------------------------------------------------------- ℹ MySQL and Percona version 8.0 and greater have removed PROCEDURE ANALYSE feature ℹ Disabling colstat parameter ℹ Database: employees ℹ +-- TABLE: departments ℹ +-- TYPE: InnoDB ℹ +-- Index dept_name - Cols: dept_name - Type: BTREE ℹ +-- Index PRIMARY - Cols: dept_no - Type: BTREE ℹ +-- Column departments.dept_no: CHAR(4) NOT NULL ℹ +-- Column departments.dept_name: VARCHAR(40) NOT NULL ℹ +-- TABLE: dept_emp ℹ +-- TYPE: InnoDB ℹ +-- Index dept_no - Cols: dept_no - Type: BTREE ℹ +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE ℹ +-- Column dept_emp.emp_no: INT NOT NULL ℹ +-- Column dept_emp.dept_no: CHAR(4) NOT NULL ℹ +-- Column dept_emp.from_date: DATE NOT NULL ℹ +-- Column dept_emp.to_date: DATE NOT NULL ℹ +-- TABLE: dept_manager ℹ +-- TYPE: InnoDB ℹ +-- Index dept_no - Cols: dept_no - Type: BTREE ℹ +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE ℹ +-- Column dept_manager.emp_no: INT NOT NULL ℹ +-- Column dept_manager.dept_no: CHAR(4) NOT NULL ℹ +-- Column dept_manager.from_date: DATE NOT NULL ℹ +-- Column dept_manager.to_date: DATE NOT NULL ℹ +-- TABLE: employees ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no - Type: BTREE ℹ +-- Column employees.emp_no: INT NOT NULL ℹ +-- Column employees.birth_date: DATE NOT NULL ℹ +-- Column employees.first_name: VARCHAR(14) NOT NULL ℹ +-- Column employees.last_name: VARCHAR(16) NOT NULL ℹ +-- Column employees.gender: ENUM('M','F') NOT NULL ℹ +-- Column employees.hire_date: DATE NOT NULL ℹ +-- TABLE: salaries ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no,from_date - Type: BTREE ℹ +-- Column salaries.emp_no: INT NOT NULL ℹ +-- Column salaries.salary: INT NOT NULL ℹ +-- Column salaries.from_date: DATE NOT NULL ℹ +-- Column salaries.to_date: DATE NOT NULL ℹ +-- TABLE: titles ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no,title,from_date - Type: BTREE ℹ +-- Column titles.emp_no: INT NOT NULL ℹ +-- Column titles.title: VARCHAR(50) NOT NULL ℹ +-- Column titles.from_date: DATE NOT NULL ℹ +-- Column titles.to_date: DATE NULL ℹ Table Column Metrics execution time: 2.555s -------- Table structures analysis ----------------------------------------------------------------- ✔ All tables get a primary key ✘ Table employees.employees: Primary key 'emp_no' does not follow 'id' or 'employees_id' naming convention ✘ Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.departments: Primary key 'dept_no' does not follow 'id' or 'departments_id' naming convention ✘ Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_manager: Primary key 'dept_no' does not follow 'id' or 'dept_manager_id' naming convention ✘ Table employees.dept_manager: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_manager: Primary key 'emp_no' does not follow 'id' or 'dept_manager_id' naming convention ✘ Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_emp: Primary key 'dept_no' does not follow 'id' or 'dept_emp_id' naming convention ✘ Table employees.dept_emp: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention ✘ Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'from_date' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'title' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention ✘ Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention ✘ Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✔ All tables are InnoDB tables ✔ All columns are UTF-8 compliant ℹ Table structures analysis execution time: 1.480s -------- Naming conventions analysis --------------------------------------------------------------- ✘ Table employees.employees: Plural name detected (prefer singular) ✘ Table employees.departments: Plural name detected (prefer singular) ✘ Table employees.titles: Plural name detected (prefer singular) ✘ Table employees.salaries: Plural name detected (prefer singular) ℹ Naming conventions analysis execution time: 0.772s -------- Foreign Key analysis ---------------------------------------------------------------------- ℹ Constraint on employees.dept_manager.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_manager.dept_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_emp.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_emp.dept_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.titles.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.salaries.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Foreign Key analysis execution time: 0.544s -------- MySQL 8.0+ Specific Modeling -------------------------------------------------------------- ✔ No MySQL 8.0+ specific modeling issues found ℹ MySQL 8.0+ Specific Modeling execution time: -1.137s -------- Data Type optimization -------------------------------------------------------------------- ✔ No data type optimization recommendations ℹ Data Type optimization execution time: 0.192s -------- Schema sanitization ----------------------------------------------------------------------- ✔ No empty or view-only schemas detected ℹ Schema sanitization execution time: 0.210s -------- Indexes Metrics --------------------------------------------------------------------------- ℹ Worst selectivity indexes: ℹ Index: dept_no(dept_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 1 column(s) ℹ +-- CARDINALITY : 8 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ dept_no(dept_no) has a low selectivity ℹ Index: PRIMARY(from_date) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 3 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 1 distinct values ℹ +-- NB ROWS : 443308 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ PRIMARY(from_date) has a low selectivity ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.salaries ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 1 distinct values ℹ +-- NB ROWS : 2844047 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ PRIMARY(emp_no) has a low selectivity ℹ Index: PRIMARY(from_date) ℹ +-- COLUMN : employees.salaries ℹ +-- NB SEQS : 2 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 1 distinct values ℹ +-- NB ROWS : 2844047 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ PRIMARY(from_date) has a low selectivity ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 1 distinct values ℹ +-- NB ROWS : 443308 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ PRIMARY(emp_no) has a low selectivity ℹ Index: PRIMARY(title) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 2 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 1 distinct values ℹ +-- NB ROWS : 443308 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ PRIMARY(title) has a low selectivity ℹ Index: dept_no(dept_no) ℹ +-- COLUMN : employees.dept_manager ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 1 column(s) ℹ +-- CARDINALITY : 9 distinct values ℹ +-- NB ROWS : 24 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 37.50% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 299710 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 90.51% ℹ Index: PRIMARY(dept_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 2 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 331143 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.dept_manager ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 24 distinct values ℹ +-- NB ROWS : 24 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Indexes per database: ℹ Database: employees ℹ +-- INDEX : departments.dept_name ℹ +-- COLUMNS : dept_name ℹ +-- CARDINALITY: 9 ℹ +-- INDEX : departments.PRIMARY ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 9 ℹ +-- INDEX : dept_emp.dept_no ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 8 ℹ +-- INDEX : dept_emp.PRIMARY ℹ +-- COLUMNS : emp_no,dept_no ℹ +-- CARDINALITY: 630853 ℹ +-- INDEX : dept_manager.dept_no ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 9 ℹ +-- INDEX : dept_manager.PRIMARY ℹ +-- COLUMNS : emp_no,dept_no ℹ +-- CARDINALITY: 48 ℹ +-- INDEX : employees.PRIMARY ℹ +-- COLUMNS : emp_no ℹ +-- CARDINALITY: 299600 ℹ +-- INDEX : salaries.PRIMARY ℹ +-- COLUMNS : emp_no,from_date ℹ +-- CARDINALITY: 2 ℹ +-- INDEX : titles.PRIMARY ℹ +-- COLUMNS : emp_no,title,from_date ℹ +-- CARDINALITY: 3 ℹ Unused indexes: ✘ Index: dept_name on employees.departments is not used. ✘ Index: dept_no on employees.dept_emp is not used. ✘ Index: dept_no on employees.dept_manager is not used. ℹ Indexes Metrics execution time: 1.059s -------- Views Metrics ----------------------------------------------------------------------------- ℹ Views Metrics execution time: 0.000s -------- Triggers Metrics -------------------------------------------------------------------------- ℹ Triggers Metrics execution time: 0.000s -------- Routines Metrics -------------------------------------------------------------------------- ℹ Routines Metrics execution time: 0.000s -------- Security Recommendations ------------------------------------------------------------------ ℹ Percona Server (GPL), Release 36, Revision 8fe4a72d - 8.0.45 ✔ No Role user detected ✔ There are no anonymous accounts for any database users ✔ All database users have passwords assigned ✘ User 'root'@% does not specify hostname restrictions. ℹ There are 620 basic passwords in the list. ℹ Security Recommendations execution time: 56.094s -------- Authentication Plugin Security ------------------------------------------------------------ ✔ No users found using insecure or deprecated authentication plugins ℹ Authentication Plugin Security execution time: 0.198s -------- SSL/TLS Security Recommendations ---------------------------------------------------------- ✘ Current connection is NOT encrypted! ✔ SSL support is enabled ✘ require_secure_transport is OFF ✔ Only secure TLS versions enabled: TLSv1.2,TLSv1.3 ✘ Public Certificate file not found: server-cert.pem ✘ CA Certificate file not found: ca.pem ✘ 1 users can connect remotely without SSL enforcement ℹ SSL/TLS Security Recommendations execution time: 0.557s -------- CVE Security Recommendations -------------------------------------------------------------- ✘ CVE-2026-21998(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-22001(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Information Schema). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploita... ✘ CVE-2026-22002(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-22004(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerability al... ✘ CVE-2026-22005(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-22009(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-22015(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Information Schema). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploita... ✘ CVE-2026-22017(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-34267(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privilege... ✘ CVE-2026-34270(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily ex... ✘ CVE-2026-34271(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily ex... ✘ CVE-2026-34276(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Group Replication Plugin). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily ex... ✘ CVE-2026-34278(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privilege... ✘ CVE-2026-34293(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: DML). Supported versions that are affected are 8.0.0-8.0.45. Easily exploitable vulnerability allows high privileged atta... ✘ CVE-2026-34303(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ CVE-2026-34304(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerability al... ✘ CVE-2026-34308(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: JSON). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerabil... ✘ CVE-2026-35236(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerability al... ✘ CVE-2026-35237(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerability al... ✘ CVE-2026-35238(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: InnoDB). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerability al... ✘ CVE-2026-35239(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: DML). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulnerabili... ✘ CVE-2026-35240(<= 8.0.45) : Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Optimizer). Supported versions that are affected are 8.0.0-8.0.45, 8.4.0-8.4.8 and 9.0.0-9.6.0. Easily exploitable vulne... ✘ 22 CVE(s) found for your MySQL release. ℹ CVE Security Recommendations execution time: 0.002s -------- Plugin Information ------------------------------------------------------------------------ ℹ Plugin | Version | Status | Type ℹ -------------------------------------------------------------------------------- ℹ mysqlx_cache_cleaner | 1.0 | ACTIVE | AUDIT ℹ sha2_cache_cleaner | 1.0 | ACTIVE | AUDIT ℹ caching_sha2_password | 1.0 | ACTIVE | AUTHENTICATION ℹ mysql_native_password | 1.1 | ACTIVE | AUTHENTICATION ℹ sha256_password | 1.1 | ACTIVE | AUTHENTICATION ℹ daemon_keyring_proxy_plugin | 1.0 | ACTIVE | DAEMON ℹ mysqlx | 1.0 | ACTIVE | DAEMON ℹ ngram | 0.1 | ACTIVE | FTPARSER ℹ ARCHIVE | 3.0 | ACTIVE | STORAGE ENGINE ℹ binlog | 1.0 | ACTIVE | STORAGE ENGINE ℹ BLACKHOLE | 1.0 | ACTIVE | STORAGE ENGINE ℹ CSV | 1.0 | ACTIVE | STORAGE ENGINE ℹ InnoDB | 8.0 | ACTIVE | STORAGE ENGINE ℹ MEMORY | 1.0 | ACTIVE | STORAGE ENGINE ℹ MRG_MYISAM | 1.0 | ACTIVE | STORAGE ENGINE ℹ MyISAM | 1.0 | ACTIVE | STORAGE ENGINE ℹ PERFORMANCE_SCHEMA | 0.1 | ACTIVE | STORAGE ENGINE ℹ TempTable | 1.0 | ACTIVE | STORAGE ENGINE ℹ Plugin Information execution time: 0.174s -------- Performance Metrics ----------------------------------------------------------------------- ℹ Up for: 48s (720 q [15.000 qps], 527 conn, TX: 452K, RX: 164M) ℹ Reads / Writes: 59% / 41% ℹ Binary logging is enabled (GTID MODE: OFF) ℹ Physical Memory : 15.3G ℹ Max MySQL memory : 1.8G ℹ Other process memory: 19.9M ℹ Total buffers: 152.0M global + 1.0G temptable + 1.9M per thread (151 max threads) ℹ Performance_schema Max memory usage: 332M ℹ Galera GCache Max memory usage: 0B ℹ Global Buffers ℹ +-- Key Buffer: 8.0M ℹ +-- Max Tmp Table: 16.0M ℹ Per Thread Buffers ℹ +-- Read Buffer: 128.0K ℹ +-- Read RND Buffer: 256.0K ℹ +-- Sort Buffer: 256.0K ℹ +-- Thread stack: 1.0M ℹ +-- Join Buffer: 256.0K ℹ Binlog Cache Buffers ℹ +-- Binlog Cache: 32.0K ✔ Maximum reached memory usage: 520.5M (3.33% of installed RAM) ✔ Maximum possible memory usage: 1.8G (11.49% of installed RAM) ✔ Overall possible memory usage with other process is compatible with memory available ✔ Slow queries: 0% (0/720) ✔ Highest usage of available connections: 1% (2/151) ✘ Aborted connections: 57.50% (303/527) ℹ Query cache has been removed since MySQL 8.0 ✘ Sorts requiring temporary tables: 19% (41 temp sorts / 207 sorts) ✘ Joins performed without indexes: 66 ✔ Temporary tables created on disk: 2% (8 on disk / 274 total) ✔ temptable_max_mmap (1.0G) is compatible with available disk space on /tmp (823.8G) ✔ Thread cache hit rate: 99% (2 created / 527 connections) ✔ Table cache hit rate: 90% (6K hits / 7K requests) ✔ table_definition_cache (2000) is greater than number of tables (349) ✔ Open file limit used: 0% (2/8K) ✔ Table locks acquired immediately: 100% (184 immediate / 184 locks) ✘ Binlog cache memory access: 6.21% (11 Memory / 177 Total) ℹ Performance Metrics execution time: 0.837s -------- Performance schema ------------------------------------------------------------------------ ℹ Performance_schema is activated. ℹ Memory used by Performance_schema: 332.7M ℹ Sys schema is installed. ℹ Sys schema Version: 2.1.3 ℹ Performance schema execution time: 0.510s -------- Performance schema: Top 5 user per connection --------------------------------------------- ℹ +-- 1: root 921 conn(s) ℹ +-- 2: background 13 conn(s) ℹ +-- 3: event_scheduler 1 conn(s) ℹ Performance schema: Top 5 user per connection execution time: 0.198s -------- Performance schema: Top 5 user per statement ---------------------------------------------- ℹ +-- 1: root 2044 stmt(s) ℹ +-- 2: background 0 stmt(s) ℹ +-- 3: event_scheduler 0 stmt(s) ℹ Performance schema: Top 5 user per statement execution time: 0.193s -------- Performance schema: Top 5 user per statement latency -------------------------------------- ℹ +-- 1: root 19881811832.1951 ℹ +-- 2: background 0.0000 ℹ +-- 3: event_scheduler 0.0000 ℹ Performance schema: Top 5 user per statement latency execution time: 0.199s -------- Performance schema: Top 5 user per lock latency ------------------------------------------- ℹ +-- 1: root 2498000000 ℹ +-- 2: background 0 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per lock latency execution time: 0.194s -------- Performance schema: Top 5 user per nb full scans ------------------------------------------ ℹ +-- 1: root 199 ℹ +-- 2: background 0 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per nb full scans execution time: 0.204s -------- Performance schema: Top 5 user per rows sent ---------------------------------------------- ℹ +-- 1: root 6793 ℹ +-- 2: background 0 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per rows sent execution time: 0.217s -------- Performance schema: Top 5 user per rows modified ------------------------------------------ ℹ +-- 1: root 3919016 ℹ +-- 2: background 0 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per rows modified execution time: 0.189s -------- Performance schema: Top 5 user per IO ----------------------------------------------------- ℹ +-- 1: background 99847 ℹ +-- 2: root 38768 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per IO execution time: 0.193s -------- Performance schema: Top 5 user per IO latency --------------------------------------------- ℹ +-- 1: background 36545716999854 ℹ +-- 2: root 5845336494948 ℹ +-- 3: event_scheduler 0 ℹ Performance schema: Top 5 user per IO latency execution time: 0.170s -------- Performance schema: Top 5 host per connection --------------------------------------------- ℹ +-- 1: 172.18.0.2 513 conn(s) ℹ +-- 2: localhost 418 conn(s) ℹ Performance schema: Top 5 host per connection execution time: 0.201s -------- Performance schema: Top 5 host per statement ---------------------------------------------- ℹ +-- 1: 172.18.0.2 704 stmt(s) ℹ +-- 2: localhost 690 stmt(s) ℹ Performance schema: Top 5 host per statement execution time: -1.714s -------- Performance schema: Top 5 host per statement latency -------------------------------------- ℹ +-- 1: 172.18.0.2 28755876992.8977 ℹ +-- 2: localhost 473616752.8736 ℹ Performance schema: Top 5 host per statement latency execution time: 0.202s -------- Performance schema: Top 5 host per lock latency ------------------------------------------- ℹ +-- 1: 172.18.0.2 2059000000 ℹ +-- 2: localhost 458000000 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per lock latency execution time: 0.184s -------- Performance schema: Top 5 host per nb full scans ------------------------------------------ ℹ +-- 1: 172.18.0.2 150 ℹ +-- 2: localhost 58 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per nb full scans execution time: 0.208s -------- Performance schema: Top 5 host per rows sent ---------------------------------------------- ℹ +-- 1: 172.18.0.2 3877 ℹ +-- 2: localhost 2949 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per rows sent execution time: 0.176s -------- Performance schema: Top 5 host per rows modified ------------------------------------------ ℹ +-- 1: 172.18.0.2 3919016 ℹ +-- 2: localhost 0 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per rows modified execution time: 0.173s -------- Performance schema: Top 5 host per io ----------------------------------------------------- ℹ +-- 1: 172.18.0.2 19380 ℹ +-- 2: localhost 8 ℹ Performance schema: Top 5 host per io execution time: 0.186s -------- Performance schema: Top 5 host per io latency --------------------------------------------- ℹ +-- 1: 172.18.0.2 2880700394382 ℹ +-- 2: localhost 83935706184 ℹ Performance schema: Top 5 host per io latency execution time: 0.201s -------- Performance schema: Top IO type order by total io ----------------------------------------- ℹ +-- 1: innodb/innodb_log_file 78984 i/o ℹ +-- 2: innodb/innodb_data_file 16770 i/o ℹ +-- 3: sql/io_cache 9573 i/o ℹ +-- 4: sql/binlog 8473 i/o ℹ +-- 5: innodb/innodb_dblwr_file 5280 i/o ℹ +-- 6: innodb/innodb_temp_file 78 i/o ℹ +-- 7: sql/binlog_index 41 i/o ℹ +-- 8: sql/casetest 10 i/o ℹ +-- 9: sql/misc 6 i/o ℹ +-- 10: sql/ERRMSG 5 i/o ℹ +-- 11: mysys/cnf 5 i/o ℹ +-- 12: sql/pid 3 i/o ℹ +-- 13: mysys/charset 3 i/o ℹ Performance schema: Top IO type order by total io execution time: 0.183s -------- Performance schema: Top IO type order by total latency ------------------------------------ ℹ +-- 1: innodb/innodb_log_file 15822000084258 ℹ +-- 2: innodb/innodb_data_file 12436438579038 ℹ +-- 3: innodb/innodb_dblwr_file 9708839311050 ℹ +-- 4: sql/binlog 1150337646774 ℹ +-- 5: innodb/innodb_temp_file 173539988892 ℹ +-- 6: sql/io_cache 172985807592 ℹ +-- 7: sql/binlog_index 2440946124 ℹ +-- 8: sql/casetest 1290780720 ℹ +-- 9: sql/pid 227905200 ℹ +-- 10: sql/ERRMSG 186604560 ℹ +-- 11: sql/misc 44046360 ℹ +-- 12: mysys/charset 32343120 ℹ +-- 13: mysys/cnf 21203640 ℹ Performance schema: Top IO type order by total latency execution time: 0.191s -------- Performance schema: Top IO type order by max latency -------------------------------------- ℹ +-- 1: innodb/innodb_log_file 56671552746 ℹ +-- 2: innodb/innodb_dblwr_file 39089970000 ℹ +-- 3: innodb/innodb_temp_file 28644613758 ℹ +-- 4: innodb/innodb_data_file 25383956418 ℹ +-- 5: sql/binlog 16887608280 ℹ +-- 6: sql/io_cache 1932736320 ℹ +-- 7: sql/binlog_index 1276989480 ℹ +-- 8: sql/casetest 1172046600 ℹ +-- 9: sql/pid 202358520 ℹ +-- 10: sql/ERRMSG 142067520 ℹ +-- 11: mysys/charset 18572760 ℹ +-- 12: sql/misc 16108920 ℹ +-- 13: mysys/cnf 13530240 ℹ Performance schema: Top IO type order by max latency execution time: 0.205s -------- Performance schema: Top Stages order by total io ------------------------------------------ ℹ +-- 1: innodb/buffer pool load 1 i/o ℹ Performance schema: Top Stages order by total io execution time: 0.177s -------- Performance schema: Top Stages order by total latency ------------------------------------- ℹ +-- 1: innodb/buffer pool load 5837754000 ℹ Performance schema: Top Stages order by total latency execution time: 0.174s -------- Performance schema: Top Stages order by avg latency --------------------------------------- ℹ +-- 1: innodb/buffer pool load 5837754000 ℹ Performance schema: Top Stages order by avg latency execution time: 0.177s -------- Performance schema: Top 5 host per table scans -------------------------------------------- ℹ +-- 1: 172.18.0.2 150 ℹ +-- 2: localhost 138 ℹ Performance schema: Top 5 host per table scans execution time: 0.184s -------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------ ℹ +-- 1: employees 100515840 91844979 6135 page(s) ℹ Performance schema: InnoDB Buffer Pool by schema execution time: 0.290s -------- Performance schema: 40 InnoDB Buffer Pool by table ---------------------------------------- ℹ +-- 1: employees salaries 92454912 84479984 5643 page(s) ℹ +-- 2: employees employees 7028736 6444378 429 page(s) ℹ +-- 3: employees titles 1032192 920617 63 page(s) ℹ Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.249s -------- Performance schema: Process per time ------------------------------------------------------ ℹ +-- 1: innodb/dict_stats_thread NULL 128 ℹ +-- 2: innodb/srv_master_thread NULL 128 ℹ +-- 3: innodb/fts_optimize_thread NULL 128 ℹ +-- 4: innodb/page_flush_coordinator_thread NULL 128 ℹ +-- 5: sql/main NULL 127 ℹ +-- 6: sql/compress_gtid_table Daemon 127 ℹ +-- 7: sql/event_scheduler Daemon 127 ℹ +-- 8: innodb/srv_worker_thread NULL 127 ℹ +-- 9: innodb/srv_worker_thread NULL 127 ℹ +-- 10: innodb/srv_worker_thread NULL 127 ℹ +-- 11: innodb/srv_purge_thread NULL 127 ℹ +-- 12: innodb/clone_gtid_thread NULL 127 ℹ +-- 13: root@localhost Query 0 ℹ +-- 14: innodb/io_read_thread NULL NULL ℹ +-- 15: innodb/io_write_thread NULL NULL ℹ +-- 16: innodb/io_write_thread NULL NULL ℹ +-- 17: innodb/io_write_thread NULL NULL ℹ +-- 18: innodb/srv_error_monitor_thread NULL NULL ℹ +-- 19: innodb/buf_lru_manager_thread NULL NULL ℹ +-- 20: innodb/srv_monitor_thread NULL NULL ℹ +-- 21: innodb/log_checkpointer_thread NULL NULL ℹ +-- 22: innodb/log_flush_notifier_thread NULL NULL ℹ +-- 23: innodb/log_flusher_thread NULL NULL ℹ +-- 24: innodb/log_write_notifier_thread NULL NULL ℹ +-- 25: innodb/log_writer_thread NULL NULL ℹ +-- 26: innodb/log_files_governor_thread NULL NULL ℹ +-- 27: innodb/io_read_thread NULL NULL ℹ +-- 28: innodb/io_read_thread NULL NULL ℹ +-- 29: innodb/io_read_thread NULL NULL ℹ +-- 30: innodb/io_ibuf_thread NULL NULL ℹ +-- 31: innodb/io_write_thread NULL NULL ℹ +-- 32: innodb/buf_resize_thread NULL NULL ℹ +-- 33: innodb/srv_lock_timeout_thread NULL NULL ℹ +-- 34: mysqlx/acceptor_network NULL NULL ℹ +-- 35: sql/signal_handler NULL NULL ℹ +-- 36: innodb/buf_dump_thread NULL NULL ℹ +-- 37: mysqlx/worker NULL NULL ℹ +-- 38: mysqlx/worker NULL NULL ℹ +-- 39: mysqlx/acceptor_network NULL NULL ℹ Performance schema: Process per time execution time: 0.190s -------- Performance schema: InnoDB Lock Waits ----------------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: InnoDB Lock Waits execution time: 0.185s -------- Performance schema: Thread IO Latency ----------------------------------------------------- ℹ +-- 1: log_flusher_thread 13213462538250 56671552746 ℹ +-- 2: page_flush_coordinator_thread 10165354924698 39089970000 ℹ +-- 3: io_write_thread 2704962927474 16996940136 ℹ +-- 4: io_write_thread 2600368727814 18588747294 ℹ +-- 5: io_write_thread 2585768443668 10456317720 ℹ +-- 6: io_write_thread 2509103460420 23521438494 ℹ +-- 7: log_writer_thread 1656324203706 30150371304 ℹ +-- 8: log_files_governor_thread 705493964610 10509953742 ℹ +-- 9: log_checkpointer_thread 158908409280 29966548482 ℹ +-- 10: buf_lru_manager_thread 44318170098 12049785360 ℹ +-- 11: main 9038972880 2522867760 ℹ +-- 12: buf_dump_thread 5305367880 173481480 ℹ +-- 13: srv_purge_thread 1504706760 64686240 ℹ +-- 14: dict_stats_thread 667356120 111582720 ℹ +-- 15: clone_gtid_thread 223938000 192837240 ℹ +-- 16: srv_worker_thread 48639960 48639960 ℹ Performance schema: Thread IO Latency execution time: 0.200s -------- Performance schema: Top 15 Most latency statements ---------------------------------------- ℹ +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */ 180318467000 ℹ +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */ 131535734000 ℹ +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */ 104959980000 ℹ +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */ 102589484000 ℹ +-- 5: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 79125948000 ℹ +-- 6: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 74995563000 ℹ +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 65049337000 ℹ +-- 8: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 58002911000 ℹ +-- 9: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 51315435000 ℹ +-- 10: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 50401098000 ℹ +-- 11: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d 49382964000 ℹ +-- 12: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 48614695000 ℹ +-- 13: CREATE TABLE `salaries` ( `emp_no` INTEGER NOT NULL , `salary` INTEGER NOT NULL , `from_date` DATE NOT NULL , `to_date` 47819706000 ℹ +-- 14: CREATE TABLE `dept_emp` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , `to 46953955000 ℹ +-- 15: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 46693081000 ℹ Performance schema: Top 15 Most latency statements execution time: 0.187s -------- Performance schema: Top 15 slower queries ------------------------------------------------- ℹ +-- 1: INSERT INTO `salaries` VALUES (...) /* , ... */ 114 s ℹ +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */ 21 s ℹ +-- 3: INSERT INTO `employees` VALUES (...) /* , ... */ 17 s ℹ +-- 4: INSERT INTO `dept_emp` VALUES (...) /* , ... */ 14 s ℹ +-- 5: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2 s ℹ +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2 s ℹ +-- 7: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2 s ℹ +-- 8: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 1 s ℹ +-- 9: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d 1 s ℹ +-- 10: CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 1 s ℹ +-- 11: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 1 s ℹ Performance schema: Top 15 slower queries execution time: 0.229s -------- Performance schema: Top 15 nb statement type ---------------------------------------------- ℹ +-- 1: select 507 ℹ +-- 2: Quit 346 ℹ +-- 3: insert 168 ℹ +-- 4: Init DB 52 ℹ +-- 5: show_engine_status 12 ℹ +-- 6: show_status 6 ℹ +-- 7: create_table 6 ℹ +-- 8: show_databases 5 ℹ +-- 9: show_variables 5 ℹ +-- 10: truncate 2 ℹ +-- 11: show_slave_status 2 ℹ +-- 12: show_grants 2 ℹ +-- 13: show_slave_hosts 2 ℹ +-- 14: show_storage_engines 2 ℹ +-- 15: Statistics 2 ℹ Performance schema: Top 15 nb statement type execution time: 0.189s -------- Performance schema: Top 15 statement by total latency ------------------------------------- ℹ +-- 1: insert 19015621905000 ℹ +-- 2: select 1213323915000 ℹ +-- 3: create_table 291574219000 ℹ +-- 4: create_view 29234418000 ℹ +-- 5: drop_db 18940195000 ℹ +-- 6: flush 15605007000 ℹ +-- 7: create_db 11178662000 ℹ +-- 8: show_variables 7222988000 ℹ +-- 9: show_status 7092294000 ℹ +-- 10: drop_table 5240980000 ℹ +-- 11: Init DB 5176363000 ℹ +-- 12: show_databases 4433616000 ℹ +-- 13: Quit 2499478000 ℹ +-- 14: truncate 2470391000 ℹ +-- 15: show_engine_status 2065718000 ℹ Performance schema: Top 15 statement by total latency execution time: 0.217s -------- Performance schema: Top 15 statement by lock latency -------------------------------------- ℹ +-- 1: select 1340000000 ℹ +-- 2: insert 925000000 ℹ +-- 3: create_table 177000000 ℹ +-- 4: create_view 24000000 ℹ +-- 5: show_databases 20000000 ℹ +-- 6: show_variables 15000000 ℹ +-- 7: show_status 15000000 ℹ +-- 8: truncate 14000000 ℹ +-- 9: drop_table 14000000 ℹ +-- 10: create_db 5000000 ℹ +-- 11: drop_db 3000000 ℹ +-- 12: Init DB 3000000 ℹ +-- 13: show_storage_engines 2000000 ℹ +-- 14: show_engine_status 0 ℹ +-- 15: Ping 0 ℹ Performance schema: Top 15 statement by lock latency execution time: 0.172s -------- Performance schema: Top 15 statement by full scans ---------------------------------------- ℹ +-- 1: select 212 ℹ +-- 2: show_status 6 ℹ +-- 3: show_databases 5 ℹ +-- 4: show_variables 5 ℹ +-- 5: show_storage_engines 2 ℹ +-- 6: truncate 0 ℹ +-- 7: show_engine_status 0 ℹ +-- 8: show_slave_status 0 ℹ +-- 9: show_grants 0 ℹ +-- 10: show_slave_hosts 0 ℹ +-- 11: Quit 0 ℹ +-- 12: Init DB 0 ℹ +-- 13: Statistics 0 ℹ +-- 14: create_table 0 ℹ +-- 15: insert 0 ℹ Performance schema: Top 15 statement by full scans execution time: 0.191s -------- Performance schema: Top 15 statement by rows sent ----------------------------------------- ℹ +-- 1: show_variables 2821 ℹ +-- 2: show_status 2184 ℹ +-- 3: select 2005 ℹ +-- 4: show_databases 25 ℹ +-- 5: show_storage_engines 22 ℹ +-- 6: truncate 0 ℹ +-- 7: show_engine_status 0 ℹ +-- 8: show_slave_status 0 ℹ +-- 9: show_grants 0 ℹ +-- 10: show_slave_hosts 0 ℹ +-- 11: Quit 0 ℹ +-- 12: Init DB 0 ℹ +-- 13: Statistics 0 ℹ +-- 14: create_table 0 ℹ +-- 15: insert 0 ℹ Performance schema: Top 15 statement by rows sent execution time: 0.178s -------- Performance schema: Top 15 statement by rows modified ------------------------------------- ℹ +-- 1: insert 3919015 ℹ +-- 2: create_db 1 ℹ +-- 3: select 0 ℹ +-- 4: truncate 0 ℹ +-- 5: show_databases 0 ℹ +-- 6: show_variables 0 ℹ +-- 7: show_status 0 ℹ +-- 8: show_engine_status 0 ℹ +-- 9: show_slave_status 0 ℹ +-- 10: show_grants 0 ℹ +-- 11: show_slave_hosts 0 ℹ +-- 12: show_storage_engines 0 ℹ +-- 13: Quit 0 ℹ +-- 14: Init DB 0 ℹ +-- 15: Statistics 0 ℹ Performance schema: Top 15 statement by rows modified execution time: 0.186s -------- Performance schema: 15 sample queries using temp table ------------------------------------ ℹ +-- 1: SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER ℹ +-- 2: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch ℹ +-- 3: SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P ℹ +-- 4: SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? ℹ +-- 5: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` ℹ +-- 6: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in ℹ +-- 7: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER ℹ +-- 8: SELECT `thread` , FILE , `latency` , `operation` FROM `sys` . `x$latest_file_io` ORDER BY `latency` LIMIT ? ℹ +-- 9: SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? ℹ +-- 10: SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? ℹ +-- 11: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? ℹ +-- 12: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? ℹ +-- 13: SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? ℹ +-- 14: SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? ℹ +-- 15: SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? ℹ Performance schema: 15 sample queries using temp table execution time: 0.173s -------- Performance schema: Unused indexes -------------------------------------------------------- ℹ +-- 1: employees.dept_emp (dept_no) ℹ +-- 2: employees.dept_manager (dept_no) ✘ Performance schema: 2 unused index(es) found. ℹ Performance schema: Unused indexes execution time: 0.189s -------- Performance schema: Tables with full table scans ------------------------------------------ ℹ No information found or indicators deactivated. ℹ Performance schema: Tables with full table scans execution time: 0.169s -------- Performance schema: Latest File IO by latency --------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: Latest File IO by latency execution time: 0.171s -------- Performance schema: File by IO read bytes ------------------------------------------------- ℹ +-- 1: /var/lib/mysql/mysql.ibd 9076736 ℹ +-- 2: /var/lib/mysql/undo_001 8634368 ℹ +-- 3: /var/lib/mysql/#ib_16384_1.dblwr 8585216 ℹ +-- 4: /var/lib/mysql/undo_002 7864320 ℹ +-- 5: /var/lib/mysql/employees/employees.ibd 4980736 ℹ +-- 6: /var/lib/mysql/ibtmp1 2097152 ℹ +-- 7: /var/lib/mysql/employees/titles.ibd 1064960 ℹ +-- 8: /usr/share/percona-server/english/errmsg.sys 399123 ℹ +-- 9: /var/lib/mysql/ibdata1 229376 ℹ +-- 10: /var/lib/mysql/#ib_16384_0.dblwr 196608 ℹ +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp 68096 ℹ +-- 12: /var/lib/mysql/employees/departments.ibd 65536 ℹ +-- 13: /var/lib/mysql/employees/salaries.ibd 32768 ℹ +-- 14: /usr/share/percona-server/charsets/Index.xml 19525 ℹ +-- 15: /var/lib/mysql/sys/sys_config.ibd 16384 ℹ Performance schema: File by IO read bytes execution time: 0.180s -------- Performance schema: File by IO written bytes ---------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/salaries.ibd 209158144 ℹ +-- 2: /var/lib/mysql/#ib_16384_0.dblwr 171360256 ℹ +-- 3: /var/lib/mysql/binlog.000003 66378596 ℹ +-- 4: /var/lib/mysql/employees/titles.ibd 48103424 ℹ +-- 5: /var/lib/mysql/employees/dept_emp.ibd 43499520 ℹ +-- 6: /var/lib/mysql/employees/employees.ibd 37896192 ℹ +-- 7: /var/lib/mysql/ibtmp1 14729216 ℹ +-- 8: /var/lib/mysql/#innodb_redo/#ib_redo86 11753472 ℹ +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo83 11664896 ℹ +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo88 11654656 ℹ +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo82 11654656 ℹ +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo89 11650560 ℹ +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo85 11649024 ℹ +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo87 11622912 ℹ +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo91 11474432 ℹ Performance schema: File by IO written bytes execution time: 0.174s -------- Performance schema: File per IO total latency --------------------------------------------- ℹ +-- 1: /var/lib/mysql/#ib_16384_0.dblwr 9663586440966 ℹ +-- 2: /var/lib/mysql/employees/salaries.ibd 6229236970998 ℹ +-- 3: /var/lib/mysql/employees/dept_emp.ibd 1610354013750 ℹ +-- 4: /var/lib/mysql/employees/titles.ibd 1376463717306 ℹ +-- 5: /var/lib/mysql/employees/employees.ibd 1284889596084 ℹ +-- 6: /var/lib/mysql/binlog.000003 1099078248492 ℹ +-- 7: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp 1041796022562 ℹ +-- 8: /var/lib/mysql/undo_002 922162592088 ℹ +-- 9: /var/lib/mysql/undo_001 792032644152 ℹ +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo82 754629085458 ℹ +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo91 698565002382 ℹ +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo103 680717681964 ℹ +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo88 530572962078 ℹ +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo86 519282336456 ℹ +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo102 510819841062 ℹ +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo87 510054959682 ℹ +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo89 502920618642 ℹ +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo94 498581051508 ℹ +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo96 495948025044 ℹ +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo85 495342455976 ℹ Performance schema: File per IO total latency execution time: 0.177s -------- Performance schema: file per IO read latency ---------------------------------------------- ℹ +-- 1: /var/lib/mysql/undo_002 9638843274 ℹ +-- 2: /var/lib/mysql/undo_001 8197237962 ℹ +-- 3: /var/lib/mysql/mysql.ibd 7824742416 ℹ +-- 4: /var/lib/mysql/#ib_16384_1.dblwr 3379876920 ℹ +-- 5: /var/lib/mysql/ibtmp1 853741440 ℹ +-- 6: /var/lib/mysql/employees/employees.ibd 412515720 ℹ +-- 7: /var/lib/mysql/sys/sys_config.ibd 408459258 ℹ +-- 8: /var/lib/mysql/ibdata1 372092040 ℹ +-- 9: /var/lib/mysql/employees/titles.ibd 181593360 ℹ +-- 10: /var/lib/mysql/employees/departments.ibd 179181720 ℹ +-- 11: /usr/share/percona-server/english/errmsg.sys 163072800 ℹ +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp 126115200 ℹ +-- 13: /var/lib/mysql/#ib_16384_0.dblwr 79103880 ℹ +-- 14: /var/lib/mysql/employees/salaries.ibd 28344600 ℹ +-- 15: /var/lib/mysql/#innodb_temp/temp_10.ibt 26580240 ℹ +-- 16: /var/lib/mysql/binlog.index 13885200 ℹ +-- 17: /usr/share/percona-server/charsets/Index.xml 10283400 ℹ +-- 18: /var/lib/mysql/binlog.000001 8331120 ℹ +-- 19: /var/lib/mysql/auto.cnf 4426560 ℹ +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo107_tmp 0 ℹ Performance schema: file per IO read latency execution time: 0.192s -------- Performance schema: file per IO write latency --------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/salaries.ibd 355740936012 ℹ +-- 2: /var/lib/mysql/binlog.000003 86594120640 ℹ +-- 3: /var/lib/mysql/employees/dept_emp.ibd 84282874812 ℹ +-- 4: /var/lib/mysql/employees/titles.ibd 73717665282 ℹ +-- 5: /var/lib/mysql/employees/employees.ibd 57416770908 ℹ +-- 6: /var/lib/mysql/#ib_16384_0.dblwr 48977113014 ℹ +-- 7: /var/lib/mysql/undo_002 35391222594 ℹ +-- 8: /var/lib/mysql/undo_001 29617990812 ℹ +-- 9: /var/lib/mysql/#innodb_redo/#ib_redo105_tmp 17855315370 ℹ +-- 10: /var/lib/mysql/#innodb_redo/#ib_redo91 16584682284 ℹ +-- 11: /var/lib/mysql/#innodb_redo/#ib_redo102 16305502590 ℹ +-- 12: /var/lib/mysql/#innodb_redo/#ib_redo88 16241430222 ℹ +-- 13: /var/lib/mysql/#innodb_redo/#ib_redo94 15721274970 ℹ +-- 14: /var/lib/mysql/#innodb_redo/#ib_redo100 15418982682 ℹ +-- 15: /var/lib/mysql/#innodb_redo/#ib_redo86 15269210442 ℹ +-- 16: /var/lib/mysql/#innodb_redo/#ib_redo82 14979863232 ℹ +-- 17: /var/lib/mysql/#innodb_redo/#ib_redo83 14774153994 ℹ +-- 18: /var/lib/mysql/#innodb_redo/#ib_redo87 14674027086 ℹ +-- 19: /var/lib/mysql/#innodb_redo/#ib_redo89 14234010840 ℹ +-- 20: /var/lib/mysql/#innodb_redo/#ib_redo101 13874919210 ℹ Performance schema: file per IO write latency execution time: 0.187s -------- Performance schema: Event Wait by read bytes ---------------------------------------------- ℹ +-- 1: sql/io_cache 251499989 ℹ +-- 2: innodb/innodb_data_file 34062336 ℹ +-- 3: innodb/innodb_dblwr_file 8781824 ℹ +-- 4: sql/ERRMSG 399123 ℹ +-- 5: innodb/innodb_log_file 68096 ℹ +-- 6: mysys/charset 19525 ℹ +-- 7: innodb/innodb_temp_file 16384 ℹ +-- 8: sql/binlog 360 ℹ +-- 9: sql/binlog_index 176 ℹ +-- 10: mysys/cnf 56 ℹ +-- 11: sql/casetest 0 ℹ +-- 12: sql/misc 0 ℹ +-- 13: sql/pid 0 ℹ Performance schema: Event Wait by read bytes execution time: 0.182s -------- Performance schema: Event Wait written bytes ---------------------------------------------- ℹ +-- 1: innodb/innodb_data_file 374194176 ℹ +-- 2: innodb/innodb_log_file 356764672 ℹ +-- 3: sql/io_cache 234046315 ℹ +-- 4: innodb/innodb_dblwr_file 171769856 ℹ +-- 5: sql/binlog 66383262 ℹ +-- 6: innodb/innodb_temp_file 1540096 ℹ +-- 7: sql/pid 2 ℹ +-- 8: sql/binlog_index 0 ℹ +-- 9: sql/casetest 0 ℹ +-- 10: sql/ERRMSG 0 ℹ +-- 11: sql/misc 0 ℹ +-- 12: mysys/charset 0 ℹ +-- 13: mysys/cnf 0 ℹ Performance schema: Event Wait written bytes execution time: 0.186s -------- Performance schema: event per wait total latency ------------------------------------------ ℹ +-- 1: innodb/innodb_log_file 15822000084258 ℹ +-- 2: innodb/innodb_data_file 12435956240598 ℹ +-- 3: innodb/innodb_dblwr_file 9708839311050 ℹ +-- 4: sql/binlog 1150337646774 ℹ +-- 5: innodb/innodb_temp_file 301388158944 ℹ +-- 6: sql/io_cache 206304845220 ℹ +-- 7: sql/binlog_index 2440946124 ℹ +-- 8: sql/casetest 1290780720 ℹ +-- 9: sql/pid 227905200 ℹ +-- 10: sql/ERRMSG 186604560 ℹ +-- 11: sql/misc 44046360 ℹ +-- 12: mysys/charset 32343120 ℹ +-- 13: mysys/cnf 21203640 ℹ Performance schema: event per wait total latency execution time: 0.173s -------- Performance schema: event per wait read latency ------------------------------------------- ℹ +-- 1: innodb/innodb_data_file 28096751790 ℹ +-- 2: sql/io_cache 19665618156 ℹ +-- 3: innodb/innodb_dblwr_file 3458980800 ℹ +-- 4: sql/ERRMSG 163072800 ℹ +-- 5: innodb/innodb_log_file 126115200 ℹ +-- 6: sql/binlog_index 36477360 ℹ +-- 7: innodb/innodb_temp_file 26580240 ℹ +-- 8: mysys/charset 10283400 ℹ +-- 9: sql/binlog 8331120 ℹ +-- 10: mysys/cnf 4426560 ℹ +-- 11: sql/casetest 0 ℹ +-- 12: sql/misc 0 ℹ +-- 13: sql/pid 0 ℹ Performance schema: event per wait read latency execution time: 0.184s -------- Performance schema: event per wait write latency ------------------------------------------ ℹ +-- 1: innodb/innodb_data_file 656323067970 ℹ +-- 2: innodb/innodb_log_file 423063831420 ℹ +-- 3: sql/io_cache 172955817126 ℹ +-- 4: sql/binlog 86910410880 ℹ +-- 5: innodb/innodb_dblwr_file 49450201614 ℹ +-- 6: innodb/innodb_temp_file 1867569840 ℹ +-- 7: sql/pid 19209600 ℹ +-- 8: sql/binlog_index 0 ℹ +-- 9: sql/casetest 0 ℹ +-- 10: sql/ERRMSG 0 ℹ +-- 11: sql/misc 0 ℹ +-- 12: mysys/charset 0 ℹ +-- 13: mysys/cnf 0 ℹ Performance schema: event per wait write latency execution time: 0.188s -------- Performance schema: Top 15 most read indexes ---------------------------------------------- ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 most read indexes execution time: 0.183s -------- Performance schema: Top 15 most modified indexes ------------------------------------------ ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 most modified indexes execution time: 0.177s -------- Performance schema: Top 15 high read latency index ---------------------------------------- ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 high read latency index execution time: 0.192s -------- Performance schema: Top 15 most modified indexes ------------------------------------------ ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 most modified indexes execution time: 0.184s -------- Performance schema: Top 15 high update latency index -------------------------------------- ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 high update latency index execution time: 0.194s -------- Performance schema: Top 15 high delete latency index -------------------------------------- ℹ +-- 1: employees employees PRIMARY 0 ℹ +-- 2: employees departments PRIMARY 0 ℹ +-- 3: employees departments dept_name 0 ℹ +-- 4: employees dept_manager PRIMARY 0 ℹ +-- 5: employees dept_manager dept_no 0 ℹ +-- 6: employees dept_emp PRIMARY 0 ℹ +-- 7: employees dept_emp dept_no 0 ℹ +-- 8: employees titles PRIMARY 0 ℹ +-- 9: employees salaries PRIMARY 0 ℹ Performance schema: Top 15 high delete latency index execution time: 0.171s -------- Performance schema: Top 15 most read tables ----------------------------------------------- ℹ +-- 1: employees salaries 0 ℹ +-- 2: employees dept_emp 0 ℹ +-- 3: employees titles 0 ℹ +-- 4: employees employees 0 ℹ +-- 5: employees dept_manager 0 ℹ +-- 6: employees departments 0 ℹ Performance schema: Top 15 most read tables execution time: 0.175s -------- Performance schema: Top 15 most modified tables ------------------------------------------- ℹ +-- 1: employees salaries 2844047 ℹ +-- 2: employees titles 443308 ℹ +-- 3: employees dept_emp 331603 ℹ +-- 4: employees employees 300024 ℹ +-- 5: employees dept_manager 24 ℹ +-- 6: employees departments 9 ℹ Performance schema: Top 15 most modified tables execution time: 0.192s -------- Performance schema: Top 15 high read latency tables --------------------------------------- ℹ +-- 1: employees salaries 0 ℹ +-- 2: employees dept_emp 0 ℹ +-- 3: employees titles 0 ℹ +-- 4: employees employees 0 ℹ +-- 5: employees dept_manager 0 ℹ +-- 6: employees departments 0 ℹ Performance schema: Top 15 high read latency tables execution time: 0.192s -------- Performance schema: Top 15 high insert latency tables ------------------------------------- ℹ +-- 1: employees salaries 4623350328252 ℹ +-- 2: employees dept_emp 1477569796038 ℹ +-- 3: employees titles 1170140603130 ℹ +-- 4: employees employees 655020752616 ℹ +-- 5: employees dept_manager 172103400 ℹ +-- 6: employees departments 87873480 ℹ Performance schema: Top 15 high insert latency tables execution time: 0.159s -------- Performance schema: Top 15 high update latency tables ------------------------------------- ℹ +-- 1: employees salaries 0 ℹ +-- 2: employees dept_emp 0 ℹ +-- 3: employees titles 0 ℹ +-- 4: employees employees 0 ℹ +-- 5: employees dept_manager 0 ℹ +-- 6: employees departments 0 ℹ Performance schema: Top 15 high update latency tables execution time: 0.184s -------- Performance schema: Top 15 high delete latency tables ------------------------------------- ℹ +-- 1: employees salaries 0 ℹ +-- 2: employees dept_emp 0 ℹ +-- 3: employees titles 0 ℹ +-- 4: employees employees 0 ℹ +-- 5: employees dept_manager 0 ℹ +-- 6: employees departments 0 ℹ Performance schema: Top 15 high delete latency tables execution time: 0.199s -------- Performance schema: Redundant indexes ----------------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: Redundant indexes execution time: 0.169s -------- Performance schema: Table not using InnoDB buffer ----------------------------------------- ℹ +-- 1: employees dept_emp ℹ +-- 2: employees dept_manager ℹ +-- 3: employees departments ℹ Performance schema: Table not using InnoDB buffer execution time: 0.272s -------- Performance schema: Top 15 Tables using InnoDB buffer ------------------------------------- ℹ +-- 1: employees salaries 92454912 ℹ +-- 2: employees employees 7028736 ℹ +-- 3: employees titles 1032192 ℹ Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.245s -------- Performance schema: Top 15 Tables with InnoDB buffer free --------------------------------- ℹ +-- 1: employees salaries 7835536 ℹ +-- 2: employees employees 584358 ℹ +-- 3: employees titles 111575 ℹ Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.249s -------- Performance schema: Top 15 Most executed queries ------------------------------------------ ℹ +-- 1: NULL SELECT @@`version_comment` LIMIT ? 174 ℹ +-- 2: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 114 ℹ +-- 3: NULL SELECT SCHEMA ( ) 76 ℹ +-- 4: employees INSERT INTO `titles` VALUES (...) /* , ... */ 21 ℹ +-- 5: employees INSERT INTO `employees` VALUES (...) /* , ... */ 17 ℹ +-- 6: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 14 ℹ +-- 7: NULL SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS 12 ℹ +-- 8: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 9: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 10: employees SELECT ? AS ? 7 ℹ +-- 11: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 6 ℹ +-- 12: NULL SHOW SCHEMAS 5 ℹ +-- 13: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN 4 ℹ +-- 14: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 15: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 4 ℹ Performance schema: Top 15 Most executed queries execution time: 0.184s -------- Performance schema: Latest SQL queries in errors or warnings ------------------------------ ℹ +-- 1: DROP SCHEMA IF EXISTS `employees` 2026-07-05 15:41:56.283555 ℹ +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 2026-07-05 15:41:56.306044 ℹ +-- 3: SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.013359 ℹ +-- 4: SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.215823 ℹ +-- 5: SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.144841 ℹ +-- 6: SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.346725 ℹ +-- 7: SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:52.728392 ℹ +-- 8: SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:43:53.636339 ℹ Performance schema: Latest SQL queries in errors or warnings execution time: 0.172s -------- Performance schema: Top 20 queries with full table scans ---------------------------------- ℹ +-- 1: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 2: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) AN 4 ℹ +-- 3: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 2 ℹ +-- 4: NULL SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i 2 ℹ +-- 5: NULL SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform 2 ℹ +-- 6: NULL SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST 2 ℹ +-- 7: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (. 2 ℹ +-- 8: NULL SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T 2 ℹ +-- 9: NULL SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL 2 ℹ +-- 10: NULL SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST 2 ℹ +-- 11: NULL SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 2 ℹ +-- 12: NULL SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...) 2 ℹ +-- 13: NULL SELECT COUNT ( * ) FROM `performance_schema` . `error_log` 2 ℹ +-- 14: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 2 ℹ +-- 15: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 2 ℹ +-- 16: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ +-- 17: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 18: NULL SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . ` 2 ℹ +-- 19: NULL SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 2 ℹ +-- 20: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 2 ℹ Performance schema: Top 20 queries with full table scans execution time: 0.206s -------- Performance schema: Last 50 queries with full table scans --------------------------------- ℹ +-- 1: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O 2026-07-05 15:44:02.521747 ℹ +-- 2: NULL SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db` 2026-07-05 15:44:02.314982 ℹ +-- 3: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 2026-07-05 15:44:02.143832 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:44:01.958110 ℹ +-- 5: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:44:01.710009 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:44:01.464255 ℹ +-- 7: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:44:01.193698 ℹ +-- 8: NULL SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:43:58.279098 ℹ +-- 9: NULL SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:43:58.091896 ℹ +-- 10: NULL SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 2026-07-05 15:43:57.531467 ℹ +-- 11: NULL SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:43:57.355078 ℹ +-- 12: NULL SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:43:57.181348 ℹ +-- 13: NULL SELECT * FROM `sys` . `x$schema_tables_with_full_table_scans` WHERE ( `object_schema` IS NULL OR `object_schema` NOT IN 2026-07-05 15:43:56.830869 ℹ +-- 14: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER 2026-07-05 15:43:56.660439 ℹ +-- 15: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:43:55.165725 ℹ +-- 16: NULL SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 2026-07-05 15:43:54.936516 ℹ +-- 17: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:43:54.750167 ℹ +-- 18: NULL SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w 2026-07-05 15:43:54.551258 ℹ +-- 19: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:43:54.364431 ℹ +-- 20: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:43:54.175245 ℹ +-- 21: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:43:53.925663 ℹ +-- 22: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:43:53.636339 ℹ +-- 23: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:52.728392 ℹ +-- 24: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:43:52.719421 ℹ +-- 25: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.526848 ℹ +-- 26: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.355996 ℹ +-- 27: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.346725 ℹ +-- 28: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:43:52.164527 ℹ +-- 29: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.144841 ℹ +-- 30: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.975655 ℹ +-- 31: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:43:51.958757 ℹ +-- 32: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.785580 ℹ +-- 33: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.757373 ℹ +-- 34: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.608411 ℹ +-- 35: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:43:51.553047 ℹ +-- 36: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:43:51.401141 ℹ +-- 37: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.358986 ℹ +-- 38: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.215823 ℹ +-- 39: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.160995 ℹ +-- 40: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.013359 ℹ +-- 41: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:50.967350 ℹ +-- 42: NULL SELECT COUNT ( * ) FROM `information_schema` . `tables` 2026-07-05 15:43:50.260380 ℹ +-- 43: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:43:49.423188 ℹ +-- 44: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , PLUGIN FROM `mysql` . `user` WHERE SYSTEM_USER != ? 2026-07-05 15:43:48.687528 ℹ +-- 45: NULL SELECT SYSTEM_USER , HOST , PLUGIN , `authentication_string` FROM `mysql` . `user` WHERE SYSTEM_USER != ? 2026-07-05 15:42:54.288299 ℹ +-- 46: NULL SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 2026-07-05 15:42:53.356910 ℹ +-- 47: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE ( `authentication_string` 2026-07-05 15:42:53.177416 ℹ +-- 48: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 2026-07-05 15:42:52.397966 ℹ +-- 49: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `DATA_TYPE` = ? AND `TABLE_ 2026-07-05 15:42:52.265372 ℹ +-- 50: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 2026-07-05 15:42:52.073009 ℹ Performance schema: Last 50 queries with full table scans execution time: 0.170s -------- Performance schema: Top 15 reader queries (95% percentile) -------------------------------- ℹ +-- 1: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 20 ℹ +-- 2: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 7 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 7 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 5 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2 ℹ +-- 6: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 0 ℹ +-- 7: employees CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 0 ℹ +-- 8: employees INSERT INTO `employees` VALUES (...) /* , ... */ 0 ℹ +-- 9: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 0 ℹ +-- 10: employees INSERT INTO `titles` VALUES (...) /* , ... */ 0 ℹ +-- 11: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 0 ℹ Performance schema: Top 15 reader queries (95% percentile) execution time: 0.194s -------- Performance schema: Top 15 most row look queries (95% percentile) ------------------------- ℹ +-- 1: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 286 ℹ +-- 2: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 14 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 14 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 5 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 4 ℹ +-- 6: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 0 ℹ +-- 7: employees CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 0 ℹ +-- 8: employees INSERT INTO `employees` VALUES (...) /* , ... */ 0 ℹ +-- 9: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 0 ℹ +-- 10: employees INSERT INTO `titles` VALUES (...) /* , ... */ 0 ℹ +-- 11: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 0 ℹ Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.205s -------- Performance schema: Top 15 total latency queries (95% percentile) ------------------------- ℹ +-- 1: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 11965437816000 ℹ +-- 2: employees INSERT INTO `titles` VALUES (...) /* , ... */ 2762250421000 ℹ +-- 3: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 2524458544000 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 1744021238000 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 158251896000 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 149991126000 ℹ +-- 7: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 130098674000 ℹ +-- 8: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 119882278000 ℹ +-- 9: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 100583903000 ℹ +-- 10: employees CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 58002911000 ℹ +-- 11: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 51315435000 ℹ Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.210s -------- Performance schema: Top 15 max latency queries (95% percentile) --------------------------- ℹ +-- 1: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 525384142000 ℹ +-- 2: employees INSERT INTO `employees` VALUES (...) /* , ... */ 344248815000 ℹ +-- 3: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 340699368000 ℹ +-- 4: employees INSERT INTO `titles` VALUES (...) /* , ... */ 323528181000 ℹ +-- 5: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 146582405000 ℹ +-- 6: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 87149463000 ℹ +-- 7: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 69481180000 ℹ +-- 8: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 68451175000 ℹ +-- 9: employees CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 58002911000 ℹ +-- 10: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 53890822000 ℹ +-- 11: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 51315435000 ℹ Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.200s -------- Performance schema: Top 15 average latency queries (95% percentile) ----------------------- ℹ +-- 1: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 180318467000 ℹ +-- 2: employees INSERT INTO `titles` VALUES (...) /* , ... */ 131535734000 ℹ +-- 3: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 104959980000 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 102589484000 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 79125948000 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 74995563000 ℹ +-- 7: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 65049337000 ℹ +-- 8: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 59941139000 ℹ +-- 9: employees CREATE TABLE `dept_manager` ( `emp_no` INTEGER NOT NULL , `dept_no` CHARACTER (?) NOT NULL , `from_date` DATE NOT NULL , 58002911000 ℹ +-- 10: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 51315435000 ℹ +-- 11: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 50291951000 ℹ Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.199s -------- Performance schema: Top 20 queries with sort ---------------------------------------------- ℹ +-- 1: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 2: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 3: NULL SHOW SCHEMAS 5 ℹ +-- 4: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 5: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2 ℹ +-- 6: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2 ℹ +-- 7: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2 ℹ +-- 8: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2 ℹ +-- 9: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2 ℹ +-- 10: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2 ℹ +-- 11: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2 ℹ +-- 12: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2 ℹ +-- 13: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2 ℹ +-- 14: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2 ℹ +-- 15: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 2 ℹ +-- 16: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2 ℹ +-- 17: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2 ℹ +-- 18: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 2 ℹ +-- 19: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 2 ℹ +-- 20: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ Performance schema: Top 20 queries with sort execution time: 0.210s -------- Performance schema: Last 50 queries with sort --------------------------------------------- ℹ +-- 1: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NO 2026-07-05 15:44:03.908171 ℹ +-- 2: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR 2026-07-05 15:44:02.690934 ℹ +-- 3: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O 2026-07-05 15:44:02.521747 ℹ +-- 4: NULL SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db` 2026-07-05 15:44:02.314982 ℹ +-- 5: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 2026-07-05 15:44:02.143832 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:44:01.958110 ℹ +-- 7: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:44:01.710009 ℹ +-- 8: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:44:01.464255 ℹ +-- 9: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:44:01.193698 ℹ +-- 10: NULL SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:43:58.279098 ℹ +-- 11: NULL SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:43:58.091896 ℹ +-- 12: NULL SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 2026-07-05 15:43:57.531467 ℹ +-- 13: NULL SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:43:57.355078 ℹ +-- 14: NULL SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:43:57.181348 ℹ +-- 15: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER 2026-07-05 15:43:56.660439 ℹ +-- 16: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:43:55.165725 ℹ +-- 17: NULL SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 2026-07-05 15:43:54.936516 ℹ +-- 18: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:43:54.750167 ℹ +-- 19: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:43:54.364431 ℹ +-- 20: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:43:54.175245 ℹ +-- 21: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:43:53.925663 ℹ +-- 22: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:43:53.636339 ℹ +-- 23: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:52.728392 ℹ +-- 24: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:43:52.719421 ℹ +-- 25: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.526848 ℹ +-- 26: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.355996 ℹ +-- 27: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.346725 ℹ +-- 28: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:43:52.164527 ℹ +-- 29: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.144841 ℹ +-- 30: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.975655 ℹ +-- 31: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:43:51.958757 ℹ +-- 32: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.785580 ℹ +-- 33: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.757373 ℹ +-- 34: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.608411 ℹ +-- 35: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:43:51.553047 ℹ +-- 36: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:43:51.401141 ℹ +-- 37: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.358986 ℹ +-- 38: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.215823 ℹ +-- 39: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.160995 ℹ +-- 40: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.013359 ℹ +-- 41: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:50.967350 ℹ +-- 42: NULL SHOW SCHEMAS 2026-07-05 15:43:50.606404 ℹ +-- 43: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:43:49.423188 ℹ +-- 44: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 2026-07-05 15:42:52.397966 ℹ +-- 45: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2026-07-05 15:42:51.977323 ℹ +-- 46: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2026-07-05 15:42:51.559138 ℹ +-- 47: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 2026-07-05 15:42:49.276530 ℹ +-- 48: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 2026-07-05 15:42:49.104716 ℹ +-- 49: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 2026-07-05 15:42:47.062295 ℹ +-- 50: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 2026-07-05 15:42:43.237775 ℹ Performance schema: Last 50 queries with sort execution time: 0.192s -------- Performance schema: Top 15 row sorting queries with sort ---------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 12924 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 12915 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 12730 ℹ +-- 4: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 12567 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 12557 ℹ +-- 6: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 322 ℹ +-- 7: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 237 ℹ +-- 8: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR 100 ℹ +-- 9: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_sorting` WHERE ( `db` IS NULL OR `db` NOT 100 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 64 ℹ +-- 11: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 56 ℹ +-- 12: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_temp_tables` WHERE ( `db` IS NULL OR `db` 50 ℹ +-- 13: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 48 ℹ +-- 14: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O 40 ℹ +-- 15: NULL SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 40 ℹ Performance schema: Top 15 row sorting queries with sort execution time: 0.201s -------- Performance schema: Top 15 total latency queries with sort -------------------------------- ℹ +-- 1: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 158251896000 ℹ +-- 2: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 149991126000 ℹ +-- 3: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 130098674000 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 119882278000 ℹ +-- 5: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 100583903000 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 98578648000 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 30921659000 ℹ +-- 8: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 30639252000 ℹ +-- 9: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 30606460000 ℹ +-- 10: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 16055825000 ℹ +-- 11: NULL SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 13230742000 ℹ +-- 12: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 11400821000 ℹ +-- 13: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 10890015000 ℹ +-- 14: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 10860008000 ℹ +-- 15: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 10336136000 ℹ Performance schema: Top 15 total latency queries with sort execution time: 0.195s -------- Performance schema: Top 15 merge queries with sort ---------------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 17 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 17 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 17 ℹ +-- 4: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 17 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 10 ℹ +-- 6: NULL SHOW SCHEMAS 0 ℹ +-- 7: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 8: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 9: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 0 ℹ +-- 10: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 11: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 12: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 13: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 14: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 15: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ Performance schema: Top 15 merge queries with sort execution time: 0.217s -------- Performance schema: Top 15 average sort merges queries with sort -------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 9 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 9 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 9 ℹ +-- 4: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 9 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 5 ℹ +-- 6: NULL SHOW SCHEMAS 0 ℹ +-- 7: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 8: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 9: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 0 ℹ +-- 10: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 11: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 12: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 13: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 14: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 15: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ Performance schema: Top 15 average sort merges queries with sort execution time: 0.177s -------- Performance schema: Top 15 scans queries with sort ---------------------------------------- ℹ +-- 1: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 2: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 3: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 12 ℹ +-- 4: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 12 ℹ +-- 5: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 12 ℹ +-- 6: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 12 ℹ +-- 7: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 12 ℹ +-- 8: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 10 ℹ +-- 9: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 10 ℹ +-- 10: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 10 ℹ +-- 11: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 10 ℹ +-- 12: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 10 ℹ +-- 13: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 10 ℹ +-- 14: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 8 ℹ +-- 15: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 8 ℹ Performance schema: Top 15 scans queries with sort execution time: 0.189s -------- Performance schema: Top 15 range queries with sort ---------------------------------------- ℹ +-- 1: NULL SHOW SCHEMAS 0 ℹ +-- 2: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 3: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 4: NULL SELECT DATA FROM `performance_schema` . `error_log` ORDER BY `LOGGED` DESC LIMIT ? 0 ℹ +-- 5: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 6: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 7: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 8: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 9: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 10: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ +-- 11: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 0 ℹ +-- 12: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 0 ℹ +-- 13: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 0 ℹ +-- 14: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 0 ℹ +-- 15: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 0 ℹ Performance schema: Top 15 range queries with sort execution time: 0.163s -------- Performance schema: Top 20 queries with temp table ---------------------------------------- ℹ +-- 1: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 2: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 3: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 4: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 4 ℹ +-- 5: NULL SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST 2 ℹ +-- 6: NULL SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST 2 ℹ +-- 7: NULL SELECT `TABLE_SCHEMA` , SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `I 2 ℹ +-- 8: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE ENGINE IS NOT NULL AND `TABLE_SCHEMA` NOT IN (. 2 ℹ +-- 9: NULL SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T 2 ℹ +-- 10: NULL SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL 2 ℹ +-- 11: NULL SHOW VARIABLES 2 ℹ +-- 12: NULL SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 2 ℹ +-- 13: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ +-- 14: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 15: NULL SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . ` 2 ℹ +-- 16: NULL SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 2 ℹ +-- 17: NULL SHOW ENGINES 2 ℹ +-- 18: NULL SHOW GLOBAL STATUS 2 ℹ +-- 19: NULL SHOW STATUS 2 ℹ +-- 20: NULL SHOW GLOBAL VARIABLES 2 ℹ Performance schema: Top 20 queries with temp table execution time: 0.180s -------- Performance schema: Last 50 queries with temp table --------------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:44:01.958110 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:44:01.710009 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:44:01.464255 ℹ +-- 4: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:44:01.193698 ℹ +-- 5: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:43:55.165725 ℹ +-- 6: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:43:54.750167 ℹ +-- 7: NULL SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w 2026-07-05 15:43:54.551258 ℹ +-- 8: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:43:54.364431 ℹ +-- 9: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:43:54.175245 ℹ +-- 10: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:43:53.925663 ℹ +-- 11: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:43:53.636339 ℹ +-- 12: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:52.728392 ℹ +-- 13: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:43:52.719421 ℹ +-- 14: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.526848 ℹ +-- 15: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.355996 ℹ +-- 16: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:43:52.346725 ℹ +-- 17: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:43:52.164527 ℹ +-- 18: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:43:52.144841 ℹ +-- 19: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.975655 ℹ +-- 20: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:43:51.958757 ℹ +-- 21: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:43:51.785580 ℹ +-- 22: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.757373 ℹ +-- 23: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:43:51.608411 ℹ +-- 24: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:43:51.553047 ℹ +-- 25: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:43:51.401141 ℹ +-- 26: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.358986 ℹ +-- 27: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:43:51.215823 ℹ +-- 28: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.160995 ℹ +-- 29: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:43:51.013359 ℹ +-- 30: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:43:50.967350 ℹ +-- 31: NULL SELECT `sys_version` FROM `sys` . `version` 2026-07-05 15:43:50.771075 ℹ +-- 32: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:43:49.423188 ℹ +-- 33: NULL SHOW SESSION STATUS LIKE ? 2026-07-05 15:43:48.896469 ℹ +-- 34: NULL SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 2026-07-05 15:42:53.356910 ℹ +-- 35: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 2026-07-05 15:42:52.073009 ℹ +-- 36: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2026-07-05 15:42:51.977323 ℹ +-- 37: NULL SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . ` 2026-07-05 15:42:51.900732 ℹ +-- 38: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 2026-07-05 15:42:51.773296 ℹ +-- 39: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2026-07-05 15:42:51.559138 ℹ +-- 40: NULL SELECT DISTINCTROW `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE `INDEX_NAME 2026-07-05 15:42:51.348954 ℹ +-- 41: NULL SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E 2026-07-05 15:42:51.336401 ℹ +-- 42: NULL SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN 2026-07-05 15:42:50.936929 ℹ +-- 43: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 2026-07-05 15:42:50.010303 ℹ +-- 44: NULL SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform 2026-07-05 15:42:49.453613 ℹ +-- 45: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 2026-07-05 15:42:49.276530 ℹ +-- 46: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 2026-07-05 15:42:49.104716 ℹ +-- 47: NULL SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA 2026-07-05 15:42:46.722972 ℹ +-- 48: NULL SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL 2026-07-05 15:42:46.543911 ℹ +-- 49: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 2026-07-05 15:42:46.183585 ℹ +-- 50: NULL SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_COLLAT 2026-07-05 15:42:45.816170 ℹ Performance schema: Last 50 queries with temp table execution time: 0.163s -------- Performance schema: Top 15 total latency queries with temp table -------------------------- ℹ +-- 1: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 158251896000 ℹ +-- 2: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 149991126000 ℹ +-- 3: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 130098674000 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 119882278000 ℹ +-- 5: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 100583903000 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 98578648000 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 30921659000 ℹ +-- 8: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 30639252000 ℹ +-- 9: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 30606460000 ℹ +-- 10: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 16055825000 ℹ +-- 11: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 11400821000 ℹ +-- 12: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 10890015000 ℹ +-- 13: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 10860008000 ℹ +-- 14: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 10336136000 ℹ +-- 15: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 10290835000 ℹ Performance schema: Top 15 total latency queries with temp table execution time: 0.160s -------- Performance schema: Top 15 queries with temp table to disk -------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2 ℹ +-- 4: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2 ℹ +-- 6: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2 ℹ +-- 7: NULL SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 2 ℹ +-- 8: NULL SHOW VARIABLES 0 ℹ +-- 9: NULL SHOW GLOBAL VARIABLES 0 ℹ +-- 10: NULL SHOW STATUS 0 ℹ +-- 11: NULL SHOW GLOBAL STATUS 0 ℹ +-- 12: NULL SHOW ENGINES 0 ℹ +-- 13: NULL SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 0 ℹ +-- 14: NULL SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . ` 0 ℹ +-- 15: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ Performance schema: Top 15 queries with temp table to disk execution time: 0.186s -------- Performance schema: Top 15 class events by number ----------------------------------------- ℹ +-- 1: wait/io/table 3919015 ℹ +-- 2: wait/io/file 124104 ℹ +-- 3: wait/lock/table 168 ℹ Performance schema: Top 15 class events by number execution time: 0.196s -------- Performance schema: Top 30 events by number ----------------------------------------------- ℹ +-- 1: wait/io/table/sql/handler 3919015 ℹ +-- 2: wait/io/file/innodb/innodb_log_file 78984 ℹ +-- 3: wait/io/file/innodb/innodb_data_file 16757 ℹ +-- 4: wait/io/file/sql/io_cache 14433 ℹ +-- 5: wait/io/file/sql/binlog 8473 ℹ +-- 6: wait/io/file/innodb/innodb_dblwr_file 5280 ℹ +-- 7: wait/lock/table/sql/handler 168 ℹ +-- 8: wait/io/file/innodb/innodb_temp_file 104 ℹ +-- 9: wait/io/file/sql/binlog_index 41 ℹ +-- 10: wait/io/file/sql/casetest 10 ℹ +-- 11: wait/io/file/sql/misc 6 ℹ +-- 12: wait/io/file/sql/ERRMSG 5 ℹ +-- 13: wait/io/file/mysys/cnf 5 ℹ +-- 14: wait/io/file/sql/pid 3 ℹ +-- 15: wait/io/file/mysys/charset 3 ℹ Performance schema: Top 30 events by number execution time: 0.179s -------- Performance schema: Top 15 class events by total latency ---------------------------------- ℹ +-- 1: wait/io/file 39778832711052 ℹ +-- 2: wait/io/table 7926341456916 ℹ +-- 3: wait/lock/table 513783720 ℹ Performance schema: Top 15 class events by total latency execution time: 0.188s -------- Performance schema: Top 30 events by total latency ---------------------------------------- ℹ +-- 1: wait/io/file/innodb/innodb_log_file 15822000084258 ℹ +-- 2: wait/io/file/innodb/innodb_data_file 12435956240598 ℹ +-- 3: wait/io/file/innodb/innodb_dblwr_file 9708839311050 ℹ +-- 4: wait/io/table/sql/handler 7926341456916 ℹ +-- 5: wait/io/file/sql/binlog 1150337646774 ℹ +-- 6: wait/io/file/innodb/innodb_temp_file 402486588810 ℹ +-- 7: wait/io/file/sql/io_cache 254969009838 ℹ +-- 8: wait/io/file/sql/binlog_index 2440946124 ℹ +-- 9: wait/io/file/sql/casetest 1290780720 ℹ +-- 10: wait/lock/table/sql/handler 513783720 ℹ +-- 11: wait/io/file/sql/pid 227905200 ℹ +-- 12: wait/io/file/sql/ERRMSG 186604560 ℹ +-- 13: wait/io/file/sql/misc 44046360 ℹ +-- 14: wait/io/file/mysys/charset 32343120 ℹ +-- 15: wait/io/file/mysys/cnf 21203640 ℹ Performance schema: Top 30 events by total latency execution time: 0.199s -------- Performance schema: Top 15 class events by max latency ------------------------------------ ℹ +-- 1: wait/io/table 68907554298 ℹ +-- 2: wait/io/file 56671552746 ℹ +-- 3: wait/lock/table 5303520 ℹ Performance schema: Top 15 class events by max latency execution time: 0.202s -------- Performance schema: Top 30 events by max latency ------------------------------------------ ℹ +-- 1: wait/io/table/sql/handler 68907554298 ℹ +-- 2: wait/io/file/innodb/innodb_log_file 56671552746 ℹ +-- 3: wait/io/file/innodb/innodb_temp_file 55894494150 ℹ +-- 4: wait/io/file/innodb/innodb_dblwr_file 39089970000 ℹ +-- 5: wait/io/file/innodb/innodb_data_file 25383956418 ℹ +-- 6: wait/io/file/sql/binlog 16887608280 ℹ +-- 7: wait/io/file/sql/io_cache 1932736320 ℹ +-- 8: wait/io/file/sql/binlog_index 1276989480 ℹ +-- 9: wait/io/file/sql/casetest 1172046600 ℹ +-- 10: wait/io/file/sql/pid 202358520 ℹ +-- 11: wait/io/file/sql/ERRMSG 142067520 ℹ +-- 12: wait/io/file/mysys/charset 18572760 ℹ +-- 13: wait/io/file/sql/misc 16108920 ℹ +-- 14: wait/io/file/mysys/cnf 13530240 ℹ +-- 15: wait/lock/table/sql/handler 5303520 ℹ Performance schema: Top 30 events by max latency execution time: 0.186s -------- MyISAM Metrics ---------------------------------------------------------------------------- ℹ General MyIsam metrics: ℹ +-- Total MyISAM Tables : 0 ℹ +-- Total MyISAM indexes : 0B ℹ +-- KB Size :8.0M ℹ +-- KB Used Size :1.5M ℹ +-- KB used :18.2% ℹ +-- Read KB hit rate: 0% (0 cached / 0 reads) ℹ +-- Write KB hit rate: 0% (0 cached / 0 writes) ℹ No MyISAM table(s) detected .... ℹ MyISAM Metrics execution time: 0.185s -------- InnoDB Metrics ---------------------------------------------------------------------------- ℹ InnoDB is enabled. ℹ InnoDB Metrics execution time: 0.001s -------- Smart Migration LTS Advisor --------------------------------------------------------------- ✘ Found 4 potential migration risks. ℹ - [Migration Risk] default_authentication_plugin: Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead. ℹ - [Migration Risk] binlog_transaction_dependency_tracking: Removed in MySQL 8.4. ℹ - [Migration Risk] avoid_temporal_upgrade: Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade. ℹ - [Migration Risk] expire_logs_days: Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead. ℹ InnoDB Buffers ℹ +-- InnoDB Buffer Pool: 128.0M ℹ +-- InnoDB Buffer Pool Instances: 1 ℹ +-- InnoDB Buffer Pool Chunk Size: 128.0M ℹ +-- InnoDB Redo Log Capacity: 100.0M ℹ +-- InnoDB Log Buffer: 16.0M ℹ +-- InnoDB Buffer Free: 1.1K ℹ +-- InnoDB Buffer Used: 8.0K ℹ InnoDB Thread Concurrency: 0 ✔ InnoDB File per table is activated ✔ InnoDB Buffer Pool size ( 128.0M ) under limit for 64 bits architecture: (17179869184.0G ) ✔ InnoDB buffer pool / data size: 128.0M / 31.7M ℹ InnoDB Redo Log Capacity is set to 100.0M ℹ Server uptime is less than 1 hour. Cannot make a reliable recommendation for innodb_redo_log_capacity. ✔ InnoDB buffer pool instances: 1 ℹ Number of InnoDB Buffer Pool Chunk: 1 for 1 Buffer Pool Instance(s) ✔ Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances ✔ InnoDB Read buffer efficiency: 99.99% (20584866 hits / 20586374 total) ✔ InnoDB Write Log efficiency: 99.11% (8110785 hits / 8183644 total) ✔ InnoDB log waits: 0.00% (0 waits / 72859 writes) ℹ Smart Migration LTS Advisor execution time: 0.001s -------- InnoDB Transactions ----------------------------------------------------------------------- ℹ Transaction Isolation Level: REPEATABLE-READ ℹ Active InnoDB Transactions: 0 ℹ InnoDB Transactions execution time: 0.000s -------- InnoDB Index/Data Ratio Check ------------------------------------------------------------- ℹ Checked InnoDB tables with > 50,000 rows: 4 ✘ Under-indexed tables (ratio < 0.3): 3 ℹ InnoDB Index/Data Ratio Check execution time: 0.185s -------- Query Cache Information ------------------------------------------------------------------- ℹ Not a MariaDB server. Skipping Query Cache Info plugin check. ℹ Query Cache Information execution time: 0.000s -------- Query Anti-Pattern Detection (Experimental) ----------------------------------------------- ℹ Skipped: Performance Schema is disabled. ℹ Query Anti-Pattern Detection (Experimental) execution time: 0.189s -------- Aria Metrics ------------------------------------------------------------------------------ ℹ Aria Storage Engine not available. ℹ Aria Metrics execution time: 0.000s -------- TokuDB Metrics ---------------------------------------------------------------------------- ℹ TokuDB is disabled. ℹ TokuDB Metrics execution time: 0.000s -------- XtraDB Metrics ---------------------------------------------------------------------------- ℹ XtraDB is disabled. ℹ XtraDB Metrics execution time: 0.000s -------- Galera Metrics ---------------------------------------------------------------------------- ℹ Galera is disabled. ℹ Galera Metrics execution time: 0.000s -------- Replication Metrics ----------------------------------------------------------------------- ℹ Galera Synchronous replication: NO ℹ No replication replica(s) for this server. ℹ Binlog format: ROW ℹ XA support enabled: ON ℹ Semi synchronous replication Source: Not Activated ℹ Semi synchronous replication Replica: Not Activated ℹ This is a standalone server ℹ Replication Metrics execution time: 0.000s -------- Predictive Capacity Planning -------------------------------------------------------------- ✔ Memory headroom: 17.5G (Theoretical max usage is 11.49% of physical RAM) ℹ Growth forecasting: Insufficient uptime (< 24h) for reliable estimation. ℹ Predictive Capacity Planning execution time: 0.000s -------- Cluster & Replication Intelligence -------------------------------------------------------- ℹ Replication status: Not running as a replica. ✘ gtid_mode is OFF (recommended: ON) ✘ enforce_gtid_consistency is OFF (recommended: ON) ✘ binlog_transaction_dependency_tracking is set to COMMIT_ORDER (recommended: WRITESET for parallel throughput) ℹ binlog_transaction_compression is OFF (consider setting to ON to save network/disk space) ✘ Binlog cache disk use ratio is 48.40% (too many disk spills) ✘ source_verify_checksum is disabled (recommended: ON) ℹ Cluster & Replication Intelligence execution time: 0.000s -------- Security Hardening 2.0 -------------------------------------------------------------------- ℹ TLS/SSL is enabled. Minimum supported TLS version: TLSv1.2,TLSv1.3 ℹ Security Hardening 2.0 execution time: 0.000s -------- Guided Auto-Fix Snippets ------------------------------------------------------------------ Ready-to-Apply SQL Snippets (SET GLOBAL): Ready-to-Apply Configuration Block ([mysqld]): sort_buffer_size (> 256K) read_rnd_buffer_size (> 256K) join_buffer_size (> 256.0K, or always use indexes with JOINs) binlog_cache_size (16.0M) ℹ Guided Auto-Fix Snippets execution time: 0.181s -------- Health Score KPI -------------------------------------------------------------------------- Overall Weighted Health Score: 80/100 - Performance: 40/40 - Security: 15/30 - Resilience: 25/30 ℹ Your database health is good, but there's room for improvement. ℹ Health Score KPI execution time: 0.000s -------- Recommendations --------------------------------------------------------------------------- General recommendations: Use 'id' or '__id' for Primary Key naming in 11 table(s) Use BIGINT UNSIGNED AUTO_INCREMENT for Primary Keys in 11 table(s) Use singular names for table in 4 table(s) Remove unused indexes. Restrict Host for 'root'@'%' to 'root'@LimitedIPRangeOrLocalhost RENAME USER 'root'@'%' TO 'root'@LimitedIPRangeOrLocalhost; Current connection is NOT encrypted! Consider using SSL for all connections. Enable require_secure_transport to force all connections to use SSL. Enforce SSL for remote users (ALTER USER ... REQUIRE SSL) 22 CVE(s) found for your MySQL release. Consider upgrading your version ! MySQL was started within the last 24 hours: recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Reduce or eliminate unclosed connections and network issues We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found. See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size Increase binlog_cache_size (current value: 32768) Unused indexes found: 2 index(es) should be reviewed and potentially removed. Migration Risk (default_authentication_plugin): Removed in MySQL 9.0. Use caching_sha2_password or mysql-native-password (if enabled) instead. Migration Risk (binlog_transaction_dependency_tracking): Removed in MySQL 8.4. Migration Risk (avoid_temporal_upgrade): Removed in MySQL 8.4. Upgrading from very old versions (5.5) might need manual temporal upgrade. Migration Risk (expire_logs_days): Removed in MySQL 8.4. Use binlog_expire_logs_seconds instead. Set gtid_mode = ON to enable global transaction identifier replication. Set enforce_gtid_consistency = ON to prevent unsafe replication operations. Set binlog_transaction_dependency_tracking = WRITESET to improve parallel replication throughput. Enable binlog_transaction_compression = ON to reduce replication stream size. Increase binlog_cache_size to reduce disk spills for binary log transactions. Enable source_verify_checksum = ON (or master_verify_checksum). Variables to adjust: sort_buffer_size (> 256K) read_rnd_buffer_size (> 256K) join_buffer_size (> 256.0K, or always use indexes with JOINs) binlog_cache_size (16.0M) ✔ HTML Report successfully generated: /home/jmren/GIT_REPOS/MySQLTuner-perl/examples/20260705_174129_percona80/Container/mysqltuner_report.html ℹ Recommendations execution time: 0.007s -------- Execution Times --------------------------------------------------------------------------- ℹ Started at : 2026-07-05 17:42:31 ℹ Ended at : 2026-07-05 17:44:07 ℹ Security Recommendations : 56.094s (58.5%) ℹ System Linux Recommendations : 4.510s (4.7%) ℹ Database Metrics : 3.489s (3.6%) ℹ Table Column Metrics : 2.555s (2.7%) ℹ Table structures analysis : 1.480s (1.5%) ℹ Audit Snapshot Summary : 1.158s (1.2%) ℹ Storage Engine Statistics : 1.117s (1.2%) ℹ Indexes Metrics : 1.059s (1.1%) ℹ Performance Metrics : 0.837s (0.9%) ℹ Filesystem Linux Recommendations : 0.779s (0.8%) ℹ Naming conventions analysis : 0.772s (0.8%) ℹ SSL/TLS Security Recommendations : 0.557s (0.6%) ℹ Foreign Key analysis : 0.544s (0.6%) ℹ Performance schema : 0.510s (0.5%) ℹ Performance schema: InnoDB Buffer Pool by schema : 0.290s (0.3%) ℹ Performance schema: Table not using InnoDB buffer : 0.272s (0.3%) ℹ Performance schema: 40 InnoDB Buffer Pool by table: 0.249s (0.3%) ℹ Performance schema: Top 15 Tables with InnoDB buffer free: 0.249s (0.3%) ℹ Performance schema: Top 15 Tables using InnoDB buffer: 0.245s (0.3%) ℹ Performance schema: Top 15 slower queries : 0.229s (0.2%) ℹ Log file Recommendations : 0.227s (0.2%) ℹ Performance schema: Top 5 user per rows sent : 0.217s (0.2%) ℹ Performance schema: Top 15 merge queries with sort: 0.217s (0.2%) ℹ Performance schema: Top 15 statement by total latency: 0.217s (0.2%) ℹ Schema sanitization : 0.210s (0.2%) ℹ Performance schema: Top 20 queries with sort : 0.210s (0.2%) ℹ Performance schema: Top 15 total latency queries (95% percentile): 0.210s (0.2%) ℹ Performance schema: Top 5 host per nb full scans : 0.208s (0.2%) ℹ Performance schema: Top 20 queries with full table scans: 0.206s (0.2%) ℹ Performance schema: Top IO type order by max latency: 0.205s (0.2%) ℹ Performance schema: Top 15 most row look queries (95% percentile): 0.205s (0.2%) ℹ Performance schema: Top 5 user per nb full scans : 0.204s (0.2%) ℹ Performance schema: Top 5 host per statement latency: 0.202s (0.2%) ℹ Performance schema: Top 15 class events by max latency: 0.202s (0.2%) ℹ Performance schema: Top 5 host per io latency : 0.201s (0.2%) ℹ Performance schema: Top 5 host per connection : 0.201s (0.2%) ℹ Performance schema: Top 15 row sorting queries with sort: 0.201s (0.2%) ℹ Performance schema: Top 15 max latency queries (95% percentile): 0.200s (0.2%) ℹ Performance schema: Thread IO Latency : 0.200s (0.2%) ℹ Performance schema: Top 5 user per statement latency: 0.199s (0.2%) ℹ Performance schema: Top 15 high delete latency tables: 0.199s (0.2%) ℹ Performance schema: Top 30 events by total latency: 0.199s (0.2%) ℹ Performance schema: Top 15 average latency queries (95% percentile): 0.199s (0.2%) ℹ Performance schema: Top 5 user per connection : 0.198s (0.2%) ℹ Authentication Plugin Security : 0.198s (0.2%) ℹ Performance schema: Top 15 class events by number : 0.196s (0.2%) ℹ Performance schema: Top 15 total latency queries with sort: 0.195s (0.2%) ℹ Performance schema: Top 15 reader queries (95% percentile): 0.194s (0.2%) ℹ Performance schema: Top 5 user per lock latency : 0.194s (0.2%) ℹ Performance schema: Top 15 high update latency index: 0.194s (0.2%) ℹ Performance schema: Top 5 user per statement : 0.193s (0.2%) ℹ Performance schema: Top 5 user per IO : 0.193s (0.2%) ℹ Performance schema: Top 15 high read latency index: 0.192s (0.2%) ℹ Performance schema: Top 15 high read latency tables: 0.192s (0.2%) ℹ Performance schema: Last 50 queries with sort : 0.192s (0.2%) ℹ Data Type optimization : 0.192s (0.2%) ℹ Performance schema: file per IO read latency : 0.192s (0.2%) ℹ Performance schema: Top 15 most modified tables : 0.192s (0.2%) ℹ Performance schema: Top 15 statement by full scans: 0.191s (0.2%) ℹ Performance schema: Top IO type order by total latency: 0.191s (0.2%) ℹ Performance schema: Process per time : 0.190s (0.2%) ℹ Query Anti-Pattern Detection (Experimental) : 0.189s (0.2%) ℹ Performance schema: Unused indexes : 0.189s (0.2%) ℹ Performance schema: Top 15 scans queries with sort: 0.189s (0.2%) ℹ Performance schema: Top 5 user per rows modified : 0.189s (0.2%) ℹ Performance schema: Top 15 nb statement type : 0.189s (0.2%) ℹ Performance schema: Top 15 class events by total latency: 0.188s (0.2%) ℹ Performance schema: event per wait write latency : 0.188s (0.2%) ℹ Performance schema: Top 15 Most latency statements: 0.187s (0.2%) ℹ Performance schema: file per IO write latency : 0.187s (0.2%) ℹ Performance schema: Top 5 host per io : 0.186s (0.2%) ℹ Performance schema: Top 15 statement by rows modified: 0.186s (0.2%) ℹ Performance schema: Event Wait written bytes : 0.186s (0.2%) ℹ Performance schema: Top 15 queries with temp table to disk: 0.186s (0.2%) ℹ Performance schema: Top 30 events by max latency : 0.186s (0.2%) ℹ Performance schema: InnoDB Lock Waits : 0.185s (0.2%) ℹ InnoDB Index/Data Ratio Check : 0.185s (0.2%) ℹ MyISAM Metrics : 0.185s (0.2%) ℹ Performance schema: Top 5 host per lock latency : 0.184s (0.2%) ℹ Performance schema: Top 15 Most executed queries : 0.184s (0.2%) ℹ Performance schema: Top 5 host per table scans : 0.184s (0.2%) ℹ Performance schema: event per wait read latency : 0.184s (0.2%) ℹ Performance schema: Top 15 high update latency tables: 0.184s (0.2%) ℹ Performance schema: Top 15 most modified indexes : 0.184s (0.2%) ℹ Performance schema: Top 15 most read indexes : 0.183s (0.2%) ℹ Performance schema: Top IO type order by total io : 0.183s (0.2%) ℹ Performance schema: Event Wait by read bytes : 0.182s (0.2%) ℹ Guided Auto-Fix Snippets : 0.181s (0.2%) ℹ Performance schema: Top 20 queries with temp table: 0.180s (0.2%) ℹ Performance schema: File by IO read bytes : 0.180s (0.2%) ℹ Performance schema: Top 30 events by number : 0.179s (0.2%) ℹ Performance schema: Top 15 statement by rows sent : 0.178s (0.2%) ℹ Performance schema: Top 15 most modified indexes : 0.177s (0.2%) ℹ Performance schema: Top Stages order by avg latency: 0.177s (0.2%) ℹ Performance schema: File per IO total latency : 0.177s (0.2%) ℹ Performance schema: Top 15 average sort merges queries with sort: 0.177s (0.2%) ℹ Performance schema: Top Stages order by total io : 0.177s (0.2%) ℹ Performance schema: Top 5 host per rows sent : 0.176s (0.2%) ℹ Performance schema: Top 15 most read tables : 0.175s (0.2%) ℹ Performance schema: File by IO written bytes : 0.174s (0.2%) ℹ Plugin Information : 0.174s (0.2%) ℹ Performance schema: Top Stages order by total latency: 0.174s (0.2%) ℹ Performance schema: 15 sample queries using temp table: 0.173s (0.2%) ℹ Performance schema: Top 5 host per rows modified : 0.173s (0.2%) ℹ Performance schema: event per wait total latency : 0.173s (0.2%) ℹ Performance schema: Top 15 statement by lock latency: 0.172s (0.2%) ℹ Performance schema: Latest SQL queries in errors or warnings: 0.172s (0.2%) ℹ Performance schema: Latest File IO by latency : 0.171s (0.2%) ℹ Performance schema: Top 15 high delete latency index: 0.171s (0.2%) ℹ Performance schema: Top 5 user per IO latency : 0.170s (0.2%) ℹ Performance schema: Last 50 queries with full table scans: 0.170s (0.2%) ℹ Performance schema: Redundant indexes : 0.169s (0.2%) ℹ Performance schema: Tables with full table scans : 0.169s (0.2%) ℹ Performance schema: Last 50 queries with temp table: 0.163s (0.2%) ℹ Performance schema: Top 15 range queries with sort: 0.163s (0.2%) ℹ Performance schema: Top 15 total latency queries with temp table: 0.160s (0.2%) ℹ Performance schema: Top 15 high insert latency tables: 0.159s (0.2%) ℹ Recommendations : 0.007s (0.0%) ℹ CVE Security Recommendations : 0.002s (0.0%) ℹ Smart Migration LTS Advisor : 0.001s (0.0%) ℹ InnoDB Metrics : 0.001s (0.0%) ℹ Views Metrics : 0.000s (0.0%) ℹ Cluster & Replication Intelligence : 0.000s (0.0%) ℹ Replication Metrics : 0.000s (0.0%) ℹ Query Cache Information : 0.000s (0.0%) ℹ Aria Metrics : 0.000s (0.0%) ℹ Predictive Capacity Planning : 0.000s (0.0%) ℹ Health Score KPI : 0.000s (0.0%) ℹ Routines Metrics : 0.000s (0.0%) ℹ InnoDB Transactions : 0.000s (0.0%) ℹ Analysis Performance Metrics : 0.000s (0.0%) ℹ TokuDB Metrics : 0.000s (0.0%) ℹ XtraDB Metrics : 0.000s (0.0%) ℹ Triggers Metrics : 0.000s (0.0%) ℹ Galera Metrics : 0.000s (0.0%) ℹ Security Hardening 2.0 : 0.000s (0.0%) ℹ MySQL 8.0+ Specific Modeling : -1.137s (-1.2%) ℹ Performance schema: Top 5 host per statement : -1.714s (-1.8%) ℹ Total Execution Time : 1m 35.916s (95.916s) ✔ Terminated successfully