Re: Largest Informix Database size
In article <7sfv9m$717$1@news.xmission.com>, William Raper <WilliamR@catmktg.com> writes > > > >> -----Original Message----- >> From: pankaj [SMTP:pankaj.patel@punks.demon.co.uk] >> Sent: Friday, September 24, 1999 6:16 AM >> To: informix-list@iiug.org >> Subject: Largest Informix Database size >> >> Hi All , >> >> The question I have is :- What is the largest single size database you can >> have on one informix instance ? >> >> I did not think there was a limit but am not sure. >> >> The reason I ask is that MS SQL server has a limit of 1.xx something TB's >> or >> so I have been told. >> >> >> Pankaj >> > [Bill Raper] > > The math is: > > 477,102,080 * 4,277,659,295 * 32,767 * <I can't find this >one> = one very huge number (6.687351978251e+22 * max fragments) > (max tables) (max rows per fragment) (max row length) * (max >fragments per table) > 1 chunk = 2Gb x max chunks 2048 = 4Tb However for more than 4Tb check out IDS XPO (Extended Parallel Option) which is a shared nothing architecture. For more than 4Tb you will find an SMP machine cannot handle it since there is contention between processors trying to access memory. For that much data you either need MPP or a cluster. The most largest XPO I've heard of was a benchmark with 176 machines running in parallel. 176*4Tb = 704Tb! Of course you could probably scale further if you have the hardware, if 176 is possible I wonder what the limit is, Tim? > From the release notes for 7.31.UC2 on Solaris 2.6: > > LIMITS IN Informix Dynamic Server > ================================= > Maximum Capacity > System-Level Parameters Per Computer System > ----------------------------------------------------------------- > Informix Dynamic Server systems per computer...........255 > (Dependent on available system resources) > Maximum number of accessible remote sites ...... machine specific > > > Maximum Capacity > Table-Level Parameters (based on 2K page size) per Table > ----------------------------------------------------------------- > Data rows per fragment............................. 4,277,659,295 > Data pages per fragment............................... 16,775,134 > Data bytes per fragment........................... 33,818,671,136 > (excludes Binary Large Objects, BLOBs; roughly double this > number for 4k page size) > Binary Large Object bytes.................................. 2**31 > Row length................................................ 32,767 > Number of columns............................................ 32K > Indexes....................................................... 77 > (roughly double this number for 4k page size) > Columns per index............................................. 16 > Bytes per index.............................................. 255 > > > Maximum Capacity > Access Capabilities per Dynamic Server System > ----------------------------------------------------------------- > Maximum databases per Dynamic Server.................. 21 million > Maximum tables per Dynamic Server..................... 477,102,080 > Maximum active users per Dynamic Server........... 32K userthreads > (minus the minimum number of system threads) > Maximum active users per database and table...... 32K userthreads > (Also limited by the number of available locks, a tunable parameter) > Maximum number of open tables per Dynamic Server.......... 32,000 > Maximum number of open tables per user and join........... 32,000 > Maximum locks per Dynamic Server and database........... 8 million > Maximum number of page cleaners.............................. 128 > Maximum number of recursive synonym mappings.................. 16 > Maximum number of tables locked by user....................... 32 > Maximum number of cursors per user.............. machine specific > Maximum number of pages per chunk............................. 1m > > Maximum number of open BLOBs.................................. 20 > Maximum number of B-tree levels............................... 20 > Maximum amount of Decision Support memory ...... machine specific > > > Informix Dynamic Server System Defaults > ----------------------------------------------------------------- > Table lock mode............................................. Page > Initial extent size...................................... 8 Pages > Next extent size......................................... 8 Pages > Read-only isolation level......................... Committed Read > (w/ database transactions) > Read-only isolation level........................ Repeatable Read > (MODE ANSI database) > > ON-Monitor > ----------------------------------------------------------------- > Number of displayed user threads.............................1000 > Number of displayed chunks...................................1000 > Number of displayed dbspaces.................................1000 > Number of displayed databases................................1000 > Number of displayed logical logs.............................1000 > -- David Williams