Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
row *************************** LOGGED: 2020-08-06 09:25:00.363521 THREAD_ID: 1 PRIO: System ERROR_CODE: MY-013576 SUBSYSTEM: InnoDB DATA: InnoDB initialization has started. Of the logs the MySQL server maintains, one is the error log to which it ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
For SQL statements, the EVENT_NAME value initially is statement/com/Query until the statement is parsed, then changes to a more appropriate value, as described in Section 29.12.6, “Performance Schema Statement Event Tables”. The table stores one ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
MySQL does not perform matching of Host column values in the mysql.user system table against host names for which one or more of the initial components of the name are entirely numeric, such as 1.2.example.com. The MySQL server maintains an ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-options.html
Runtime configuration is also possible in many cases (see Section 29.4, “Performance Schema Runtime Configuration”), but startup configuration must be used when runtime configuration is too late to affect instruments that have already been ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-performance-timers-table.html
The Performance Schema determines this value by invoking the timer 20 times during initialization and picking the smallest value. For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Possible overhead from the instrumentation itself (namely, mutex initialization) has no effect for this instrument then. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: reads METER: mysql.inno.data METRIC_TYPE: ASYNC COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: Number of reads initiated (innodb_data_reads) ... The setup_metrics table lists the available metrics: mysql> select ...