Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/parameter-binding.html
bind('param', 'Nadya').execute(); // Binding works for all CRUD statements except add() var myRes3 = myColl.find('name like :param'). // one bind() per parameter var myColl = db.getCollection('relatives'); var juniors = myColl.find('alias = ...
https://dev.mysql.com/doc/refman/8.4/en/deleting-from-related-tables.html
You probably get the fastest DELETE by specifying only 100 to 1,000 related_column values per statement if the related_column is indexed. If the total length of the DELETE statement for related_table is more than the default value of the ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. It is also recommended that you do not use column names ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Adding foreign keys ensures that referenced columns are indexed, which can improve performance. Group sets of related DML operations into transactions by bracketing them with START TRANSACTION and COMMIT statements. While you don't want to commit ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
PROCESS_COUNT The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth. EXEC_COUNT: The accumulated number of queries (statements) passed ... The tp_thread_state table has one row per thread created by the thread pool to handle ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
Placing the host name and user name together means that index lookup can be used, which improves performance for CREATE USER, DROP USER, and RENAME USER statements, and for ACL checks for multiple users with multiple privileges. Dropping and ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. Enter a name for the foreign key and select the column or columns that you wish to ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
PAGE_BTR_SEG_LEAF and PAGE_BTR_SEG_TOP: These variables contain information (space ID, page number, and byte offset) about index node file segments. The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
This buffer is used only when the join is of type ALL or index (in other words, when no possible keys can be used). A join buffer is never allocated for the first non-const table, even if it would be of type ALL or index. Accepted row combinations ... Basic information about the join buffer cache: The size of each join buffer is determined by the value of the join_buffer_size system ...