Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
When there is no adaptive hash index contention, this value remains zero and statements reserve the latch until they finish. The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the ...For usage information, see Section 17.15.2.1, “Using InnoDB Transaction and Locking ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
PROCESSLIST_INFO The statement the thread is executing, or NULL if it is executing no statement. The statement might be the one sent to the server, or an innermost statement if the statement executes other statements. For example, if a CALL ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
See Section 15.7.7.23, “SHOW INDEX Statement”, for more about this statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem ...You have previously seen SHOW DATABASES, which lists the databases managed by the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/quan-advisor-ref.html
Average Statement Execution Time Advisor Monitors the average execution time of a normalized SQL statement and generates events if the execution time exceeds the defined thresholds. Minimum Execution Count: Minimum number of times a normalized ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. This topic includes the following sections: ...
https://dev.mysql.com/doc/refman/8.4/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. This means you can use := in any valid SQL statement (not ...Causes the user variable on the left hand side of the operator to take on the value to its ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to replica. You can cause this format to be used by starting the ...In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can verify that this is true by examining the Information Schema EVENTS table before and after issuing ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Do stored procedures have a statement for raising application errors? A.4.13. Can a stored procedure call a trigger? A stored procedure can execute an SQL statement, such as an UPDATE, that causes a trigger to activate. Do stored procedures have a ...Where can I find documentation for MySQL stored procedures and stored functions? ...