WWW.APPSERVGRID.COM

Phorum about AppServers & Grid Technologies
It is currently Thu Nov 15, 2018 7:17 am

All times are UTC + 2 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Tue Nov 20, 2012 8:33 am 
Offline
Site Admin

Joined: Tue Jan 25, 2011 8:51 pm
Posts: 29
Answer:

It all depends on the type of MySQL database you wish to use and also the operating system the server has. Most of the restraints are due to the max file size the operating system can store. The limits are done by table size rather than the database size as a whole.
•Win 32 w/ FAT/FAT32 - 2GB/4GB
•Win 32 w/ NTFS - 2TB (possibly larger)
•Linux 2.2-Intel 32-bit - 2GB (LFS: 4GB)
•Linux 2.4+ - (using ext3 file system) 4TB
•Solaris 9/10 - 16TB
•MacOS X w/ HFS+ - 2TB
•NetWare w/NSS file system - 8TB

InnoDB tables are often split up into multiple files to allow larger tables, this is known as a tablespace. The maximum table space is 64TB.

MyISAM tables default size is at 4GB, but this can be changed to a maximum of 65,536TB.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 2 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron