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/performance-schema-timing.html
The idle, stage, statement, and transaction timers use NANOSECOND on platforms where the NANOSECOND timer is available, MICROSECOND otherwise. If the processor runs at 1 GHz (one billion cycles/second) or higher, the cycle counter delivers ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
mysql> SELECT CONCAT_WS(',', 'First name', 'Second name', 'Last Name'); -> 'First name,Second name,Last Name' mysql> SELECT CONCAT_WS(',', 'First name', NULL, 'Last Name'); -> 'First name,Last Name' CONCAT_WS() does not skip empty strings. If the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
JSON_MERGE_PATCH(), when used on 2 JSON objects, merges them into a single JSON object that has as members a union of the following sets: Each member of the first object for which there is no member with the same key in the second object. Each ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
If the base DN is ou=Admin,dc=example,dc=com: Searches find user entries only in the second set. If the base DN is ou=dc=example,dc=com: Searches find user entries in the first or second set. authentication_ldap_sasl performs a second bind using the ...If FIDO authentication is attempted and this value is not the one expected by the FIDO device, the device assumes that it is not talking to the correct server and an error ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The first such query opens a 60-second window within which the server logs queries ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
DATETIME is packed more efficiently, requiring 5 rather than 8 bytes for the nonfractional part, and all three parts have a fractional part that requires from 0 to 3 bytes, depending on the fractional seconds precision of stored values. Fractional ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. Use NULL to collect data for the default of 60 seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) precision. For information about fractional seconds support in MySQL, see Section 13.2.6, “Fractional ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Statements that modify secondary passwords require these privileges: The APPLICATION_PASSWORD_ADMIN privilege is required to use the RETAIN CURRENT PASSWORD or DISCARD OLD PASSWORD clause for ALTER USER statements that apply to your own account. The ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...