What is the maximum size of a MySQL database in version 5 and up?
I do not mean the maximum size of row or table, but the maximum size of the whole database.
Two billion (2'000'000'000) tables and a max total of 64TB for InnoDB. MyISAM tables are files, so it's underlying OS file limit.
Check this answer: https://forums.mysql.com/read.php?79,158,165
It's dependent of your operating system. I.e. on Windows its dependent on maximum folder size.
This documentation entry is very helpful in regards to this
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With