PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
The replication_connection_status table has these columns: CHANNEL_NAME The replication channel which this row is displaying. LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent I/O error took ... This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction queued in the relay log, and information on the transaction currently being queued in the relay ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
If not all threads are instrumented by the Performance Schema, this table misses some rows. The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System Variables”). System variable ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
No row has this value if the server was started with persisted_globals_load disabled. The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
Use row-based or mixed binary logging format instead, which do not create the temporary files. Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. You can purge these files ...
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
These are referred to as statement-based replication (SBR) or row-based replication (RBR). This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-json.html
For this reason, when replicating to such a server from a server running MySQL 8.0.3 or later, binlog_row_value_options must be disabled on the source by setting this variable to '' (empty string). Before MySQL 8.0, an update to a JSON column was ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql schema are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...