mysql有parallel模式吗_Mysql管理必备工具Maatkit详解之十（mk-parallel-restore）

mk-parallel-restore --help

mk-parallel-restore loads files into MySQL in parallel. For more details,

please use the --help option, or try 'perldoc mk-parallel-restore' for complete

documentation.

Usage: mk-parallel-restore PATH [PATH...]

Options:

--askpass Prompt for a password when connecting to MySQL

--[no]atomicresume Treat chunks as atomic when resuming restore (default

yes)

--basedir Directory where FIFO files will be created

--[no]biggestfirst Restore the biggest tables first for highest concurrency

(default yes)

--binlog Set SQL_LOG_BIN to 1 or 0 to enable or disable binary

logging (default 1)

--bulkinsbufsize Set bulk_insert_buffer_size before each LOAD DATA INFILE

--charset -A Sets the connection, database, and LOAD DATA INFILE

character set (default BINARY)

--commit Commit after each load via LOAD DATA INFILE

--createdb Create databases if they don't exist

--csv Files are in CSV format (implies --tab)

--database -D Load all files into this database

--databases -d Restore only this comma-separated list of databases

--dbregex Restore only databases whose names match this regex

--decompress Command used to decompress and print .gz files to STDOUT

(like zcat). (default gzip -d -c)

--defaults-file -F Only read mysql options from the given file. You must

give an absolute pathname.

--[no]disablekeys Execute ALTER TABLE DISABLE KEYS before each table

--[no]fifo Stream files into a FIFO for --tab (default yes)

--help Show this help message

--host -h Connect to host

--ignore -i Adds the IGNORE modifier to LOAD DATA INFILE

--ignoredb -g Ignore this comma-separated list of databases

--ignoretbl -n Ignore this comma-separated list of table names

--local -L Uses the LOCAL option to LOAD DATA INFILE

--[no]locktables Lock tables before LOAD DATA INFILE

--[no]noautovalon0 Set SQL NO_AUTO_VALUE_ON_ZERO before LOAD DATA INFILE

--[no]noforeignkeys Set FOREIGN_KEY_CHECKS=0 before LOAD DATA INFILE

--noresume Do not resume restore

--[no]nouniquechecks Set UNIQUE_CHECKS=0 before LOAD DATA INFILE

--numthread -m Specifies the number of parallel processes to run

--password -p Password to use when connecting

--port -P Port number to use for connection

--progress Display progress messages

--quiet -q Sets --verbose to 0

--replace -r Adds the REPLACE modifier to LOAD DATA INFILE

--setvars Set these MySQL variables (default wait_timeout=10000)

--socket -S Socket file to use for connection

--tab -T Load tab-separated files with LOAD DATA INFILE

--tables -t Restore only this comma-separated list of table names

--tblregex Restore only tables whose names match this regex

--test Print commands instead of executing them

--truncate Run TRUNCATE TABLE before LOAD DATA INFILE

--umask Set the program's umask to this octal value

--user -u User for login if not current user

--verbose -v Verbosity; can specify multiple times (default 1)

--version Output version information and exit

--wait -w Wait limit when server is down (default 5m). Optional

suffix s=seconds, m=minutes, h=hours, d=days; if no

suffix, s is used.

Options and values after processing arguments:

--askpass FALSE

--atomicresume TRUE

--basedir /root/cron

--biggestfirst TRUE

--binlog 1

--bulkinsbufsize (No value)

--charset BINARY

--commit FALSE

--createdb FALSE

--csv FALSE

--database (No value)

--databases (No value)

--dbregex (No value)

--decompress gzip -d -c

--defaults-file (No value)

--disablekeys FALSE

--fifo TRUE

--help TRUE

--host (No value)

--ignore FALSE

--ignoredb

--ignoretbl

--local FALSE

--locktables FALSE

--noautovalon0 FALSE

--noforeignkeys FALSE

--noresume FALSE

--nouniquechecks FALSE

--numthread 4

--password (No value)

--port (No value)

--progress FALSE

--quiet FALSE

--replace FALSE

--setvars wait_timeout=10000

--socket (No value)

--tab FALSE

--tables (No value)

--tblregex (No value)

--test FALSE

--truncate FALSE

--umask 0

--user (No value)

--verbose 1

--version FALSE

--wait 300