Search Results
https://dev.mysql.com/doc/internals/en/test-faults-macros.html
DBUG_EXECUTE_IF (keyword, code) allows executing a piece of code if the appropriate dbug instruction is set. DBUG_EVALUATE_IF (keyword, val1, val2) is used in if expressions and returns val1 if the appropriate dbug instruction is set.
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.
https://dev.mysql.com/doc/internals/en/synchronization-pattern.html
It is possible that the condition variable is signaled multiple times without the wait condition to be true. If the killing thread would kill us when we are after the second test, but still before sleeping, we hold the mutex, which is registered in ...This is done to allow the thread to be interrupted (killed) from its ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
time The time in seconds that the thread has been in its current state. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. By default, rows are sorted by descending process ...They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. The following table describes the maximum length for ...
https://dev.mysql.com/doc/ndbapi/en/mgm-concepts.html
A function can return any of the following: An integer value, with a value of -1 indicating an error. A NULL value indicates an error; otherwise, the return value must be freed by the programmer. A constant pointer value, with a NULL value ... This ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-threadactivity-category.html
Main Thd Loops One Sec (Delta) The number of times the InnoDB main thread has entered its one second loop structure, to flush dirty pages or drop tables in the background or insert buffer merging. Main Thd Loops Sleeps (Delta) The number of times ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...