PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
Except for events_statements_summary_by_digest, tt resets the summary columns to zero rather than removing rows. These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate ...When a connection terminates, the row in socket_summary_by_instance corresponding to it is ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total_latency The total wait time of timed statements for the host. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.html
These views summarize informaion about statements executed, grouped by host and statement type. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host ...By default, rows are sorted by host and descending total ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Today, MySQL Server and many other modern database systems offer a wide range of outer join types. MySQL Server supports multiple-table DELETE statements ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/channels-naming-conventions.html
Because channel names are used in replication metadata repositories, the character set used for these is always UTF-8. Although you are generally free to use any name for channels, the following names are reserved: group_replication_applier ... This ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
To detect this condition, you can set up a handler for it (or for a NOT FOUND condition). This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-server-id.html
You can use mysqlbinlog to request log files from a server in several ways: Specify an explicitly named set of files: For each file, mysqlbinlog connects and issues a Binlog dump command. Specify the beginning file and --to-last-log: mysqlbinlog ...