Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Common uses are the cleanup of obsolete data, the creation of summary tables for statistics, and monitoring of server performance and usage. Default frequency 00:05:00 Default auto-close enabled no In-Memory Temporary Table Size Limited By Maximum ...Default frequency 12:00:00 Default auto-close enabled yes Database May Not Be Portable Due To Identifier Case Sensitivity The case sensitivity of the underlying operating system determines the case sensitivity of database and table ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...ON mydb.mytable ...; A column name may be given multiple qualifiers to indicate context in statements that reference it, as shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
When a user-created NDB table is accessed using a unique index, the hidden index table is first read to find the primary key that is then used to read the user-created table. When a row referenced by a unique index in the user-created NDB table is ...NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.4, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Next, for every table in the query, we estimate the cost of, and number of records returned by, a table scan or a range access. "resulting_clause_is_simple": true, "resulting_clause": "`test`.`alias1`.`col_int_key`" } /* clause_processing */ }, The ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
If innodb_strict_mode is ON, MySQL checks the maximum row size during CREATE TABLE or CREATE INDEX. If you create a table when innodb_strict_mode is OFF, and a subsequent INSERT or UPDATE statement attempts to create an index entry that does not fit ... This section describes some internal implementation details about compression for InnoDB ...The information presented here may ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The mysql.gtid_executed system table is used to preserve the assigned GTIDs of all the ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
Workarounds for Locking Performance Issues The following items describe some ways to avoid or reduce contention caused by table locking: Consider switching the table to the InnoDB storage engine, either using CREATE TABLE ... You might have to ...