Limits on MySQL

1. Limits of Joins

The maximum number of tables that can being referenced in a single join IS . This also applies to the number of tables that can is referenced in the definition of a view.
2. How many tables can be

MySQL has a no limit on the number of tables. The underlying file system may has a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to4 billion tables.

3. Table Size LimitThe effective maximum table size for MySQL databases are usually determined by operating system constraints on file Sizes, not by MySQL internal limits.
theInnoDB storage Engine maintainsInnoDB tables within a tablespace that can be CRE Ated from several files. This enables a table to exceed the maximum individual file size. The tablespace can include raw disk partitions, which permits extremely large tables. The maximum tablespace size is 64TB
you is using Amyisam table and the space required for the table exceeds What are permitted by The internal pointer size.myisam permits data and index files to grow-256TB by Default, but this limit can is changed up to the maximum permissible size of 65,536TB ( 2567–1 bytes) to change the default size limit for MyISAM tables, set the myisam_data_pointer_sizethe number of bytes used for internal row pointers. The value is used to set the pointer size for New tables If you don't specify Themax_rows option. The value of myisam_data_pointer_sizecan be from 2 to 7. A value of 4 permits tables up to 4GB; A value of 6 permits tables up to 256TB.
You are using theMEMORY (HEAP) storage engine; the the need to increase the value of the max_heap_table_sizesystem variable.

Limits on MySQL