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/performance-schema-host-cache-table.html
The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a string. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-coordinator-table.html
An error number of 0 and message which is an empty string means “no error”. For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. For a multithreaded replica, the replication_applier_status_by_worker table shows the status of the worker ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
An error number of 0 and message of the empty string mean “no error”. If the replica is not multithreaded, this table shows the status of the applier thread. Otherwise, the replica uses multiple worker threads and a coordinator thread to manage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
An error number of 0 and message of the empty string mean “no error.” If the LAST_ERROR_MESSAGE value is not empty, the error values also appear in the replica's error log. This table shows the current status of the replication I/O thread that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
Longer instrument name strings take precedence over shorter pattern names, regardless of order. To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. Assuming that the Performance Schema is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
Statement events occur at a high level of the event hierarchy. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store statement events: ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Slave_SQL_Running_State: A string indicating the state of the SQL thread (analogous to Slave_IO_State). MySQL 5.7 supports delayed replication such that a replica server deliberately lags behind the source by at least a specified amount of time.
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
In that case, the values that you need to use later when specifying the source's log file and position are the empty string ('') and 4. To configure the replica to start the replication process at the correct point, you need to note the source's ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
This means that fields which display GTID sets, such as gtid_executed, gtid_purged, RECEIVED_TRANSACTION_SET in the replication_connection_status Performance Schema table, and the GTID related results of SHOW SLAVE STATUS, now return the empty ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. However, if you have the possibility to take the servers ...