time pt-archiver - source u = root, p =, h = localhost, accident report ma S = / tmp/mysql10010.soc

However, follow-up due to the relatively frequent business needs, colleagues growing demand for data capacity, is no longer suitable to operate in localhost, need a central management unit to unified management, export mysqldump plus-T parameters accident report ma at this time only in CSV format limitations accident report ma of local operations can not meet the request. Demand began to turn to other methods to study a little percona tools pt-archive, found to meet our needs, began to use it, but found a problem in actual use, resulting in pt-archinve completely unusable, which is the speed problems. Comparison with mysqldump, pt-archive speed totally unacceptable, after the actual test, no arguments pt-archive is much slower than mysqldump belongs completely unusable accident report ma state.
time pt-archiver - source u = root, p =, h = localhost, S = / tmp/mysql10010.sock, D = gemini, t = table_definition_20130821 - no-delete - where "1 = 1" - no -check-charset - file = / data1/dbatemp/mysql10010/4.txt - statistics real 9m5.620s user 3m58.810s sys 0m38.124s
time pt-archiver - source u = root, p =, h = localhost, S = / tmp/mysql10010.sock, D = gemini, accident report ma t = table_definition_20130821 - no-delete - where "1 = 1" - no -check-charset - file = / data1/dbatemp/mysql10010/4.txt - limit = 1000 - statistics real 3m13.553s user 2m15.873s accident report ma sys 0m26.648s Action Count Time Pct commit 1065539 46.1518 23.86 print_file accident report ma 1065538 6.2581 3.24 select 1067 4.6308 2.39 other 0 136.3800 70.51
time pt-archiver - source u = root, p =, h = localhost, accident report ma S = / tmp/mysql10010.sock, D = gemini, t = table_definition_20130821 - no-delete - where "1 = 1" - no -check-charset - file = / data1/dbatemp/mysql10010/4.txt - limit = 1000 - txn-size = 1000 - statistics real 1m57.196s user 1m41.504s sys 0m10.627s Action Count Time Pct print_file 1065538 4.9122 4.19 select 1067 4.4760 3.82 commit 1066 0.1161 0.10 other 0 107.5997 91.88
time pt-archiver - source u = root, p =, h = localhost, S = / tmp/mysql10010.sock, D = gemini, t = table_definition_20130821 - no-delete - where "1 = 1" - no -check-charset - statistics - buffer accident report ma - limit = 10000 - commit-each - no-check-charset - primary-key-only - share-lock - file = / data1/dbatemp/mysql10010 / 12 txt Action Count Time Pct select 108 1.1020 1.94 commit 108 0.0358 0.06 flush 108 0.0009 0.00 print_file 1065538 -. 5.2057 - 9.18 other 0 60.7444 107.18 real 0m56.810s user 0m54.604s sys 0m0.629s