Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The stored program definition cache partition exists in parallel with the stored procedure and stored function caches that are configured using the stored_program_cache option. The stored_program_cache option sets a soft upper limit for the number ... The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data Directory Initialization Post-Initialization root Password Assignment Data Directory Initialization Overview In the examples shown here, the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. ORDINAL_POSITION For successive parameters of a stored procedure or function, the ...The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
parameter_type_elements: Information about stored procedure and function parameters, and about return values for stored functions. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
Always fully test the recovery procedure for any partial backups to understand the relevant procedures and restrictions. Always fully test the recovery procedure for any partial backups to understand the relevant procedures and restrictions. By ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-next-result.html
int mysql_stmt_next_result(MYSQL_STMT *mysql) Description This function is used when you use prepared CALL statements to execute stored procedures, which can return multiple result sets. If a procedure has OUT or INOUT parameters, their values will ...Use a loop that calls mysql_stmt_next_result() to determine whether there are more ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-switchover.html
Follow the controlled switchover procedure if the primary cluster in an InnoDB ClusterSet deployment is functioning acceptably, but you need to carry out maintenance or fix some minor issues to improve the primary cluster's function. That procedure ... A controlled switchover makes a selected replica cluster into the primary cluster for the InnoDB ClusterSet ...
https://dev.mysql.com/doc/connectors/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...