摘要:
select * from mysql.tidb where variable_name in ('tikv_gc_safe_point','tikv_gc_life_time'); tikv_gc_life_time 10m0s select * from sbtest1 where id=202 阅读全文
摘要:
统计信息相关参数: tidb_build_stats_concurrencytidb_distsql_scan_concurrency SHOW ANALYZE STATUS show stats_healthy where db_name='sbtest' and table_name='sbte 阅读全文
摘要:
create global binding for select * from sbtest1 where c='cc'using select * from sbtest1 use index(idx_2) where c='cc'; explain analyze select * from s 阅读全文
摘要:
调整索引创建的速度 #生成测试数据sysbench --config-file=./config_new ./oltp_common.lua --table-size=200000 prepare set global tidb_ddl_reorg_worker_cnt=2;set global t 阅读全文
摘要:
聚簇表 region 拆分 CREATE TABLE `sbtest1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT '0', `c` char(120) NOT NULL DEFAULT '', `pad 阅读全文