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/replication-channels.html
For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to monitor multi-source replication, see Section 16.1.5, “MySQL Multi-Source Replication”. This channel is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...The ...For a compressed InnoDB table, both the table data and all the secondary indexes are ...In this context, the table data is ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
Thus, for any other region, this variable must be set explicitly. (It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format ...These ...
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/security-plugins.html
A password-validation plugin for implementing password strength policies and assessing the strength of potential passwords. MySQL includes several plugins that implement security features: Plugins for authenticating attempts by clients to connect ...(MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to output lines o,/tmp/mysqld.trace, O,\mysqld.trace: Set the debug output file. Here are some example debug control strings as they ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the result is S1 + S2: mysql> SELECT .01 * .01; +-----------+ | .01 * .01 | +-----------+ | 0.0001 | +-----------+ Example 3. Rounding behavior for exact-value numbers is ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. If the directory specified does not exist, NDB attempts to create it; the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. If slave_parallel_type is set to DATABASE (rather than ... On a ...
https://dev.mysql.com/doc/refman/5.7/en/not-enough-file-handles.html
There is also a “hard” limit that can be overridden only if you start mysqld_safe or mysqld as root (just remember that you also need to start the server with the --user option in this case so that it does not continue to run as root after it ...