1,2,3都上了
set tidb_enable_rate_limit_action = 0；
set tidb_distsql_scan_concurrency = 1；
系统内存没之前张的那么块也在缓慢涨，但是跑了近10分钟，内存已经满 最后oom。
看上去 tidb，确实还不没有像mysql有这种“磁盘换时间”机制，mysql虽然慢但总可以出来。tidb要么提示 out of memory quota， 要么最后系统oom ，大的sql没办法？？？
[2022/11/10 11:17:10.053 +08:00] [INFO] [row_container.go:368] ["memory exceeds quota, spill to disk now."] [consumed=524678879] [quota=524288000]
[2022/11/10 11:17:10.053 +08:00] [INFO] [row_container.go:562] ["memory exceeds quota, spill to disk now."] [consumed=524638922] [quota=524288000]
[2022/11/10 11:17:10.058 +08:00] [INFO] [row_container.go:368] ["memory exceeds quota, spill to disk now."] [consumed=525997030] [quota=524288000]
[2022/11/10 11:17:10.669 +08:00] [INFO] [row_container.go:368] ["memory exceeds quota, spill to disk now."] [consumed=524618199] [quota=524288000]
[2022/11/10 11:17:10.677 +08:00] [WARN] [expensivequery.go:179] [expensive_query] [cost_time=15.470587844s] [cop_time=44.804289864s] [process_time=145.775s] [wait_time=5.234s] [request_count=21621] [total_keys=7242446] [process_keys=6781539] [num_cop_tasks=21621] [process_avg_time=0.006742287s] [process_p90_time=0.017s] [process_max_time=0.887s] [process_max_addr=10.0.8.39:20160] [wait_avg_time=0.000242079s] [wait_p90_time=0.001s] [wait_max_time=0.091s] [wait_max_addr=10.0.8.39:20161] [stats=weplay_user:437269348093526017,weplay_gift_config:437246981652611087,weplay_gift_consume:437268436107395086] [conn_id=29] [user=root] [database=weplayzy] [table_ids="[1008,308,1012]"] [index_names="[weplay_gift_consume:idx_uid]"] [txn_start_ts=437269355603689479] [mem_max="658532008 Bytes (628.0 MB)"] [sql="SELECT\r\n /*+ MERGE_JOIN(wu) */\r\n wgc.*,wu.nickname AS 'sendUserNickName',wu.channel_id as register_channel_id,\r\n b.charm_score*wgc.gift_amount as charm_score from weplay_gift_consume wgc\r\n LEFT JOIN weplay_user wu ON wgc.uid = wu.uid\r\n LEFT JOIN weplay_gift_config b ON wgc.gift_id = b.id\r\n ORDER BY wgc.create_time DESC"]