| Subject | Re: [ib-support] Firebird makes /tmp/core file, and it is HUGE |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-08-03T02:27:57Z |
At 07:00 PM 02-08-02 -0700, you wrote:
them via sort files.
soak-testing your own query scenarios. I've seen suggestions varying from
"twice the size of your largest table times the peak number of users" to "a
dedicated large, fast drive in a fast RAID". I don't think there is any
reliable alternative to good QA for establishing your runtime and growth
metrics.
OpGuide and Firebird release notes; or get hold of the Using Firebird
manual, which has a whole chapter dedicated to configuration.
Oh, you're not alone in this. I think it's a stretch for folk to believe
they can get all their answers from a single source of
documentation....especially if they are determined not to part with any
money to acquire or promote resource materials developed to assist them in
the learning curve.
Don't take this personally, since I know you are one who has taken steps to
get these resources. Producing documentation is horrendously
expensive. Everyone wants the book but too few are willing to contribute
to its development or maintenance.
<hobby horse off>
heLen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________
>So if my /tmp file is always empty does that mean that any files createdYes: and you are not looking at it when users are doing sorts. <g>
>are always being cleaned up?
>I should not assume that it is not using them at all should I?Ermmm...no...if you have users getting ordered result sets then they got
them via sort files.
>In that case is there a rule of thumb to use on /tmp file size based onNot really. You have to use your own rules of thumb, derived from
>the size of the queries. Some sort of ratio.
soak-testing your own query scenarios. I've seen suggestions varying from
"twice the size of your largest table times the peak number of users" to "a
dedicated large, fast drive in a fast RAID". I don't think there is any
reliable alternative to good QA for establishing your runtime and growth
metrics.
>I do not remember seeing anything about it in the docs, but that doesIt's there - either totally internalise where to find stuff in the Borland
>not mean it's not there. As I have proven in the past to miss the
>obvious in the docs. :)
OpGuide and Firebird release notes; or get hold of the Using Firebird
manual, which has a whole chapter dedicated to configuration.
>I do not mean to, but my little brain can only take in so much at one<hobby horse on>
>time. :)
Oh, you're not alone in this. I think it's a stretch for folk to believe
they can get all their answers from a single source of
documentation....especially if they are determined not to part with any
money to acquire or promote resource materials developed to assist them in
the learning curve.
Don't take this personally, since I know you are one who has taken steps to
get these resources. Producing documentation is horrendously
expensive. Everyone wants the book but too few are willing to contribute
to its development or maintenance.
<hobby horse off>
heLen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________