>> 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:40:14 ℹ 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:40:14 ℹ Server Connection : 127.0.0.1:3306 ℹ Database User : root@localhost ℹ Database Version : 11.4.10-MariaDB-ubu2404 ℹ System Physical RAM: 15.3G ℹ System Swap Memory : 4.0G ℹ Database Uptime : 34s ℹ Skipping architecture check on remote host ℹ Using default 64 bits as target architecture ℹ Audit Snapshot Summary execution time: 1.163s -------- Storage Engine Statistics ----------------------------------------------------------------- ℹ Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE ℹ Data in Aria tables: 32.0K (Tables: 1) ℹ Data in InnoDB tables: 146.8M (Tables: 6) ✔ Total fragmented tables: 0 ✔ Currently running supported MySQL/MariaDB version 11.4.10-MariaDB(LTS) ℹ Storage Engine Statistics execution time: 1.189s -------- 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 : ℹ 1: lo: mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 ℹ link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 ℹ -- ℹ 2: eth0@if22: mtu 1500 qdisc noqueue state UP group default ℹ link/ether 0e:a2:8b:5b:4a:ed brd ff:ff:ff:ff:ff:ff link-netnsid 0 ℹ Internal IP : 172.18.0.3 ℹ HTTP client found: /usr/bin/curl ℹ External IP : sh: 1: /usr/bin/curl: not found ℹ Name Servers : 127.0.0.11 ℹ Logged In users : ℹ Ram Usages in MB : ℹ total used free shared buff/cache available ℹ Mem: 15630 3597 10627 4 1648 12033 ℹ Swap: 4096 0 4096 ℹ Load Average : ℹ top - 15:40:24 up 4 days, 5:11, 0 user, load average: 1.24, 0.89, 0.46 ℹ System Uptime : ℹ 15:40:24 up 4 days, 5:11, 0 user, load average: 1.24, 0.89, 0.46 ℹ Database Uptime : 34s ✔ 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 614M RAM. ℹ Other user process except mysqld used less than 15% of total physical memory 3.93% (614M / 15G) ℹ System Linux Recommendations execution time: 4.556s -------- Filesystem Linux Recommendations ---------------------------------------------------------- ℹ mount point /etc/hosts is using 14 % total space (131.73 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.751s -------- Log file Recommendations ------------------------------------------------------------------ ✔ Log from cloud` docker:mariadb-11.4 exists ✔ docker:mariadb-11.4 doesn't contain any warning. ✔ docker:mariadb-11.4 doesn't contain any error. ℹ 0 start(s) detected in docker:mariadb-11.4 ℹ 0 shutdown(s) detected in docker:mariadb-11.4 ℹ Log file Recommendations execution time: 0.100s -------- Analysis Performance Metrics -------------------------------------------------------------- ℹ innodb_stats_on_metadata: OFF ✔ No stat updates during querying INFORMATION_SCHEMA. ℹ Analysis Performance Metrics execution time: 0.000s -------- Database Metrics -------------------------------------------------------------------------- ℹ There is 1 Database(s). ℹ All User Databases: ℹ +-- TABLE : 6 ℹ +-- VIEW : 2 ℹ +-- INDEX : 9 ℹ +-- CHARS : 1 (utf8mb4) ℹ +-- COLLA : 1 (utf8mb4_uca1400_ai_ci) ℹ +-- ROWS : 3910400 ℹ +-- DATA : 141.2M(96.22%) ℹ +-- INDEX : 5.5M(3.78%) ℹ +-- SIZE : 146.8M ℹ +-- ENGINE: 1 (InnoDB) ℹ Database: employees ℹ +-- TABLE : 6 ℹ +-- VIEW : 2 ℹ +-- INDEX : 9 ℹ +-- CHARS : 1 (utf8mb4) ℹ +-- COLLA : 1 (utf8mb4_uca1400_ai_ci) ℹ +-- ROWS : 3910400 ℹ +-- DATA : 141.2M(96.22%) ℹ +-- INDEX : 5.5M(3.78%) ℹ +-- TOTAL : 146.8M ℹ +-- ENGINE: 1 (InnoDB) ℹ +-- ENGINE InnoDB : 6 TABLE(s) ✔ 1 collation for employees database. ✔ 1 engine for employees database. ℹ Charsets for employees database table column: utf8mb4 ✔ employees table column(s) has same charset defined for all text like column(s). ℹ Collations for employees database table column: utf8mb4_uca1400_ai_ci ✔ employees table column(s) has same collation defined for all text like column(s). ℹ Database Metrics execution time: 3.684s -------- Table Column Metrics ---------------------------------------------------------------------- ℹ MySQL and Percona version 8.0 and greater have removed PROCEDURE ANALYSE feature ℹ Disabling colstat parameter ℹ Database: employees ℹ +-- TABLE: departments ℹ +-- TYPE: InnoDB ℹ +-- Index dept_name - Cols: dept_name - Type: BTREE ℹ +-- Index PRIMARY - Cols: dept_no - Type: BTREE ℹ +-- Column departments.dept_no: CHAR(4) NOT NULL ℹ +-- Column departments.dept_name: VARCHAR(40) NOT NULL ℹ +-- TABLE: dept_emp ℹ +-- TYPE: InnoDB ℹ +-- Index dept_no - Cols: dept_no - Type: BTREE ℹ +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE ℹ +-- Column dept_emp.emp_no: INT(11) NOT NULL ℹ +-- Column dept_emp.dept_no: CHAR(4) NOT NULL ℹ +-- Column dept_emp.from_date: DATE NOT NULL ℹ +-- Column dept_emp.to_date: DATE NOT NULL ℹ +-- TABLE: dept_manager ℹ +-- TYPE: InnoDB ℹ +-- Index dept_no - Cols: dept_no - Type: BTREE ℹ +-- Index PRIMARY - Cols: emp_no,dept_no - Type: BTREE ℹ +-- Column dept_manager.emp_no: INT(11) NOT NULL ℹ +-- Column dept_manager.dept_no: CHAR(4) NOT NULL ℹ +-- Column dept_manager.from_date: DATE NOT NULL ℹ +-- Column dept_manager.to_date: DATE NOT NULL ℹ +-- TABLE: employees ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no - Type: BTREE ℹ +-- Column employees.emp_no: INT(11) NOT NULL ℹ +-- Column employees.birth_date: DATE NOT NULL ℹ +-- Column employees.first_name: VARCHAR(14) NOT NULL ℹ +-- Column employees.last_name: VARCHAR(16) NOT NULL ℹ +-- Column employees.gender: ENUM('M','F') NOT NULL ℹ +-- Column employees.hire_date: DATE NOT NULL ℹ +-- TABLE: salaries ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no,from_date - Type: BTREE ℹ +-- Column salaries.emp_no: INT(11) NOT NULL ℹ +-- Column salaries.salary: INT(11) NOT NULL ℹ +-- Column salaries.from_date: DATE NOT NULL ℹ +-- Column salaries.to_date: DATE NOT NULL ℹ +-- TABLE: titles ℹ +-- TYPE: InnoDB ℹ +-- Index PRIMARY - Cols: emp_no,title,from_date - Type: BTREE ℹ +-- Column titles.emp_no: INT(11) NOT NULL ℹ +-- Column titles.title: VARCHAR(50) NOT NULL ℹ +-- Column titles.from_date: DATE NOT NULL ℹ +-- Column titles.to_date: DATE NULL ℹ Table Column Metrics execution time: 2.799s -------- Table structures analysis ----------------------------------------------------------------- ✔ All tables get a primary key ✘ Table employees.employees: Primary key 'emp_no' does not follow 'id' or 'employees_id' naming convention ✘ Table employees.employees: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_emp: Primary key 'emp_no' does not follow 'id' or 'dept_emp_id' naming convention ✘ Table employees.dept_emp: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_emp: Primary key 'dept_no' does not follow 'id' or 'dept_emp_id' naming convention ✘ Table employees.dept_emp: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.salaries: Primary key 'emp_no' does not follow 'id' or 'salaries_id' naming convention ✘ Table employees.salaries: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.salaries: Primary key 'from_date' does not follow 'id' or 'salaries_id' naming convention ✘ Table employees.salaries: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'emp_no' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'title' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'title' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.titles: Primary key 'from_date' does not follow 'id' or 'titles_id' naming convention ✘ Table employees.titles: Primary key 'from_date' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.departments: Primary key 'dept_no' does not follow 'id' or 'departments_id' naming convention ✘ Table employees.departments: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_manager: Primary key 'emp_no' does not follow 'id' or 'dept_manager_id' naming convention ✘ Table employees.dept_manager: Primary key 'emp_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✘ Table employees.dept_manager: Primary key 'dept_no' does not follow 'id' or 'dept_manager_id' naming convention ✘ Table employees.dept_manager: Primary key 'dept_no' is not a recommended surrogate key (BIGINT UNSIGNED AUTO_INCREMENT) ✔ All tables are InnoDB tables ✔ All columns are UTF-8 compliant ℹ Table structures analysis execution time: 1.594s -------- Naming conventions analysis --------------------------------------------------------------- ✘ Table employees.employees: Plural name detected (prefer singular) ✘ Table employees.salaries: Plural name detected (prefer singular) ✘ Table employees.titles: Plural name detected (prefer singular) ✘ Table employees.departments: Plural name detected (prefer singular) ℹ Naming conventions analysis execution time: 0.794s -------- Foreign Key analysis ---------------------------------------------------------------------- ℹ Constraint on employees.dept_emp.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_emp.dept_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.salaries.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.titles.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_manager.emp_no uses ON DELETE CASCADE; ensure this is intended. ℹ Constraint on employees.dept_manager.dept_no uses ON DELETE CASCADE; ensure this is intended. ℹ Foreign Key analysis execution time: 0.623s -------- MariaDB 10.x+ Specific Modeling ----------------------------------------------------------- ✔ No MySQL 8.0+ specific modeling issues found ℹ MariaDB 10.x+ Specific Modeling execution time: 0.566s -------- Data Type optimization -------------------------------------------------------------------- ✔ No data type optimization recommendations ℹ Data Type optimization execution time: 0.202s -------- Schema sanitization ----------------------------------------------------------------------- ✔ No empty or view-only schemas detected ℹ Schema sanitization execution time: 0.180s -------- Indexes Metrics --------------------------------------------------------------------------- ℹ Worst selectivity indexes: ℹ Index: dept_no(dept_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 1 column(s) ℹ +-- CARDINALITY : 8 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 0.00% ✘ dept_no(dept_no) has a low selectivity ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.salaries ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 315380 distinct values ℹ +-- NB ROWS : 2838426 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 11.11% ✘ PRIMARY(emp_no) has a low selectivity ℹ Index: dept_no(dept_no) ℹ +-- COLUMN : employees.dept_manager ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 1 column(s) ℹ +-- CARDINALITY : 12 distinct values ℹ +-- NB ROWS : 24 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 50.00% ℹ Index: PRIMARY(from_date) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 3 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 441951 distinct values ℹ +-- NB ROWS : 441951 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 331143 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 441951 distinct values ℹ +-- NB ROWS : 441951 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.dept_manager ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 24 distinct values ℹ +-- NB ROWS : 24 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(dept_no) ℹ +-- COLUMN : employees.dept_emp ℹ +-- NB SEQS : 2 sequence(s) ℹ +-- NB COLS : 2 column(s) ℹ +-- CARDINALITY : 331143 distinct values ℹ +-- NB ROWS : 331143 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(title) ℹ +-- COLUMN : employees.titles ℹ +-- NB SEQS : 2 sequence(s) ℹ +-- NB COLS : 3 column(s) ℹ +-- CARDINALITY : 441951 distinct values ℹ +-- NB ROWS : 441951 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Index: PRIMARY(emp_no) ℹ +-- COLUMN : employees.employees ℹ +-- NB SEQS : 1 sequence(s) ℹ +-- NB COLS : 1 column(s) ℹ +-- CARDINALITY : 298847 distinct values ℹ +-- NB ROWS : 298847 rows ℹ +-- TYPE : BTREE ℹ +-- SELECTIVITY : 100.00% ℹ Indexes per database: ℹ Database: employees ℹ +-- INDEX : departments.dept_name ℹ +-- COLUMNS : dept_name ℹ +-- CARDINALITY: 9 ℹ +-- INDEX : departments.PRIMARY ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 9 ℹ +-- INDEX : dept_emp.dept_no ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 8 ℹ +-- INDEX : dept_emp.PRIMARY ℹ +-- COLUMNS : emp_no,dept_no ℹ +-- CARDINALITY: 662286 ℹ +-- INDEX : dept_manager.dept_no ℹ +-- COLUMNS : dept_no ℹ +-- CARDINALITY: 12 ℹ +-- INDEX : dept_manager.PRIMARY ℹ +-- COLUMNS : emp_no,dept_no ℹ +-- CARDINALITY: 48 ℹ +-- INDEX : employees.PRIMARY ℹ +-- COLUMNS : emp_no ℹ +-- CARDINALITY: 298847 ℹ +-- INDEX : salaries.PRIMARY ℹ +-- COLUMNS : emp_no,from_date ℹ +-- CARDINALITY: 3153806 ℹ +-- INDEX : titles.PRIMARY ℹ +-- COLUMNS : emp_no,title,from_date ℹ +-- CARDINALITY: 1325853 ℹ Unused indexes: ✘ Index: dept_name on employees.departments is not used. ✘ Index: dept_no on employees.dept_emp is not used. ✘ Index: dept_no on employees.dept_manager is not used. ℹ Indexes Metrics execution time: 1.001s -------- Views Metrics ----------------------------------------------------------------------------- ℹ Views Metrics execution time: 0.000s -------- Triggers Metrics -------------------------------------------------------------------------- ℹ Triggers Metrics execution time: 0.000s -------- Routines Metrics -------------------------------------------------------------------------- ℹ Routines Metrics execution time: 0.000s -------- Security Recommendations ------------------------------------------------------------------ ℹ mariadb.org binary distribution - 11.4.10-MariaDB ✔ There are no anonymous accounts for any database users ✔ All database users have passwords assigned ✘ User 'root'@% does not specify hostname restrictions. ℹ There are 620 basic passwords in the list. ℹ Security Recommendations execution time: 2.251s -------- Authentication Plugin Security ------------------------------------------------------------ ✘ User 'mariadb.sys'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password ✘ User 'root'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password ✘ User 'root'@'%' uses SHA-1 based insecure plugin: mysql_native_password ✘ User 'healthcheck'@'127.0.0.1' uses SHA-1 based insecure plugin: mysql_native_password ✘ User 'healthcheck'@'::1' uses SHA-1 based insecure plugin: mysql_native_password ✘ User 'healthcheck'@'localhost' uses SHA-1 based insecure plugin: mysql_native_password ℹ Authentication Plugin Security execution time: 0.180s -------- SSL/TLS Security Recommendations ---------------------------------------------------------- ✔ Current connection is encrypted (TLS_AES_256_GCM_SHA384) ✔ SSL support is enabled ✘ require_secure_transport is OFF ✔ Only secure TLS versions enabled: TLSv1.2,TLSv1.3 ✔ TLS is active, but no explicit ssl_cert/ssl_key paths are configured (MariaDB zero-configuration TLS active) ✔ All remote users have SSL enforcement active (or no remote users exist) ℹ SSL/TLS Security Recommendations execution time: 0.372s -------- CVE Security Recommendations -------------------------------------------------------------- ✘ CVE-2026-49261(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. Versions 10.6.1 through 10.6.26, 10.11.1 through 10.11.17, 11.4.1 through 11.4.11, 11.8.1 through 11.8.7, and 12.3.1 with `wsrep_notify_c... ✘ CVE-2026-44168(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, during ... ✘ CVE-2026-44169(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, a user getting EXECUTE access to a stored routine via a role,... ✘ CVE-2026-44170(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, MariaDB... ✘ CVE-2026-44171(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, mbstrea... ✘ CVE-2026-44173(<= 11.4.10) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.26, 10.11.1 to before 10.11.17, 11.4.1 to before 11.4.11, 11.8.1 to before 11.8.7, and 12.3.1, MariaDB... ✘ CVE-2026-48163(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.27, 10.11.1 to before 10.11.18, 11.4.1 to before 11.4.12, 11.8.1 to before 11.8.8, and 12.3.1, during ... ✘ CVE-2026-48165(<= 11.4.11) : MariaDB server is a community developed fork of MySQL server. From versions 10.6.1 to before 10.6.27, 10.11.1 to before 10.11.18, 11.4.1 to before 11.4.12, 11.8.1 to before 11.8.8, and 12.3.1, a high-... ✘ 8 CVE(s) found for your MySQL release. ℹ CVE Security Recommendations execution time: 0.002s -------- Plugin Information ------------------------------------------------------------------------ ℹ Plugin | Version | Status | Type ℹ -------------------------------------------------------------------------------- ℹ mysql_native_password | 1.0 | ACTIVE | AUTHENTICATION ℹ mysql_old_password | 1.0 | ACTIVE | AUTHENTICATION ℹ unix_socket | 1.0 | ACTIVE | AUTHENTICATION ℹ inet4 | 1.0 | ACTIVE | DATA TYPE ℹ inet6 | 1.0 | ACTIVE | DATA TYPE ℹ uuid | 1.0 | ACTIVE | DATA TYPE ℹ inet6_aton | 1.0 | ACTIVE | FUNCTION ℹ inet6_ntoa | 1.0 | ACTIVE | FUNCTION ℹ inet_aton | 1.0 | ACTIVE | FUNCTION ℹ inet_ntoa | 1.0 | ACTIVE | FUNCTION ℹ is_ipv4 | 1.0 | ACTIVE | FUNCTION ℹ is_ipv4_compat | 1.0 | ACTIVE | FUNCTION ℹ is_ipv4_mapped | 1.0 | ACTIVE | FUNCTION ℹ is_ipv6 | 1.0 | ACTIVE | FUNCTION ℹ sys_guid | 1.0 | ACTIVE | FUNCTION ℹ uuid | 1.0 | ACTIVE | FUNCTION ℹ wsrep | 1.0 | ACTIVE | REPLICATION ℹ wsrep_provider | 1.0 | ACTIVE | REPLICATION ℹ Aria | 1.5 | ACTIVE | STORAGE ENGINE ℹ binlog | 1.0 | ACTIVE | STORAGE ENGINE ℹ CSV | 1.0 | ACTIVE | STORAGE ENGINE ℹ InnoDB | 11.4 | ACTIVE | STORAGE ENGINE ℹ MEMORY | 1.0 | ACTIVE | STORAGE ENGINE ℹ MRG_MyISAM | 1.0 | ACTIVE | STORAGE ENGINE ℹ MyISAM | 1.0 | ACTIVE | STORAGE ENGINE ℹ online_alter_log | 1.0 | ACTIVE | STORAGE ENGINE ℹ partition | 1.0 | ACTIVE | STORAGE ENGINE ℹ PERFORMANCE_SCHEMA | 0.1 | ACTIVE | STORAGE ENGINE ℹ SEQUENCE | 1.0 | ACTIVE | STORAGE ENGINE ℹ SQL_SEQUENCE | 1.0 | ACTIVE | STORAGE ENGINE ℹ Plugin Information execution time: 0.176s -------- Performance Metrics ----------------------------------------------------------------------- ℹ Up for: 34s (709 q [20.853 qps], 219 conn, TX: 402K, RX: 164M) ℹ Reads / Writes: 59% / 41% ℹ Binary logging is disabled ℹ Physical Memory : 15.3G ℹ Max MySQL memory : 3.4G ℹ Other process memory: 615.0M ℹ Total buffers: 401.0M global + 18.9M per thread (151 max threads) ℹ Performance_schema Max memory usage: 197M ℹ Galera GCache Max memory usage: 0B ℹ Global Buffers ℹ +-- Key Buffer: 128.0M ℹ +-- Max Tmp Table: 16.0M ℹ Query Cache Buffers ℹ +-- Query Cache: OFF - DISABLED ℹ +-- Query Cache Size: 1.0M ℹ Per Thread Buffers ℹ +-- Read Buffer: 128.0K ℹ +-- Read RND Buffer: 256.0K ℹ +-- Sort Buffer: 2.0M ℹ +-- Thread stack: 292.0K ℹ +-- Join Buffer: 256.0K ✔ Maximum reached memory usage: 617.3M (3.95% of installed RAM) ✔ Maximum possible memory usage: 3.4G (22.13% of installed RAM) ✔ Overall possible memory usage with other process is compatible with memory available ✔ Slow queries: 0% (0/709) ✔ Highest usage of available connections: 0% (1/151) ✔ Aborted connections: 1.37% (3/219) ✔ Query cache is disabled by default due to mutex contention on multiprocessor machines. ✔ Sorts requiring temporary tables: 0% (0 temp sorts / 227 sorts) ✘ Joins performed without indexes: 39 ✔ Temporary tables created on disk: 15% (281 on disk / 1K total) ✔ Thread cache hit rate: 99% (1 created / 219 connections) ✔ Table cache hit rate: 61% (4K hits / 6K requests) ✔ table_definition_cache (400) is greater than number of tables (304) ✔ Open file limit used: 0% (60/32K) ✔ Table locks acquired immediately: 100% (1K immediate / 1K locks) ℹ Performance Metrics execution time: 0.829s -------- Performance schema ------------------------------------------------------------------------ ℹ Performance_schema is activated. ℹ Memory used by Performance_schema: 197.3M ℹ Sys schema is installed. ℹ Sys schema Version: 1.5.2 ℹ Performance schema execution time: 0.598s -------- Performance schema: Top 5 user per connection --------------------------------------------- ℹ +-- 1: root 310 conn(s) ℹ +-- 2: background 39 conn(s) ℹ Performance schema: Top 5 user per connection execution time: 0.218s -------- Performance schema: Top 5 user per statement ---------------------------------------------- ℹ +-- 1: root 15482 stmt(s) ℹ +-- 2: background 0 stmt(s) ℹ Performance schema: Top 5 user per statement execution time: 0.210s -------- Performance schema: Top 5 user per statement latency -------------------------------------- ℹ +-- 1: root 2509306549.7362 ℹ +-- 2: background 0.0000 ℹ Performance schema: Top 5 user per statement latency execution time: 0.188s -------- Performance schema: Top 5 user per lock latency ------------------------------------------- ℹ +-- 1: root 3495005000000 ℹ +-- 2: background 0 ℹ Performance schema: Top 5 user per lock latency execution time: 0.197s -------- Performance schema: Top 5 user per nb full scans ------------------------------------------ ℹ +-- 1: root 277 ℹ +-- 2: background 0 ℹ Performance schema: Top 5 user per nb full scans execution time: 0.214s -------- Performance schema: Top 5 user per rows sent ---------------------------------------------- ℹ +-- 1: root 6629 ℹ +-- 2: background 0 ℹ Performance schema: Top 5 user per rows sent execution time: 0.205s -------- Performance schema: Top 5 user per rows modified ------------------------------------------ ℹ +-- 1: root 3919016 ℹ +-- 2: background 0 ℹ Performance schema: Top 5 user per rows modified execution time: 0.184s -------- Performance schema: Top 5 user per IO ----------------------------------------------------- ℹ +-- 1: root 41556 ℹ +-- 2: background 10313 ℹ Performance schema: Top 5 user per IO execution time: 0.184s -------- Performance schema: Top 5 user per IO latency --------------------------------------------- ℹ +-- 1: root 6149149897604 ℹ +-- 2: background 1173986902774 ℹ Performance schema: Top 5 user per IO latency execution time: 0.186s -------- Performance schema: Top 5 host per connection --------------------------------------------- ℹ +-- 1: 172.18.0.2 207 conn(s) ℹ +-- 2: localhost 112 conn(s) ℹ Performance schema: Top 5 host per connection execution time: 0.183s -------- Performance schema: Top 5 host per statement ---------------------------------------------- ℹ +-- 1: 172.18.0.2 7504 stmt(s) ℹ +-- 2: localhost 283 stmt(s) ℹ Performance schema: Top 5 host per statement execution time: 0.201s -------- Performance schema: Top 5 host per statement latency -------------------------------------- ℹ +-- 1: 172.18.0.2 2568948779.8507 ℹ +-- 2: localhost 834807680.7018 ℹ Performance schema: Top 5 host per statement latency execution time: 0.214s -------- Performance schema: Top 5 host per lock latency ------------------------------------------- ℹ +-- 1: 172.18.0.2 3360201000000 ℹ +-- 2: localhost 136762000000 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per lock latency execution time: 0.177s -------- Performance schema: Top 5 host per nb full scans ------------------------------------------ ℹ +-- 1: 172.18.0.2 188 ℹ +-- 2: localhost 98 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per nb full scans execution time: 0.184s -------- Performance schema: Top 5 host per rows sent ---------------------------------------------- ℹ +-- 1: 172.18.0.2 3854 ℹ +-- 2: localhost 2795 ℹ +-- 3: background 0 ℹ Performance schema: Top 5 host per rows sent execution time: 0.192s -------- 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.203s -------- Performance schema: Top 5 host per io ----------------------------------------------------- ℹ +-- 1: 172.18.0.2 11672 ℹ +-- 2: localhost 9106 ℹ Performance schema: Top 5 host per io execution time: 0.194s -------- Performance schema: Top 5 host per io latency --------------------------------------------- ℹ +-- 1: 172.18.0.2 3021707208702 ℹ +-- 2: localhost 52867740100 ℹ Performance schema: Top 5 host per io latency execution time: 0.186s -------- Performance schema: Top IO type order by total io ----------------------------------------- ℹ +-- 1: aria/MAI 16225 i/o ℹ +-- 2: innodb/innodb_data_file 10804 i/o ℹ +-- 3: aria/MAD 2775 i/o ℹ +-- 4: sql/FRM 833 i/o ℹ +-- 5: sql/file_parser 228 i/o ℹ +-- 6: sql/global_ddl_log 112 i/o ℹ +-- 7: sql/misc 25 i/o ℹ +-- 8: sql/dbopt 21 i/o ℹ +-- 9: myisam/dfile 18 i/o ℹ +-- 10: aria/translog 9 i/o ℹ +-- 11: csv/metadata 8 i/o ℹ +-- 12: partition/ha_partition::parfile 6 i/o ℹ +-- 13: myisam/kfile 6 i/o ℹ +-- 14: sql/casetest 5 i/o ℹ +-- 15: csv/data 4 i/o ℹ +-- 16: sql/pid 3 i/o ℹ +-- 17: sql/tclog 3 i/o ℹ +-- 18: aria/control 3 i/o ℹ +-- 19: mysys/charset 3 i/o ℹ Performance schema: Top IO type order by total io execution time: 0.212s -------- Performance schema: Top IO type order by total latency ------------------------------------ ℹ +-- 1: innodb/innodb_data_file 3988481746011.0 ℹ +-- 2: sql/global_ddl_log 83462353947.0 ℹ +-- 3: aria/MAI 81041046212.0 ℹ +-- 4: aria/MAD 45148876514.0 ℹ +-- 5: sql/FRM 23477240066.0 ℹ +-- 6: csv/metadata 15542308320.0 ℹ +-- 7: sql/file_parser 6997911403.0 ℹ +-- 8: mysys/charset 3310927683.0 ℹ +-- 9: sql/misc 302557360.0 ℹ +-- 10: sql/dbopt 129722740.0 ℹ +-- 11: sql/casetest 107768640.0 ℹ +-- 12: sql/pid 104273680.0 ℹ +-- 13: sql/tclog 93578660.0 ℹ +-- 14: aria/translog 82629260.0 ℹ +-- 15: aria/control 76513080.0 ℹ +-- 16: myisam/dfile 74135180.0 ℹ +-- 17: partition/ha_partition::parfile 51539600.0 ℹ +-- 18: csv/data 47148780.0 ℹ +-- 19: myisam/kfile 29574440.0 ℹ Performance schema: Top IO type order by total latency execution time: 0.201s -------- Performance schema: Top IO type order by max latency -------------------------------------- ℹ +-- 1: innodb/innodb_data_file 124827012751 ℹ +-- 2: csv/metadata 14999527760 ℹ +-- 3: sql/global_ddl_log 10150138040 ℹ +-- 4: sql/FRM 4029539017 ℹ +-- 5: mysys/charset 3283996583 ℹ +-- 6: sql/file_parser 3200161783 ℹ +-- 7: aria/MAD 2483384197 ℹ +-- 8: aria/MAI 348246220 ℹ +-- 9: sql/misc 108299520 ℹ +-- 10: sql/pid 76756400 ℹ +-- 11: sql/casetest 71757280 ℹ +-- 12: aria/control 64568280 ℹ +-- 13: sql/dbopt 51119320 ℹ +-- 14: sql/tclog 49637280 ℹ +-- 15: aria/translog 35148680 ℹ +-- 16: csv/data 26112660 ℹ +-- 17: partition/ha_partition::parfile 14300580 ℹ +-- 18: myisam/dfile 6735540 ℹ +-- 19: myisam/kfile 6702360 ℹ Performance schema: Top IO type order by max latency execution time: 0.200s -------- 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.200s -------- Performance schema: Top Stages order by total latency ------------------------------------- ℹ +-- 1: innodb/buffer pool load 2707585000.0 ℹ Performance schema: Top Stages order by total latency execution time: 0.204s -------- Performance schema: Top Stages order by avg latency --------------------------------------- ℹ +-- 1: innodb/buffer pool load 2707585000 ℹ Performance schema: Top Stages order by avg latency execution time: 0.213s -------- Performance schema: Top 5 host per table scans -------------------------------------------- ℹ +-- 1: 172.18.0.2 188 ℹ +-- 2: localhost 109 ℹ Performance schema: Top 5 host per table scans execution time: 0.187s -------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------ ℹ +-- 1: employees 100941824 92277192 6161 page(s) ℹ +-- 2: InnoDB System 98304 8530 6 page(s) ℹ Performance schema: InnoDB Buffer Pool by schema execution time: 0.207s -------- Performance schema: 40 InnoDB Buffer Pool by table ---------------------------------------- ℹ +-- 1: employees salaries 88522752 80885744 5403 page(s) ℹ +-- 2: employees employees 12419072 11391448 758 page(s) ℹ +-- 3: InnoDB System SYS_FOREIGN 32768 640 2 page(s) ℹ +-- 4: InnoDB System SYS_COLUMNS 16384 3772 1 page(s) ℹ +-- 5: InnoDB System SYS_FIELDS 16384 1547 1 page(s) ℹ +-- 6: InnoDB System SYS_INDEXES 16384 1532 1 page(s) ℹ +-- 7: InnoDB System SYS_TABLES 16384 1039 1 page(s) ℹ Performance schema: 40 InnoDB Buffer Pool by table execution time: 0.201s -------- Performance schema: Process per time ------------------------------------------------------ ℹ +-- 1: sql/main NULL 63 ℹ +-- 2: root@localhost Query 0 ℹ +-- 3: mysys/statement_timer NULL NULL ℹ +-- 4: aria/checkpoint_background NULL NULL ℹ +-- 5: innodb/thread_pool_thread NULL NULL ℹ +-- 6: innodb/page_cleaner_thread NULL NULL ℹ +-- 7: innodb/thread_pool_thread NULL NULL ℹ +-- 8: innodb/thread_pool_thread NULL NULL ℹ +-- 9: sql/manager NULL NULL ℹ +-- 10: sql/signal_handler NULL NULL ℹ +-- 11: innodb/thread_pool_thread NULL NULL ℹ +-- 12: innodb/thread_pool_thread NULL NULL ℹ +-- 13: innodb/thread_pool_thread NULL NULL ℹ +-- 14: innodb/thread_pool_thread NULL NULL ℹ +-- 15: innodb/thread_pool_thread NULL NULL ℹ +-- 16: innodb/thread_pool_thread NULL NULL ℹ +-- 17: innodb/thread_pool_thread NULL NULL ℹ +-- 18: innodb/thread_pool_thread NULL NULL ℹ +-- 19: innodb/thread_pool_thread NULL NULL ℹ +-- 20: innodb/thread_pool_thread NULL NULL ℹ +-- 21: innodb/thread_pool_thread NULL NULL ℹ +-- 22: innodb/thread_pool_thread NULL NULL ℹ +-- 23: innodb/thread_pool_thread NULL NULL ℹ +-- 24: innodb/thread_pool_thread NULL NULL ℹ +-- 25: innodb/thread_pool_thread NULL NULL ℹ +-- 26: innodb/thread_pool_thread NULL NULL ℹ +-- 27: innodb/thread_pool_thread NULL NULL ℹ +-- 28: innodb/thread_pool_thread NULL NULL ℹ +-- 29: innodb/thread_pool_thread NULL NULL ℹ +-- 30: innodb/thread_pool_thread NULL NULL ℹ +-- 31: innodb/thread_pool_thread NULL NULL ℹ +-- 32: innodb/thread_pool_thread NULL NULL ℹ +-- 33: innodb/thread_pool_thread NULL NULL ℹ Performance schema: Process per time execution time: 0.187s -------- Performance schema: InnoDB Lock Waits ----------------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: InnoDB Lock Waits execution time: 0.189s -------- Performance schema: Thread IO Latency ----------------------------------------------------- ℹ +-- 1: page_cleaner_thread 812639675351 124827012751 ℹ +-- 2: thread_pool_thread 77073255728 58664389511 ℹ +-- 3: main 71109481975 7682519320 ℹ +-- 4: thread_pool_thread 44698592393 20859646087 ℹ +-- 5: thread_pool_thread 42124265134 19851109019 ℹ +-- 6: thread_pool_thread 23415724899 13547484692 ℹ +-- 7: thread_pool_thread 13075221033 3602412324 ℹ +-- 8: thread_pool_thread 12904406522 12904406522 ℹ +-- 9: thread_pool_thread 9257699451 8330650251 ℹ +-- 10: thread_pool_thread 9134526996 8591259796 ℹ +-- 11: thread_pool_thread 9014408760 7849602740 ℹ +-- 12: thread_pool_thread 8062751613 4497580521 ℹ +-- 13: thread_pool_thread 7159651184 2437015700 ℹ +-- 14: thread_pool_thread 6533070663 6451846023 ℹ +-- 15: thread_pool_thread 6438324620 3876883920 ℹ +-- 16: thread_pool_thread 5592693610 2927685411 ℹ +-- 17: thread_pool_thread 4323736123 767481603 ℹ +-- 18: thread_pool_thread 3683380372 3568743472 ℹ +-- 19: thread_pool_thread 3439236402 3349628282 ℹ +-- 20: thread_pool_thread 2196299777 2047299457 ℹ +-- 21: thread_pool_thread 1986993148 748750940 ℹ +-- 22: signal_handler 104273680 76756400 ℹ +-- 23: manager 19233340 15196440 ℹ Performance schema: Thread IO Latency execution time: 0.194s -------- Performance schema: Top 15 Most latency statements ---------------------------------------- ℹ +-- 1: INSERT INTO `dept_emp` VALUES (...) /* , ... */ 154384764000 ℹ +-- 2: INSERT INTO `titles` VALUES (...) /* , ... */ 111553432000 ℹ +-- 3: INSERT INTO `salaries` VALUES (...) /* , ... */ 111087783000 ℹ +-- 4: INSERT INTO `employees` VALUES (...) /* , ... */ 84473896000 ℹ +-- 5: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 49350103000 ℹ +-- 6: SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 37454601000 ℹ +-- 7: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 36125345000 ℹ +-- 8: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 23588540000 ℹ +-- 9: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 18041597000 ℹ +-- 10: SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 17374842000 ℹ +-- 11: SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 17247846000 ℹ +-- 12: SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 15912575000 ℹ +-- 13: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 15775572000 ℹ +-- 14: SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 15557520000 ℹ +-- 15: CREATE TABLE `departments` ( `dept_no` CHARACTER (?) NOT NULL , `dept_name` VARCHARACTER (?) NOT NULL , PRIMARY KEY ( `d 15384918000 ℹ Performance schema: Top 15 Most latency statements execution time: 0.202s -------- 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 `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 4 s ℹ +-- 6: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2 s ℹ +-- 7: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 2 s ℹ +-- 8: SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 2 s ℹ +-- 9: SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 2 s ℹ +-- 10: CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 1 s ℹ +-- 11: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 1 s ℹ Performance schema: Top 15 slower queries execution time: 0.200s -------- Performance schema: Top 15 nb statement type ---------------------------------------------- ℹ +-- 1: freturn 6766 ℹ +-- 2: select 368 ℹ +-- 3: Quit 341 ℹ +-- 4: insert 168 ℹ +-- 5: jump_if_not 96 ℹ +-- 6: Init DB 52 ℹ +-- 7: show_engine_status 12 ℹ +-- 8: show_status 6 ℹ +-- 9: create_table 6 ℹ +-- 10: show_variables 5 ℹ +-- 11: show_databases 5 ℹ +-- 12: Statistics 2 ℹ +-- 13: create_view 2 ℹ +-- 14: show_slave_status 2 ℹ +-- 15: show_storage_engines 2 ℹ Performance schema: Top 15 nb statement type execution time: 0.223s -------- Performance schema: Top 15 statement by total latency ------------------------------------- ℹ +-- 1: insert 18606886331000 ℹ +-- 2: select 806281366000 ℹ +-- 3: create_table 89178970000 ℹ +-- 4: drop_table 49350103000 ℹ +-- 5: create_view 17507493000 ℹ +-- 6: show_variables 6188014000 ℹ +-- 7: freturn 5907238000 ℹ +-- 8: show_status 4724202000 ℹ +-- 9: Init DB 3807943000 ℹ +-- 10: show_engine_status 2267227000 ℹ +-- 11: Quit 2258645000 ℹ +-- 12: show_databases 1626526000 ℹ +-- 13: create_db 808364000 ℹ +-- 14: show_storage_engines 529189000 ℹ +-- 15: show_slave_status 273213000 ℹ Performance schema: Top 15 statement by total latency execution time: 0.206s -------- Performance schema: Top 15 statement by lock latency -------------------------------------- ℹ +-- 1: insert 3152505000000 ℹ +-- 2: select 340961000000 ℹ +-- 3: create_view 4917000000 ℹ +-- 4: create_table 720000000 ℹ +-- 5: show_status 503000000 ℹ +-- 6: drop_table 502000000 ℹ +-- 7: show_databases 409000000 ℹ +-- 8: show_variables 408000000 ℹ +-- 9: show_storage_engines 201000000 ℹ +-- 10: Statistics 0 ℹ +-- 11: create_db 0 ℹ +-- 12: freturn 0 ℹ +-- 13: flush 0 ℹ +-- 14: show_slave_status 0 ℹ +-- 15: Init DB 0 ℹ Performance schema: Top 15 statement by lock latency execution time: 0.176s -------- Performance schema: Top 15 statement by full scans ---------------------------------------- ℹ +-- 1: select 290 ℹ +-- 2: show_status 6 ℹ +-- 3: show_databases 5 ℹ +-- 4: show_variables 5 ℹ +-- 5: show_storage_engines 2 ℹ +-- 6: drop_db 0 ℹ +-- 7: Init DB 0 ℹ +-- 8: create_table 0 ℹ +-- 9: show_grants 0 ℹ +-- 10: jump_if_not 0 ℹ +-- 11: show_slave_hosts 0 ℹ +-- 12: Ping 0 ℹ +-- 13: drop_table 0 ℹ +-- 14: create_db 0 ℹ +-- 15: Quit 0 ℹ Performance schema: Top 15 statement by full scans execution time: 0.203s -------- Performance schema: Top 15 statement by rows sent ----------------------------------------- ℹ +-- 1: show_variables 2731 ℹ +-- 2: show_status 2222 ℹ +-- 3: select 1888 ℹ +-- 4: show_databases 25 ℹ +-- 5: show_storage_engines 16 ℹ +-- 6: Statistics 0 ℹ +-- 7: create_view 0 ℹ +-- 8: create_db 0 ℹ +-- 9: create_table 0 ℹ +-- 10: freturn 0 ℹ +-- 11: flush 0 ℹ +-- 12: show_slave_status 0 ℹ +-- 13: drop_table 0 ℹ +-- 14: Init DB 0 ℹ +-- 15: set_option 0 ℹ Performance schema: Top 15 statement by rows sent execution time: 0.203s -------- Performance schema: Top 15 statement by rows modified ------------------------------------- ℹ +-- 1: insert 3919015 ℹ +-- 2: create_db 1 ℹ +-- 3: Statistics 0 ℹ +-- 4: create_view 0 ℹ +-- 5: show_status 0 ℹ +-- 6: create_table 0 ℹ +-- 7: freturn 0 ℹ +-- 8: flush 0 ℹ +-- 9: show_slave_status 0 ℹ +-- 10: drop_table 0 ℹ +-- 11: Init DB 0 ℹ +-- 12: show_storage_engines 0 ℹ +-- 13: set_option 0 ℹ +-- 14: show_variables 0 ℹ +-- 15: select 0 ℹ Performance schema: Top 15 statement by rows modified execution time: 0.191s -------- Performance schema: 15 sample queries using temp table ------------------------------------ ℹ +-- 1: SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T ℹ +-- 2: SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? ℹ +-- 3: SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` ℹ +-- 4: SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU ℹ +-- 5: SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform ℹ +-- 6: SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i ℹ +-- 7: SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO ℹ +-- 8: SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . ` ℹ +-- 9: SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS ℹ +-- 10: SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN ℹ +-- 11: SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND ℹ +-- 12: SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ℹ +-- 13: SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE ℹ +-- 14: SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA ℹ +-- 15: SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch ℹ Performance schema: 15 sample queries using temp table execution time: 0.194s -------- Performance schema: Unused indexes -------------------------------------------------------- ℹ +-- 1: employees.departments (dept_name) ℹ +-- 2: employees.dept_emp (dept_no) ℹ +-- 3: employees.dept_manager (dept_no) ✘ Performance schema: 3 unused index(es) found. ℹ Performance schema: Unused indexes execution time: 0.198s -------- Performance schema: Tables with full table scans ------------------------------------------ ℹ No information found or indicators deactivated. ℹ Performance schema: Tables with full table scans execution time: 0.190s -------- Performance schema: Latest File IO by latency --------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: Latest File IO by latency execution time: 0.185s -------- Performance schema: File by IO read bytes ------------------------------------------------- ℹ +-- 1: /var/lib/mysql/ibdata1 2555904 ℹ +-- 2: /var/lib/mysql/employees/employees.ibd 1851392 ℹ +-- 3: /var/lib/mysql/undo001 802816 ℹ +-- 4: /var/lib/mysql/undo002 753664 ℹ +-- 5: /var/lib/mysql/undo003 753664 ℹ +-- 6: /var/lib/mysql/mysql/transaction_registry.ibd 163840 ℹ +-- 7: /var/lib/mysql/employees/salaries.ibd 98304 ℹ +-- 8: /var/lib/mysql/mysql/innodb_index_stats.ibd 49152 ℹ +-- 9: /var/lib/mysql/mysql/innodb_table_stats.ibd 49152 ℹ +-- 10: /var/lib/mysql/mysql/proc.MAD 40960 ℹ +-- 11: /var/lib/mysql/mysql/gtid_slave_pos.ibd 32768 ℹ +-- 12: /usr/share/mariadb/charsets/Index.xml 23509 ℹ +-- 13: /var/lib/mysql/mysql/proxies_priv.MAD 16384 ℹ +-- 14: /var/lib/mysql/mysql/global_priv.MAD 16384 ℹ +-- 15: /var/lib/mysql/mysql/user.frm 13657 ℹ Performance schema: File by IO read bytes execution time: 0.203s -------- Performance schema: File by IO written bytes ---------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/salaries.ibd 95797248 ℹ +-- 2: /var/lib/mysql/employees/titles.ibd 19644416 ℹ +-- 3: /var/lib/mysql/employees/dept_emp.ibd 17055744 ℹ +-- 4: /var/lib/mysql/employees/employees.ibd 14581760 ℹ +-- 5: /var/lib/mysql/ibdata1 4816896 ℹ +-- 6: /var/lib/mysql/undo001 4177920 ℹ +-- 7: /var/lib/mysql/undo003 3588096 ℹ +-- 8: /var/lib/mysql/undo002 3014656 ℹ +-- 9: /var/lib/mysql/ibtmp1 2146304 ℹ +-- 10: /var/lib/mysql/ddl_recovery.log 98406 ℹ +-- 11: /var/lib/mysql/employees/departments.ibd 81920 ℹ +-- 12: /var/lib/mysql/employees/dept_manager.ibd 81920 ℹ +-- 13: /var/lib/mysql/mysql/innodb_index_stats.ibd 49152 ℹ +-- 14: /var/lib/mysql/mysql/innodb_table_stats.ibd 49152 ℹ +-- 15: /var/lib/mysql/employees/departments.frm 1619 ℹ Performance schema: File by IO written bytes execution time: 0.236s -------- Performance schema: File per IO total latency --------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/salaries.ibd 2042423271112 ℹ +-- 2: /var/lib/mysql/employees/titles.ibd 572146089319 ℹ +-- 3: /var/lib/mysql/employees/employees.ibd 546248338391 ℹ +-- 4: /var/lib/mysql/employees/dept_emp.ibd 522583906719 ℹ +-- 5: /var/lib/mysql/ibdata1 105090899529 ℹ +-- 6: /var/lib/mysql/ddl_recovery.log 83441671747 ℹ +-- 7: /var/lib/mysql/undo002 79130009826 ℹ +-- 8: /var/lib/mysql/undo003 50881269537 ℹ +-- 9: /var/lib/mysql/undo001 27959842582 ℹ +-- 10: /var/lib/mysql/employees/dept_manager.ibd 17987243533 ℹ +-- 11: /var/lib/mysql/mysql/general_log.CSM 15011450440 ℹ +-- 12: /var/lib/mysql/mysql/innodb_index_stats.ibd 6673880500 ℹ +-- 13: /var/lib/mysql/mysql/innodb_table_stats.ibd 6247048003 ℹ +-- 14: /var/lib/mysql/employees/departments.ibd 5779566688 ℹ +-- 15: /var/lib/mysql/employees/employees.frm 4200404957 ℹ +-- 16: /var/lib/mysql/employees/salaries.frm 3942115800 ℹ +-- 17: /var/lib/mysql/employees/departments.frm 3647030023 ℹ +-- 18: /var/lib/mysql/employees/dept_emp_latest_date.frm 3334319583 ℹ +-- 19: /usr/share/mariadb/charsets/Index.xml 3310927683 ℹ +-- 20: /var/lib/mysql/employees/dept_emp.frm 3188359104 ℹ Performance schema: File per IO total latency execution time: 0.208s -------- Performance schema: file per IO read latency ---------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/employees.ibd 110433560825 ℹ +-- 2: /var/lib/mysql/undo001 15426181638 ℹ +-- 3: /var/lib/mysql/undo002 14641083114 ℹ +-- 4: /var/lib/mysql/undo003 14615043450 ℹ +-- 5: /var/lib/mysql/ibdata1 10073816851 ℹ +-- 6: /var/lib/mysql/employees/salaries.ibd 3389084279 ℹ +-- 7: /var/lib/mysql/mysql/transaction_registry.ibd 1858102120 ℹ +-- 8: /var/lib/mysql/mysql/innodb_table_stats.ibd 1049589023 ℹ +-- 9: /var/lib/mysql/mysql/gtid_slave_pos.ibd 734972392 ℹ +-- 10: /var/lib/mysql/mysql/innodb_index_stats.ibd 659702456 ℹ +-- 11: /var/lib/mysql/aria_log_control 64568280 ℹ +-- 12: /var/lib/mysql/mysql/global_priv.MAD 57456700 ℹ +-- 13: /var/lib/mysql/mysql/event.frm 46330340 ℹ +-- 14: /var/lib/mysql/sys/x@0024user_summary_by_statement_type.frm 42950404 ℹ +-- 15: /var/lib/mysql/mysql/proc.MAD 35756980 ℹ +-- 16: /var/lib/mysql/employees/salaries.frm 28932960 ℹ +-- 17: /var/lib/mysql/aria_log.00000001 25106200 ℹ +-- 18: /var/lib/mysql/employees/titles.frm 22617700 ℹ +-- 19: /var/lib/mysql/mysql/proc.MAI 20626900 ℹ +-- 20: /var/lib/mysql/mysql/user.frm 19885880 ℹ Performance schema: file per IO read latency execution time: 0.183s -------- Performance schema: file per IO write latency --------------------------------------------- ℹ +-- 1: /var/lib/mysql/employees/salaries.ibd 75683096125 ℹ +-- 2: /var/lib/mysql/employees/employees.ibd 33978565180 ℹ +-- 3: /var/lib/mysql/employees/dept_emp.ibd 18198887140 ℹ +-- 4: /var/lib/mysql/employees/titles.ibd 16396537374 ℹ +-- 5: /var/lib/mysql/undo001 6151959653 ℹ +-- 6: /var/lib/mysql/undo003 3817318631 ℹ +-- 7: /var/lib/mysql/undo002 3396083600 ℹ +-- 8: /var/lib/mysql/ibtmp1 2573418680 ℹ +-- 9: /var/lib/mysql/ddl_recovery.log 765960300 ℹ +-- 10: /var/lib/mysql/ibdata1 657815620 ℹ +-- 11: /var/lib/mysql/employees/departments.ibd 649045040 ℹ +-- 12: /var/lib/mysql/employees/dept_manager.ibd 538024760 ℹ +-- 13: /var/lib/mysql/mysql/innodb_table_stats.ibd 96166700 ℹ +-- 14: /var/lib/mysql/mysql/innodb_index_stats.ibd 31465700 ℹ +-- 15: /var/lib/mysql/employees/departments.frm 25725560 ℹ +-- 16: /run/mysqld/mysqld.pid 22042580 ℹ +-- 17: /var/lib/mysql/employees/salaries.frm 21390040 ℹ +-- 18: /var/lib/mysql/employees/employees.frm 19509840 ℹ +-- 19: /var/lib/mysql/employees/dept_manager.frm 18260060 ℹ +-- 20: /var/lib/mysql/employees/dept_emp.frm 17773420 ℹ Performance schema: file per IO write latency execution time: 0.182s -------- Performance schema: Event Wait by read bytes ---------------------------------------------- ℹ +-- 1: innodb/innodb_data_file 7110656 ℹ +-- 2: sql/FRM 488413 ℹ +-- 3: aria/MAI 461826 ℹ +-- 4: aria/MAD 139264 ℹ +-- 5: mysys/charset 23509 ℹ +-- 6: aria/translog 8236 ℹ +-- 7: sql/file_parser 2063 ℹ +-- 8: sql/dbopt 204 ℹ +-- 9: csv/metadata 70 ℹ +-- 10: aria/control 52 ℹ +-- 11: sql/misc 0 ℹ +-- 12: sql/pid 0 ℹ +-- 13: sql/tclog 0 ℹ +-- 14: myisam/dfile 0 ℹ +-- 15: myisam/kfile 0 ℹ Performance schema: Event Wait by read bytes execution time: 0.201s -------- Performance schema: Event Wait written bytes ---------------------------------------------- ℹ +-- 1: innodb/innodb_data_file 165085184 ℹ +-- 2: aria/MAI 419454 ℹ +-- 3: sql/global_ddl_log 98406 ℹ +-- 4: sql/FRM 8078 ℹ +-- 5: sql/file_parser 1935 ℹ +-- 6: sql/dbopt 70 ℹ +-- 7: sql/pid 2 ℹ +-- 8: sql/misc 0 ℹ +-- 9: sql/tclog 0 ℹ +-- 10: mysys/charset 0 ℹ +-- 11: myisam/dfile 0 ℹ +-- 12: myisam/kfile 0 ℹ +-- 13: csv/metadata 0 ℹ +-- 14: csv/data 0 ℹ +-- 15: aria/translog 0 ℹ Performance schema: Event Wait written bytes execution time: 0.202s -------- Performance schema: event per wait total latency ------------------------------------------ ℹ +-- 1: innodb/innodb_data_file 3988481746011 ℹ +-- 2: sql/global_ddl_log 83462353947 ℹ +-- 3: aria/MAI 83061863052 ℹ +-- 4: aria/MAD 45765084414 ℹ +-- 5: sql/FRM 24086845146 ℹ +-- 6: csv/metadata 15542308320 ℹ +-- 7: sql/file_parser 6388306323 ℹ +-- 8: mysys/charset 3310927683 ℹ +-- 9: sql/misc 302557360 ℹ +-- 10: sql/dbopt 129722740 ℹ +-- 11: sql/casetest 107768640 ℹ +-- 12: sql/pid 104273680 ℹ +-- 13: sql/tclog 93578660 ℹ +-- 14: aria/translog 82629260 ℹ +-- 15: aria/control 76513080 ℹ +-- 16: myisam/dfile 74135180 ℹ +-- 17: partition/ha_partition::parfile 51539600 ℹ +-- 18: csv/data 47148780 ℹ +-- 19: myisam/kfile 29574440 ℹ Performance schema: event per wait total latency execution time: 0.204s -------- Performance schema: event per wait read latency ------------------------------------------- ℹ +-- 1: innodb/innodb_data_file 172881136148 ℹ +-- 2: aria/MAI 1755611312 ℹ +-- 3: sql/FRM 784401744 ℹ +-- 4: aria/MAD 149874060 ℹ +-- 5: aria/control 64568280 ℹ +-- 6: aria/translog 25106200 ℹ +-- 7: mysys/charset 19498780 ℹ +-- 8: sql/file_parser 19377120 ℹ +-- 9: sql/dbopt 10805620 ℹ +-- 10: csv/metadata 5773320 ℹ +-- 11: sql/casetest 0 ℹ +-- 12: sql/global_ddl_log 0 ℹ +-- 13: sql/misc 0 ℹ +-- 14: sql/pid 0 ℹ +-- 15: sql/tclog 0 ℹ +-- 16: myisam/dfile 0 ℹ +-- 17: myisam/kfile 0 ℹ +-- 18: csv/data 0 ℹ +-- 19: partition/ha_partition::parfile 0 ℹ Performance schema: event per wait read latency execution time: 0.198s -------- Performance schema: event per wait write latency ------------------------------------------ ℹ +-- 1: innodb/innodb_data_file 162168384203 ℹ +-- 2: aria/MAI 21206742620 ℹ +-- 3: sql/global_ddl_log 765960300 ℹ +-- 4: sql/FRM 120211140 ℹ +-- 5: sql/file_parser 32638060 ℹ +-- 6: sql/pid 22042580 ℹ +-- 7: sql/dbopt 17286780 ℹ +-- 8: sql/casetest 0 ℹ +-- 9: sql/misc 0 ℹ +-- 10: sql/tclog 0 ℹ +-- 11: mysys/charset 0 ℹ +-- 12: myisam/dfile 0 ℹ +-- 13: myisam/kfile 0 ℹ +-- 14: csv/metadata 0 ℹ +-- 15: csv/data 0 ℹ +-- 16: aria/translog 0 ℹ +-- 17: aria/MAD 0 ℹ +-- 18: aria/control 0 ℹ +-- 19: partition/ha_partition::parfile 0 ℹ Performance schema: event per wait write latency execution time: 0.190s -------- 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.180s -------- 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.176s -------- 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.199s -------- 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.186s -------- 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.193s -------- 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.191s -------- Performance schema: Top 15 most read tables ----------------------------------------------- ℹ +-- 1: employees dept_manager 0 ℹ +-- 2: employees titles 0 ℹ +-- 3: employees salaries 0 ℹ +-- 4: employees departments 0 ℹ +-- 5: employees employees 0 ℹ +-- 6: employees dept_emp 0 ℹ Performance schema: Top 15 most read tables execution time: 0.207s -------- 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.204s -------- Performance schema: Top 15 high read latency tables --------------------------------------- ℹ +-- 1: employees dept_manager 0 ℹ +-- 2: employees titles 0 ℹ +-- 3: employees salaries 0 ℹ +-- 4: employees departments 0 ℹ +-- 5: employees employees 0 ℹ +-- 6: employees dept_emp 0 ℹ Performance schema: Top 15 high read latency tables execution time: 0.220s -------- Performance schema: Top 15 high insert latency tables ------------------------------------- ℹ +-- 1: employees salaries 7218141168371 ℹ +-- 2: employees dept_emp 1498872346167 ℹ +-- 3: employees titles 1370980709721 ℹ +-- 4: employees employees 685673502654 ℹ +-- 5: employees dept_manager 156797620 ℹ +-- 6: employees departments 112535500 ℹ Performance schema: Top 15 high insert latency tables execution time: 0.205s -------- Performance schema: Top 15 high update latency tables ------------------------------------- ℹ +-- 1: employees dept_manager 0 ℹ +-- 2: employees titles 0 ℹ +-- 3: employees salaries 0 ℹ +-- 4: employees departments 0 ℹ +-- 5: employees employees 0 ℹ +-- 6: employees dept_emp 0 ℹ Performance schema: Top 15 high update latency tables execution time: 0.195s -------- Performance schema: Top 15 high delete latency tables ------------------------------------- ℹ +-- 1: employees dept_manager 0 ℹ +-- 2: employees titles 0 ℹ +-- 3: employees salaries 0 ℹ +-- 4: employees departments 0 ℹ +-- 5: employees employees 0 ℹ +-- 6: employees dept_emp 0 ℹ Performance schema: Top 15 high delete latency tables execution time: 0.214s -------- Performance schema: Redundant indexes ----------------------------------------------------- ℹ No information found or indicators deactivated. ℹ Performance schema: Redundant indexes execution time: 0.211s -------- Performance schema: Table not using InnoDB buffer ----------------------------------------- ℹ +-- 1: employees dept_emp ℹ +-- 2: employees titles ℹ +-- 3: employees dept_manager ℹ +-- 4: employees departments ℹ Performance schema: Table not using InnoDB buffer execution time: 0.207s -------- Performance schema: Top 15 Tables using InnoDB buffer ------------------------------------- ℹ +-- 1: employees salaries 88522752 ℹ +-- 2: employees employees 12419072 ℹ Performance schema: Top 15 Tables using InnoDB buffer execution time: 0.214s -------- Performance schema: Top 15 Tables with InnoDB buffer free --------------------------------- ℹ +-- 1: employees salaries 7637008 ℹ +-- 2: employees employees 1027624 ℹ Performance schema: Top 15 Tables with InnoDB buffer free execution time: 0.213s -------- Performance schema: Top 15 Most executed queries ------------------------------------------ ℹ +-- 1: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 114 ℹ +-- 2: NULL SELECT SCHEMA ( ) 76 ℹ +-- 3: employees INSERT INTO `titles` VALUES (...) /* , ... */ 21 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 17 ℹ +-- 5: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 14 ℹ +-- 6: NULL SHOW ENGINE `PERFORMANCE_SCHEMA` STATUS 12 ℹ +-- 7: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 8: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 9: employees SELECT ? AS ? 7 ℹ +-- 10: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 6 ℹ +-- 11: NULL SHOW SCHEMAS 5 ℹ +-- 12: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 4 ℹ +-- 13: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 14: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 4 ℹ +-- 15: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 4 ℹ Performance schema: Top 15 Most executed queries execution time: 0.189s -------- Performance schema: Latest SQL queries in errors or warnings ------------------------------ ℹ +-- 1: DROP SCHEMA IF EXISTS `employees` 2026-07-05 15:39:48 ℹ +-- 2: DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 2026-07-05 15:39:48 ℹ Performance schema: Latest SQL queries in errors or warnings execution time: 0.176s -------- Performance schema: Top 20 queries with full table scans ---------------------------------- ℹ +-- 1: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 12 ℹ +-- 2: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 3: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 6 ℹ +-- 4: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 4 ℹ +-- 5: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 6: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 4 ℹ +-- 7: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 8: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME FROM `information_schema` . `tables` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN 4 ℹ +-- 9: NULL SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 2 ℹ +-- 10: NULL SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . ` 2 ℹ +-- 11: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 12: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ +-- 13: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 2 ℹ +-- 14: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 2 ℹ +-- 15: NULL SELECT ? FROM `information_schema` . `tables` WHERE `table_schema` = ? AND TABLE_NAME = ? LIMIT ? 2 ℹ +-- 16: NULL SELECT SCHEMA_NAME FROM `information_schema` . `SCHEMATA` WHERE SCHEMA_NAME NOT IN (...) 2 ℹ +-- 17: NULL SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , 2 ℹ +-- 18: NULL SELECT COUNT ( DISTINCTROW ( `concat` ( TABLE_NAME , `TABLE_SCHEMA` , `INDEX_NAME` ) ) ) FROM `information_schema` . `ST 2 ℹ +-- 19: NULL SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `columns` WHERE `CHARACTER_SET_NAME` IS NOT NULL 2 ℹ +-- 20: NULL SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_COLLATION` IS NOT NULL AND `T 2 ℹ Performance schema: Top 20 queries with full table scans execution time: 0.187s -------- 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:40:56 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:40:55 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:40:55 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:40:55 ℹ +-- 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:40:55 ℹ +-- 6: NULL SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db` 2026-07-05 15:40:55 ℹ +-- 7: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:40:54 ℹ +-- 8: NULL SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:40:51 ℹ +-- 9: NULL SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:40:51 ℹ +-- 10: NULL SELECT * FROM `sys` . `x$schema_tables_with_full_table_scans` WHERE ( `object_schema` IS NULL OR `object_schema` NOT IN 2026-07-05 15:40:50 ℹ +-- 11: NULL SELECT FILE , `total_read` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:40:50 ℹ +-- 12: NULL SELECT FILE , `total_written` FROM `sys` . `x$io_global_by_file_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:40:50 ℹ +-- 13: NULL SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 2026-07-05 15:40:50 ℹ +-- 14: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER 2026-07-05 15:40:49 ℹ +-- 15: NULL SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 2026-07-05 15:40:48 ℹ +-- 16: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:40:48 ℹ +-- 17: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:40:47 ℹ +-- 18: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:40:47 ℹ +-- 19: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:40:47 ℹ +-- 20: NULL SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w 2026-07-05 15:40:47 ℹ +-- 21: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:40:47 ℹ +-- 22: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:40:46 ℹ +-- 23: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 24: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 25: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 26: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:40:45 ℹ +-- 27: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 28: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 29: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 30: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 31: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 32: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 33: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 34: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:40:43 ℹ +-- 35: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 36: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 37: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 38: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 39: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 40: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 41: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:40:42 ℹ +-- 42: NULL SELECT COUNT ( * ) FROM `information_schema` . `tables` 2026-07-05 15:40:41 ℹ +-- 43: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) , `JSON_VALUE` ( `Priv` , ? ) FROM `mysql` . `global_ 2026-07-05 15:40:40 ℹ +-- 44: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:40:40 ℹ +-- 45: NULL SELECT SYSTEM_USER , HOST , `JSON_VALUE` ( `Priv` , ? ) , `JSON_VALUE` ( `Priv` , ? ) FROM `mysql` . `global_priv` WHERE 2026-07-05 15:40:39 ℹ +-- 46: NULL SELECT COUNT ( * ) FROM `information_schema` . `columns` WHERE TABLE_NAME = ? AND `TABLE_SCHEMA` = ? AND COLUMN_NAME = ? 2026-07-05 15:40:38 ℹ +-- 47: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE `IS_ROLE` = ? 2026-07-05 15:40:38 ℹ +-- 48: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `user` WHERE `IS_ROLE` = ? AND ( TRIM 2026-07-05 15:40:38 ℹ +-- 49: NULL SELECT `CONCAT` ( `QUOTE` ( SYSTEM_USER ) , ? , `QUOTE` ( HOST ) ) FROM `mysql` . `global_priv` WHERE ( SYSTEM_USER != ? 2026-07-05 15:40:38 ℹ +-- 50: NULL SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 2026-07-05 15:40:38 ℹ Performance schema: Last 50 queries with full table scans execution time: 0.189s -------- Performance schema: Top 15 reader queries (95% percentile) -------------------------------- ℹ +-- 1: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 4 ℹ +-- 2: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 4 ℹ +-- 3: employees INSERT INTO `employees` VALUES (...) /* , ... */ 0 ℹ +-- 4: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 0 ℹ +-- 5: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 0 ℹ +-- 6: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 0 ℹ +-- 7: employees INSERT INTO `titles` VALUES (...) /* , ... */ 0 ℹ +-- 8: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 0 ℹ +-- 9: employees DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 0 ℹ +-- 10: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 0 ℹ +-- 11: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 0 ℹ Performance schema: Top 15 reader queries (95% percentile) execution time: 0.196s -------- Performance schema: Top 15 most row look queries (95% percentile) ------------------------- ℹ +-- 1: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 28577 ℹ +-- 2: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 888 ℹ +-- 3: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 174 ℹ +-- 4: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 36 ℹ +-- 5: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 16 ℹ +-- 6: employees INSERT INTO `employees` VALUES (...) /* , ... */ 0 ℹ +-- 7: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 0 ℹ +-- 8: employees INSERT INTO `titles` VALUES (...) /* , ... */ 0 ℹ +-- 9: employees DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 0 ℹ +-- 10: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 0 ℹ +-- 11: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 0 ℹ Performance schema: Top 15 most row look queries (95% percentile) execution time: 0.188s -------- Performance schema: Top 15 total latency queries (95% percentile) ------------------------- ℹ +-- 1: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 12664007343000 ℹ +-- 2: employees INSERT INTO `titles` VALUES (...) /* , ... */ 2342622074000 ℹ +-- 3: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 2161386697000 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 1436056239000 ℹ +-- 5: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 74909203000 ℹ +-- 6: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 72250691000 ℹ +-- 7: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 69499370000 ℹ +-- 8: employees DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 49350103000 ℹ +-- 9: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 36083194000 ℹ +-- 10: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 34495693000 ℹ +-- 11: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 23588540000 ℹ Performance schema: Top 15 total latency queries (95% percentile) execution time: 0.196s -------- Performance schema: Top 15 max latency queries (95% percentile) --------------------------- ℹ +-- 1: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 322412890000 ℹ +-- 2: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 262360561000 ℹ +-- 3: employees INSERT INTO `titles` VALUES (...) /* , ... */ 213981432000 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 211810419000 ℹ +-- 5: employees DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 49350103000 ℹ +-- 6: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 39880362000 ℹ +-- 7: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 39866921000 ℹ +-- 8: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 38725269000 ℹ +-- 9: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 23588540000 ℹ +-- 10: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 22580028000 ℹ +-- 11: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 17275168000 ℹ Performance schema: Top 15 max latency queries (95% percentile) execution time: 0.187s -------- Performance schema: Top 15 average latency queries (95% percentile) ----------------------- ℹ +-- 1: employees INSERT INTO `dept_emp` VALUES (...) /* , ... */ 154384764000 ℹ +-- 2: employees INSERT INTO `titles` VALUES (...) /* , ... */ 111553432000 ℹ +-- 3: employees INSERT INTO `salaries` VALUES (...) /* , ... */ 111087783000 ℹ +-- 4: employees INSERT INTO `employees` VALUES (...) /* , ... */ 84473896000 ℹ +-- 5: employees DROP TABLE IF EXISTS `dept_emp` , `dept_manager` , `titles` , `salaries` , `employees` , `departments` 49350103000 ℹ +-- 6: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 37454601000 ℹ +-- 7: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 36125345000 ℹ +-- 8: employees CREATE TABLE `employees` ( `emp_no` INTEGER NOT NULL , `birth_date` DATE NOT NULL , `first_name` VARCHARACTER (?) NOT NU 23588540000 ℹ +-- 9: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 18041597000 ℹ +-- 10: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 17374842000 ℹ +-- 11: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 17247846000 ℹ Performance schema: Top 15 average latency queries (95% percentile) execution time: 0.189s -------- 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 SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 4: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ +-- 5: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 2 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2 ℹ +-- 8: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 2 ℹ +-- 9: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2 ℹ +-- 11: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2 ℹ +-- 12: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2 ℹ +-- 13: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2 ℹ +-- 14: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2 ℹ +-- 15: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2 ℹ +-- 16: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2 ℹ +-- 17: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2 ℹ +-- 18: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2 ℹ +-- 19: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2 ℹ +-- 20: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2 ℹ Performance schema: Top 20 queries with sort execution time: 0.200s -------- 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:40:57 ℹ +-- 2: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL O 2026-07-05 15:40:56 ℹ +-- 3: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_full_table_scans` WHERE ( `db` IS NULL OR 2026-07-05 15:40:56 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:40:55 ℹ +-- 5: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:40:55 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:40:55 ℹ +-- 7: NULL SELECT `db` , LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN 2026-07-05 15:40:55 ℹ +-- 8: NULL SELECT LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_errors_or_warnings` WHERE ( `db` IS NULL OR `db` 2026-07-05 15:40:55 ℹ +-- 9: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:40:54 ℹ +-- 10: NULL SELECT `event_name` , `total_read` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_read` DESC LIMIT ? 2026-07-05 15:40:51 ℹ +-- 11: NULL SELECT `event_name` , `total_written` FROM `sys` . `x$io_global_by_wait_by_bytes` ORDER BY `total_written` DESC LIMIT ? 2026-07-05 15:40:51 ℹ +-- 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:40:50 ℹ +-- 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:40:50 ℹ +-- 14: NULL SELECT FILE , `total_latency` FROM `sys` . `x$io_global_by_file_by_latency` ORDER BY `total_latency` DESC LIMIT ? 2026-07-05 15:40:50 ℹ +-- 15: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` , ? , `index_name` , ? ) FROM `sys` . `schema_unused_indexes` WHER 2026-07-05 15:40:49 ℹ +-- 16: NULL SELECT LEFT ( QUERY , ? ) , `avg_latency` FROM `sys` . `x$statement_analysis` WHERE ( `db` IS NULL OR `db` NOT IN (...) 2026-07-05 15:40:48 ℹ +-- 17: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:40:48 ℹ +-- 18: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:40:47 ℹ +-- 19: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:40:47 ℹ +-- 20: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:40:47 ℹ +-- 21: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:40:47 ℹ +-- 22: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:40:46 ℹ +-- 23: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 24: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 25: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 26: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:40:45 ℹ +-- 27: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 28: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 29: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 30: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 31: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 32: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 33: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 34: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:40:43 ℹ +-- 35: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 36: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 37: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 38: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 39: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 40: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 41: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:40:42 ℹ +-- 42: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:40:40 ℹ +-- 43: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2026-07-05 15:40:37 ℹ +-- 44: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 2026-07-05 15:40:37 ℹ +-- 45: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2026-07-05 15:40:36 ℹ +-- 46: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 2026-07-05 15:40:32 ℹ +-- 47: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 2026-07-05 15:40:32 ℹ +-- 48: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 2026-07-05 15:40:30 ℹ +-- 49: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2026-07-05 15:40:20 ℹ +-- 50: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2026-07-05 15:40:19 ℹ Performance schema: Last 50 queries with sort execution time: 0.184s -------- Performance schema: Top 15 row sorting queries with sort ---------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 12687 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 12687 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 12687 ℹ +-- 4: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 12365 ℹ +-- 5: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 12345 ℹ +-- 6: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 692 ℹ +-- 7: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 198 ℹ +-- 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 88 ℹ +-- 11: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 60 ℹ +-- 12: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 56 ℹ +-- 13: NULL SELECT `db` , LEFT ( QUERY , ? ) , `last_seen` FROM `sys` . `x$statements_with_temp_tables` WHERE ( `db` IS NULL OR `db` 50 ℹ +-- 14: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 48 ℹ +-- 15: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 40 ℹ Performance schema: Top 15 row sorting queries with sort execution time: 0.199s -------- 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 36083194000 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 32963226000 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 32461630000 ℹ +-- 4: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 30832292000 ℹ +-- 5: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 30574204000 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 27183780000 ℹ +-- 7: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 22471040000 ℹ +-- 8: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 17806638000 ℹ +-- 9: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 13105558000 ℹ +-- 10: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 9187457000 ℹ +-- 11: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 8740224000 ℹ +-- 12: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 7898996000 ℹ +-- 13: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 6088003000 ℹ +-- 14: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 5627855000 ℹ +-- 15: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 4975329000 ℹ Performance schema: Top 15 total latency queries with sort execution time: 0.198s -------- Performance schema: Top 15 merge queries with sort ---------------------------------------- ℹ +-- 1: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 2: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 3: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 4: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 5: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 8: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ +-- 9: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 0 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 0 ℹ +-- 11: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 0 ℹ +-- 12: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 0 ℹ +-- 13: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 0 ℹ +-- 14: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 0 ℹ +-- 15: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 0 ℹ Performance schema: Top 15 merge queries with sort execution time: 0.212s -------- Performance schema: Top 15 average sort merges queries with sort -------------------------- ℹ +-- 1: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 2: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 3: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 4: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 5: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 8: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ +-- 9: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 0 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 0 ℹ +-- 11: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 0 ℹ +-- 12: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 0 ℹ +-- 13: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 0 ℹ +-- 14: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 0 ℹ +-- 15: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 0 ℹ Performance schema: Top 15 average sort merges queries with sort execution time: 0.203s -------- 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 , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 12 ℹ +-- 4: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 12 ℹ +-- 5: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 12 ℹ +-- 6: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 12 ℹ +-- 7: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 12 ℹ +-- 8: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 10 ℹ +-- 9: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 10 ℹ +-- 10: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 10 ℹ +-- 11: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` 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 10 ℹ +-- 15: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 10 ℹ Performance schema: Top 15 scans queries with sort execution time: 0.173s -------- Performance schema: Top 15 range queries with sort ---------------------------------------- ℹ +-- 1: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 0 ℹ +-- 2: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 0 ℹ +-- 3: NULL SELECT TABLE_NAME , ENGINE FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY T 0 ℹ +-- 4: NULL SELECT `index_name` AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS `cols` , `INDEX_TYPE` AS TYPE 0 ℹ +-- 5: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 0 ℹ +-- 6: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 0 ℹ +-- 7: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 0 ℹ +-- 8: NULL SELECT `CONCAT` ( `object_schema` , ? , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `table_io_waits_ 0 ℹ +-- 9: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 0 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 0 ℹ +-- 11: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 0 ℹ +-- 12: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 0 ℹ +-- 13: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 0 ℹ +-- 14: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 0 ℹ +-- 15: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 0 ℹ Performance schema: Top 15 range queries with sort execution time: 0.187s -------- 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 COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 6 ℹ +-- 4: NULL SHOW SCHEMAS 5 ℹ +-- 5: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 4 ℹ +-- 6: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 7: NULL SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND ENGINE IS NOT NULL 4 ℹ +-- 8: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 4 ℹ +-- 9: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME FROM `information_schema` . `tables` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` NOT IN 4 ℹ +-- 10: NULL SHOW VARIABLES 2 ℹ +-- 11: NULL SHOW GLOBAL VARIABLES 2 ℹ +-- 12: NULL SHOW STATUS 2 ℹ +-- 13: NULL SHOW GLOBAL STATUS 2 ℹ +-- 14: NULL SHOW ENGINES 2 ℹ +-- 15: NULL SELECT COUNT ( * ) FROM `information_schema` . `INNODB_TRX` 2 ℹ +-- 16: NULL SELECT `IFNULL` ( MAX ( TIMESTAMPDIFF ( SQL_TSI_SECOND , `trx_started` , NOW ( ) ) ) , ? ) FROM `information_schema` . ` 2 ℹ +-- 17: NULL SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC 2 ℹ +-- 18: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 2 ℹ +-- 19: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 2 ℹ +-- 20: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 2 ℹ Performance schema: Top 20 queries with temp table execution time: 0.162s -------- Performance schema: Last 50 queries with temp table --------------------------------------- ℹ +-- 1: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 2026-07-05 15:40:55 ℹ +-- 2: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 2026-07-05 15:40:55 ℹ +-- 3: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 2026-07-05 15:40:55 ℹ +-- 4: NULL SELECT `CONCAT` ( `table_schema` , ? , TABLE_NAME , ? , `redundant_index_name` , ? , `dominant_index_name` , ? , `sql_dr 2026-07-05 15:40:54 ℹ +-- 5: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 2026-07-05 15:40:48 ℹ +-- 6: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 2026-07-05 15:40:47 ℹ +-- 7: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 2026-07-05 15:40:47 ℹ +-- 8: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 2026-07-05 15:40:47 ℹ +-- 9: NULL SELECT `wait_age_secs` , `locked_table` , `locked_type` , `waiting_query` FROM `sys` . `x$innodb_lock_waits` ORDER BY `w 2026-07-05 15:40:47 ℹ +-- 10: NULL SELECT SYSTEM_USER , `total_latency` , `max_latency` FROM `sys` . `x$io_by_thread_by_latency` ORDER BY `total_latency` D 2026-07-05 15:40:47 ℹ +-- 11: NULL SELECT HOST , `table_scans` FROM `sys` . `x$host_summary` ORDER BY `table_scans` DESC LIMIT ? 2026-07-05 15:40:46 ℹ +-- 12: NULL SELECT HOST , `rows_affected` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_affected` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 13: NULL SELECT HOST , `file_ios` FROM `sys` . `x$host_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 14: NULL SELECT HOST , `file_io_latency` FROM `sys` . `x$host_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:45 ℹ +-- 15: NULL SELECT SUBSTRING ( `event_name` , ? ) , `ROUND` ( SUM ( `total_latency` ) , ? ) AS `total_latency` FROM `sys` . `x$host_ 2026-07-05 15:40:45 ℹ +-- 16: NULL SELECT HOST , `statements` FROM `sys` . `x$host_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 17: NULL SELECT HOST , `statement_avg_latency` FROM `sys` . `x$host_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 18: NULL SELECT HOST , `lock_latency` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 19: NULL SELECT HOST , `full_scans` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 20: NULL SELECT HOST , `rows_sent` FROM `sys` . `x$host_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:44 ℹ +-- 21: NULL SELECT SYSTEM_USER , `full_scans` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `full_scans` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 22: NULL SELECT SYSTEM_USER , `rows_sent` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_sent` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 23: NULL SELECT SYSTEM_USER , `rows_affected` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `rows_affected` DESC LI 2026-07-05 15:40:43 ℹ +-- 24: NULL SELECT SYSTEM_USER , `file_ios` FROM `sys` . `x$user_summary` ORDER BY `file_ios` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 25: NULL SELECT SYSTEM_USER , `file_io_latency` FROM `sys` . `x$user_summary` ORDER BY `file_io_latency` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 26: NULL SELECT HOST , `total_connections` FROM `sys` . `x$host_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:43 ℹ +-- 27: NULL SELECT SYSTEM_USER , `total_connections` FROM `sys` . `user_summary` ORDER BY `total_connections` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 28: NULL SELECT SYSTEM_USER , `statements` FROM `sys` . `user_summary` ORDER BY `statements` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 29: NULL SELECT SYSTEM_USER , `statement_avg_latency` FROM `sys` . `x$user_summary` ORDER BY `statement_avg_latency` DESC LIMIT ? 2026-07-05 15:40:42 ℹ +-- 30: NULL SELECT SYSTEM_USER , `lock_latency` FROM `sys` . `x$user_summary_by_statement_latency` ORDER BY `lock_latency` DESC LIMI 2026-07-05 15:40:42 ℹ +-- 31: NULL SHOW SCHEMAS 2026-07-05 15:40:41 ℹ +-- 32: NULL SELECT COUNT ( * ) FROM `information_schema` . `tables` 2026-07-05 15:40:41 ℹ +-- 33: NULL SELECT `sys_version` FROM `sys` . `version` 2026-07-05 15:40:41 ℹ +-- 34: NULL SHOW SESSION STATUS LIKE ? 2026-07-05 15:40:40 ℹ +-- 35: NULL SELECT `PLUGIN_NAME` , `PLUGIN_VERSION` , `PLUGIN_STATUS` , `PLUGIN_TYPE` FROM `information_schema` . `PLUGINS` WHERE `P 2026-07-05 15:40:40 ℹ +-- 36: NULL SELECT COUNT ( * ) FROM `information_schema` . `columns` WHERE TABLE_NAME = ? AND `TABLE_SCHEMA` = ? AND COLUMN_NAME = ? 2026-07-05 15:40:38 ℹ +-- 37: NULL SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ? 2026-07-05 15:40:38 ℹ +-- 38: NULL SELECT COUNT ( * ) FROM `information_schema` . `TABLES` WHERE `TABLE_TYPE` = ? AND `TABLE_SCHEMA` = ? 2026-07-05 15:40:37 ℹ +-- 39: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 2026-07-05 15:40:37 ℹ +-- 40: NULL SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? 2026-07-05 15:40:37 ℹ +-- 41: NULL SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...) 2026-07-05 15:40:36 ℹ +-- 42: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , `INDEX_NAME` FROM `information_schema` . `statistics` WHERE IGNORED = ? AND `TABLE_ 2026-07-05 15:40:36 ℹ +-- 43: NULL SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN 2026-07-05 15:40:36 ℹ +-- 44: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME FROM `information_schema` . `columns` WHERE `IS_NULLABLE` = ? AND `TABL 2026-07-05 15:40:36 ℹ +-- 45: NULL SELECT `TABLE_SCHEMA` , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? ELSE ? END ) , SUM ( CASE WHEN `TABLE_TYPE` = ? THEN ? E 2026-07-05 15:40:36 ℹ +-- 46: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 2026-07-05 15:40:36 ℹ +-- 47: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , COLUMN_NAME , `DATA_TYPE` FROM `information_schema` . `columns` WHERE `TABLE_SCHEMA 2026-07-05 15:40:35 ℹ +-- 48: NULL SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO 2026-07-05 15:40:35 ℹ +-- 49: NULL SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . ` 2026-07-05 15:40:35 ℹ +-- 50: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 2026-07-05 15:40:35 ℹ Performance schema: Last 50 queries with temp table execution time: 0.184s -------- Performance schema: Top 15 total latency queries with temp table -------------------------- ℹ +-- 1: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 74909203000 ℹ +-- 2: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 72250691000 ℹ +-- 3: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 69499370000 ℹ +-- 4: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 36083194000 ℹ +-- 5: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 34495693000 ℹ +-- 6: NULL SELECT `table_schema` , TABLE_NAME FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `innodb_buffer_allocated` 32963226000 ℹ +-- 7: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_allocated` FROM `sys` . `x$schema_table_statistics_with_buffer` WHER 32461630000 ℹ +-- 8: NULL SELECT `table_schema` , TABLE_NAME , `innodb_buffer_free` FROM `sys` . `x$schema_table_statistics_with_buffer` WHERE `in 30832292000 ℹ +-- 9: NULL SELECT `object_schema` , `object_name` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_table` WHER 30574204000 ℹ +-- 10: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 27183780000 ℹ +-- 11: NULL SELECT SYSTEM_USER , `Command` AS `PROC` , TIME FROM `sys` . `x$processlist` ORDER BY TIME DESC 22471040000 ℹ +-- 12: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 18693482000 ℹ +-- 13: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 17806638000 ℹ +-- 14: NULL SELECT LEFT ( QUERY , ? ) , `exec_count` FROM `sys` . `x$statements_with_runtimes_in_95th_percentile` WHERE ( `db` IS NU 13105558000 ℹ +-- 15: NULL SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i 11374043000 ℹ Performance schema: Top 15 total latency queries with temp table execution time: 0.176s -------- Performance schema: Top 15 queries with temp table to disk -------------------------------- ℹ +-- 1: NULL SELECT `k` . `CONSTRAINT_SCHEMA` , `k` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `c1` . `COLUMN_TYPE` , `k` . `REFERENCED_T 106 ℹ +-- 2: NULL SELECT `CONCAT` ( `k` . `TABLE_SCHEMA` , ? , `k` . `TABLE_NAME` , ? , `k` . `COLUMN_NAME` , ? , `c1` . `COLUMN_TYPE` , ? 80 ℹ +-- 3: NULL SELECT `t` . `TABLE_SCHEMA` , `t` . `TABLE_NAME` , `t` . `TABLE_ROWS` , `t` . `AUTO_INCREMENT` , `c` . `DATA_TYPE` , `c` 40 ℹ +-- 4: NULL SELECT `CONCAT` ( `t` . `TABLE_SCHEMA` , ? , `t` . `TABLE_NAME` ) AS ? , `CONCAT` ( `s` . `INDEX_NAME` , ? , `s` . `COLU 38 ℹ +-- 5: NULL SELECT `CONCAT` ( `c` . `table_schema` , ? , `c` . `table_name` ) FROM `information_schema` . `columns` `c` JOIN `inform 28 ℹ +-- 6: NULL SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` , `c` . `DATA_TYPE` , `c` . `COLUMN_TYPE` FROM `i 28 ℹ +-- 7: NULL SELECT `c` . `TABLE_SCHEMA` , `c` . `TABLE_NAME` , `c` . `COLUMN_NAME` FROM `information_schema` . `columns` `c` LEFT JO 28 ℹ +-- 8: NULL SELECT `rc` . `CONSTRAINT_SCHEMA` , `rc` . `TABLE_NAME` , `k` . `COLUMN_NAME` , `rc` . `REFERENCED_TABLE_NAME` , `k` . ` 26 ℹ +-- 9: NULL SELECT CONSTRAINT_SCHEMA , TABLE_NAME , CONSTRAINT_NAME FROM `information_schema` . `table_constraints` WHERE `CONSTRAIN 26 ℹ +-- 10: NULL SELECT `concat` ( TABLE_NAME , ? , `index_name` ) AS `idxname` , GROUP_CONCAT ( COLUMN_NAME ORDER BY `seq_in_index` ) AS 26 ℹ +-- 11: NULL SELECT `IFNULL` ( SUM ( `INDEX_LENGTH` ) , ? ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (?) AND 24 ℹ +-- 12: NULL SELECT ENGINE , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) , COUNT ( ENGINE ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` 12 ℹ +-- 13: NULL SELECT `TABLE_SCHEMA` , TABLE_NAME , ENGINE , CAST ( `DATA_FREE` AS SIGNED ) FROM `information_schema` . `TABLES` WHERE 12 ℹ +-- 14: NULL SELECT COLUMN_NAME , `COLUMN_TYPE` , `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TA 12 ℹ +-- 15: NULL SELECT `object_schema` , `allocated` , DATA , `pages` FROM `sys` . `x$innodb_buffer_stats_by_schema` WHERE ( `object_sch 6 ℹ Performance schema: Top 15 queries with temp table to disk execution time: 0.187s -------- Performance schema: Top 15 class events by number ----------------------------------------- ℹ +-- 1: wait/io/table 3919015 ℹ +-- 2: wait/io/file 31703 ℹ +-- 3: wait/lock/table 171 ℹ Performance schema: Top 15 class events by number execution time: 0.190s -------- Performance schema: Top 30 events by number ----------------------------------------------- ℹ +-- 1: wait/io/file/aria/MAI 16731 ℹ +-- 2: wait/io/file/innodb/innodb_data_file 10804 ℹ +-- 3: wait/io/file/aria/MAD 2881 ℹ +-- 4: wait/io/file/sql/FRM 933 ℹ +-- 5: wait/io/file/sql/file_parser 128 ℹ +-- 6: wait/io/file/sql/global_ddl_log 112 ℹ +-- 7: wait/io/file/sql/misc 25 ℹ +-- 8: wait/io/file/sql/dbopt 21 ℹ +-- 9: wait/io/file/myisam/dfile 18 ℹ +-- 10: wait/io/file/aria/translog 9 ℹ +-- 11: wait/io/file/csv/metadata 8 ℹ +-- 12: wait/io/file/myisam/kfile 6 ℹ +-- 13: wait/io/file/partition/ha_partition::parfile 6 ℹ +-- 14: wait/io/file/sql/casetest 5 ℹ +-- 15: wait/io/file/csv/data 4 ℹ +-- 16: wait/io/file/sql/pid 3 ℹ +-- 17: wait/io/file/sql/tclog 3 ℹ +-- 18: wait/io/file/mysys/charset 3 ℹ +-- 19: wait/io/file/aria/control 3 ℹ Performance schema: Top 30 events by number execution time: 0.201s -------- Performance schema: Top 15 class events by total latency ---------------------------------- ℹ +-- 1: wait/io/table 10773937060033 ℹ +-- 2: wait/io/file 4254162967376 ℹ +-- 3: wait/lock/table 404696460 ℹ Performance schema: Top 15 class events by total latency execution time: 0.209s -------- Performance schema: Top 30 events by total latency ---------------------------------------- ℹ +-- 1: wait/io/file/innodb/innodb_data_file 3988481746011 ℹ +-- 2: wait/io/file/aria/MAI 85202205312 ℹ +-- 3: wait/io/file/sql/global_ddl_log 83462353947 ℹ +-- 4: wait/io/file/aria/MAD 46588833214 ℹ +-- 5: wait/io/file/sql/FRM 24086845146 ℹ +-- 6: wait/io/file/csv/metadata 15542308320 ℹ +-- 7: wait/io/file/sql/file_parser 6388306323 ℹ +-- 8: wait/io/file/mysys/charset 3310927683 ℹ +-- 9: wait/io/file/sql/misc 302557360 ℹ +-- 10: wait/io/file/sql/dbopt 129722740 ℹ +-- 11: wait/io/file/sql/casetest 107768640 ℹ +-- 12: wait/io/file/sql/pid 104273680 ℹ +-- 13: wait/io/file/sql/tclog 93578660 ℹ +-- 14: wait/io/file/aria/translog 82629260 ℹ +-- 15: wait/io/file/aria/control 76513080 ℹ +-- 16: wait/io/file/myisam/dfile 74135180 ℹ +-- 17: wait/io/file/partition/ha_partition::parfile 51539600 ℹ +-- 18: wait/io/file/csv/data 47148780 ℹ +-- 19: wait/io/file/myisam/kfile 29574440 ℹ Performance schema: Top 30 events by total latency execution time: 0.218s -------- Performance schema: Top 15 class events by max latency ------------------------------------ ℹ +-- 1: wait/io/file 124827012751 ℹ +-- 2: wait/io/table 110776402023 ℹ +-- 3: wait/lock/table 4977000 ℹ Performance schema: Top 15 class events by max latency execution time: 0.216s -------- Performance schema: Top 30 events by max latency ------------------------------------------ ℹ +-- 1: wait/io/file/innodb/innodb_data_file 124827012751 ℹ +-- 2: wait/io/file/csv/metadata 14999527760 ℹ +-- 3: wait/io/file/sql/global_ddl_log 10150138040 ℹ +-- 4: wait/io/file/sql/FRM 4029539017 ℹ +-- 5: wait/io/file/mysys/charset 3283996583 ℹ +-- 6: wait/io/file/sql/file_parser 3200161783 ℹ +-- 7: wait/io/file/aria/MAD 2483384197 ℹ +-- 8: wait/io/file/aria/MAI 348246220 ℹ +-- 9: wait/io/file/sql/misc 108299520 ℹ +-- 10: wait/io/file/sql/pid 76756400 ℹ +-- 11: wait/io/file/sql/casetest 71757280 ℹ +-- 12: wait/io/file/aria/control 64568280 ℹ +-- 13: wait/io/file/sql/dbopt 51119320 ℹ +-- 14: wait/io/file/sql/tclog 49637280 ℹ +-- 15: wait/io/file/aria/translog 35148680 ℹ +-- 16: wait/io/file/csv/data 26112660 ℹ +-- 17: wait/io/file/partition/ha_partition::parfile 14300580 ℹ +-- 18: wait/io/file/myisam/dfile 6735540 ℹ +-- 19: wait/io/file/myisam/kfile 6702360 ℹ Performance schema: Top 30 events by max latency execution time: 0.208s -------- MyISAM Metrics ---------------------------------------------------------------------------- ℹ General MyIsam metrics: ℹ +-- Total MyISAM Tables : 0 ℹ +-- Total MyISAM indexes : 0B ℹ +-- KB Size :128.0M ℹ +-- KB Used Size :23.3M ℹ +-- KB used :18.2% ℹ +-- Read KB hit rate: 0% (0 cached / 0 reads) ℹ +-- Write KB hit rate: 0% (0 cached / 0 writes) ℹ No MyISAM table(s) detected .... ℹ MyISAM Metrics execution time: 0.203s -------- InnoDB Metrics ---------------------------------------------------------------------------- ℹ InnoDB is enabled. ✘ InnoDB variable 'innodb_prefix_index_cluster_optimization' is removed in MariaDB 10.10.0. ℹ InnoDB Metrics execution time: 0.000s -------- Smart Migration LTS Advisor --------------------------------------------------------------- ✘ Found 1 potential migration risks. ℹ - [Migration Risk] sql_mode: NO_AUTO_CREATE_USER is removed in modern versions. Ensure your scripts do not rely on it. ℹ InnoDB Buffers ℹ +-- InnoDB Buffer Pool: 128.0M ℹ +-- InnoDB Buffer Pool Instances: 1 ℹ +-- InnoDB Buffer Pool Chunk Size: 0B ℹ +-- InnoDB Log File Size: 96.0M ℹ +-- InnoDB Log File In Group: 1 ℹ +-- InnoDB Total Log File Size: 96.0M(75 % of buffer pool) ℹ +-- InnoDB Log Buffer: 16.0M ℹ +-- InnoDB Buffer Free: 1.5K ℹ +-- InnoDB Buffer Used: 7.9K ✔ InnoDB File per table is activated ✔ InnoDB Buffer Pool size ( 128.0M ) under limit for 64 bits architecture: (17179869184.0G ) ✘ InnoDB buffer pool / data size: 128.0M / 146.8M ℹ innodb_buffer_pool_chunk_size is set to 'autosize' (0) in MariaDB >= 10.8. Skipping chunk size checks. ✔ InnoDB Read buffer efficiency: 100.00% (22700261 hits / 22700547 total) ✔ InnoDB Write Log efficiency: 100.00% (8178899 hits / 8179148 total) ✔ InnoDB log waits: 0.00% (0 waits / 249 writes) ℹ Smart Migration LTS Advisor execution time: 0.000s -------- InnoDB Transactions ----------------------------------------------------------------------- ℹ Transaction Isolation Level: REPEATABLE-READ ℹ InnoDB Snapshot Isolation: OFF ✘ innodb_snapshot_isolation is OFF with REPEATABLE-READ (Stricter snapshot isolation is disabled) ℹ Active InnoDB Transactions: 0 ℹ InnoDB Transactions execution time: 0.000s -------- 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.215s -------- Query Cache Information ------------------------------------------------------------------- ℹ QUERY_CACHE_INFO plugin is not active or not installed. ℹ Query Cache Information execution time: 0.193s -------- Query Anti-Pattern Detection (Experimental) ----------------------------------------------- ℹ Skipped: Performance Schema is disabled. ℹ Query Anti-Pattern Detection (Experimental) execution time: 0.182s -------- Aria Metrics ------------------------------------------------------------------------------ ℹ Aria Storage Engine is enabled. ✔ Aria pagecache size / total Aria indexes: 128.0M/936.0K ✔ Aria pagecache hit rate: 100.0% (89K cached / 20 reads) ℹ Aria Metrics execution time: 0.000s -------- TokuDB Metrics ---------------------------------------------------------------------------- ℹ TokuDB is disabled. ℹ TokuDB Metrics execution time: 0.000s -------- XtraDB Metrics ---------------------------------------------------------------------------- ℹ XtraDB is disabled. ℹ XtraDB Metrics execution time: 0.000s -------- Galera Metrics ---------------------------------------------------------------------------- ℹ Galera is disabled. ℹ Galera Metrics execution time: 0.000s -------- Replication Metrics ----------------------------------------------------------------------- ℹ Galera Synchronous replication: NO ℹ No replication replica(s) for this server. ℹ Binlog format: MIXED ℹ XA support enabled: ON ℹ Semi synchronous replication Source: OFF ℹ Semi synchronous replication Replica: OFF ℹ This is a standalone server ℹ Replication Metrics execution time: 0.000s -------- Predictive Capacity Planning -------------------------------------------------------------- ✔ Memory headroom: 15.9G (Theoretical max usage is 22.13% of physical RAM) ℹ Growth forecasting: Insufficient uptime (< 24h) for reliable estimation. ℹ Predictive Capacity Planning execution time: 0.000s -------- Cluster & Replication Intelligence -------------------------------------------------------- ℹ Replication status: Not running as a replica. ✘ binlog_format is MIXED (recommended: ROW) ✘ source_verify_checksum is disabled (recommended: ON) ℹ Cluster & Replication Intelligence execution time: 0.000s -------- Security Hardening 2.0 -------------------------------------------------------------------- ℹ TLS/SSL is enabled. Minimum supported TLS version: TLSv1.2,TLSv1.3 ℹ Security Hardening 2.0 execution time: 0.000s -------- Guided Auto-Fix Snippets ------------------------------------------------------------------ Ready-to-Apply SQL Snippets (SET GLOBAL): SET GLOBAL innodb_snapshot_isolation = ON; Ready-to-Apply Configuration Block ([mysqld]): join_buffer_size (> 256.0K, or always use indexes with JOINs) innodb_buffer_pool_size (>= 146.8M) if possible. innodb_snapshot_isolation=ON ℹ Guided Auto-Fix Snippets execution time: 0.160s -------- Health Score KPI -------------------------------------------------------------------------- Overall Weighted Health Score: 60/100 - Performance: 35/40 - Security: 0/30 - Resilience: 25/30 ✘ Your database health is below optimal levels. Refer to the specific findings below. ℹ Health Score KPI execution time: 0.000s -------- Recommendations --------------------------------------------------------------------------- General recommendations: 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; Migrate to 'ed25519', 'parsec' or 'unix_socket' for 6 user(s) Enable require_secure_transport to force all connections to use SSL. 8 CVE(s) found for your MySQL release. Consider upgrading your version ! MySQL was started within the last 24 hours: recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries 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 Unused indexes found: 3 index(es) should be reviewed and potentially removed. Remove 'innodb_prefix_index_cluster_optimization' from your configuration. Always enabled. Migration Risk (sql_mode): NO_AUTO_CREATE_USER is removed in modern versions. Ensure your scripts do not rely on it. Set binlog_format = ROW for robust GTID and replication consistency. Enable source_verify_checksum = ON (or master_verify_checksum). Variables to adjust: join_buffer_size (> 256.0K, or always use indexes with JOINs) innodb_buffer_pool_size (>= 146.8M) if possible. innodb_snapshot_isolation=ON ✔ HTML Report successfully generated: /home/jmren/GIT_REPOS/MySQLTuner-perl/examples/20260705_173929_mariadb114/Container/mysqltuner_report.html ℹ Recommendations execution time: 0.005s -------- Execution Times --------------------------------------------------------------------------- ℹ Started at : 2026-07-05 17:40:14 ℹ Ended at : 2026-07-05 17:41:01 ℹ System Linux Recommendations : 4.556s (9.7%) ℹ Database Metrics : 3.684s (7.8%) ℹ Table Column Metrics : 2.799s (5.9%) ℹ Security Recommendations : 2.251s (4.8%) ℹ Table structures analysis : 1.594s (3.4%) ℹ Storage Engine Statistics : 1.189s (2.5%) ℹ Audit Snapshot Summary : 1.163s (2.5%) ℹ Indexes Metrics : 1.001s (2.1%) ℹ Performance Metrics : 0.829s (1.8%) ℹ Naming conventions analysis : 0.794s (1.7%) ℹ Filesystem Linux Recommendations : 0.751s (1.6%) ℹ Foreign Key analysis : 0.623s (1.3%) ℹ Performance schema : 0.598s (1.3%) ℹ MariaDB 10.x+ Specific Modeling : 0.566s (1.2%) ℹ SSL/TLS Security Recommendations : 0.372s (0.8%) ℹ Performance schema: File by IO written bytes : 0.236s (0.5%) ℹ Performance schema: Top 15 nb statement type : 0.223s (0.5%) ℹ Performance schema: Top 15 high read latency tables: 0.220s (0.5%) ℹ Performance schema: Top 30 events by total latency: 0.218s (0.5%) ℹ Performance schema: Top 5 user per connection : 0.218s (0.5%) ℹ Performance schema: Top 15 class events by max latency: 0.216s (0.5%) ℹ InnoDB Index/Data Ratio Check : 0.215s (0.5%) ℹ Performance schema: Top 15 high delete latency tables: 0.214s (0.5%) ℹ Performance schema: Top 15 Tables using InnoDB buffer: 0.214s (0.5%) ℹ Performance schema: Top 5 host per statement latency: 0.214s (0.5%) ℹ Performance schema: Top 5 user per nb full scans : 0.214s (0.5%) ℹ Performance schema: Top Stages order by avg latency: 0.213s (0.5%) ℹ Performance schema: Top 15 Tables with InnoDB buffer free: 0.213s (0.5%) ℹ Performance schema: Top IO type order by total io : 0.212s (0.5%) ℹ Performance schema: Top 15 merge queries with sort: 0.212s (0.4%) ℹ Performance schema: Redundant indexes : 0.211s (0.4%) ℹ Performance schema: Top 5 user per statement : 0.210s (0.4%) ℹ Performance schema: Top 15 class events by total latency: 0.209s (0.4%) ℹ Performance schema: File per IO total latency : 0.208s (0.4%) ℹ Performance schema: Top 30 events by max latency : 0.208s (0.4%) ℹ Performance schema: Table not using InnoDB buffer : 0.207s (0.4%) ℹ Performance schema: InnoDB Buffer Pool by schema : 0.207s (0.4%) ℹ Performance schema: Top 15 most read tables : 0.207s (0.4%) ℹ Performance schema: Top 15 statement by total latency: 0.206s (0.4%) ℹ Performance schema: Top 15 high insert latency tables: 0.205s (0.4%) ℹ Performance schema: Top 5 user per rows sent : 0.205s (0.4%) ℹ Performance schema: Top Stages order by total latency: 0.204s (0.4%) ℹ Performance schema: event per wait total latency : 0.204s (0.4%) ℹ Performance schema: Top 15 most modified tables : 0.204s (0.4%) ℹ Performance schema: Top 15 average sort merges queries with sort: 0.203s (0.4%) ℹ Performance schema: Top 15 statement by full scans: 0.203s (0.4%) ℹ MyISAM Metrics : 0.203s (0.4%) ℹ Performance schema: Top 15 statement by rows sent : 0.203s (0.4%) ℹ Performance schema: File by IO read bytes : 0.203s (0.4%) ℹ Performance schema: Top 5 host per rows modified : 0.203s (0.4%) ℹ Performance schema: Top 15 Most latency statements: 0.202s (0.4%) ℹ Performance schema: Event Wait written bytes : 0.202s (0.4%) ℹ Data Type optimization : 0.202s (0.4%) ℹ Performance schema: Top IO type order by total latency: 0.201s (0.4%) ℹ Performance schema: Top 5 host per statement : 0.201s (0.4%) ℹ Performance schema: 40 InnoDB Buffer Pool by table: 0.201s (0.4%) ℹ Performance schema: Event Wait by read bytes : 0.201s (0.4%) ℹ Performance schema: Top 30 events by number : 0.201s (0.4%) ℹ Performance schema: Top 20 queries with sort : 0.200s (0.4%) ℹ Performance schema: Top IO type order by max latency: 0.200s (0.4%) ℹ Performance schema: Top Stages order by total io : 0.200s (0.4%) ℹ Performance schema: Top 15 slower queries : 0.200s (0.4%) ℹ Performance schema: Top 15 high read latency index: 0.199s (0.4%) ℹ Performance schema: Top 15 row sorting queries with sort: 0.199s (0.4%) ℹ Performance schema: Top 15 total latency queries with sort: 0.198s (0.4%) ℹ Performance schema: event per wait read latency : 0.198s (0.4%) ℹ Performance schema: Unused indexes : 0.198s (0.4%) ℹ Performance schema: Top 5 user per lock latency : 0.197s (0.4%) ℹ Performance schema: Top 15 total latency queries (95% percentile): 0.196s (0.4%) ℹ Performance schema: Top 15 reader queries (95% percentile): 0.196s (0.4%) ℹ Performance schema: Top 15 high update latency tables: 0.195s (0.4%) ℹ Performance schema: 15 sample queries using temp table: 0.194s (0.4%) ℹ Performance schema: Top 5 host per io : 0.194s (0.4%) ℹ Performance schema: Thread IO Latency : 0.194s (0.4%) ℹ Performance schema: Top 15 high update latency index: 0.193s (0.4%) ℹ Query Cache Information : 0.193s (0.4%) ℹ Performance schema: Top 5 host per rows sent : 0.192s (0.4%) ℹ Performance schema: Top 15 high delete latency index: 0.191s (0.4%) ℹ Performance schema: Top 15 statement by rows modified: 0.191s (0.4%) ℹ Performance schema: event per wait write latency : 0.190s (0.4%) ℹ Performance schema: Tables with full table scans : 0.190s (0.4%) ℹ Performance schema: Top 15 class events by number : 0.190s (0.4%) ℹ Performance schema: Top 15 Most executed queries : 0.189s (0.4%) ℹ Performance schema: InnoDB Lock Waits : 0.189s (0.4%) ℹ Performance schema: Top 15 average latency queries (95% percentile): 0.189s (0.4%) ℹ Performance schema: Last 50 queries with full table scans: 0.189s (0.4%) ℹ Performance schema: Top 5 user per statement latency: 0.188s (0.4%) ℹ Performance schema: Top 15 most row look queries (95% percentile): 0.188s (0.4%) ℹ Performance schema: Top 15 max latency queries (95% percentile): 0.187s (0.4%) ℹ Performance schema: Top 20 queries with full table scans: 0.187s (0.4%) ℹ Performance schema: Process per time : 0.187s (0.4%) ℹ Performance schema: Top 5 host per table scans : 0.187s (0.4%) ℹ Performance schema: Top 15 queries with temp table to disk: 0.187s (0.4%) ℹ Performance schema: Top 15 range queries with sort: 0.187s (0.4%) ℹ Performance schema: Top 15 most modified indexes : 0.186s (0.4%) ℹ Performance schema: Top 5 host per io latency : 0.186s (0.4%) ℹ Performance schema: Top 5 user per IO latency : 0.186s (0.4%) ℹ Performance schema: Latest File IO by latency : 0.185s (0.4%) ℹ Performance schema: Top 5 host per nb full scans : 0.184s (0.4%) ℹ Performance schema: Top 5 user per IO : 0.184s (0.4%) ℹ Performance schema: Top 5 user per rows modified : 0.184s (0.4%) ℹ Performance schema: Last 50 queries with sort : 0.184s (0.4%) ℹ Performance schema: Last 50 queries with temp table: 0.184s (0.4%) ℹ Performance schema: file per IO read latency : 0.183s (0.4%) ℹ Performance schema: Top 5 host per connection : 0.183s (0.4%) ℹ Performance schema: file per IO write latency : 0.182s (0.4%) ℹ Query Anti-Pattern Detection (Experimental) : 0.182s (0.4%) ℹ Performance schema: Top 15 most read indexes : 0.180s (0.4%) ℹ Schema sanitization : 0.180s (0.4%) ℹ Authentication Plugin Security : 0.180s (0.4%) ℹ Performance schema: Top 5 host per lock latency : 0.177s (0.4%) ℹ Plugin Information : 0.176s (0.4%) ℹ Performance schema: Latest SQL queries in errors or warnings: 0.176s (0.4%) ℹ Performance schema: Top 15 total latency queries with temp table: 0.176s (0.4%) ℹ Performance schema: Top 15 statement by lock latency: 0.176s (0.4%) ℹ Performance schema: Top 15 most modified indexes : 0.176s (0.4%) ℹ Performance schema: Top 15 scans queries with sort: 0.173s (0.4%) ℹ Performance schema: Top 20 queries with temp table: 0.162s (0.3%) ℹ Guided Auto-Fix Snippets : 0.160s (0.3%) ℹ Log file Recommendations : 0.100s (0.2%) ℹ Recommendations : 0.005s (0.0%) ℹ CVE Security Recommendations : 0.002s (0.0%) ℹ Smart Migration LTS Advisor : 0.000s (0.0%) ℹ InnoDB Metrics : 0.000s (0.0%) ℹ Analysis Performance Metrics : 0.000s (0.0%) ℹ Aria Metrics : 0.000s (0.0%) ℹ Views Metrics : 0.000s (0.0%) ℹ Health Score KPI : 0.000s (0.0%) ℹ Cluster & Replication Intelligence : 0.000s (0.0%) ℹ Replication Metrics : 0.000s (0.0%) ℹ Predictive Capacity Planning : 0.000s (0.0%) ℹ Triggers Metrics : 0.000s (0.0%) ℹ InnoDB Transactions : 0.000s (0.0%) ℹ Routines Metrics : 0.000s (0.0%) ℹ Galera Metrics : 0.000s (0.0%) ℹ XtraDB Metrics : 0.000s (0.0%) ℹ Security Hardening 2.0 : 0.000s (0.0%) ℹ TokuDB Metrics : 0.000s (0.0%) ℹ Total Execution Time : 47.116s (47.116s) ✔ Terminated successfully