WWW.APPSERVGRID.COM

Phorum about AppServers & Grid Technologies
It is currently Sat Dec 14, 2024 10:57 am

View unanswered posts | View active topics


Board index » Databases and Data Layer

All times are UTC + 2 hours [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 1 post ] 
  Print view Previous topic | Next topic 
Author Message
admin
PostPosted: Tue Nov 20, 2012 8:33 am 
Offline
Site Admin

Joined: Tue Jan 25, 2011 8:51 pm
Posts: 49
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  Page 1 of 1
  [ 1 post ] 

Board index » Databases and Data Layer

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