According to the MySQL 5.7 documentation about the size limit of the tables, says:
C.10.3 Limits on table size
The maximum effective table size for MySQL databases
is usually determined by the operating system restrictions in
file sizes, not the internal boundaries of MySQL.
get up-to-date information about file size limits
operating system, refer to the specific documentation for your
operating system.
Windows users, note that FAT and VFAT (FAT32) are not considered
suitable for production use with MySQL. Use NTFS instead.
If you encounter a complete table error, there are several reasons why
which it may have occurred:
The disk may be full.
- You are using InnoDB in tables and ran out of space in an InnoDB table space file. The maximum size of tablespace
is also the maximum size for a table.
- Generally, tablesharing across multiple tablespace files is recommended for tables larger than 1 TB.
- You have reached a file size limit of the operating system. For example, you are using MyISAM in the tables in a
operating system that supports files up to 2GB in size and you
reached this limit for the data file or index file.
- You are using a MyISAM in the table and the space required for the table exceeds what is allowed by the internal pointer size. MyISAM
allows data and index files to grow up to 256 TB by
default, but this limit can be changed to the maximum size
allowed 65,536 TB (256 7 - 1 bytes).
That is, the problem is not in MySQL. Maybe if you post some snippets of code we can help you better.