Re: Performance Testing
-- elisa@ccserv.cc.nccu.edu (Elisa Chen) wrote: >Hi, > >I have a very critical problem here. How many users the Informix >DB engine can handle concurrently? This information was dug up at Informix's Web site. The number of users depends upon the engine you are running. The later the engine, the more users. The information below is for both version 5 and OnLine version 6 and greater. This information is for the version 6 and above products: LIMITS IN INFORMIX-OnLine Dynamic Server ======================================== Maximum Capacity System-Level Parameters Per Computer System ----------------------------------------------------------------- INFORMIX-OnLine 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 OnLine System ----------------------------------------------------------------- Maximum databases per OnLine system................... 21 million Maximum tables per OnLine system..................... 477,102,080 Maximum active users per OnLine system........... 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 OnLine system........... 32,000 Maximum number of open tables per user and join........ TBLSPACES (Subject to the value set in the TBLSPACES field of TBCONFIG) Maximum locks per OnLine system 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 .................... 1G INFORMIX-OnLine 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 This information is for the version 5 products: LIMITS IN INFORMIX-SE ===================== Number of tables locked by user: 32 Number of cursors per user: machine specific Number of bytes in key: 120 Number of key parts: 8 LIMITS IN INFORMIX-OnLine ========================= Maximum Capacity System-Level Parameters Per Computer System ----------------------------------------------------------------- INFORMIX-OnLine 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.......................................... 4,278,190,080 Data pages............................................ 16,777,216 Data bytes........................................ 33,822,867,456 (excludes Binary Large OBjects, BLOBs) Binary Large OBject bytes.................................. 2**31 Row length................................................ 32,767 Number of columns......................................... 32,767 Indexes...................................................... 100 Columns per index............................................. 16 Bytes per index.............................................. 255 Maximum Capacity Access Capabilities per INFORMIX-OnLine System ----------------------------------------------------------------- Maximum databases per OnLine system.......................... 100 Maximum tables per OnLine system...................... 16,777,216 Maximum active users per OnLine system...................... 1000 Maximum active users per database and table................. 1000 (Also limited by the number of available locks, a tunable parameter) Maximum number of open tables per OnLine system........... 32,000 Maximum number of open tables per user and join........ TBLSPACES (Subject to the value set in the TBLSPACES field of TBCONFIG) Maximum locks per OnLine system and database........... 8,000,000 Maximum number of buffers................................ 512,000 Maximum number of page cleaners............................... 32 Maximum number of recursive synonym mappings.................. 16 Number of tables locked by user............................... 32 Number of cursors per user.................................... 64 Maximum size of blob table.................., ............... int Maximum size of user table................................... 32K Maximum size of logical log partition............ 1,000,000 pages Maximum number of open BLOBs.................................. 20 Maximum number of B-tree levels............................... 10 INFORMIX-OnLine System Defaults -----------------------------------------------------------------@@NL@