Rechercher dans le manuel MySQL

15.23 InnoDB Restrictions and Limitations

Contents

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 applies to use of the names in any lettercase.

    1. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB;
    2. ERROR 1166 (42000): Incorrect column name 'db_row_id'

  • SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. The row count is only a rough estimate used in SQL optimization.

  • InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. Consequently, SELECT COUNT(*) statements only count rows visible to the current transaction.

    For information about how InnoDB processes SELECT COUNT(*) statements, refer to the COUNT() description in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.

  • ROW_FORMAT=COMPRESSED is unsupported for page sizes greater than 16KB.

  • A MySQL instance using a particular InnoDB page size (innodb_page_size) cannot use data files or log files from an instance that uses a different page size.

  • For limitations associated with importing tables using the Transportable Tablespaces feature, see Table Import Limitations.

  • For limitations associated with online DDL, see Section 15.12.6, “Online DDL Limitations”.

  • For limitations associated with general tablespaces, see General Tablespace Limitations.

  • For limitations associated with data-at-rest encryption, see Encryption Limitations.


Find a PHP function

Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-innodb-restrictions-limitations.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

  1. View the html document Language of the document:en Manuel MySQL : https://dev.mysql.com/

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut