Movatterモバイル変換

--abort-on-error

Dump core on any fatal error; used for debugging only.

--ai-increment=#

For a table with a hidden primary key, specify the autoincrement increment, like theauto_increment_increment system variable does in the MySQL Server.

--ai-offset=#

For a table with hidden primary key, specify the autoincrement offset. Similar to theauto_increment_offset system variable.

--ai-prefetch-sz=#

For a table with a hidden primary key, specify the number of autoincrement values that are prefetched. Behaves like thendb_autoincrement_prefetch_sz system variable does in the MySQL Server.

--character-sets-dir

Directory containing character sets.

--connections=#

Number of cluster connections to create.

--connect-retries

Number of times to retry connection before giving up.

--connect-retry-delay

Number of seconds to wait between attempts to contact management server.

--connect-string

Same as--ndb-connectstring.

--continue

When a job fails, continue to the next job.

--core-file

Write core file on error; used in debugging.

--csvopt=string

Provides a shortcut method for setting typical CSV import options. The argument to this option is a string consisting of one or more of the following parameters:

The order of parameters used in the argument to this option is handled such that the rightmost parameter always takes precedence over any potentially conflicting parameters which have already been used in the same argument value. This also applies to any duplicate instances of a given parameter.

This option is intended for use in testing under conditions in which it is difficult to transmit escapes or quotation marks.

--db-workers=#

Number of threads, per data node, executing database operations.

--defaults-file

Read default options from given file only.

--defaults-extra-file

Read given file after global files are read.

--defaults-group-suffix

Also read groups with concat(group, suffix).

--errins-type=name

Error insert type; uselist as thename value to obtain all possible values. This option is used for testing purposes only.

--errins-delay=#

Error insert delay in milliseconds; random variation is added. This option is used for testing purposes only.

--fields-enclosed-by=char

This works in the same way as theFIELDS ENCLOSED BY option does for theLOAD DATA statement, specifying a character to be interpreted as quoting field values. For CSV input, this is the same as--fields-optionally-enclosed-by.

--fields-escaped-by=name

Specify an escape character in the same way as theFIELDS ESCAPED BY option does for the SQLLOAD DATA statement.

--fields-optionally-enclosed-by=char

This works in the same way as theFIELDS OPTIONALLY ENCLOSED BY option does for theLOAD DATA statement, specifying a character to be interpreted as optionally quoting field values. For CSV input, this is the same as--fields-enclosed-by.

--fields-terminated-by=char

This works in the same way as theFIELDS TERMINATED BY option does for theLOAD DATA statement, specifying a character to be interpreted as the field separator.

--help

Display help text and exit.

--idlesleep=#

Number of milliseconds to sleep waiting for more work to perform.

--idlespin=#

Number of times to retry before sleeping.

--ignore-lines=#

Cause ndb_import to ignore the first# lines of the input file. This can be employed to skip a file header that does not contain any data.

--input-type=name

Set the type of input type. The default iscsv;random is intended for testing purposes only. .

--input-workers=#

Set the number of threads processing input.

--keep-state

By default, ndb_import removes all state files (except non-empty*.rej files) when it completes a job. Specify this option (nor argument is required) to force the program to retain all state files instead.

--lines-terminated-by=name

This works in the same way as theLINES TERMINATED BY option does for theLOAD DATA statement, specifying a character to be interpreted as end-of-line.

--log-level=#

Performs internal logging at the given level. This option is intended primarily for internal and development use.

In debug builds of NDB only, the logging level can be set using this option to a maximum of 4.

--login-path

Read given path from login file.

--no-login-paths

Skips reading options from the login path file.

--max-rows=#

Import only this number of input data rows; the default is 0, which imports all rows.

--missing-ai-column

This option can be employed when importing a single table, or multiple tables. When used, it indicates that the CSV file being imported does not contain any values for anAUTO_INCREMENT column, and thatndb_import should supply them; if the option is used and theAUTO_INCREMENT column contains any values, the import operation cannot proceed.

--monitor=#

