Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-index-statistics.html
insert_latency The total wait time of timed inserts into the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
insert_latency The total wait time of timed insert I/O events for the table. These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
insert_latency The total wait time of timed insert I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
With INSERT and REPLACE statements, where you would otherwise use SELECT *. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/8.4/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
You can declare an auto-increment column so that ascending values are filled in automatically as rows are inserted: # The value of ID can act like a pointer between related items in different tables. InnoDB tables are created using the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Immediately preceding SELECT for statements that include a SELECT statement: INSERT ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that ...