Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_waits_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a ... The events_waits_history table contains the N most recent wait events that have ended per ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** 2. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE REASON: Injected failure ... This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-instances-table.html
The table contains one row per TCP/IP or Unix socket file connection. row *************************** EVENT_NAME: wait/io/socket/sql/server_unix_socket OBJECT_INSTANCE_BEGIN: 4316619408 THREAD_ID: 1 SOCKET_ID: 16 IP: PORT: 0 STATE: ACTIVE ... The ...
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: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
Tables that use the MEMORY storage engine are deleted automatically the first time they are accessed after the server is started, because rows might have been lost during the shutdown. This also includes no-op transactions when row-based replication ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
By default, if the FOR CHANNEL channel clause is not used, this statement shows the replica status for all channels with one row per channel. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: ... To monitor the status ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
Each row in the result set corresponds to one “instruction” in the routine. The final row contains an instruction jump 2, meaning GOTO instruction #2. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). innodb_buffer_rows_cached The total number of InnoDB cached rows for the table. These views summarize table statistics, including InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated table. For example, rows can be inserted by INSERT or LOAD DATA statements, and an insert trigger activates for each inserted row. For example, you ... A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the ...