PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/subquery-optimization-with-exists.html
AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X when the “linked” outer expression oe_i is not NULL TRUE when the “linked” outer expression oe_i is NULL Note Trigger functions are ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. The MySQL installation procedure creates the time zone tables, but does not load them. This section describes the time ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This ...