1、备库备份报错 mydumper -u root-p xxxx--trx-consistency-only -B test -T t1,t2 -o /backup/mysql/`date +%F`** (mydumper:19792): WARNING **: Using trx_consistency_only, binlog coordinates will not be accurate if you are writing to non transactional tables.** (mydumper:19792): CRITICAL **: There are queries in PROCESSLIST running longer than 60s, aborting dump,use --long-query-guard to change the guard value, kill queries (--kill-long-queries) or use different server for dump2、解决方法添加一个-l 参数，设置足够大的值，可以顺利备份mydumper -u root-p xxx --trx-consistency-only -l 99999999 -B test -T t1,t2 -o /backup/mysql/`date +%F`3、帮助文件[mysql@roidb01 ~]$ mydumper --helpUsage:mydumper [OPTION...] multi-threaded MySQL dumpingHelp Options:-?, --helpShow help optionsApplication Options:-B, --databaseDatabase to dump-T, --tables-list Comma delimited table list to dump (does not exclude regex option)-O, --omit-from-fileFile containing a list of database.table entries to skip, one per line (skips before applying regex option)-o, --outputdir Directory to output files to-s, --statement-sizeAttempted size of INSERT statement in bytes, default 1000000-r, --rowsTry to split tables into chunks of this many rows. This option turns off --chunk-filesize-F, --chunk-filesizeSplit tables into chunks of this output file size. This value is in MB-c, --compressCompress output files-e, --build-empty-files Build dump files even if no data available from table-x, --regex Regular expression for 'db.table' matching-i, --ignore-enginesComma delimited list of storage engines to ignore-N, --insert-ignore Dump rows with INSERT IGNORE-m, --no-schemasDo not dump table schemas with the data-d, --no-data Do not dump table data-G, --triggersDump triggers-E, --eventsDump events-R, --routinesDump stored procedures and functions-W, --no-viewsDo not dump VIEWs-k, --no-locksDo not execute the temporary shared read lock.WARNING: This will cause inconsistent backups--no-backup-locks Do not use Percona backup locks--less-lockingMinimize locking time on InnoDB tables.**-l, --long-query-guardSet long query timer in seconds, default 60**-K, --kill-long-queries Kill long running queries (instead of aborting)-D, --daemonEnable daemon mode-I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60-L, --logfile Log file name to use, by default stdout is used--tz-utcSET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.--skip-tz-utc --use-savepointsUse savepoints to reduce metadata locking issues, needs SUPER privilege--success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn't exist--lock-all-tables Use LOCK TABLE for all, instead of FTWRL-U, --updated-since Use Update_time to dump only tables updated in the last U days--trx-consistency-onlyTransactional consistency only--complete-insert Use complete INSERT statements that include column names-h, --hostThe host to connect to-u, --userUsername with the necessary privileges-p, --passwordUser password-a, --ask-passwordPrompt For User password-P, --portTCP/IP port to connect to-S, --socketUNIX domain socket file to use for connection-t, --threads Number of threads to use, default 4-C, --compress-protocol Use compression on the MySQL connection-V, --version Show the program version and exit-v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2--defaults-file Use a specific defaults file--ssl Connect using SSL--key The path name to the key file--certThe path name to the certificate file--caThe path name to the certificate authority file--capathThe path name to a directory that contains trusted SSL CA certificates in PEM format--cipherA list of permissible ciphers to use for SSL encryption