Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. INSERT INTO t1 VALUES (4), (5), (6); -- Write to transactional table -- Transaction 2 START (implicit) 9. From the perspective of the Performance Schema, Transaction 2 starts ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
To reload a table, first change location into the output directory. For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
If you have a repeatable test case that demonstrates the bug, please enter it into our bugs database using the instructions given in Section 1.6, “How to Report Bugs or Problems”. In this case, the replication thread stops and waits for you to ... When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
INTO OUTFILE do not overwrite existing files and are writable by everyone. With this privilege, you can read any file into a database table. This could be abused, for example, by using LOAD DATA to load /etc/passwd into a table, which then can be ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
For binary or case-sensitive collations, lettercase is taken into account when assigning values to the column. For example, you can retrieve numeric values from a SET column like this: mysql> SELECT set_col+0 FROM tbl_name; If a number is stored ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
In the third and final phase, the sorted entries are inserted into the B-tree; this final phase is multithreaded. Prior to the introduction of sorted index builds, index entries were inserted into the B-tree one record at a time using insert APIs.
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... INTO var_list or by opening a cursor and using FETCH ... System variables and user-defined variables can be used in stored programs, just as they can be used outside ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
CHAR() arguments larger than 255 are converted into multiple result bytes. A newline is added after each 76 characters of encoded output to divide long output into multiple lines. For example, '41' is stored into a CHAR(3) column as '41 ' and ...For ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
To load the time zone tables from the command line, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program. To use an SQL-statement time zone package that you have downloaded, unpack it, then load the ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...