(mysql.info)Command-line options

mysqld Command-line Options

---------------------------

`mysqld' accepts the following command-line options:

`--ansi'

     Use ANSI SQL syntax instead of MySQL syntax.  Note: ANSI mode.

`-b, --basedir=path'

     Path to installation directory. All paths are usually resolved

     relative to this.

`--big-tables'

     Allow big result sets by saving all temporary sets on file.  It

     solves most 'table full' errors, but also slows down the queries

     where in-memory tables would suffice.  Since Version 3.23.2, MySQL

     is able to solve it automatically by using memory for small

     temporary tables and switching to disk tables where necessary.

`--bind-address=IP'

     IP address to bind to.

`--character-sets-dir=path'

     Directory where character sets are.  Note: Character sets.

`--chroot=path'

     Chroot `mysqld' daemon during startup.  Recommended security

     measure. It will somewhat limit `LOAD DATA INFILE' and `SELECT ...

     INTO OUTFILE' though.

`--core-file'

     Write a core file if `mysqld' dies.  For some systems you must also

     specify `--core-file-size' to `safe_mysqld'. *Note `safe_mysqld':

     safe_mysqld.

`-h, --datadir=path'

     Path to the database root.

`--default-character-set=charset'

     Set the default character set.  Note: Character sets.

`--default-table-type=type'

     Set the default table type for tables.  Note: Table types.

`--debug[...]='

     If MySQL is configured with `--with-debug', you can use this

     option to get a trace file of what `mysqld' is doing.  Note:

     Making trace files.

`--delay-key-write-for-all-tables'

     Don't flush key buffers between writes for any `MyISAM' table.

     Note: Server parameters.

`--enable-locking'

     Enable system locking.  Note that if you use this option on a

     system which a not fully working lockd() (as on Linux) you will

     easily get mysqld to deadlock.

`--enable-named-pipe'

     Enable support for named pipes (only on NT/Win2000/XP).

`-T, --exit-info'

     This is a bit mask of different flags one can use for debugging the

     mysqld server;  One should not use this option if one doesn't know

     exactly what it does!

`--flush'

     Flush all changes to disk after each SQL command.  Normally MySQL

     only does a write of all changes to disk after each SQL command

     and lets the operating system handle the syncing to disk.  Note:

     Crashing.

`-?, --help'

     Display short help and exit.

`--init-file=file'

     Read SQL commands from this file at startup.

`-L, --language=...'

     Client error messages in given language.  May be given as a full

     path.  Note: Languages.

`-l, --log[=file]'

     Log connections and queries to file. Note: Query log.

`--log-isam[=file]'

     Log all ISAM/MyISAM changes to file (only used when debugging

     ISAM/MyISAM).

`--log-slow-queries[=file]'

     Log all queries that have taken more than `long_query_time'

     seconds to execute to file.  Note: Slow query log.

`--log-update[=file]'

     Log updates to `file.#' where `#' is a unique number if not given.

     Note: Update log.

`--log-long-format'

     Log some extra information to update log.  If you are using

     `--log-slow-queries' then queries that are not using indexes are

     logged to the slow query log.

`--low-priority-updates'

     Table-modifying operations (`INSERT'/`DELETE'/`UPDATE') will have

     lower priority than selects.  It can also be done via `{INSERT |

     REPLACE | UPDATE | DELETE} LOW_PRIORITY ...' to lower the priority

     of only one query, or by `SET OPTION SQL_LOW_PRIORITY_UPDATES=1'

     to change the priority in one thread.  Note: Table locking.

`--memlock'

     Lock the `mysqld' process in memory.  This works only if your

     system supports the `mlockall()' system call (like Solaris).  This

     may help if you have a problem where the operating system is

     causing `mysqld' to swap on disk.

`--myisam-recover [=option[,option...]]] where option is any combination'

     of `DEFAULT', `BACKUP', `FORCE' or `QUICK'.  You can also set this

     explicitely to `""' if you want to disable this option. If this

     option is used, `mysqld' will on open check if the table is marked

     as crashed or if if the table wasn't closed properly.  (The last

     option only works if you are running with `--skip-locking').  If

     this is the case `mysqld' will run check on the table. If the

     table was corrupted, `mysqld' will attempt to repair it.

     The following options affects how the repair works.

     DEFAULT              The same as not giving any option to

                                   `--myisam-recover'.

     BACKUP               If the data table was changed during recover,

                          save a                     backup of the

                          `table_name.MYD' data file as

                            `table_name-datetime.BAK'.

     FORCE                Run recover even if we will loose more than

                          one row                     from the .MYD file.

     QUICK                Don't check the rows in the table if there

                          isn't any                     delete blocks.

     Before a table is automatically repaired, MySQL will add a note

     about this in the error log.  If you want to be able to recover

     from most things without user intervention, you should use the

     options `BACKUP,FORCE'.  This will force a repair of a table even

     if some rows would be deleted, but it will keep the old data file

     as a backup so that you can later examine what happened.

