PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
Plugin activation states are visible in the LOAD_OPTION column of the Information Schema PLUGINS table. These can be identified as those that have a library name of NULL in the output from INFORMATION_SCHEMA.PLUGINS or SHOW PLUGINS. These can be ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Thread information available using the SHOW PROCESSLIST statement, the mysqladmin processlist command, the INFORMATION_SCHEMA.PROCESSLIST table, and the Performance Schema processlist table is accessible as follows: With the PROCESS privilege, a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. If the failing transaction generated an error in a worker thread, you can obtain its GTID directly ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
The ORIGINATOR column in the Information Schema EVENTS table and the originator column in mysql.event store this information. See Section 24.3.8, “The INFORMATION_SCHEMA EVENTS Table”, and Section 13.7.5.18, “SHOW EVENTS Statement”, for more ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
The heartbeat interval defaults to half the value of slave_net_timeout, and it is recorded in the replica's connection metadata repository and shown in the replication_connection_configuration Performance Schema table. The Performance Schema table ... This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
To see which plugins are installed, use the SHOW PLUGINS statement, or query the Information Schema PLUGINS table. To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Performance_schema_xxx Performance Schema status variables are listed in Section 25.16, “Performance Schema Status Variables”. The MySQL server maintains many status variables that provide information about its operation. You can view these ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION LEVEL WITH CONSISTENT SNAPSHOT Available Session State Trackers To support the session-tracking activities, notification is available for these types of ...A ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM ...Note The SHOW ...