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-cond-instances-table.html
The cond_instances table lists all the conditions seen by the Performance Schema while the server executes. A condition is a synchronization mechanism used in the code to signal that a specific event has happened, so that a thread waiting for this ...The cond_instances table has these columns: NAME The instrument name associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...The access is either shared (many threads can have a read lock at the same time), exclusive (only one thread can have a write lock at a given time), or shared-exclusive (a thread can have a write lock while permitting inconsistent reads by other ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-status-and-maintenance.html
The RESET QUERY CACHE statement removes all query results from the query cache. Every cached query requires a minimum of two blocks (one for the query text and one or more for the query results). The information provided by the Qcache_lowmem_prunes ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-statements-master.html
Section 13.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/replication-statements-replica.html
Section 13.4.1, “SQL Statements for Controlling Replication Source Servers”, discusses statements for managing source servers. For information about these statements, see Section 13.7.5.34, “SHOW SLAVE STATUS Statement”, and Section ...In ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
This means that the order is undefined for columns that are identical except for their case. You can force a case-sensitive sort for a column by using BINARY like so: ORDER BY BINARY col_name. You may have noticed in the preceding examples that the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io.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. ios The total number of file I/O events for the host. io_latency The total ...
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 ...