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/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 ...
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 ...