Expansion of single table capacity in mysql

The default capacity of the mysql table is 4 GB. When loaddata is used, an error occurs when the file load 2 GB. However, if the myd file is 4 GB, I don't know what is going on. Expand the table capacity first. First check the table status: show table status like 'table _ name', and then modify the table capacity: alter table_name max_rows = 2000000000000, avg_low_length = 500000; Now load 4G data is enough.

But I still don't know the rule of myd files (I sometimes modify the content recorded in the table, but its size does not change. Sometimes I only add one letter, and the size increases by dozens of bytes. Delete from table_name and delete from table_name where... the results are different. The table is cleared by a statement without conditions, and the myd file size is 0. However, after the entire table is deleted with conditions, the size of the myd file is not 0, the myi file is also different from the empty file). You can check it later.

Haha, mysql has never been used since the project was completed, so I have never read it.