MySQL Restrictions and Limitations

Abstract

This is the MySQL Restrictions and Limitations extract from the MySQL 5.5 Reference Manual.

For legal information, see the Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

Document generated on: 2019-02-16 (revision: 60964)

---

Table of Contents     [+/-]

Preface and Legal Notices

1 Restrictions and Limits

2 Restrictions on Stored Programs

3 Restrictions on Server-Side Cursors

4 Restrictions on Subqueries

5 Restrictions on Views

6 Restrictions on XA Transactions

7 Restrictions on Character Sets

8 Limits in MySQL     [+/-]

8.1 Limits on Joins

8.2 Limits on Number of Databases and Tables

8.3 Limits on Table Size

8.4 Limits on Table Column Count and Row Size

8.5 Limits Imposed by .frm File Structure

8.6 Windows Platform Limitations

9 Restrictions and Limitations on Partitioning     [+/-]

9.1 Partitioning Keys, Primary Keys, and Unique Keys

9.2 Partitioning Limitations Relating to Storage Engines

9.3 Partitioning Limitations Relating to Functions

9.4 Partitioning and Table-Level Locking

10 MySQL Differences from Standard SQL     [+/-]

10.1 SELECT INTO TABLE Differences

10.2 UPDATE Differences

10.3 Foreign Key Differences

10.4 '--' as the Start of a Comment

11 Known Issues in MySQL