Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Gap locking is not needed for statements that lock rows using a unique index to search for a unique row. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for ...A ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Dictionary::createIndex() Description This method creates an index given an instance of Index and possibly an optional instance of Table. Signature This method can be invoked with or without a reference to a table object: int createIndex ( const ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. The following discussion describes the structure of the diagnostics area in MySQL, the information items recognized by MySQL, how statements clear and set the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Elements following that one represent events such as client connect and disconnect events, executed SQL statements, and so forth. Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Full-Text Parser Plugins MySQL has a built-in parser that it uses by default for full-text operations (parsing text to be indexed, or parsing a query string to determine the terms to be used for a search). When parsing for indexing purposes, the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
Statements that create these files are shown later in this section. Each of these tasks can be accomplished using SQL statements in the mysql client or other MySQL client application, as shown in the example that follows. Every CREATE LOGFILE GROUP ... NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
This means that any attempt to use a nonstandard key as a foreign key in a CREATE TABLE or ALTER TABLE statement is rejected with the error ER_FK_NO_INDEX_PARENT; setting it to ON allows such statements to run, but they raise ...mysql_refresh(): ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The pages that make up each table are arranged in a tree ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
QRTi Graph: adds a Query Response Time index pie-chart to the left side of the statement. Notices: Filters on the notices, enabling you to filter the list to show only the queries that did not raise a notice, indicated a full table scan, or ... The ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE statements. Use of index names, indexes on a prefix of a column, and use of INDEX or KEY in CREATE TABLE statements. For example, MySQL Server recognizes the ...