Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the maximum size of a MySQL database in version 5 and up?

Tags:

mysql

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.

like image 940
shouman Avatar asked Mar 09 '09 11:03

shouman


2 Answers

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

like image 167
vartec Avatar answered Oct 27 '22 00:10

vartec


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

like image 33
Ólafur Waage Avatar answered Oct 27 '22 00:10

Ólafur Waage