PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...For ...A value of 0 signifies that there is no fractional ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timezone.html
For an explanation of MySQL Server's time zone settings, and how to change them, see Section 7.1.15, “MySQL Server Time Zone Support”. By default, source and replica servers assume that they are in the same time zone. If you are replicating ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-time.html
Note As of MySQL 8.0.16, format_time() is deprecated and subject to removal in a future MySQL version. Example mysql> SELECT sys.format_time(3501), sys.format_time(188732396662000); +-----------------------+----------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-instrument-default-timed.html
Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); +-----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf') | ... Returns YES or NO to ...
https://dev.mysql.com/doc/refman/8.0/en/timezone-problems.html
You can set the time zone for the server with the --timezone=timezone_name option to mysqld_safe. If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
For example, use these lines in the server option file: [mysqld] default_authentication_plugin=mysql_native_password That setting enables pre-8.0 clients to connect to 8.0 servers until such time as the clients and connectors in use at your ...Our ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
However, if the connect command is subsequently used at runtime and specifies a host name argument, that host name takes precedence over any --dns-srv-name option given at mysql startup to specify a DNS SRV record. However, if the connect command is ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
replica_net_timeout Command-Line Format --replica-net-timeout=# Introduced 8.0.26 System Variable replica_net_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 60 Minimum Value 1 Maximum Value 31536000 Unit seconds ...Many of the options can be set while the server is running by using the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL ... This section explains the server options and system variables that apply to replica ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
Environment variables which can be used to configure a MySQL instance are listed here: The boolean variables including MYSQL_RANDOM_ROOT_PASSWORD, MYSQL_ONETIME_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD, and MYSQL_LOG_CONSOLE are made true by setting ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
To set and persist each value at runtime rather than at startup, use these statements: SET PERSIST authentication_ldap_simple_server_host='127.0.0.1'; SET PERSIST authentication_ldap_simple_bind_base_dn='dc=example,dc=com'; SET PERSIST ... Note LDAP ...Security: Using TLS, connections to the LDAP server can be ...