https://dev.mysql.com/setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. row *************************** NAME: ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/mysqlbinlog.html
For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so forth. For example: # at 141 #100309 9:28:36 ...
https://dev.mysql.com/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/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 24.4, “Using the Event ...
https://dev.mysql.com/replication-options-reference.html
gtid_executed_compression_period: Compress gtid_executed table each time this many transactions have occurred. Slave_received_heartbeats: Number of heartbeats received by a replication slave since previous reset Slave_retried_transactions: The total ... The following two lists provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/events-metadata.html
Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the server's global time_zone value when the session begins but may be changed during the session.
https://dev.mysql.com/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. The ...
https://dev.mysql.com/server-options.html
However, in most cases it is desirable to make sure that the server uses the same options each time it runs. These can be displayed at runtime using the SHOW VARIABLES statement. To restrict the maximum value to which a system variable can be set at ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/events-waits-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
