Hi to all,

If I am going to deploy my program which uses mySQL as its database server, I would like to ask if what is the maximum limit of a mySQL database? is it over 1 TB? or lower? I know that I can search this query on google, but I'd rather take the info from the experts here.

Thanks and god bless!

For MyISAM 256TB as of MySQL 5.0.6 however this can be increased.
For InnoDB the max tablespace is 64TB.
Bear in mind it also depends on what OS you have as individual files are limited :
Win32 w/NTFS : 2TB (possibly larger)
Linux 2.4+ : (using ext3 filesystem) 4TB

so really you'll be looking at splitting tables up into sizeable chunks in reality...

If in Windows XP, you mean that I can only have a 2 TB size of a mySQL database?

http://webdocs.math.univ-rennes1.fr/...able_size.html
HTH

they are referring here about mySQL tables, which its limit size is 4 GB. Is it the same of what I meant about the 'database' size? To be specific, I am asking about the whole size of a single database in mySQL, not just the 'table' size.

by the way georgedev, the link you have given is not working.

Thanks anyways

the link works for me.

george, i really must know -- what was your purpose in linking to (a mirror of) the ancient 3.23 mysql manual???

that's like someone asking for help with windows and you point them to the windows 3.1 manual

why?

sorry about that george, it does work

Lol alright Rudy, but if you read the first few lines you get a lovely answer of
Which was reasonably applicable imo

Unless of course that information had changed and was not applicable in the current versions.

Has it changed?

not sure, all i'm saying is you are pointing to something over three years old and there have been a lot of other changes in mysql over that time.

Will the constaints have been decreased with new versions - I doubt it.
But I guess you're right. I only did I quick look in my links, never noticed the version etc (doesn't help that I don't have practical knowledge of mySQL, only theoretical )