What is the space limit of each database in mysql

4

I see that some SGBD's has a defined space limit for each Database. As in the case of the Express version of SQL Server that provides 10GB for each Base. I would like to know if MySql has any limits, and if a heavy bank can interfere greatly with my application.

I have this doubt because I am thinking of adding more data in a Base that I have for my analysis in QlikView to be more complete. Thank you.

    
asked by anonymous 15.05.2015 / 16:24

2 answers

5

MySQL is more complicated to evaluate in this sense than other DBMSs because the storage engine influences the capabilities of the database.

For example, MySQL itself has no table boundaries, but is limited by the file system you choose. However, if you use InnoDB as a storage engine, it is limited to 4 billion tables (32-bit unsigned integer).

In case of table size using a modern file system, the limitation is a bit absurd: using MyISAM, you can have up to 256TB table if the file system supports (today any modern FS-aka NTFS , ext4, xfs, etc - supports at least 2TB, and they support 256TB.)

Anyway, overall, there is not much to worry about as long as you do not work on the LHC, which generates TB of data daily.

The most important is to use the most modern versions of both the Operating System and the File System, as well as the DBMS (and obviously use the most appropriate DBMS for the task).

More details on the limits of MySQL, see the official documentation:

link

    
15.05.2015 / 16:38
3

It's a very complicated answer because it depends a lot on the type of record you're going to add, the field sizes and a lot of things that can interfere with this busy space in MySql.

In this link you can study:

link

    
15.05.2015 / 16:29