Add index with distributed global sort performance is unstable #54147
Closed
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
go-ycsb run mysql -P /ycsb/workloads/workloada -p mysql.host=xxx.xxx.xxx.xx -p mysql.port=xxxxx -p mysql.db=test -p threadcount=100 -p recordcount=100000000 -p operationcount=50000000 -p workload=core -p fieldcount=10 -p fieldlength=100 -p requestdistribution=uniform
alter table usertable add index test_idx(FIELD0);2. What did you expect to see? (Required)
The execution time should be stable.
3. What did you see instead (Required)
(drop index statements are omitted)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (2 min 27.07 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (3 min 6.07 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (3 min 9.06 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (2 min 36.06 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (2 min 42.08 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (3 min 23.18 sec)
mysql> alter table usertable add index test_idx(FIELD0);
Query OK, 0 rows affected (3 min 24.68 sec)