Periodically print the status of a running job if something has changed (status, rejected rows, temporary errors). Set to 0 to disable this reporting. Setting to 1 prints any change that is seen. Higher values reduce the frequency of this status reporting.

--ndb-connectstring

Set connection string for connecting tondb_mgmd. Syntax:[nodeid=id;][host=]hostname[:port]. Overrides entries inNDB_CONNECTSTRING andmy.cnf.

--ndb-mgm-tls

Sets the level of TLS support required to connect to the management server; one ofrelaxed orstrict.relaxed (the default) means that a TLS connection is attempted, but success is not required;strict means that TLS is required to connect.

--ndb-mgmd-host

Same as--ndb-connectstring.

--ndb-nodeid

Set node ID for this node, overriding any ID set by--ndb-connectstring.

--ndb-optimized-node-selection

Enable optimizations for selection of nodes for transactions. Enabled by default; use--skip-ndb-optimized-node-selection to disable.

--ndb-tls-search-path

Specify a list of directories to search for a CA file. On Unix platforms, the directory names are separated by colons (:); on Windows systems, the semicolon character (;) is used as the separator. A directory reference may be relative or absolute; it may contain one or more environment variables, each denoted by a prefixed dollar sign ($), and expanded prior to use.

Searching begins with the leftmost named directory and proceeds from left to right until a file is found. An empty string denotes an empty search path, which causes all searches to fail. A string consisting of a single dot (.) indicates that the search path limited to the current working directory.

If no search path is supplied, the compiled-in default value is used. This value depends on the platform used: On Windows, this is\ndb-tls; on other platforms (including Linux), it is$HOME/ndb-tls. This can be overridden by compiling NDB Cluster using-DWITH_NDB_TLS_SEARCH_PATH.

--no-asynch

Run database operations as batches, in single transactions.

--no-defaults

Do not read default options from any option file other than login file.

--no-hint

Do not use distribution key hinting to select a data node.

--opbatch=#

Set a limit on the number of operations (including blob operations), and thus the number of asynchronous transactions, per execution batch.

--opbytes=#

Set a limit on the number of bytes per execution batch. Use 0 for no limit.

--output-type=name

Set the output type.ndb is the default.null is used only for testing.

--output-workers=#

Set the number of threads processing output or relaying database operations.

--pagesize=#

Align I/O buffers to the given size.

--pagecnt=#

Set the size of I/O buffers as multiple of page size. The CSV input worker allocates buffer that is doubled in size.

--polltimeout=#

Set a timeout per poll for completed asynchronous transactions; polling continues until all polls are completed, or until an error occurs.

--print-defaults

Print program argument list and exit.

--rejects=#

Limit the number of rejected rows (rows with permanent errors) in the data load. The default is 0, which means that any rejected row causes a fatal error. Any rows causing the limit to be exceeded are added to the.rej file.

The limit imposed by this option is effective for the duration of the current run. A run restarted using--resume is considered a“new” run for this purpose.

--resume

If a job is aborted (due to a temporary db error or when interrupted by the user), resume with any rows not yet processed.

--rowbatch=#

Set a limit on the number of rows per row queue. Use 0 for no limit.

--rowbytes=#

Set a limit on the number of bytes per row queue. Use 0 for no limit.

--stats

Save information about options related to performance and other internal statistics in files named*.sto and*.stt. These files are always kept on successful completion (even if--keep-state is not also specified).

--state-dir=name

Where to write the state files (tbl_name.map,tbl_name.rej,tbl_name.res, andtbl_name.stt) produced by a run of the program; the default is the current directory.

--table=name

By default,ndb_import attempts to import data into a table whose name is the base name of the CSV file from which the data is being read. You can override the choice of table name by specifying it with the--table option (short form-t).

--tempdelay=#

Number of milliseconds to sleep between temporary errors.

--temperrors=#

Number of times a transaction can fail due to a temporary error, per execution batch. The default is 0, which means that any temporary error is fatal. Temporary errors do not cause any rows to be added to the.rej file.

--verbose,-v

Enable verbose output.

--usage

Display help text and exit; same as--help.

--version

Display version information and exit.