Search Results
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/en/copying-databases.html
Check the description for the mysqldump --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 ... 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.4/en/create-procedure.html
The following example shows a simple stored procedure that, given a country code, counts the number of cities for that country that appear in the city table of the world database. This prohibition includes SELECT statements that do not have an INTO ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...