Please take our Survey
logo       
<prev   next>

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

RE: Cache Size: msg#00276

db.maxdb

Subject: RE: Cache Size

> HOW does it depend on MAXUSERS. Right now I have setup around
> 217000 pages, which is around 1,7 GB. I've set the /3GB-Flag
> in the boot.ini for my Win2K-System, so that the application
> can access 3 GB, but anyway I can't set a higher Cachesize
> above the 2GB.
>
> For this reason it would be great to learn how MAXUSERS
> influences the CACHE_SIZE.

Every user has its own context, stack, shared libraries etc. There's no
"number" to calculate this, you have to iterate what's the best setup.

To enable PAE you have to set the following parameters:

USE_MEM_ENHANCES YES
MEM_ENHANCE_LIMIT 0 (MB to be used ABOVE 4 GB)


Greetz,


SIEGENIA-AUBI KG
Informationswesen

i.A.

Markus Döhr
SAP-CC/BC, SAPDB-DBA

Tel.: +49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: markus.doehr@xxxxxxxxxxxxxxxxx
Internet: http://www.siegenia-aubi.com


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  AW: Cache Size, Christoph Weser
Next by Date:  RE: Duplicate key - at a loss, Ruth, Brice
Previous by Thread:  RE: Cache Size, "Döhr, Markus ICC-H"
Next by Thread:  AW: Cache Size, Christoph Weser
Indexes:  [Date] [Thread] [Top] [All Lists]

Google Custom Search

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation
Home | advertise | OSDir is an inevitable website. super tiny logo