PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-latest-file-io.html
The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections). For background threads, the thread name and thread ID file The file ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-host-by-latency.html
total The total number of occurrences of the event for the host. total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the host. max_latency The ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
It may occur for temporary tables created outside stored functions and referred to across multiple calling and callee functions. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). Sending the signal enables the flush operations to be performed without having to connect ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END statement. For an IDLE XA transaction, you can issue either an XA PREPARE statement or an XA COMMIT ... For a PREPARED XA transaction, you ... An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The purge operation can write disk blocks for a series of index values more efficiently than if each value were written to disk immediately. During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. The ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. IS_DEFAULT Whether the collation is the default for its character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated.
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. The SAVEPOINT statement ...The ROLLBACK TO SAVEPOINT statement rolls back a transaction to the named savepoint without terminating the ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
Following each set of rows for a given year, an extra super-aggregate summary row appears showing the total for all countries and products. For any column in the result set with a name that matches any of those names, its value is set to NULL. For ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...