- rm -rf 100968/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/100968 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/100968 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/100968/log.err --mysqlx=0 --log-error-verbosity=3 --secure-file-priv="" --performance-schema=ON 2>&1 & - CLI 1 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.21 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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 database if not exists test; use test; drop table if exists keyvalue; CREATE TABLE `keyvalue` ( `id` bigint(20) unsigned NOT NULL, `name1` varchar(250), `name2` varchar(250), `name3` varchar(250), `name4` varchar(250), PRIMARY KEY (`id`, name1(10)) ) ENGINE=innodb STATS_SAMPLE_PAGES=10000; set @id:=0; insert into `keyvalue` values (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) Query OK, 1 row affected (0.00 sec) mysql> use test; Database changed mysql> drop table if exists keyvalue; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE TABLE `keyvalue` ( -> `id` bigint(20) unsigned NOT NULL, -> `name1` varchar(250), -> `name2` varchar(250), -> `name3` varchar(250), -> `name4` varchar(250), -> PRIMARY KEY (`id`, name1(10)) -> ) ENGINE=innodb STATS_SAMPLE_PAGES=10000; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `keyvalue` values -> (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)) -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)); Query OK, 4 rows affected, 4 warnings (0.01 sec) Records: 4 Duplicates: 0 Warnings: 4 mysql> mysql> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`) -> select @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 10000000; Query OK, 10000000 rows affected, 1 warning (5 min 4.89 sec) Records: 10000000 Duplicates: 0 Warnings: 1 mysql> create table keyvalue_1 like keyvalue; Query OK, 0 rows affected (0.01 sec) mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> insert into keyvalue_1 select * from keyvalue limit 10000000; Query OK, 10000000 rows affected (4 min 10.89 sec) Records: 10000000 Duplicates: 0 Warnings: 0 mysql> - CLI 2 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.21 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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 test 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 count(*) from keyvalue_1; - CLI 3 bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.21 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 598 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 52 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Query | 6 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 617 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 71 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Query | 25 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 631 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 85 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Query | 39 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> kill 8; Query OK, 0 rows affected (0.00 sec) - CLI 2 mysql> select count(*) from keyvalue_1; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> - CLI 3 mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 653 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 107 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Killed | 61 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 658 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 112 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Killed | 66 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 683 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 137 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Killed | 91 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 707 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 161 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Killed | 115 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 740 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Query | 194 | executing | insert into keyvalue_1 select * from keyvalue limit 10000000 | | 8 | root | localhost | test | Killed | 148 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+--------------------------------------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 803 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 257 | | NULL | | 8 | root | localhost | test | Killed | 211 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 808 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 262 | | NULL | | 8 | root | localhost | test | Killed | 216 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 812 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 266 | | NULL | | 8 | root | localhost | test | Killed | 220 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.01 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 814 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 268 | | NULL | | 8 | root | localhost | test | Killed | 222 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 833 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 287 | | NULL | | 8 | root | localhost | test | Killed | 241 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 915 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 369 | | NULL | | 8 | root | localhost | test | Killed | 323 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 963 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 417 | | NULL | | 8 | root | localhost | test | Killed | 371 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1060 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 514 | | NULL | | 8 | root | localhost | test | Killed | 468 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1152 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 606 | | NULL | | 8 | root | localhost | test | Killed | 560 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1200 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 654 | | NULL | | 8 | root | localhost | test | Killed | 608 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) . . mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1546 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 1000 | | NULL | | 8 | root | localhost | test | Killed | 954 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql> show processlist; +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 1764 | Waiting on empty queue | NULL | | 7 | root | localhost | test | Sleep | 1218 | | NULL | | 8 | root | localhost | test | Killed | 1172 | executing | select count(*) from keyvalue_1 | | 9 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-----------------+-----------+------+---------+------+------------------------+---------------------------------+ 4 rows in set (0.00 sec) mysql>