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/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled-consumers.html
Example mysql> CALL sys.ps_setup_show_enabled_consumers(); +---------------------------+ | enabled_consumers | +---------------------------+ | events_statements_current | | events_statements_history | | global_instrumentation | | statements_digest | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html
On the source, you can check the status of connected replicas using SHOW PROCESSLIST to examine the list of running processes. Replica connections have Binlog Dump in the Command field: mysql> SHOW PROCESSLIST \G; *************************** 4. The ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
The text of a running CHANGE MASTER TO statement, including values for MASTER_USER and MASTER_PASSWORD, can be seen in the output of a concurrent SHOW PROCESSLIST statement. (The complete text of a START SLAVE statement is also visible to SHOW ...It ...] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the replication source server, for reading the source's binary log, and reading the replica's relay ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
(This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds displayed for the replication SQL thread is the number of seconds between the timestamp of the last replicated event and the real ...How do I know how late a replica is compared to the source? In other words, how do I know the date of the last statement replicated by the replica? Check the Seconds_Behind_Master column in the output from SHOW REPLICA | SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Example: "class": "connection" The following table shows the permitted combinations of class and event values. Example: "general_data": { "command": "Query", "sql_command": "show_variables", "query": "SHOW VARIABLES", "status": 0 } id An unsigned ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
The value returned by CONNECTION_ID() is the same type of value as displayed in the ID column of the Information Schema PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads ...