Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
--plugin-authentication-webauthn-client-preserve-privacy={OFF|ON} Command-Line Format --plugin-authentication-webauthn-client-preserve-privacy Type Boolean Default Value OFF Determines how assertions are sent to server in case there is more than one ... 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.4/en/mysql-configurator-cli.html
lower-case-table-names N/A N/A list 0, 1, 2 1 configure N/A If set to 0, table names are stored as specified and comparisons are case-sensitive. If set to 1, table names are stored in lowercase on disk and comparisons are not case-sensitive. If set ... MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. HISTOGRAM: A JSON value describing the column statistics, stored as a histogram. Column ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
Store system tablespace files on Fusion-io devices You can take advantage of a doublewrite buffer-related I/O optimization by storing the files that contain the doublewrite storage area on Fusion-io devices that support atomic writes. If you follow ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
Take into account that the size of column values stored in the sort buffer is affected by the max_sort_length system variable value. For example, if tuples store values of long string columns and you increase the value of max_sort_length, the size ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
In other words, for a given expression expr, the partition in which the record is stored is partition number N, where N = MOD(expr, num). Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
The LOGGED column stores values using the TIMESTAMP data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”. This enables a server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE For nested statements ...Of ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
Pluggable authentication makes it possible for clients to connect to the MySQL server with credentials appropriate for authentication methods that store credentials elsewhere than in the mysql.user system table. Use cases for this plugin include ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating ...The encryption algorithm used for the files, the AES (Advanced Encryption Standard) cipher algorithm, is built in to MySQL Server and cannot be ...