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 the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2019-06-22 (revision: 62443)

---

Table of Contents     [+/-]

Preface and Legal Notices

1 Restrictions on Stored Programs

2 Restrictions on Condition Handling

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 Restrictions on Performance Schema

9 Restrictions on Pluggable Authentication

10 Limits in MySQL     [+/-]

10.1 Limits on Joins

10.2 Limits on Number of Databases and Tables

10.3 Limits on Table Size

10.4 Limits on Table Column Count and Row Size

10.5 Limits Imposed by .frm File Structure

10.6 Windows Platform Limitations

11 Restrictions and Limitations on Partitioning     [+/-]

11.1 Partitioning Keys, Primary Keys, and Unique Keys

11.2 Partitioning Limitations Relating to Storage Engines

11.3 Partitioning Limitations Relating to Functions

11.4 Partitioning and Table-Level Locking

12 MySQL Differences from Standard SQL     [+/-]

12.1 SELECT INTO TABLE Differences

12.2 UPDATE Differences

12.3 Foreign Key Differences

12.4 '--' as the Start of a Comment

13 Known Issues in MySQL