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/internals/en/not-so-fast-path.html
server uses mysql_native_password as default: 4d 00 00 00 0a 35 2e 36 2e 37 2d 6c 6f 67 00 01 M....5.6.7-log.. If the servers default auth method doesn't match the clients or accounts auth method a extra round is needed as usual. server sends ...00 ...
https://dev.mysql.com/doc/refman/8.4/en/audit-api-message-emit.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the audit_api_message_emit component, use this statement: UNINSTALL COMPONENT ...Installing or Uninstalling the Audit Message Component Audit Message Function Installing or Uninstalling the Audit Message Component To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
Character set issues affect not only data storage, but also communication between client programs and the MySQL server. If you want the client program to communicate with the server using a character set different from the default, you need to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
By default, MySQL retrieves cached values for those columns from the mysql.index_stats and mysql.innodb_table_stats dictionary tables when the columns are queried, which is more efficient than retrieving statistics directly from the storage engine.
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
To avoid the problem if you have modified the minimum or maximum word length or the stopword file in the server, specify the same ft_min_word_len, ft_max_word_len, and ft_stopword_file values to myisamchk that you use for mysqld. This option is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logging-management-commands.html
In the listing that follows, node_id denotes either a storage node ID or the keyword ALL, which indicates that the command should be applied to all of the cluster's data nodes. This means that, in an NDB Cluster with multiple management servers, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache table has these columns: IP The IP address of the client that ...The ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
Telling the server to ignore the .MYI file makes important table metadata stored in the .MYI unavailable to the repair process, which can have deleterious consequences: The current AUTO_INCREMENT value is lost. If you use USE_FRM for a table that ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables. (By ...To minimize the problem with multiple client sessions having different states on the same table, the table is opened independently by each concurrent ...