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.
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...
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.
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 )