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/telemetry-metrics-meter-metrics.html
table_locks_immediate Table_locks_immediate ASYNC COUNTER The number of times that a request for a table lock could be granted immediately table_locks_waited Table_locks_waited ASYNC COUNTER The number of times that a request for a table lock could ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics mysql.mle Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-status-variables.html
Gr_all_consensus_time_sum The total elapsed time for all consensus rounds started and finished on this node. By comparing this value with Gr_all_consensus_proposals_count, we can determine whether a given consensus time has an upward trend, which ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. The following table lists each built-in (native) function and operator and provides a short description of each one. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. Only the most recent report for any given node is shown. The restart_info table contains the following columns: node_id Node ID ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton FLAGS: NULL VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. row ... The ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> ... Important The audit_log plugin is deprecated, and is being replaced by the audit_log ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EVENT_TYPE The event repetition type, either ONE TIME (transient) or RECURRING (repeating). EXECUTE_AT For a ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.5, “Using the Event ...
https://dev.mysql.com/doc/refman/9.7/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
To specify more than one database, use this option multiple times, once for each database; however, doing so does not replicate cross-database statements such as UPDATE some_db.some_table SET foo='bar' while a different database (or no database) is ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-reference.html
The position is given as a timestamp and the read starts from the first event that occurs on or after the timestamp value. The start item has this format, where value is a literal timestamp value: "start": { "timestamp": "value" } timestamp, id: The ...Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account ...