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/caching-sha2-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. On the other hand, requesting the public key from the server is more convenient (it requires no management of a client-side file) and may be acceptable in secure network ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
The table shown at https://msdn.microsoft.com/en-us/goglobal/cc305152.aspx provides information about the Unicode values of cp932 characters. For cp932 table entries with characters under which a four-digit number appears, the number represents the ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and unloading, and also registers loaded components in the mysql.component ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. For small numbers of tables (typically less than 7 to 10) this is not a problem. The behavior of ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
Check the description for mysqldump's --set-gtid-purged option to find what happens with the versions you are using, and how to change the behavior if the outcome of the default behavior is not suitable for your situation. For large tables, this is ... In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
The tablespace_definition_cache option sets a limit for the number of tablespace definition objects that can be stored in the dictionary object cache. The table definition cache partition exists in parallel with the table definition cache that is ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in the mysql database together with non-data dictionary system tables. Data dictionary tables are created in a single InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Suppose that a customer table containing customer records has these columns: id: Customer ID number. Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all rows from a MyISAM table, TRUNCATE TABLE tbl_name is faster than DELETE FROM tbl_name. Truncate operations are not ...To ...