-- Env # System Summary Report ###################################### Date | 2025-05-05 08:00:14 UTC (local TZ: CEST +0200) Hostname | bug118020 Uptime | 1:58, 2 users, load average: 0.07, 0.02, 0.00 Platform | Linux Release | Ubuntu 22.04.5 LTS (jammy) Kernel | 6.8.0-1021-oracle Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.35 SELinux | No SELinux detected Virtualized | No virtualization detected # Processor ################################################## Processors | physical = 1, cores = 8, virtual = 16, hyperthreading = yes Speeds | 16x2445.406 Models | 16xAMD EPYC 7J13 64-Core Processor Caches | 16x512 KB # Memory ##################################################### Total | 125.8G Free | 124.0G Used | physical = 696.1M, swap allocated = 0.0, swap used = 0.0, virtual = 696.1M Shared | 1.5M Buffers | 1.1G Caches | 124.1G Dirty | 760 kB UsedRSS | 932.4M Swappiness | 60 DirtyPolicy | 20, 10 DirtyStatus | 0, 0 -- [umshastr@bug118020:~]$ df -hT /bv/ushastry Filesystem Type Size Used Avail Use% Mounted on /dev/sdb1 ext4 492G 12K 467G 1% /bv/ushastry [umshastr@bug118020:~]$ cd /bv/ushastry/ [umshastr@bug118020:/bv/ushastry]$ ls -l total 0 [umshastr@bug118020:/bv/ushastry]$ cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=22.04 DISTRIB_CODENAME=jammy DISTRIB_DESCRIPTION="Ubuntu 22.04.5 LTS" PRETTY_NAME="Ubuntu 22.04.5 LTS" NAME="Ubuntu" VERSION_ID="22.04" VERSION="22.04.5 LTS (Jammy Jellyfish)" VERSION_CODENAME=jammy ID=ubuntu ID_LIKE=debian HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" UBUNTU_CODENAME=jammy [umshastr@bug118020:/bv/ushastry]$ sudo apt-get -y install apt-transport-https curl software-properties-common gnutls-dev libssl-dev ncurses-dev pkg-config bison Reading package lists... Done Building dependency tree... Done Reading state information... Done Note, selecting 'libgnutls28-dev' instead of 'gnutls-dev' Note, selecting 'libncurses-dev' instead of 'ncurses-dev' bison is already the newest version (2:3.8.2+dfsg-1build1). pkg-config is already the newest version (0.29.2-1ubuntu3). pkg-config set to manually installed. curl is already the newest version (7.81.0-1ubuntu1.20). curl set to manually installed. libncurses-dev is already the newest version (6.3-2ubuntu0.1). libssl-dev is already the newest version (3.0.2-0ubuntu1.19). software-properties-common is already the newest version (0.99.22.9). software-properties-common set to manually installed. The following packages were automatically installed and are no longer required: bc bcache-tools cloud-initramfs-copymods cloud-initramfs-dyn-netconf cryptsetup cryptsetup-initramfs dmeventd ethtool fonts-ubuntu-console kpartx landscape-common libdevmapper-event1.02.1 libestr0 libfastjson4 liblvm2cmd2.03 libmspack0 libsgutils2-2 liburcu8 libxmlsec1 libxmlsec1-openssl lvm2 lxd-agent-loader motd-news-config multipath-tools open-vm-tools overlayroot pollinate python3-apport python3-automat python3-click python3-colorama python3-constantly python3-hamcrest python3-hyperlink python3-incremental python3-pexpect python3-problem-report python3-ptyprocess python3-service-identity python3-systemd python3-twisted python3-zope.interface sg3-utils sg3-utils-udev sosreport thin-provisioning-tools zerofree Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: libgmp-dev libgmpxx4ldbl libgnutls-dane0 libgnutls-openssl27 libgnutlsxx28 libidn2-dev libp11-kit-dev libtasn1-6-dev libtasn1-doc libunbound8 nettle-dev Suggested packages: gmp-doc libgmp10-doc libmpfr-dev dns-root-data gnutls-bin gnutls-doc p11-kit-doc The following NEW packages will be installed: apt-transport-https libgmp-dev libgmpxx4ldbl libgnutls-dane0 libgnutls-openssl27 libgnutls28-dev libgnutlsxx28 libidn2-dev libp11-kit-dev libtasn1-6-dev libtasn1-doc libunbound8 nettle-dev 0 upgraded, 13 newly installed, 0 to remove and 102 not upgraded. Need to get 3492 kB of archives. After this operation, 12.0 MB of additional disk space will be used. Get:1 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/universe amd64 apt-transport-https all 2.4.13 [1510 B] Get:2 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy/main amd64 libgmpxx4ldbl amd64 2:6.2.1+dfsg-3ubuntu1 [9580 B] Get:3 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy/main amd64 libgmp-dev amd64 2:6.2.1+dfsg-3ubuntu1 [337 kB] Get:4 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libgnutls-openssl27 amd64 3.7.3-4ubuntu1.6 [22.8 kB] Get:5 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libunbound8 amd64 1.13.1-1ubuntu5.10 [400 kB] Get:6 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libgnutls-dane0 amd64 3.7.3-4ubuntu1.6 [22.6 kB] Get:7 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libgnutlsxx28 amd64 3.7.3-4ubuntu1.6 [16.3 kB] Get:8 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy/main amd64 libidn2-dev amd64 2.3.2-2build1 [86.7 kB] Get:9 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy/main amd64 libp11-kit-dev amd64 0.24.0-6build1 [20.2 kB] Get:10 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libtasn1-6-dev amd64 4.18.0-4ubuntu0.1 [91.8 kB] Get:11 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy/main amd64 nettle-dev amd64 3.7.3-1build2 [1135 kB] Get:12 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libgnutls28-dev amd64 3.7.3-4ubuntu1.6 [1043 kB] Get:13 http://pkgcacher.mysql.oraclecorp.com:4321/ubuntu/ubuntu jammy-updates/main amd64 libtasn1-doc all 4.18.0-4ubuntu0.1 [305 kB] Fetched 3492 kB in 1s (2838 kB/s) Selecting previously unselected package apt-transport-https. (Reading database ... 256840 files and directories currently installed.) Preparing to unpack .../00-apt-transport-https_2.4.13_all.deb ... Unpacking apt-transport-https (2.4.13) ... Selecting previously unselected package libgmpxx4ldbl:amd64. Preparing to unpack .../01-libgmpxx4ldbl_2%3a6.2.1+dfsg-3ubuntu1_amd64.deb ... Unpacking libgmpxx4ldbl:amd64 (2:6.2.1+dfsg-3ubuntu1) ... Selecting previously unselected package libgmp-dev:amd64. Preparing to unpack .../02-libgmp-dev_2%3a6.2.1+dfsg-3ubuntu1_amd64.deb ... Unpacking libgmp-dev:amd64 (2:6.2.1+dfsg-3ubuntu1) ... Selecting previously unselected package libgnutls-openssl27:amd64. Preparing to unpack .../03-libgnutls-openssl27_3.7.3-4ubuntu1.6_amd64.deb ... Unpacking libgnutls-openssl27:amd64 (3.7.3-4ubuntu1.6) ... Selecting previously unselected package libunbound8:amd64. Preparing to unpack .../04-libunbound8_1.13.1-1ubuntu5.10_amd64.deb ... Unpacking libunbound8:amd64 (1.13.1-1ubuntu5.10) ... Selecting previously unselected package libgnutls-dane0:amd64. Preparing to unpack .../05-libgnutls-dane0_3.7.3-4ubuntu1.6_amd64.deb ... Unpacking libgnutls-dane0:amd64 (3.7.3-4ubuntu1.6) ... Selecting previously unselected package libgnutlsxx28:amd64. Preparing to unpack .../06-libgnutlsxx28_3.7.3-4ubuntu1.6_amd64.deb ... Unpacking libgnutlsxx28:amd64 (3.7.3-4ubuntu1.6) ... Selecting previously unselected package libidn2-dev:amd64. Preparing to unpack .../07-libidn2-dev_2.3.2-2build1_amd64.deb ... Unpacking libidn2-dev:amd64 (2.3.2-2build1) ... Selecting previously unselected package libp11-kit-dev:amd64. Preparing to unpack .../08-libp11-kit-dev_0.24.0-6build1_amd64.deb ... Unpacking libp11-kit-dev:amd64 (0.24.0-6build1) ... Selecting previously unselected package libtasn1-6-dev:amd64. Preparing to unpack .../09-libtasn1-6-dev_4.18.0-4ubuntu0.1_amd64.deb ... Unpacking libtasn1-6-dev:amd64 (4.18.0-4ubuntu0.1) ... Selecting previously unselected package nettle-dev:amd64. Preparing to unpack .../10-nettle-dev_3.7.3-1build2_amd64.deb ... Unpacking nettle-dev:amd64 (3.7.3-1build2) ... Selecting previously unselected package libgnutls28-dev:amd64. Preparing to unpack .../11-libgnutls28-dev_3.7.3-4ubuntu1.6_amd64.deb ... Unpacking libgnutls28-dev:amd64 (3.7.3-4ubuntu1.6) ... Selecting previously unselected package libtasn1-doc. Preparing to unpack .../12-libtasn1-doc_4.18.0-4ubuntu0.1_all.deb ... Unpacking libtasn1-doc (4.18.0-4ubuntu0.1) ... Setting up libgnutls-openssl27:amd64 (3.7.3-4ubuntu1.6) ... Setting up apt-transport-https (2.4.13) ... Setting up libtasn1-doc (4.18.0-4ubuntu0.1) ... Setting up libunbound8:amd64 (1.13.1-1ubuntu5.10) ... Setting up libgmpxx4ldbl:amd64 (2:6.2.1+dfsg-3ubuntu1) ... Setting up libgnutlsxx28:amd64 (3.7.3-4ubuntu1.6) ... Setting up libidn2-dev:amd64 (2.3.2-2build1) ... Setting up libtasn1-6-dev:amd64 (4.18.0-4ubuntu0.1) ... Setting up libp11-kit-dev:amd64 (0.24.0-6build1) ... Setting up libgnutls-dane0:amd64 (3.7.3-4ubuntu1.6) ... Setting up libgmp-dev:amd64 (2:6.2.1+dfsg-3ubuntu1) ... Setting up nettle-dev:amd64 (3.7.3-1build2) ... Setting up libgnutls28-dev:amd64 (3.7.3-4ubuntu1.6) ... Processing triggers for man-db (2.10.2-1) ... Processing triggers for install-info (6.8-4build1) ... Processing triggers for libc-bin (2.35-0ubuntu3.9) ... Scanning processes... Scanning linux images... Running kernel seems to be up-to-date. No services need to be restarted. No containers need to be restarted. No user sessions are running outdated binaries. No VM guests are running outdated hypervisor (qemu) binaries on this host. --- Build from source [umshastr@bug118020:/bv/ushastry]$ ls -l total 954456 -r--r--r-- 1 umshastr common 480412608 May 5 10:05 mysql-9.2.0.tar.gz -r--r--r-- 1 umshastr common 496943901 May 5 10:05 mysql-9.3.0.tar.gz [umshastr@bug118020:/bv/ushastry]$ [umshastr@bug118020:/bv/ushastry]$ tar -zxvf mysql-9.2.0.tar.gz && cd mysql-9.2.0 MYSQL_VERSION="Bug118020" TARGET=/bv/ushastry/$MYSQL_VERSION rm -rf /bv/ushastry/$MYSQL_VERSION rm -rf bld/ mkdir bld && cd bld rm -rf CMakeCache.txt cmake .. -DCMAKE_INSTALL_PREFIX=$TARGET && make -j16 make install bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/data bin/mysqld --basedir=$PWD --datadir=$PWD/data --skip-grant-tables 2>&1 & [umshastr@bug118020:/bv/ushastry/mysql-9.2.0/bld]$ cd $TARGET [umshastr@bug118020:/bv/ushastry/Bug118020]$ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/data 2025-05-05T09:19:57.678537Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2025-05-05T09:19:57.679623Z 0 [System] [MY-013169] [Server] /bv/ushastry/Bug118020/bin/mysqld (mysqld 9.2.0) initializing of server in progress as process 84300 2025-05-05T09:19:57.686781Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-05T09:19:58.259628Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-05T09:19:59.900122Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2025-05-05T09:20:02.097864Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. [umshastr@bug118020:/bv/ushastry/Bug118020]$ bin/mysqld --basedir=$PWD --datadir=$PWD/data --skip-grant-tables 2>&1 & [1] 84358 [umshastr@bug118020:/bv/ushastry/Bug118020]$ 2025-05-05T09:20:28.685312Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-05-05T09:20:28.926738Z 0 [System] [MY-010116] [Server] /bv/ushastry/Bug118020/bin/mysqld (mysqld 9.2.0) starting as process 84358 2025-05-05T09:20:28.934720Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-05T09:20:29.403752Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-05T09:20:29.792581Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-05-05T09:20:29.792620Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-05-05T09:20:29.796974Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/bv/ushastry' in the path is accessible to all OS users. Consider choosing a different directory. 2025-05-05T09:20:29.812088Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock 2025-05-05T09:20:29.812201Z 0 [System] [MY-010931] [Server] /bv/ushastry/Bug118020/bin/mysqld: ready for connections. Version: '9.2.0' socket: '/tmp/mysql.sock' port: 0 Source distribution. [umshastr@bug118020:/bv/ushastry/Bug118020]$ bin/mysql -uroot -S/tmp/mysql.sock --local-infile Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 9.2.0 Source distribution Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use information_schema; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE; +---------------+--------------------+-----------------------+------------+--------------------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------------+---------------+--------------+---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------+---------------------+---------------+----------------------+----------------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION | CHECK_OPTION | IS_UPDATABLE | DEFINER | SECURITY_TYPE | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | +---------------+--------------------+-----------------------+------------+--------------------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------------+---------------+--------------+---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------+---------------------+---------------+----------------------+----------------------+ | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | version | select '2.1.3' AS `sys_version`,version() AS `mysql_version` | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | innodb_buffer_stats_by_table | select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'InnoDB System',replace(substring_index(`ibp`.`TABLE_NAME`,'.',1),'`','')) AS `object_schema`,replace(substring_index(`ibp`.`TABLE_NAME`,'.',-(1)),'`','') AS `object_name`,format_bytes(sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`))) AS `allocated`,format_bytes(sum(`ibp`.`DATA_SIZE`)) AS `data`,count(`ibp`.`PAGE_NUMBER`) AS `pages`,count(if((`ibp`.`IS_HASHED` = 'YES'),1,NULL)) AS `pages_hashed`,count(if((`ibp`.`IS_OLD` = 'YES'),1,NULL)) AS `pages_old`,round((sum(`ibp`.`NUMBER_RECORDS`) / count(distinct `ibp`.`INDEX_NAME`)),0) AS `rows_cached` from `information_schema`.`INNODB_BUFFER_PAGE` `ibp` where (`ibp`.`TABLE_NAME` is not null) group by `object_schema`,`object_name` order by sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | x$io_by_thread_by_latency | select if((`performance_schema`.`threads`.`PROCESSLIST_ID` is null),substring_index(`performance_schema`.`threads`.`NAME`,'/',-(1)),concat(`performance_schema`.`threads`.`PROCESSLIST_USER`,'@',`performance_schema`.`threads`.`PROCESSLIST_HOST`)) AS `user`,sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`COUNT_STAR`) AS `total`,sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`) AS `total_latency`,min(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`MIN_TIMER_WAIT`) AS `min_latency`,avg(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`AVG_TIMER_WAIT`) AS `avg_latency`,max(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`MAX_TIMER_WAIT`) AS `max_latency`,`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID` AS `thread_id`,`performance_schema`.`threads`.`PROCESSLIST_ID` AS `processlist_id` from (`performance_schema`.`events_waits_summary_by_thread_by_event_name` left join `performance_schema`.`threads` on((`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID` = `performance_schema`.`threads`.`THREAD_ID`))) where ((`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`EVENT_NAME` like 'wait/io/file/%') and (`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT` > 0)) group by `performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID`,`performance_schema`.`threads`.`PROCESSLIST_ID`,`user` order by sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | ps_check_lost_instrumentation | select `performance_schema`.`global_status`.`VARIABLE_NAME` AS `variable_name`,`performance_schema`.`global_status`.`VARIABLE_VALUE` AS `variable_value` from `performance_schema`.`global_status` where ((`performance_schema`.`global_status`.`VARIABLE_NAME` like 'perf%lost') and (`performance_schema`.`global_status`.`VARIABLE_VALUE` > 0)) | NONE | YES | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | io_by_thread_by_latency | select if((`performance_schema`.`threads`.`PROCESSLIST_ID` is null),substring_index(`performance_schema`.`threads`.`NAME`,'/',-(1)),concat(`performance_schema`.`threads`.`PROCESSLIST_USER`,'@',`performance_schema`.`threads`.`PROCESSLIST_HOST`)) AS `user`,sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`COUNT_STAR`) AS `total`,format_pico_time(sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`)) AS `total_latency`,format_pico_time(min(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`MIN_TIMER_WAIT`)) AS `min_latency`,format_pico_time(avg(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`AVG_TIMER_WAIT`)) AS `avg_latency`,format_pico_time(max(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`MAX_TIMER_WAIT`)) AS `max_latency`,`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID` AS `thread_id`,`performance_schema`.`threads`.`PROCESSLIST_ID` AS `processlist_id` from (`performance_schema`.`events_waits_summary_by_thread_by_event_name` left join `performance_schema`.`threads` on((`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID` = `performance_schema`.`threads`.`THREAD_ID`))) where ((`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`EVENT_NAME` like 'wait/io/file/%') and (`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT` > 0)) group by `performance_schema`.`events_waits_summary_by_thread_by_event_name`.`THREAD_ID`,`performance_schema`.`threads`.`PROCESSLIST_ID`,`user` order by sum(`performance_schema`.`events_waits_summary_by_thread_by_event_name`.`SUM_TIMER_WAIT`) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | x$schema_flattened_keys | select `information_schema`.`STATISTICS`.`TABLE_SCHEMA` AS `TABLE_SCHEMA`,`information_schema`.`STATISTICS`.`TABLE_NAME` AS `TABLE_NAME`,`information_schema`.`STATISTICS`.`INDEX_NAME` AS `INDEX_NAME`,max(`information_schema`.`STATISTICS`.`NON_UNIQUE`) AS `non_unique`,max(if((`information_schema`.`STATISTICS`.`SUB_PART` is null),0,1)) AS `subpart_exists`,group_concat(`information_schema`.`STATISTICS`.`COLUMN_NAME` order by `information_schema`.`STATISTICS`.`SEQ_IN_INDEX` ASC separator ',') AS `index_columns` from `information_schema`.`STATISTICS` where ((`information_schema`.`STATISTICS`.`INDEX_TYPE` = 'BTREE') and (`information_schema`.`STATISTICS`.`TABLE_SCHEMA` not in ('mysql','sys','INFORMATION_SCHEMA','PERFORMANCE_SCHEMA'))) group by `information_schema`.`STATISTICS`.`TABLE_SCHEMA`,`information_schema`.`STATISTICS`.`TABLE_NAME`,`information_schema`.`STATISTICS`.`INDEX_NAME` | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | x$innodb_buffer_stats_by_table | select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'InnoDB System',replace(substring_index(`ibp`.`TABLE_NAME`,'.',1),'`','')) AS `object_schema`,replace(substring_index(`ibp`.`TABLE_NAME`,'.',-(1)),'`','') AS `object_name`,sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) AS `allocated`,sum(`ibp`.`DATA_SIZE`) AS `data`,count(`ibp`.`PAGE_NUMBER`) AS `pages`,count(if((`ibp`.`IS_HASHED` = 'YES'),1,NULL)) AS `pages_hashed`,count(if((`ibp`.`IS_OLD` = 'YES'),1,NULL)) AS `pages_old`,round(ifnull((sum(`ibp`.`NUMBER_RECORDS`) / nullif(count(distinct `ibp`.`INDEX_NAME`),0)),0),0) AS `rows_cached` from `information_schema`.`INNODB_BUFFER_PAGE` `ibp` where (`ibp`.`TABLE_NAME` is not null) group by `object_schema`,`object_name` order by sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | x$innodb_buffer_stats_by_schema | select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'InnoDB System',replace(substring_index(`ibp`.`TABLE_NAME`,'.',1),'`','')) AS `object_schema`,sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) AS `allocated`,sum(`ibp`.`DATA_SIZE`) AS `data`,count(`ibp`.`PAGE_NUMBER`) AS `pages`,count(if((`ibp`.`IS_HASHED` = 'YES'),1,NULL)) AS `pages_hashed`,count(if((`ibp`.`IS_OLD` = 'YES'),1,NULL)) AS `pages_old`,round(ifnull((sum(`ibp`.`NUMBER_RECORDS`) / nullif(count(distinct `ibp`.`INDEX_NAME`),0)),0),0) AS `rows_cached` from `information_schema`.`INNODB_BUFFER_PAGE` `ibp` where (`ibp`.`TABLE_NAME` is not null) group by `object_schema` order by sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | innodb_buffer_stats_by_schema | select if((locate('.',`ibp`.`TABLE_NAME`) = 0),'InnoDB System',replace(substring_index(`ibp`.`TABLE_NAME`,'.',1),'`','')) AS `object_schema`,format_bytes(sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`))) AS `allocated`,format_bytes(sum(`ibp`.`DATA_SIZE`)) AS `data`,count(`ibp`.`PAGE_NUMBER`) AS `pages`,count(if((`ibp`.`IS_HASHED` = 'YES'),1,NULL)) AS `pages_hashed`,count(if((`ibp`.`IS_OLD` = 'YES'),1,NULL)) AS `pages_old`,round((sum(`ibp`.`NUMBER_RECORDS`) / count(distinct `ibp`.`INDEX_NAME`)),0) AS `rows_cached` from `information_schema`.`INNODB_BUFFER_PAGE` `ibp` where (`ibp`.`TABLE_NAME` is not null) group by `object_schema` order by sum(if((`ibp`.`COMPRESSED_SIZE` = 0),16384,`ibp`.`COMPRESSED_SIZE`)) desc | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | x$latest_file_io | select if((`processlist`.`ID` is null),concat(substring_index(`performance_schema`.`threads`.`NAME`,'/',-(1)),':',`performance_schema`.`events_waits_history_long`.`THREAD_ID`),concat(`processlist`.`USER`,'@',`processlist`.`HOST`,':',`processlist`.`ID`)) AS `thread`,`performance_schema`.`events_waits_history_long`.`OBJECT_NAME` AS `file`,`performance_schema`.`events_waits_history_long`.`TIMER_WAIT` AS `latency`,`performance_schema`.`events_waits_history_long`.`OPERATION` AS `operation`,`performance_schema`.`events_waits_history_long`.`NUMBER_OF_BYTES` AS `requested` from ((`performance_schema`.`events_waits_history_long` join `performance_schema`.`threads` on((`performance_schema`.`events_waits_history_long`.`THREAD_ID` = `performance_schema`.`threads`.`THREAD_ID`))) left join `information_schema`.`PROCESSLIST` `processlist` on((`performance_schema`.`threads`.`PROCESSLIST_ID` = `processlist`.`ID`))) where ((`performance_schema`.`events_waits_history_long`.`OBJECT_NAME` is not null) and (`performance_schema`.`events_waits_history_long`.`EVENT_NAME` like 'wait/io/file/%')) order by `performance_schema`.`events_waits_history_long`.`TIMER_START` | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | schema_object_overview | select `information_schema`.`routines`.`ROUTINE_SCHEMA` AS `db`,`information_schema`.`routines`.`ROUTINE_TYPE` AS `object_type`,count(0) AS `count` from `information_schema`.`ROUTINES` `routines` group by `information_schema`.`routines`.`ROUTINE_SCHEMA`,`information_schema`.`routines`.`ROUTINE_TYPE` union select `information_schema`.`tables`.`TABLE_SCHEMA` AS `TABLE_SCHEMA`,`information_schema`.`tables`.`TABLE_TYPE` AS `TABLE_TYPE`,count(0) AS `COUNT(*)` from `information_schema`.`TABLES` `tables` group by `information_schema`.`tables`.`TABLE_SCHEMA`,`information_schema`.`tables`.`TABLE_TYPE` union select `information_schema`.`statistics`.`TABLE_SCHEMA` AS `TABLE_SCHEMA`,concat('INDEX (',`information_schema`.`statistics`.`INDEX_TYPE`,')') AS `CONCAT('INDEX (', INDEX_TYPE, ')')`,count(0) AS `COUNT(*)` from `information_schema`.`STATISTICS` `statistics` group by `information_schema`.`statistics`.`TABLE_SCHEMA`,`information_schema`.`statistics`.`INDEX_TYPE` union select `information_schema`.`triggers`.`TRIGGER_SCHEMA` AS `TRIGGER_SCHEMA`,'TRIGGER' AS `TRIGGER`,count(0) AS `COUNT(*)` from `information_schema`.`TRIGGERS` `triggers` group by `information_schema`.`triggers`.`TRIGGER_SCHEMA` union select `information_schema`.`events`.`EVENT_SCHEMA` AS `EVENT_SCHEMA`,'EVENT' AS `EVENT`,count(0) AS `COUNT(*)` from `information_schema`.`EVENTS` `events` group by `information_schema`.`events`.`EVENT_SCHEMA` order by `db`,`object_type` | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | schema_redundant_indexes | select `sys`.`redundant_keys`.`table_schema` AS `table_schema`,`sys`.`redundant_keys`.`table_name` AS `table_name`,`sys`.`redundant_keys`.`index_name` AS `redundant_index_name`,`sys`.`redundant_keys`.`index_columns` AS `redundant_index_columns`,`sys`.`redundant_keys`.`non_unique` AS `redundant_index_non_unique`,`sys`.`dominant_keys`.`index_name` AS `dominant_index_name`,`sys`.`dominant_keys`.`index_columns` AS `dominant_index_columns`,`sys`.`dominant_keys`.`non_unique` AS `dominant_index_non_unique`,if(((0 <> `sys`.`redundant_keys`.`subpart_exists`) or (0 <> `sys`.`dominant_keys`.`subpart_exists`)),1,0) AS `subpart_exists`,concat('ALTER TABLE `',`sys`.`redundant_keys`.`table_schema`,'`.`',`sys`.`redundant_keys`.`table_name`,'` DROP INDEX `',`sys`.`redundant_keys`.`index_name`,'`') AS `sql_drop_index` from (`sys`.`x$schema_flattened_keys` `redundant_keys` join `sys`.`x$schema_flattened_keys` `dominant_keys` on(((`sys`.`redundant_keys`.`table_schema` = `sys`.`dominant_keys`.`table_schema`) and (`sys`.`redundant_keys`.`table_name` = `sys`.`dominant_keys`.`table_name`)))) where ((`sys`.`redundant_keys`.`index_name` <> `sys`.`dominant_keys`.`index_name`) and (((`sys`.`redundant_keys`.`index_columns` = `sys`.`dominant_keys`.`index_columns`) and ((`sys`.`redundant_keys`.`non_unique` > `sys`.`dominant_keys`.`non_unique`) or ((`sys`.`redundant_keys`.`non_unique` = `sys`.`dominant_keys`.`non_unique`) and (if((`sys`.`redundant_keys`.`index_name` = 'PRIMARY'),'',`sys`.`redundant_keys`.`index_name`) > if((`sys`.`dominant_keys`.`index_name` = 'PRIMARY'),'',`sys`.`dominant_keys`.`index_name`))))) or ((locate(concat(`sys`.`redundant_keys`.`index_columns`,','),`sys`.`dominant_keys`.`index_columns`) = 1) and (`sys`.`redundant_keys`.`non_unique` = 1)) or ((locate(concat(`sys`.`dominant_keys`.`index_columns`,','),`sys`.`redundant_keys`.`index_columns`) = 1) and (`sys`.`dominant_keys`.`non_unique` = 0)))) | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | latest_file_io | select if((`processlist`.`ID` is null),concat(substring_index(`performance_schema`.`threads`.`NAME`,'/',-(1)),':',`performance_schema`.`events_waits_history_long`.`THREAD_ID`),concat(`processlist`.`USER`,'@',`processlist`.`HOST`,':',`processlist`.`ID`)) AS `thread`,`sys`.`format_path`(`performance_schema`.`events_waits_history_long`.`OBJECT_NAME`) AS `file`,format_pico_time(`performance_schema`.`events_waits_history_long`.`TIMER_WAIT`) AS `latency`,`performance_schema`.`events_waits_history_long`.`OPERATION` AS `operation`,format_bytes(`performance_schema`.`events_waits_history_long`.`NUMBER_OF_BYTES`) AS `requested` from ((`performance_schema`.`events_waits_history_long` join `performance_schema`.`threads` on((`performance_schema`.`events_waits_history_long`.`THREAD_ID` = `performance_schema`.`threads`.`THREAD_ID`))) left join `information_schema`.`PROCESSLIST` `processlist` on((`performance_schema`.`threads`.`PROCESSLIST_ID` = `processlist`.`ID`))) where ((`performance_schema`.`events_waits_history_long`.`OBJECT_NAME` is not null) and (`performance_schema`.`events_waits_history_long`.`EVENT_NAME` like 'wait/io/file/%')) order by `performance_schema`.`events_waits_history_long`.`TIMER_START` | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | | def | performance_schema | innodb_redo_log_files | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | 2025-05-05 11:20:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | | | def | sys | schema_auto_increment_columns | select `information_schema`.`COLUMNS`.`TABLE_SCHEMA` AS `TABLE_SCHEMA`,`information_schema`.`COLUMNS`.`TABLE_NAME` AS `TABLE_NAME`,`information_schema`.`COLUMNS`.`COLUMN_NAME` AS `COLUMN_NAME`,`information_schema`.`COLUMNS`.`DATA_TYPE` AS `DATA_TYPE`,`information_schema`.`COLUMNS`.`COLUMN_TYPE` AS `COLUMN_TYPE`,(locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) = 0) AS `is_signed`,(locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) > 0) AS `is_unsigned`,((case `information_schema`.`COLUMNS`.`DATA_TYPE` when 'tinyint' then 255 when 'smallint' then 65535 when 'mediumint' then 16777215 when 'int' then 4294967295 when 'bigint' then 18446744073709551615 end) >> if((locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) > 0),0,1)) AS `max_value`,`information_schema`.`TABLES`.`AUTO_INCREMENT` AS `AUTO_INCREMENT`,(`information_schema`.`TABLES`.`AUTO_INCREMENT` / ((case `information_schema`.`COLUMNS`.`DATA_TYPE` when 'tinyint' then 255 when 'smallint' then 65535 when 'mediumint' then 16777215 when 'int' then 4294967295 when 'bigint' then 18446744073709551615 end) >> if((locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) > 0),0,1))) AS `auto_increment_ratio` from (`information_schema`.`COLUMNS` join `information_schema`.`TABLES` on(((`information_schema`.`COLUMNS`.`TABLE_SCHEMA` = `information_schema`.`TABLES`.`TABLE_SCHEMA`) and (`information_schema`.`COLUMNS`.`TABLE_NAME` = `information_schema`.`TABLES`.`TABLE_NAME`)))) where ((`information_schema`.`COLUMNS`.`TABLE_SCHEMA` not in ('mysql','sys','INFORMATION_SCHEMA','performance_schema')) and (`information_schema`.`TABLES`.`TABLE_TYPE` = 'BASE TABLE') and (`information_schema`.`COLUMNS`.`EXTRA` = 'auto_increment')) order by (`information_schema`.`TABLES`.`AUTO_INCREMENT` / ((case `information_schema`.`COLUMNS`.`DATA_TYPE` when 'tinyint' then 255 when 'smallint' then 65535 when 'mediumint' then 16777215 when 'int' then 4294967295 when 'bigint' then 18446744073709551615 end) >> if((locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) > 0),0,1))) desc,((case `information_schema`.`COLUMNS`.`DATA_TYPE` when 'tinyint' then 255 when 'smallint' then 65535 when 'mediumint' then 16777215 when 'int' then 4294967295 when 'bigint' then 18446744073709551615 end) >> if((locate('unsigned',`information_schema`.`COLUMNS`.`COLUMN_TYPE`) > 0),0,1)) | NONE | NO | mysql.sys@localhost | INVOKER | utf8mb4 | utf8mb4_0900_ai_ci | +---------------+--------------------+-----------------------+------------+--------------------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------------+---------------+--------------+---------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+--------------+---------------------+---------------+----------------------+----------------------+ 14 rows in set (10.45 sec) mysql> mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE; Empty set (3.00 sec) mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE; Empty set (2.98 sec) mysql> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE; Empty set (3.06 sec) mysql>