Search Results
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\dyn (DYNAMICALLY ALLOCATED ARRAY) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- dyn0dyn.c Dynamic / Dynamic 994 dynamically allocated array There is a single function in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_autoinc_lock_mode Command-Line Format --innodb-autoinc-lock-mode=# System Variable innodb_autoinc_lock_mode Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 2 Valid Values 012 The lock mode to use for generating ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Another set of functions permits version tokens to be locked and unlocked. Version Tokens also includes a set of functions enabling tokens to be locked and unlocked: version_tokens_lock_exclusive() acquires exclusive version token locks. It takes a ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
[WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF tbl_name [, tbl_name] ...] [NOWAIT | SKIP LOCKED] | LOCK IN SHARE MODE] [into_option] into_option: { INTO OUTFILE 'file_name' [CHARACTER ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
NdbOperation::getLockHandle Description Returns a pointer to the current operation's lock handle. When used with NdbRecord, the lock handle must first be requested with the OO_LOCKHANDLE operation option. In any case, the NdbLockHandle object ...
https://dev.mysql.com/doc/internals/en/debug-sync-point.html
Debug Sync Points give user-level locks the ability to synchronize at arbitrary points in code. open_tables(...) DBUG_SYNC_POINT("debug_lock.after_open_tables", 10); lock_tables(...) The synchronization points behave similar to ...They were part of ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... Following the user specifications, the statement may include options for SSL/TLS, resource-limit, ... ALTER USER ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... Following the user specifications, the statement may include options for SSL/TLS, resource-limit, ... CREATE USER ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.