Storage capacity Mysql

Asked

Viewed 2,299 times

0

I have a table in Mysql that I backup daily, I have 552 records in it today, but the last two times I backed up realized that they were only saving 487 records. How do I increase the storage capacity of a Mysql table? To perform 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" select the path to which I want to save and ready.

mysql
  • 1

    It doesn’t seem to be a problem with the storage capacity, since 487 is a relatively low number. Each record takes up a lot of memory?

  • No, it’s text only, I currently have 543 records with 240.0KiB of storage.

  • 1

    So really the problem isn’t the bank’s capacity. Possibly it’s import failure or something like that. See if you can [Edit] the question and give more details of how you are doing the data export and import.

  • Okay, I’ll go into detail, let me know if I’m performing the right way.

1 answer

1

According to the Mysql documentation 5.7 about the limit in table size, says:

C.10.3 Table size limits

The maximum effective table size for Mysql databases is usually determined by operating system restrictions on file sizes, not internal Mysql boundaries. To get up-to-date information on file size limits of the operating system, see the documentation specific to 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 may have occurred:

The disk may be full.

  • You are using Innodb in the tables and ran out of space in an Innodb table space file. The maximum size of the tablespace is also the maximum size for a table.
  • Generally, the sharing of tables in multiple files tablespace is recommended for tables with size greater than 1 TB.
  • You have reached an operating system file size limit. For example, you are using Myisam in the tables on a operating system that supports files up to 2GB in size and you reached this limit for 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 256TB per
    standard, but this limit can be changed to the maximum size
    65,536 TB allowed (256 7 - 1 bytes).

That is, the problem is not in Mysql. Maybe if you post some code snippets we can help you better.

  • How should I proceed to back up? because when I give the command :select MAX(id) from myTable it shows the total of records

  • The structure you are trying to import does not contain any training errors? For example when trying to always report to in the same digit 487 records? The 488 record follows the same formatting as the previous ones in the file?

  • So the data is correct, one thing I realized I’m not understanding is this: the backup I did last month when I give the command to know the amount of records I have it informs the current amount, Could you help me with the backup? I’m using the HEIDISQL

  • see if this links how to backup and how to import and export help you. So we will start from this post to check the mistakes that happens.

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.