Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-myisam-category.html
Table 7.21 Myisam Configuration Metrics NameDescriptionConcurrent Insert Permits INSERT and SELECT statements to run concurrently for MyISAM tables that have no free blocks in the middle of the data file. Keep Files On Create Enabled Whether to ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Moreover, a join buffer can be effectively used when there is an index access to the inner table. In EXPLAIN output, ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
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? ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. FROM INFORMATION_SCHEMA statement is intended as a more ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
For statements, it all depends on whether the statement that took a lock is a statement in a transaction that has already completed (use events_statements_history) or the statement is still running (use events_statements_current). For stages, the ...