MySQL Restrictions and Limitations

Abstract

This is the MySQL Restrictions and Limitations extract from the MySQL 5.7 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: 2024-10-29 (revision: 80141)

---

Table of Contents

Preface and Legal Notices

1 Restrictions on Stored Programs

2 Restrictions on Views

3 Restrictions on Condition Handling

4 Restrictions on Server-Side Cursors

5 Restrictions on Subqueries

6 Restrictions on XA Transactions

7 Restrictions on Character Sets

8 Restrictions on Performance Schema

9 Restrictions on Pluggable Authentication

10 Restrictions and Limitations on Partitioning

10.1 Partitioning Keys, Primary Keys, and Unique Keys

10.2 Partitioning Limitations Relating to Storage Engines

10.3 Partitioning Limitations Relating to Functions

10.4 Partitioning and Locking

11 Windows Platform Restrictions

12 Limits in MySQL

12.1 Identifier Length Limits

12.2 Grant Table Scope Column Properties

12.3 Limits on Number of Databases and Tables

12.4 Limits on Table Size

12.5 Limits on Table Column Count and Row Size

12.6 Limits Imposed by .frm File Structure

13 MySQL Differences from Standard SQL

13.1 SELECT INTO TABLE Differences

13.2 UPDATE Differences

13.3 FOREIGN KEY Constraint Differences

13.4 '--' as the Start of a Comment

14 Known Issues in MySQL