4
I see that some SGBD's has a space limit set 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 some limit, and if a heavy bench can interfere a lot in my application.
I have this doubt because I’m thinking of adding more data in a database I have for my analysis on QlikView more complete. Thank you.
5
Mysql is more complicated to be evaluated in this sense than other Dbms because the storage engine influences the capabilities of the database.
For example, Mysql itself has no table limit, being limited by the chosen file system. However, if you use Innodb as a storage engine, it is limited to 4 billion tables (32-bit integer without signal).
In the case of table size, using a modern file system, the limitation is a bit absurd: using Myisam, you can have table up to 256TB, if the file system supports (today, any modern FS - aka NTFS, ext4, xfs, etc - supports at least 2TB, being common they support 256TB).
Anyway, overall, there’s not much to worry about as long as you don’t work at the LHC, which generates TB of data daily.
The most important thing 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 Mysql boundaries, see the official documentation:
3
It is a very complicated answer because it depends a lot on the type of record you will add, the field sizes and a lot of other things that can interfere in this space occupied in Mysql.
In this link you can give a studied:
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.