Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Allow (add) ability to specify database cache in kb/mb/gb [CORE4170] #4496

Open
firebird-automations opened this issue Aug 6, 2013 · 3 comments
Open

Allow (add) ability to specify database cache in kb/mb/gb [CORE4170] #4496

firebird-automations opened this issue Aug 6, 2013 · 3 comments
Assignees
@AlexPeshkoff
Labels
affect-version: 3.0 Alpha 1 component: engine priority: major type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @ibaseru

Votes: 1

I ask in addition to existing DefaultDbCachePages add new firebird.conf/database.conf parameter
DefaultDBCacheSize which can be specified in kilobytes, megabytes or gigabytes of memory directly.

For example,
DefaultDBCacheSize = 8m
i.e allocate 8 megabytes of cache for the DB.

Of course, engine can divide this value by page_size and select closest round number of pages for cache.

If both DefaultDbCachePages and DefaultDBCacheSize specified, bigger value can be taken.

As alternative to gfix -buffers n, I think, need to be added new parameter. maybe -cachesize n ?
Also we need new dpb parameter like isc_dpb_num_buffers.
@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @ibaseru

btw, by new gfix -cachesize n option I mean that it need to be stored in addition to -buffers, not computed and transformed to the "page buffers" value in header page.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Dmitry, why do you think it's better to have two mutually exclusive values instead one, calculated when other format is used?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@AlexPeshkoff AlexPeshkoff

Labels
affect-version: 3.0 Alpha 1 component: engine priority: major type: new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@AlexPeshkoff @firebird-automations