PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
This section describes the privileges required to assign values to system variables at runtime. Setting a global system variable runtime value requires the SUPER privilege. To set a session system variable runtime value, use the SET SESSION ... A ...
https://dev.mysql.com/doc/refman/5.7/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a new row for that thread is added. The events_stages_history table contains the N most recent stage events that have ended per thread.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-table.html
When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a new row for that thread is added. The events_statements_history table contains the N most recent statement events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-table.html
When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a new row for that thread is added. The events_transactions_history table contains the N most recent transaction events that have ended ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-table.html
When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a new row for that thread is added. The events_waits_history table contains the N most recent wait events that have ended per thread.