Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-metadata.html
Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/8.4/en/structured-system-variables.html
These rules may assume greater significance if some other type of structured variable is created in the future. (You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-temp-tables.html
memory_tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. disk_tmp_tables The total number of internal on-disk temporary tables created by occurrences of the statement. These views list ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
Workarounds for Locking Performance Issues The following items describe some ways to avoid or reduce contention caused by table locking: Consider switching the table to the InnoDB storage engine, either using CREATE TABLE ... You might have to ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use DROP FUNCTION to drop the loadable ... A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
When upgrading to MySQL 8.4.4 or later, it is recommended that you drop any spatial indexes beforehand, then re-create them after the upgrade is complete. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The output can be saved in a file and reloaded later using mysql to recreate the ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
The following functions permit the server's list of version tokens to be created, changed, removed, and inspected. If a token does not exist, it is created with the given value. The following discussion serves as a reference to these Version Tokens ...
https://dev.mysql.com/doc/refman/8.4/en/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward ...