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/show-procedure-code.html
Each row in the result set corresponds to one “instruction” in the routine. The final row contains an instruction jump 2, meaning GOTO instruction #2. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). innodb_buffer_rows_cached The total number of InnoDB cached rows for the table. These views summarize table statistics, including InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated table. For example, rows can be inserted by INSERT or LOAD DATA statements, and an insert trigger activates for each inserted row. For example, you ... A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
| +----------------------------------+ 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Warning Code: 42000 Message: Invalid version token pair encountered. 1 row in set ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
InnoDB has a maximum index length of 767 bytes for tables that use COMPACT or REDUNDANT row format, so for utf8mb3 or utf8mb4 columns, you can index a maximum of 255 or 191 characters, respectively. Tables created with these row formats enable you ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
If you really want rows sorted by the MySQL rule and secondarily by code point value, it is easy: ORDER BY s1 COLLATE utf32_unicode_ci, s1 COLLATE utf32_bin For supplementary characters based on UCA versions higher than 4.0.0 (for example, ... This ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Each row is compressed separately, so there is very little access overhead. The header for a row takes up one to three bytes depending on the biggest row in ...Compressed tables have the following characteristics: Compressed tables take very little disk ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
Suppose that table t1 contains a row where column1 = 5 and column2 = 6; meanwhile, table t2 contains a row where column1 = 5 and column2 = 7. This reflects the cardinality check that the optimizer performs as part of evaluating the JOIN or WHERE ...