Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
Error number: 53; Symbol: EE_CONFIG_FILE_PERMISSION_ERROR; Message: %s should be readable/writable only by current user. Error number: 54; Symbol: EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE; Message: World-writable config file '%s' is ignored. This ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more ...The outer query does not specify DISTINCT, HAVING, or ORDER ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new values. adaptive flushing An algorithm for InnoDB tables that smooths out the I/O overhead introduced by ... These ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
This section provides information about the Table class, which models a database table in the NDB API. It is possible using the NDB API to create tables independently of the MySQL server. However, it is usually not advisable to do so, since tables ...This class extends the Object class, which in turn is an inner class of the NdbDictionary ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...| ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating ...One session cannot acquire locks for another session or release locks held by another ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...