Hello Ivan, Thanks!
What I'm trying to accomplish: a. Want to scale to hundreds of company files, with far less running at any one time. (Very few users come in and stay all day.) b. The company data can range from 200MB to 2GB of XML (pre-Sedna insertion size.) c. The idea is to dynamically stop and start databases as needed. Not everyone will be in there at the same time. d. Running on a 7.5 GB server that is dedicated to Sedna. Hence, 50 concurrent databases should be possible. e. We tried a single database instance with a separate catalog for each company, but performance started to suffer. Does the concept seem reasonable? Are there any limitations or issues with using Sedna in this way? Thanks, Malcolm -----Original Message----- From: Ivan Shcheklein [mailto:shchekl...@gmail.com] Sent: Wednesday, December 01, 2010 9:15 AM To: Malcolm Davis Cc: sedna-discussion Subject: Re: [Sedna-discussion] SEDNA Message: ERROR SE4211: maximum number of databases se_gov process (Sedna server) manages list of all available databases (either running or not). Situation: a. Clean reboot b. No other databases are loaded. c. Memory: total used free shared buffers cached Mem: 7468 387 7080 0 28 110 -/+ buffers/cache: 248 7220 Swap: 0 0 0 Total: 7468 387 7080 d. There 400 GB of free disk space on a mounted drive. e. There are only 10 other database created, but none of those are started. Command: sudo /usr/share/sedna/bin/se_cdb 181436324 Response: Creating a database (this can take a few minutes)... SEDNA Message: ERROR SE4211 Failed to create the database Details: The maximum number of databases hosted by one server is exceeded Logging is set to Level 4, but I don't see any database creation messages in the event.log file. Any ideas? Thanks, Malcolm -----Original Message----- From: Ivan Shcheklein [mailto:shchekl...@gmail.com] Sent: Wednesday, December 01, 2010 4:48 AM To: Malcolm Davis Cc: sedna-discussion Subject: Re: [Sedna-discussion] SEDNA Message: ERROR SE4211: maximum number of databases Hi Malcolm Several questions: What is the maximum number of databases that can be hosted on one server? Can the maximum number of databases be changed? Current limit is 50 databases. It's hard coded and can not be changed without recompilation. Remember also, that database in Sedna is a quite heavy instance. It has it's own buffer memory (100 MB default) not shared with other databases, own semaphores set, etc ... I believe you should consider multiple collections within one database instead of multiple databases. Unfortunately, it's the only way to run "hosted Sedna" now. Ivan Shcheklein, Sedna Team ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Sedna-discussion mailing list Sedna-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sedna-discussion
