infobright与mysql同步_MySQL到Infobright数据迁移案例

11:22:07 api_log> load data  infile ‘/data/house_apilog/INSHOP_API_ACCESS_LOG_5.csv’ into table INSHOP_API_ACCESS_LOG_201405 FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘\”‘   ESCAPED BY ‘\\’  LINES TERMINATED BY ‘\n’;

Query OK, 942548825 rows affected (6 hours 42 min 10.90 sec)

Records: 942548825  Deleted: 0  Skipped: 0  Warnings: 0

09:55:25 api_log> select concat(truncate(sum(data_length)/1024/1024,2),’MB’) as data_size,      concat(truncate(sum(max_data_length)/1024/1024,2),’MB’) as max_data_size,      concat(truncate(sum(data_free)/1024/1024,2),’MB’) as data_free,      concat(truncate(sum(index_length)/1024/1024,2),’MB’) as index_size      from information_schema.tables where TABLE_NAME = ‘INSHOP_API_ACCESS_LOG’;

+————-+—————+———–+————-+

| data_size   | max_data_size | data_free | index_size  |

+————-+—————+———–+————-+

| 640783.09MB | 0.00MB        | 179.00MB  | 111563.18MB |

+————-+—————+———–+————-+

1 row in set (19.16 sec)

09:54:17 api_log> select concat(truncate(sum(data_length)/1024/1024,2),’MB’) as data_size,      concat(truncate(sum(max_data_length)/1024/1024,2),’MB’) as max_data_size,      concat(truncate(sum(data_free)/1024/1024,2),’MB’) as data_free,      concat(truncate(sum(index_length)/1024/1024,2),’MB’) as index_size      from information_schema.tables where TABLE_NAME = ‘INSHOP_API_ACCESS_LOG_201405’;

+————+—————+———–+————+

| data_size  | max_data_size | data_free | index_size |

+————+—————+———–+————+

| 43760.19MB | 0.00MB        | 0.00MB    | 0.00MB     |

+————+—————+———–+————+

1 row in set (0.01 sec)