MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 71 to 80 of 82 total results

17.23 InnoDB Restrictions and Limitations

https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html

This section describes restrictions and limitations of the InnoDB storage engine. You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. This restriction ...

17.8.2 Configuring InnoDB for Read-Only Operation

https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html

You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. How to Enable To prepare an instance for read-only operation, make sure all the necessary ...

17.8.9 Purge Configuration

https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html

InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. This removal ...

25.4.3.6 Defining NDB Cluster Data Nodes

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html

The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are always used as the section names whether you are using ndbd or ndbmtd binaries for the data node processes. There ...

17.12.8 Online DDL Limitations

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html

The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before ...

28.3.48 The INFORMATION_SCHEMA VIEWS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html

You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...

15.3.3 Statements That Cause an Implicit Commit

https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html

The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...

11.2 Schema Object Names

https://dev.mysql.com/doc/refman/8.0/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. Section 11.2.1, “Identifier Length Limits”, indicates ...

11.2.4 Mapping of Identifiers to File Names

https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html

There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...

11.2.3 Identifier Case Sensitivity

https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...

Displaying 71 to 80 of 82 total results