`--pid-file=path'

     Path to pid file used by `safe_mysqld'.

`-P, --port=...'

     Port number to listen for TCP/IP connections.

`-o, --old-protocol'

     Use the 3.20 protocol for compatibility with some very old clients.

     *Note Upgrading-from-3.20::.

`--one-thread'

     Only use one thread (for debugging under Linux).  Note: Debugging

     server.

`-O, --set-variable var=option'

     Give a variable a value. `--help' lists variables.  You can find a

     full description for all variables in the `SHOW VARIABLES' section

     in this manual.  Note: SHOW VARIABLES.  The tuning server

     parameters section includes information of how to optimize these.

     Note: Server parameters.

`--safe-mode'

     Skip some optimize stages.  Implies `--skip-delay-key-write'.

`--safe-show-database'

     Don't show databases for which the user doesn't have any

     privileges.

`--safe-user-create'

     If this is enabled, a user can't create new users with the GRANT

     command, if the user doesn't have `INSERT' privilege to the

     `mysql.user' table or any column in this table.

`--skip-concurrent-insert'

     Turn off the ability to select and insert at the same time on

     `MyISAM' tables. (This is only to be used if you think you have

     found a bug in this feature).

`--skip-delay-key-write'

     Ignore the `delay_key_write' option for all tables.  Note: Server

     parameters.

`--skip-grant-tables'

     This option causes the server not to use the privilege system at

     all.  This gives everyone _full access_ to all databases!  (You

     can tell a running server to start using the grant tables again by

     executing `mysqladmin flush-privileges' or `mysqladmin reload'.)

`--skip-host-cache'

     Never use host name cache for faster name-ip resolution, but query

     DNS server on every connect instead.  Note: DNS.

`--skip-locking'

     Don't use system locking.  To use `isamchk' or `myisamchk' you must

     shut down the server.  Note: Stability.  Note that in MySQL

     Version 3.23 you can use `REPAIR' and `CHECK' to repair/check

     `MyISAM' tables.

`--skip-name-resolve'

     Hostnames are not resolved.  All `Host' column values in the grant

     tables must be IP numbers or `localhost'.  Note: DNS.

`--skip-networking'

     Don't listen for TCP/IP connections at all.  All interaction with

     `mysqld' must be made via Unix sockets.  This option is highly

     recommended for systems where only local requests are allowed.

     Note: DNS.

`--skip-new'

     Don't use new, possible wrong routines.  Implies

     `--skip-delay-key-write'.  This will also set default table type

     to `ISAM'.  Note: ISAM.

`--skip-symlink'

     Don't delete or rename files that a symlinked file in the data

     directory points to.

`--skip-safemalloc'

     If MySQL is configured with `--with-debug=full', all programs will

     check the memory for overruns for every memory allocation and

     memory freeing.  As this checking is very slow, you can avoid

     this, when you don't need memory checking, by using this option.

`--skip-show-database'

     Don't allow 'SHOW DATABASE' commands, unless the user has *process*

     privilege.

`--skip-stack-trace'

     Don't write stack traces.  This option is useful when you are

     running `mysqld' under a debugger. Note: Debugging server.

`--skip-thread-priority'

     Disable using thread priorities for faster response time.

`--socket=path'

     Socket file to use for local connections instead of default

     `/tmp/mysql.sock'.

`--sql-mode=option[,option[,option...]]'

     Option can be any combination of: `REAL_AS_FLOAT',

     `PIPES_AS_CONCAT', `ANSI_QUOTES', `IGNORE_SPACE', `SERIALIZE',

     `ONLY_FULL_GROUP_BY'.  It can also be empty (`""') if you want to

     reset this.

     By specifying all of the above options is same as using -ansi.

     With this option one can turn on only needed SQL modes. Note: ANSI

     mode.

`transaction-isolation= { READ-UNCOMMITTED | READ-COMMITTED | REPEATABLE-READ | SERIALIZABLE }'

     Sets the default transaction isolation level.  Note: SET

     TRANSACTION.

`-t, --tmpdir=path'

     Path for temporary files. It may be useful if your default `/tmp'

     directory resides on a partition too small to hold temporary

     tables.

`-u, --user=user_name'

     Run `mysqld' daemon as user `user_name'.  This option is

     _mandatory_ when starting `mysqld' as root.

`-V, --version'

     Output version information and exit.

`-W, --warnings'

     Print out warnings like `Aborted connection...' to the `.err' file.

     Note: Communication errors.