mysql > show create table test_1\G
*************************** 1. row ***************************
       Table: test_1
Create Table: CREATE TABLE `test_1` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `cId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `aId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `newV` longtext,
  `oldV` longtext,
  `uId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `acId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `IncrId` bigint NOT NULL,
  `dTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `IDX1` (`IncrId`),
  KEY `IDX2` (`aId`,`acId`),
  KEY `IDX3` (`aId`,`rId`),
  KEY `IDX4` (`aId`,`cId`,`rId`)
) ENGINE=InnoDB AUTO_INCREMENT=12500001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMPRESSION='LZ4'
1 row in set (0.01 sec)

mysql > SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME IN ('log_lsn_current', 'log_lsn_last_checkpoint');
+-------------------------+-------------+
| NAME                    | COUNT       |
+-------------------------+-------------+
| log_lsn_last_checkpoint | 61590950309 |
| log_lsn_current         | 61590950309 |
+-------------------------+-------------+
2 rows in set (0.00 sec)

$ mysqlslap --password=msandbox --host=127.0.0.1 --user=msandbox --port=8040 --delimiter=";" --number-of-queries=500000 --create-schema=test --concurrency=16 --query=insert1.sql
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
	Average number of seconds to run all queries: 332.086 seconds
	Minimum number of seconds to run all queries: 332.086 seconds
	Maximum number of seconds to run all queries: 332.086 seconds
	Number of clients running queries: 16
	Average number of queries per client: 31250

mysql > SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME IN ('log_lsn_current', 'log_lsn_last_checkpoint');
+-------------------------+-------------+
| NAME                    | COUNT       |
+-------------------------+-------------+
| log_lsn_last_checkpoint | 71698778543 |
| log_lsn_current         | 71698778543 |
+-------------------------+-------------+
2 rows in set (0.00 sec)

mysql > select count(*) from test_1;
+----------+
| count(*) |
+----------+
| 12500000 |
+----------+
1 row in set (11.98 sec)

mysql > alter table test_1 compression="ZLIB";
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql > truncate table test_1;
Query OK, 0 rows affected (1.54 sec)


mysql > show create table test_1\G
*************************** 1. row ***************************
       Table: test_1
Create Table: CREATE TABLE `test_1` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `cId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `aId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `newV` longtext,
  `oldV` longtext,
  `uId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `acId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `IncrId` bigint NOT NULL,
  `dTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `IDX1` (`IncrId`),
  KEY `IDX2` (`aId`,`acId`),
  KEY `IDX3` (`aId`,`rId`),
  KEY `IDX4` (`aId`,`cId`,`rId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMPRESSION='ZLIB'
1 row in set (0.00 sec)

mysql > select count(*) from test_1;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

przemek@przemek-dbg:/data/sandboxes$ mysqlslap --password=msandbox --host=127.0.0.1 --user=msandbox --port=8040 --delimiter=";" --number-of-queries=500000 --create-schema=test --concurrency=16 --query=insert1.sql
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
	Average number of seconds to run all queries: 443.262 seconds
	Minimum number of seconds to run all queries: 443.262 seconds
	Maximum number of seconds to run all queries: 443.262 seconds
	Number of clients running queries: 16
	Average number of queries per client: 31250

mysql > select count(*) from test_1;
+----------+
| count(*) |
+----------+
| 12500000 |
+----------+
1 row in set (1 min 20.24 sec)

mysql > SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME IN ('log_lsn_current', 'log_lsn_last_checkpoint');
+-------------------------+-------------+
| NAME                    | COUNT       |
+-------------------------+-------------+
| log_lsn_last_checkpoint | 81853026761 |
| log_lsn_current         | 81853026761 |
+-------------------------+-------------+
2 rows in set (0.00 sec)


mysql > truncate table test_1;
Query OK, 0 rows affected (1.54 sec)

mysql > alter table test_1 compression="none";
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql > show create table test_1\G
*************************** 1. row ***************************
       Table: test_1
Create Table: CREATE TABLE `test_1` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `cId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `aId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `newV` longtext,
  `oldV` longtext,
  `uId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `acId` char(17) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `IncrId` bigint NOT NULL,
  `dTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `IDX1` (`IncrId`),
  KEY `IDX2` (`aId`,`acId`),
  KEY `IDX3` (`aId`,`rId`),
  KEY `IDX4` (`aId`,`cId`,`rId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMPRESSION='none'
1 row in set (0.01 sec)

mysql > select count(*) from test_1;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

$ mysqlslap --password=msandbox --host=127.0.0.1 --user=msandbox --port=8040 --delimiter=";" --number-of-queries=500000 --create-schema=test --concurrency=16 --query=insert1.sql
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
	Average number of seconds to run all queries: 301.727 seconds
	Minimum number of seconds to run all queries: 301.727 seconds
	Maximum number of seconds to run all queries: 301.727 seconds
	Number of clients running queries: 16
	Average number of queries per client: 31250

mysql > select count(*) from test_1;
+----------+
| count(*) |
+----------+
| 12500000 |
+----------+
1 row in set (8.45 sec)

mysql > SELECT NAME,COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME IN ('log_lsn_current', 'log_lsn_last_checkpoint');
+-------------------------+-------------+
| NAME                    | COUNT       |
+-------------------------+-------------+
| log_lsn_last_checkpoint | 91957737306 |
| log_lsn_current         | 91957737306 |
+-------------------------+-------------+
2 rows in set (0.00 sec)


mysql > select (91957737306-81853026761)/1024/1024;
+-------------------------------------+
| (91957737306-81853026761)/1024/1024 |
+-------------------------------------+
|                       9636.60292149 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql > select (81853026761-71698871840)/1024/1024;
+-------------------------------------+
| (81853026761-71698871840)/1024/1024 |
+-------------------------------------+
|                       9683.75675297 |
+-------------------------------------+
1 row in set (0.00 sec)

mysql > select (71698871840-61590950309)/1024/1024;
+-------------------------------------+
| (71698871840-61590950309)/1024/1024 |
+-------------------------------------+
|                       9639.66515636 |
+-------------------------------------+
1 row in set (0.00 sec)

LZ4 compress ratio:

$ du -h msb_8_0_33/data/test/test_1.ibd
3.8G	msb_8_0_33/data/test/test_1.ibd

$ ls -lh msb_8_0_33/data/test/test_1.ibd 
-rw-r----- 1 przemek przemek 7.2G Sep  8 15:26 msb_8_0_33/data/test/test_1.ibd