1

wget https://download.pingcap.org/tidb-enterprise-tools-latest-linux-amd64.tar.gz

1

mydumper -h 127.0.0.1 -P 4000 -u root -t 32 -F 64 -B test -T t1,t2 --skip-tz-utc -o ./var/test

1
2
3

iconv -f latin1 -t utf-8 $file -o /data/imdbload/$basename

# iconv -f latin1 -t utf-8 iot_env_data.t_env_data_vehicle-schema.sql  -o /data1/iot_mysql_2_tidb/iot_env_data-by-mydump--utf8/iot_env_data.t_env_data_vehicle-schema.sql

1
2
3
4
5
6
7
8
9

SELECT * FROM mysql.tidb WHERE VARIABLE_NAME = 'tikv_gc_life_time';
-- +-----------------------+----------------------------------+
-- | VARIABLE_NAME         | VARIABLE_VALUE                   |
-- +-----------------------+----------------------------------+
-- | tikv_gc_life_time     | 10m0s                            |
-- +-----------------------+----------------------------------+
-- 1 rows in set (0.02 sec)

update mysql.tidb set VARIABLE_VALUE = '720h' where VARIABLE_NAME = 'tikv_gc_life_time';

1

loader  -h 127.0.0.1 -u root -P 4000 -t 32 -d ./var/test

1

update mysql.tidb set VARIABLE_VALUE = '10m' where VARIABLE_NAME = 'tikv_gc_life_time';