Storage Capacity MySql

0

I have a MySql table that I back up daily, I have 552 records on it today, but the last two times I backed up I realized that they were only saving 487 records. How do I increase the storage capacity of a MySql table? To do the backup I right click on the database and select the option "Export database as SQL" in the new window that opens I select the two items of "Create" I select the path to which I want to save and ready. / p>     

asked by anonymous 18.07.2017 / 15:51

1 answer

1

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.

    
18.07.2017 / 16:10