Appendix D. Restrictions and Limits

Table of Contents

D.1. Restrictions on Stored Programs
D.2. Restrictions on Condition Handling
D.3. Restrictions on Server-Side Cursors
D.4. Restrictions on Subqueries
D.5. Restrictions on Views
D.6. Restrictions on XA Transactions
D.7. Restrictions on Character Sets
D.8. Restrictions on Performance Schema
D.9. Restrictions on Pluggable Authentication
D.10. Limits in MySQL
D.10.1. Limits of Joins
D.10.2. Limits on Number of Databases and Tables
D.10.3. Limits on Table Size
D.10.4. Limits on Table Column Count and Row Size
D.10.5. Limits Imposed by .frm File Structure
D.10.6. Windows Platform Limitations

The discussion here describes restrictions that apply to the use of MySQL features such as subqueries or views. - all specs in one place