mysqld and options Flashcards
mysqld reads options from
[mysqld] and [server] groups
mysqld_safe reads options from
the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups.
mysql.server reads options from
[mysqld] and [mysql.server] groups.
To assign a value to a server system variable
use an option of the form –var_name=value.
When you assign a value to a variable, MySQL might automatically correct the value to stay within a given range, or adjust the value to the closest permissible value if only certain values are permitted.
To restrict the maximum value to which a system variable
set at runtime with the SET statement, specify this maximum by using an option of the form –maximum-var_name=value at server startup.
Which option:
Displays a short help message and exit.
–help
Use both the –verbose and –help options to see the full message
Which option:
Controls whether loadable functions that have only an xxx symbol for the main function can be loaded.
–allow-suspicious-udfs[={OFF | ON}]
By default, the option is off and only loadable functions that have at least one auxiliary symbol can be loaded
Which option:
Enable standard (ANSI) SQL syntax instead of MySQL syntax.
–ansi
For more precise control over the server SQL mode, use the –sql-mode option instead.
Which option:
sets the basedir system variable.
- -basedir=dir_name
- b dir_name
Default Value: configuration-dependent default
Dynamic: No
Scope: Global
Which option:
creates the MySQL privilege tables without having to start a full MySQL server.
–bootstrap (deprecated)
This option is used by the mysql_install_db program.
–bootstrap is mutually exclusive with –daemonize, –initialize, and –initialize-insecure.
True or false:
mysql_install_db is deprecated because its functionality has been integrated into mysqld,
True
Which option:
initializes a MySQL installation
–initialize or –initialize-insecure
Which option:
Invokes do not ignore character set information sent by the client
–character-set-client-handshake[={OFF|ON}]
Default Value: ON
Which option:
Puts the mysqld server in a closed environment during startup by using the chroot() system call. This is a recommended security measure.
–chroot=dir_name
Use of this option somewhat limits LOAD DATA and SELECT … INTO OUTFILE.
Which option:
(Windows only.) Writes the error log to stderr and stdout (the console).
–console
–console takes precedence over –log-error if both are given.
Which 3 are the options for Windows OS only:
- -console
- -default-time-zone=name
- -install [service_name]
- -install-manual [service_name]
- -console
- -install [service_name]
- -install-manual [service_name]
Which 3 are the options for Windows OS only:
- -local-service
- -remove [service_name]
- -skip-stack-trace
- -standalone
- -local-service
- -remove [service_name]
- -standalone
Which option:
Writes a core file if mysqld dies.
–core-file[={OFF | ON}]
The name and location of the core file is system dependent.
Default Value: OFF
Which option:
Causes the server to run as a traditional, forking daemon, permitting it to work with operating systems that use systemd for process control.
–daemonize[={OFF | ON}]
–daemonize is mutually exclusive with –bootstrap, –initialize, and –initialize-insecure.
Which option:
sets the datadir system variable.
–datadir=dir_name
Dynamic: No
Scope: Global
Which option:
If MySQL is configured with the -DWITH_DEBUG=1 CMake option, you can use this option to get a trace file of what mysqld is doing.
–debug[=debug_options]
Dynamic: Yes Default Value (Unix) d:t:i:o,/tmp/mysqld.trace Default Value (Windows) d:t:i:O,\mysqld.trace
Which option:
Controls whether the Debug Sync facility for testing and debugging is enabled.
–debug-sync-timeout[=#]
Use of Debug Sync requires that MySQL be configured with the -DENABLE_DEBUG_SYNC=1 CMake option
Which option:
Sets the default server time zone. This option sets the global time_zone system variable.
–default-time-zone=name
If this option is not given, the default time zone is the same as the system time zone (given by the value of the system_time_zone system variable.
Which option:
Directs server to read this option file after the global option file but (on Unix) before the user option file.
–defaults-extra-file=file_name
Which option:
Directs server to read not only the usual option groups, but also groups with the usual names and a suffix of str.
–defaults-group-suffix=str
If this option is given as –defaults-group-suffix=_other, mysqld also reads the [mysqld_other] group.
Which option:
Directs server to read only the given option file.
–defaults-file=file_name
If file_name is not an absolute path name, it is interpreted relative to the current directory.
Which option:
Directs server to read the default DES keys from this file
–des-key-file=file_name
Deprecated: Yes
These keys are used by the DES_ENCRYPT() and DES_DECRYPT() functions.
Which option:
Disables the startup check for tables with nonnative partitioning.
–disable-partition-engine-check[={OFF | ON}]
Default Value: (≥ 5.7.21) ON
Default Value: (≥ 5.7.17, ≤ 5.7.20) OFF
Which option:
tells the server which plugins to load before loading mandatory built-in plugins and before storage engine initialization.
–early-plugin-load=plugin_list
The option value is a semicolon-separated list of plugin_library and name=plugin_library values.
If the server is started using –initialize or –initialize-insecure, plugins specified by –early-plugin-load are not loaded.
Default Value (≥ 5.7.12): empty string Default Value (5.7.11): keyring_file plugin library file name
Which option:
is a bitmask of different flags that you can use for debugging the mysqld server.
–exit-info[=flags]
Type: Integer
Which option:
Enables external locking (system locking), which is disabled by default.
–external-locking[={OFF | ON}]
Default Value OFF
If you use this option on a system on which lockd does not fully work (such as Linux), it is easy for mysqld to deadlock.
Which option:
Flushes (synchronize) all changes to disk after each SQL statement.
–flush[={OFF | ON}]
If –flush is specified, the value of flush_time does not matter and changes to flush_time have no effect on flush behavior.
Scope: Global
Dynamic Yes
Default Value OFF
Which option:
Installs an interrupt handler for SIGINT (needed to stop mysqld with ^C to set breakpoints) and disables stack tracing and core file handling
–gdb[={OFF | ON}]
Default Value OFF
Which option:
tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables.
–ignore-db-dir=dir_name
Deprecated 5.7.16
Which option:
initializes a MySQL installation by creating the data directory and populating the tables in the mysql system database.
–initialize[={OFF | ON}]
Default Value OFF
–initialize is mutually exclusive with –bootstrap and –daemonize.