Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-internal-error.html
The index needs to be dropped and recreated NDB error code 914 MySQL error DMEC Error message Invalid index stats request NDB error code 916 MySQL error DMEC Error message Invalid index stats sys tables NDB error code 917 MySQL error DMEC Error ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure called the key cache (or key buffer) is maintained. The structure contains a number of block buffers where the most-used ... To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk. You can also use the ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
New requirements for the CHANGE MASTER TO replication statement (row format, primary key check). Failed login attempts and password lock time in ALTER USER statements. New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS ... This section summarizes ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ...Statements referencing such features, even if effectively ignored by NDB, must be syntactically and otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
The following example illustrates how an error can occur when a lock request causes a deadlock. Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-other-options.html
To obtain information about the key distribution, use a myisamchk --description --verbose tbl_name command or the SHOW INDEX FROM tbl_name statement. This improves join performance by enabling the join optimizer to better choose the order in which ... myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
This method causes the script (sequence of statements) assigned to the Query property of the MySqlScript object to be executed. script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new ... This tutorial teaches ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
This method causes the script (sequence of statements) assigned to the Query property of the MySqlScript object to be executed. script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new ... This tutorial teaches ...