PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.0Kb
Man Pages (Zip)
- 367.6Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Another way to control the optimizer is by using optimizer hints, which can be specified within individual statements. Because optimizer hints apply on a per-statement basis, they provide finer control over statement execution plans than can be ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 10.9.3, “Optimizer Hints”. (For the general syntax for specifying ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
admin_address Command-Line Format --admin-address=addr System Variable admin_address Scope Global Dynamic No SET_VAR Hint Applies No Type String The IP address on which to listen for TCP/IP connections on the administrative network interface (see ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
InnoDB System Variables innodb_adaptive_flushing Command-Line Format --innodb-adaptive-flushing[={OFF|ON}] System Variable innodb_adaptive_flushing Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Specifies whether to ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
(It is neither necessary nor desirable to use this option together with --initialize.) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] System Variable ndb_allow_copying_alter_table Scope ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
--max-relay-log-size=size Command-Line Format --max-relay-log-size=# System Variable max_relay_log_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 1073741824 Unit bytes Block Size 4096 ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
--log-bin-index[=file_name] Command-Line Format --log-bin-index=file_name System Variable log_bin_index Scope Global Dynamic No SET_VAR Hint Applies No Type File name The name for the binary log index file, which contains the names of the binary log ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
authentication_kerberos_service_principal Command-Line Format --authentication-kerberos-service-principal=name System Variable authentication_kerberos_service_principal Scope Global Dynamic Yes SET_VAR Hint Applies No Type String Default Value ...