mysql慢日志导入数据库表中

-- etldb.db_slow_log definition CREATE TABLE db_slow_log ( id bigint NOT NULL AUTO_INCREMENT COMMENT '主键id', db_name varchar(16) DEFAULT NULL COMMENT '数据库主机名', slow_time timestamp NULL DEFAULT NULL COMMENT '慢sql执行时间', host_info varchar(100) DEFAULT NULL COMMENT '连接用户端口', query_time varchar(100) DEFAULT NULL COMMENT '查询时长', lock_time varchar(100) DEFAULT NULL, rows_sent varchar(100) DEFAULT NULL, rows_examined varchar(100) DEFAULT NULL, slow_sql mediumtext COMMENT '慢sql', remak varchar(500) DEFAULT NULL COMMENT '备注', create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (id) USING BTREE, UNIQUE KEY db_slow_log_id_uindex (id) ) ENGINE=InnoDB AUTO_INCREMENT=1;