PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...
https://dev.mysql.com/doc/refman/9.7/en/program-variables.html
For variables that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Many MySQL programs have internal variables that can be set at runtime using the SET statement. See ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
Between any of the decimal types DECIMAL, FLOAT, DOUBLE, and NUMERIC. Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-concepts.html
This example shows the GTID set stored in the gtid_executed system variable (@@GLOBAL.gtid_executed) of a replica that has applied transactions from more than one source: 2174B383-5441-11E8-B90A-C80AA9429562:1-3, ... A global transaction identifier ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
The server creates relay log files in sequence by adding a numeric suffix to the base name. replica_exec_mode Command-Line Format --replica-exec-mode=mode System Variable replica_exec_mode Scope Global Dynamic Yes SET_VAR Hint Applies No Type ...
https://dev.mysql.com/doc/refman/9.7/en/reset-binary-logs-and-gtids.html
RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions: Within prepared statements, LIMIT parameters can be specified using ? placeholder markers. SELECT [ALL | DISTINCT | DISTINCTROW ] ...
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
--check-table-functions=value Command-Line Format --check-table-functions=value Type Enumeration Default Value ABORT Valid Values WARNABORT When performing an upgade of the server, we scan the data dictionary for functions used in table constraints ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/9.7/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...