Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
For example, for the following SQL statement, the name of the prepared statement is stmt: PREPARE stmt FROM 'SELECT 1'; SQL_TEXT The prepared statement text, with ? placeholder markers. These columns can be used to find stored programs that leak ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. If needed, these values can be obtained from the process list ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). The setup_actors table contains information that determines whether to enable monitoring and historical event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
Example statement event summary information: mysql> SELECT * FROM performance_schema.events_statements_summary_global_by_event_name\G *************************** 1. The Performance Schema maintains tables for collecting current and recent statement ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination), based on the ENABLED and HISTORY column values: When the best match is a row with ENABLED=YES, the INSTRUMENTED ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
For display when events are retrieved from Performance Schema tables, times are shown in picoseconds (trillionths of a second) to normalize them to a standard unit, regardless of which timer is selected. Events are collected by means of ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
The privilege SENSITIVE_VARIABLES_OBSERVER allows a holder to view the values of sensitive system variables in the Performance Schema tables global_variables, session_variables, variables_by_thread, and persisted_variables, to issue SELECT ... The ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-common-layer.html
Each set of the pluggable storage engine infrastructure components are designed to offer a selective set of benefits for a particular application. It stands to reason that understanding a particular application's set of requirements and selecting ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
mysqlbinlog has options for selecting sections of the binary log based on event times or position of events within the log. Viewing log contents can be useful when you need to determine event times or positions to select partial log contents prior ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...