+------------+---------------------+--------+------------+----------------------------+--------------------+ | rows | size | type | tool | operation | time | +------------+---------------------+--------+------------+----------------------------+--------------------+
| 1641w, | 4.5G, | .sql,| navicat, | mysqldump, | 1206s, | | 1641w, | 4.5G, | .sql,| emeditor, | open, | 秒级, | | 1641w, | 4.5G, | .sql,| emeditor, | del one line and save, | 3min, | | 1641w, | 4.5G, | .sql,| zmodem, | 传输, | 太大超过4G 失败, | | 1641w, | 4.5G, | .sql,| xftp, | 传输, | 15min | | 1641w, | 4.5G, | .sql,| navicat, | source sql, | 4h, | | 1341w, | 10w条/s, | .sql,| navicat, | select count(0), | 12s, | | 0w, | 0G, | .sql,| 0, | sql, | 0h, | | 0w, | 0G, | .sql,| 0, | sql, | 0h, | | 0w, | 0G, | .sql,| 0, | sql, | 0h, |
+------------+---------------------+--------+------------+----------------------------+--------------------+
select (396+712+284+348+404+920+304+232+292)/4758; =3892/4758 =0.818 sql文件大小 4.5G mysql数据文件大小 3.9G 转换比 0.82