tidb 造数据速度变慢

写个脚本直接用CTE造数据，具体写法如下，一次不要搞太多，100万足以。写个循环跑就行

insert into t9
WITH RECURSIVE xxx (sort, category, interesting) AS
(
SELECT 51000001, 1, 1
UNION ALL
SELECT sort + 1, (sort+1)%1000, (sort+1)>50000 FROM xxx WHERE sort<=52000000
)
SELECT * FROM xxx;