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/sys-host-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the host. max_latency The maximum single wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html
total_latency The total wait time of timed occurrences of the statement event for the host. max_latency The maximum single wait time of timed occurrences of the statement event for the host. lock_latency The total time waiting for locks by timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the user. max_latency The maximum single wait time of timed statements for the user. lock_latency The total time waiting for locks by timed statements for the user. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
total_latency The total wait time of timed occurrences of the statement event for the user. max_latency The maximum single wait time of timed occurrences of the statement event for the user. lock_latency The total time waiting for locks by timed ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...
https://dev.mysql.com/doc/refman/8.0/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
As of MySQL 8.0.28, the argument to MATCH() cannot use a rollup column. For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. Full-text searches are supported for ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-flow-control.html
MySQL Group Replication ensures that a transaction commits only after a majority of the members in a group have received it and agreed on the relative order amongst all transactions sent concurrently. This approach works well if the total number of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. Example The following example uses the ins_sum trigger defined in Section 27.3, “Using Triggers”: mysql> SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE ...To see information about a table's triggers, you must have the TRIGGER privilege for the ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
If checksum mismatches are found, restore the tablespace from backup or start the server and attempt to use mysqldump to make a backup of the tables within the tablespace. To turn on verbose mode, run: innochecksum --verbose To turn off verbose ...