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/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
In the name caching_sha2_password, “sha2” refers more generally to the SHA-2 class of encryption algorithms, of which 256-bit encryption is one instance. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html
row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
The allocation algorithm reserves memory in large amounts to reduce the number of allocation operations. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
The difference in statistics, which is not expected to affect workload performance, is due to the different algorithm used to populate the index. InnoDB performs a bulk load instead of inserting one index record at a time when creating or ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
-DWITH_ZSTD=zstd_type Connection compression using the zstd algorithm (see Section 6.2.8, “Connection Compression Control”) requires that the server be built with zstd library support. The CMake program provides a great deal of control over how ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
The string might be shorter than max_length characters because the algorithm that creates the geohash value continues until it has created a string that is either an exact representation of the location or max_length characters, whichever comes ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
For details about internal representation of temporal values, see MySQL Internals: Important Algorithms and Structures. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
DDL operations that rebuild the table and are not performed online using the ALGORITHM=INPLACE technique create a temporary copy of the original table in the same directory as the original table. On Unix, MySQL uses the value of the TMPDIR ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
Passwords stored in the user table are encrypted using plugin-specific algorithms. MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user ...