Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options for restore, if the directories are different from the data directory. Use, for example, the ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-show-status.html
show status show status --cluster|-c cluster_name show status --operation|-o cluster_name show status --backup|-b cluster_name show status --process|-r cluster_name show status --progress cluster_name show status --progressbar cluster_name This ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
The procedure takes parameters of all three types (IN, OUT, INOUT), displays their initial values, assigns new values, displays the updated values, and returns. The number of columns and the data types of the columns need not be the same for all ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
Declare the server-side plugin with the usual general descriptor format that is used for all server plugin types (see Section 4.4.2.1, “Server Plugin Library and Plugin Descriptors”). The auth_simple_handler member of the general descriptor ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-7.html
(WL #10528) X DevAPI: Consolidated the BaseSession, NodeSession, and XSession interfaces into a single com.mysql.cj.api.xdevapi.Session interface. Consolidated the AbstractSession, NodeSessionImpl, and XSessionImpl classes into the ... MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
Version 8.0.9 Release Candidate is the first release candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming features. (Bug #26748909) When working with MySQL Server 8.0, an update or delete statement for a ...It is ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-chat.html
The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by default. If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Isolate and tune any part of the query, such as a function call, that takes excessive time. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster because the results are retrieved from ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
FORMAT_PICO_TIME(time_val) Given a numeric Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. The string contains the decimal time rounded to ... MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-connections.html
These connections can be used in the modes where you created them, and one of them at a time can be assigned as MySQL Shell's global session so it can be used in all modes. Certain operations that open many connections to servers can take a long ...