What is the maximum size of a table in mysql?

I am a rookie. I set up a website because I had to record a table of mysql caused by each visit of user agent,. 100000 rows of data were recorded in a year, which became the size of 50Mb. However, from a sensory point of view, it does not seem to affect the speed.

what is the maximum Mb?? of a table in mysql?

Apr.03,2021

it depends on the engine and file system you choose.

MyISAM after MySQL 5.0 , the upper limit of a single table depends on the file system.
Innodb in the case of shared tablespace storage, the upper limit of a single table (not a single file) is about 64TB, which contains indexes and other related data;
in the case of exclusive tablespace storage, the upper limit of a single table is determined by the file system.

the above relevant information is obtained from Baidu results

Previous: How to solve the problem that Baidu Editor supports HTTPS

Next: Is there a backend component that loads 3D models to generate images?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c27482-15d96.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c27482-15d96.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?