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/information-schema-innodb-sys-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. NAME The name of the table, preceded by the schema (database) name where appropriate (for example, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary logging. For a description of the rules that servers use in evaluating these options, see Section ...You ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
| +-----------------------------------------------------------------+ 1 row in set (9.17 sec) +------------------------------------------+-----------+ | event_name | latency | +------------------------------------------+-----------+ | stage/sql/init ... Traces all Performance Schema instrumentation for a specific statement ...This procedure disables binary logging during its ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits version tokens to be locked and unlocked. Interpretation of name_list and token_list arguments (including whitespace ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), MASTER_POS_WAIT(), PASSWORD(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and UUID_SHORT().
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. With ...The ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. (See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have ...The restrictions for stored procedures also apply to the DO clause of Event Scheduler event ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
Then either explicitly take a backup or wait for the next iteration of any periodic backup routine you may have set up. If you want to set enforce_gtid_consistency=OFF, you can do so now. After setting it, you should add enforce_gtid_consistency=OFF ...The only thing that differs is the point at which you wait for logged transactions to ...