PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/en/replication-binlog-encryption.html
From MySQL 8.0.14, 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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
The information required for recovery is stored in the replica's applier metadata repository. Set relay_log_info_repository = TABLE, which stores the replication SQL thread position in the InnoDB table mysql.slave_relay_log_info, and updates it ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
Encryption helps 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 system where they are stored. Stored programs and ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
Instead, use SHA2() or some other one-way hashing function and store the hash value. That does not mean the combination needs to be a random string of characters that is difficult to remember and reproduce, although this is a good approach if you ...