################### Environment System Summary Report ###################### Date | 2023-10-26 08:38:37 UTC (local TZ: CEST +0200) Hostname | support-cluster03 Uptime | 643 days, 15:07, 3 users, load average: 0.08, 0.02, 0.00 Platform | Linux Release | Red Hat Enterprise Linux Server release 7.9 (Maipo) Kernel | 5.4.17-2102.206.1.el7uek.x86_64 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.17 Compiler | GNU CC version 4.8.5 20150623 (Red Hat 4.8.5-44.0.3). SELinux | Disabled Virtualized | VMWare # 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 | 117.4G Free | 805.2M Used | physical = 1.7G, swap allocated = 8.0G, swap used = 1.6G, virtual = 3.3G Shared | 6.5G Buffers | 114.9G Caches | 108.1G Dirty | 255080 kB UsedRSS | 1.4G Swappiness | 60 DirtyPolicy | 20, 10 DirtyStatus | 0, 0 -- uname -an Linux support-cluster03 5.4.17-2102.206.1.el7uek.x86_64 #2 SMP Wed Oct 6 16:40:40 PDT 2021 x86_64 x86_64 x86_64 GNU/Linux -- cat /etc/*release Oracle Linux Server release 7.9 NAME="Oracle Linux Server" VERSION="7.9" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.9" PRETTY_NAME="Oracle Linux Server 7.9" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:9:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.9 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.9 Red Hat Enterprise Linux Server release 7.9 (Maipo) Oracle Linux Server release 7.9 -- df -Th /export/home/tmp/ushastry Filesystem Type Size Used Avail Use% Mounted on /dev/sdb1 xfs 2.0T 1.3T 713G 65% /export/home *** Note - Binary tarball builds pulled from internal reposiroty mounted on all support boxes -- Server start up(default settings) rm -rf 112964/ bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/112964 --log-error-verbosity=3 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/112964 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/112964/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & -- bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.35 MySQL Community Server - GPL Copyright (c) 2000, 2023, 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> -- CREATE NEW SCHEMA mysql> drop schema if exists count_example; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create schema count_example; Query OK, 1 row affected (0.01 sec) mysql> use count_example; Database changed mysql> mysql> -- CREATE NEW TABLE mysql> drop table if exists test; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create table test ( -> id int unsigned not null auto_increment primary key, -> wide_field varchar(200) not null default 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ', -> small_field boolean not null default 1, -> index small_field_key (small_field) -> ); Query OK, 0 rows affected (0.03 sec) mysql> -- CREATE PROCEDURE TO LOAD DATA -- CHANGE v_max IF LESS ROWS ARE NEEDED drop procedure if exists load_data; delimiter # create procedure load_data() begin declare v_max int default 24; declare v_counter int default 0; insert into test (small_field) values (1); while v_counter < v_max do select concat('current iter: ',v_counter,' max: ',v_max-1) as progress; insert into test (small_field) select small_field from test; set v_counter=v_counter+1; end while; end # delimiter ;mysql> -- CHANGE v_max IF LESS ROWS ARE NEEDED mysql> drop procedure if exists load_data; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> delimiter # mysql> create procedure load_data() -> begin -> declare v_max int default 24; -> declare v_counter int default 0; -> insert into test (small_field) values (1); -> while v_counter < v_max do -> select concat('current iter: ',v_counter,' max: ',v_max-1) as progress; -> insert into test (small_field) select small_field from test; -> set v_counter=v_counter+1; -> end while; -> end # Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> -- CALL DATA LOAD PROC mysql> call load_data(); +-------------------------+ | progress | +-------------------------+ | current iter: 0 max: 23 | +-------------------------+ 1 row in set (0.01 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 1 max: 23 | +-------------------------+ 1 row in set (0.01 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 2 max: 23 | +-------------------------+ 1 row in set (0.02 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 3 max: 23 | +-------------------------+ 1 row in set (0.02 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 4 max: 23 | +-------------------------+ 1 row in set (0.02 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 5 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 6 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 7 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 8 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 9 max: 23 | +-------------------------+ 1 row in set (0.06 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 10 max: 23 | +--------------------------+ 1 row in set (0.07 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 11 max: 23 | +--------------------------+ 1 row in set (0.11 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 12 max: 23 | +--------------------------+ 1 row in set (0.18 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 13 max: 23 | +--------------------------+ 1 row in set (0.22 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 14 max: 23 | +--------------------------+ 1 row in set (0.30 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 15 max: 23 | +--------------------------+ 1 row in set (0.43 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 16 max: 23 | +--------------------------+ 1 row in set (0.72 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 17 max: 23 | +--------------------------+ 1 row in set (1.29 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 18 max: 23 | +--------------------------+ 1 row in set (2.35 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 19 max: 23 | +--------------------------+ 1 row in set (5.31 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 20 max: 23 | +--------------------------+ 1 row in set (11.87 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 21 max: 23 | +--------------------------+ 1 row in set (25.30 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 22 max: 23 | +--------------------------+ 1 row in set (50.58 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 23 max: 23 | +--------------------------+ 1 row in set (1 min 37.07 sec) Query OK, 8388608 rows affected (3 min 2.01 sec) mysql> SELECT @@version, @@innodb_flush_method; +-----------+-----------------------+ | @@version | @@innodb_flush_method | +-----------+-----------------------+ | 8.0.35 | fsync | +-----------+-----------------------+ 1 row in set (0.00 sec) mysql> SELECT @@innodb_parallel_read_threads; +--------------------------------+ | @@innodb_parallel_read_threads | +--------------------------------+ | 4 | +--------------------------------+ 1 row in set (0.00 sec) mysql> FLUSH STATUS; Query OK, 0 rows affected (0.01 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (1.15 sec) mysql> SHOW STATUS LIKE '%Handler%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 2 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 18 rows in set (0.00 sec) mysql> shutdown; Query OK, 0 rows affected (0.00 sec) -- restarted with --innodb-flush-method=O_DIRECT bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/112964 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/112964/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 --innodb-flush-method=O_DIRECT 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.35 MySQL Community Server - GPL Copyright (c) 2000, 2023, 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 count_example 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> FLUSH STATUS; Query OK, 0 rows affected (0.01 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (34.69 sec) mysql> SELECT @@version, @@innodb_flush_method; +-----------+-----------------------+ | @@version | @@innodb_flush_method | +-----------+-----------------------+ | 8.0.35 | O_DIRECT | +-----------+-----------------------+ 1 row in set (0.00 sec) ####### 8.0.11 (first GA in 8.0) bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.11 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 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> -- CREATE NEW SCHEMA mysql> drop schema if exists count_example; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create schema count_example; Query OK, 1 row affected (0.07 sec) mysql> use count_example; Database changed mysql> -- CREATE NEW TABLE mysql> drop table if exists test; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create table test ( -> id int unsigned not null auto_increment primary key, -> wide_field varchar(200) not null default 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ', -> small_field boolean not null default 1, -> index small_field_key (small_field) -> ); Query OK, 0 rows affected (0.10 sec) mysql> -- CREATE PROCEDURE TO LOAD DATA -- CHANGE v_max IF LESS ROWS ARE NEEDED drop procedure if exists load_data; delimiter # create procedure load_data() begin declare v_max int default 24; declare v_counter int default 0; insert into test (small_field) values (1); while v_counter < v_max do select concat('current iter: ',v_counter,' max: ',v_max-1) as progress; insert into test (small_field) select small_field from test; set v_counter=v_counter+1; end while; end # delimiter ;mysql> -- CHANGE v_max IF LESS ROWS ARE NEEDED mysql> drop procedure if exists load_data; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> delimiter # mysql> create procedure load_data() -> begin -> declare v_max int default 24; -> declare v_counter int default 0; -> insert into test (small_field) values (1); -> while v_counter < v_max do -> select concat('current iter: ',v_counter,' max: ',v_max-1) as progress; -> insert into test (small_field) select small_field from test; -> set v_counter=v_counter+1; -> end while; -> end # Query OK, 0 rows affected (0.03 sec) mysql> delimiter ; mysql> -- CALL DATA LOAD PROC mysql> call load_data(); +-------------------------+ | progress | +-------------------------+ | current iter: 0 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 1 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 2 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 3 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 4 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 5 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 6 max: 23 | +-------------------------+ 1 row in set (0.05 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 7 max: 23 | +-------------------------+ 1 row in set (0.05 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 8 max: 23 | +-------------------------+ 1 row in set (0.06 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 9 max: 23 | +-------------------------+ 1 row in set (0.07 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 10 max: 23 | +--------------------------+ 1 row in set (0.09 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 11 max: 23 | +--------------------------+ 1 row in set (0.13 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 12 max: 23 | +--------------------------+ 1 row in set (0.22 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 13 max: 23 | +--------------------------+ 1 row in set (0.25 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 14 max: 23 | +--------------------------+ 1 row in set (0.31 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 15 max: 23 | +--------------------------+ 1 row in set (0.45 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 16 max: 23 | +--------------------------+ 1 row in set (0.72 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 17 max: 23 | +--------------------------+ 1 row in set (1.21 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 18 max: 23 | +--------------------------+ 1 row in set (2.15 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 19 max: 23 | +--------------------------+ 1 row in set (3.98 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 20 max: 23 | +--------------------------+ 1 row in set (7.83 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 21 max: 23 | +--------------------------+ 1 row in set (15.43 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 22 max: 23 | +--------------------------+ 1 row in set (30.46 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 23 max: 23 | +--------------------------+ 1 row in set (1 min 1.30 sec) Query OK, 8388608 rows affected (2 min 3.66 sec) mysql> SELECT @@version, @@innodb_flush_method; +-----------+-----------------------+ | @@version | @@innodb_flush_method | +-----------+-----------------------+ | 8.0.11 | fsync | +-----------+-----------------------+ 1 row in set (0.00 sec) mysql> mysql> FLUSH STATUS; Query OK, 0 rows affected (0.00 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (2.04 sec) mysql> SHOW STATUS LIKE 'Handler%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 2 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 18 rows in set (0.00 sec) -- restart bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.11 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 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 count_example; 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 @@version, @@innodb_flush_method; +-----------+-----------------------+ | @@version | @@innodb_flush_method | +-----------+-----------------------+ | 8.0.11 | O_DIRECT | +-----------+-----------------------+ 1 row in set (0.00 sec) mysql> FLUSH STATUS; Query OK, 0 rows affected (0.00 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (12.19 sec) mysql> SHOW STATUS LIKE 'Handler%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 2 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 18 rows in set (0.01 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (13.50 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ ##### 8.0.34 bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.34 MySQL Community Server - GPL Copyright (c) 2000, 2023, 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> -- CREATE NEW SCHEMA mysql> drop schema if exists count_example; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> create schema count_example; Query OK, 1 row affected (0.00 sec) mysql> use count_example; Database changed mysql> mysql> -- CREATE NEW TABLE mysql> drop table if exists test; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> create table test ( -> id int unsigned not null auto_increment primary key, -> wide_field varchar(200) not null default 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ ABCDEFGHIJKLMNOPQRSTUVWXYZ', -> small_field boolean not null default 1, -> index small_field_key (small_field) -> ); Query OK, 0 rows affected (0.03 sec) mysql> mysql> -- CREATE PROCEDURE TO LOAD DATA mysql> -- CHANGE v_max IF LESS ROWS ARE NEEDED mysql> drop procedure if exists load_data; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> delimiter # mysql> create procedure load_data() -> begin -> declare v_max int default 24; -> declare v_counter int default 0; -> insert into test (small_field) values (1); -> while v_counter < v_max do -> select concat('current iter: ',v_counter,' max: ',v_max-1) as progress; -> insert into test (small_field) select small_field from test; -> set v_counter=v_counter+1; -> end while; -> end # Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> mysql> -- CALL DATA LOAD PROC mysql> call load_data(); +-------------------------+ | progress | +-------------------------+ | current iter: 0 max: 23 | +-------------------------+ 1 row in set (0.01 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 1 max: 23 | +-------------------------+ 1 row in set (0.01 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 2 max: 23 | +-------------------------+ 1 row in set (0.01 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 3 max: 23 | +-------------------------+ 1 row in set (0.02 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 4 max: 23 | +-------------------------+ 1 row in set (0.02 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 5 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 6 max: 23 | +-------------------------+ 1 row in set (0.03 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 7 max: 23 | +-------------------------+ 1 row in set (0.04 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 8 max: 23 | +-------------------------+ 1 row in set (0.05 sec) +-------------------------+ | progress | +-------------------------+ | current iter: 9 max: 23 | +-------------------------+ 1 row in set (0.06 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 10 max: 23 | +--------------------------+ 1 row in set (0.09 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 11 max: 23 | +--------------------------+ 1 row in set (0.13 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 12 max: 23 | +--------------------------+ 1 row in set (0.21 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 13 max: 23 | +--------------------------+ 1 row in set (0.25 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 14 max: 23 | +--------------------------+ 1 row in set (0.31 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 15 max: 23 | +--------------------------+ 1 row in set (0.45 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 16 max: 23 | +--------------------------+ 1 row in set (0.75 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 17 max: 23 | +--------------------------+ 1 row in set (1.24 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 18 max: 23 | +--------------------------+ 1 row in set (2.22 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 19 max: 23 | +--------------------------+ 1 row in set (5.07 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 20 max: 23 | +--------------------------+ 1 row in set (10.76 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 21 max: 23 | +--------------------------+ 1 row in set (22.44 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 22 max: 23 | +--------------------------+ 1 row in set (44.54 sec) +--------------------------+ | progress | +--------------------------+ | current iter: 23 max: 23 | +--------------------------+ 1 row in set (1 min 28.72 sec) Query OK, 8388608 rows affected (2 min 54.78 sec) mysql> SELECT @@version, @@innodb_flush_method; +-----------+-----------------------+ | @@version | @@innodb_flush_method | +-----------+-----------------------+ | 8.0.34 | fsync | +-----------+-----------------------+ 1 row in set (0.00 sec) mysql> SELECT @@innodb_parallel_read_threads; +--------------------------------+ | @@innodb_parallel_read_threads | +--------------------------------+ | 4 | +--------------------------------+ 1 row in set (0.00 sec) mysql> FLUSH STATUS; Query OK, 0 rows affected (0.00 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (1.08 sec) mysql> show status like '%handler%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 2 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 18 rows in set (0.00 sec) ## bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/112964 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/112964/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 --innodb-flush-method=O_DIRECT 2>&1 & [1] 30377 bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.34 MySQL Community Server - GPL Copyright (c) 2000, 2023, 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 count_example; 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> FLUSH STATUS; Query OK, 0 rows affected (0.00 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (37.92 sec) mysql> SHOW STATUS LIKE 'Handler%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 2 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 18 rows in set (0.01 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (37.33 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (36.86 sec) mysql> SELECT COUNT(*) FROM count_example.test; +----------+ | COUNT(*) | +----------+ | 16777216 | +----------+ 1 row in set (37.20 sec)