感谢各位大佬解答
compact了4天…终于compact完了
执行计划也对了
Limit_7 100.00 100 root time:1.86ms, loops:2 offset:0, count:100 N/A N/A
└─TableReader_11 100.00 100 root time:1.85ms, loops:1, cop_task: {num: 3, max: 761.3µs, min: 476.1µs, avg: 575.4µs, p95: 761.3µs, max_proc_keys: 100, p95_proc_keys: 100, rpc_num: 3, rpc_time: 1.7ms, copr_cache_hit_ratio: 0.33, distsql_concurrency: 1} data:Limit_10 14.5 KB N/A
└─Limit_10 100.00 100 cop[tikv] tikv_task:{proc max:121ms, min:0s, avg: 40.3ms, p80:121ms, p95:121ms, iters:5, tasks:3}, scan_detail: {total_process_keys: 100, total_process_keys_size: 15234, total_keys: 102, get_snapshot_time: 87.6µs, rocksdb: {key_skipped_count: 100, block: {cache_hit_count: 24}}} offset:0, count:100 N/A N/A
└─TableFullScan_9 100.00 100 cop[tikv] table:h_equip_bin_box_status_history tikv_task:{proc max:121ms, min:0s, avg: 40.3ms, p80:121ms, p95:121ms, iters:5, tasks:3} keep order:false N/A N/A