increase gt.m global buffer
dip...@gmail.com
In Cache I can increase the global (or/and routine) buffer (Memory for
Database Cache).
How can I increase gt.m global buffer?
Thanks in advance
Adrian
K.S. Bhaskar
Check out the mupip set command at
http://www.fidelityinfoservices.com/user_documentation/AdminOpsUNIX/UNIX_A_O/mupip_set_cmmd.html
(you will need stand-alone access to the database).
Regards
-- Bhaskar
dip...@gmail.com
> On Sep 11, 10:23 am, dip...@gmail.com wrote:
>
> > Hello
>
> > In Cache I can increase the global (or/and routine) buffer (Memory for
> > Database Cache).
>
> > How can I increase gt.m global buffer?
>
> > Thanks in advance
>
> > Adrian
>
> (you will need stand-alone access to the database).
>
> Regards
> -- Bhaskar
Big thanks for the fast replay.
What is the default global buffer for a mumps.dat ?
Do I need to recreate the mumps.dat when changing the global buffer
for a mumps.dat?
Do you have a recommendation for a global buffer on a linux server
with 4GB of ram?
K.S. Bhaskar
> On Sep 11, 8:08 pm, "K.S. Bhaskar" <ksbhas...@gmail.com> wrote:
>
>
>
> > On Sep 11, 10:23 am, dip...@gmail.com wrote:
>
> > > Hello
>
> > > In Cache I can increase the global (or/and routine) buffer (Memory for
> > > Database Cache).
>
> > > How can I increase gt.m global buffer?
>
> > > Thanks in advance
>
> > > Adrian
>
> > Check out the mupip set command athttp://www.fidelityinfoservices.com/user_documentation/AdminOpsUNIX/U...
> > (you will need stand-alone access to the database).
>
> > Regards
> > -- Bhaskar
>
> Big thanks for the fast replay.
[KSB] You are welcome.
> What is the default global buffer for a mumps.dat ?
[KSB] It is taken from the global directory by mupip create. I don't
remember what the default is in the global directory when gde creates
it.
> Do I need to recreate the mumps.dat when changing the global buffer
> for a mumps.dat?
[KSB] No.
> Do you have a recommendation for a global buffer on a linux server
> with 4GB of ram?
[KSB] No. It depends on your application. Make it as big as it
needs to be but no bigger. In general, performance will increase as
you increase the number of buffers, then it will usually stay flat.
If it's so big that the system starts to page, performance will
degrade rapidly. So run benchmarks to choose the best size.
Regards
-- Bhaskar
ks dot bhaskar at fnis dot com
dip...@gmail.com
Thanks again for the quick replay :-)
1. I'm sure' but I want to be 100% sure: I need to set the global
buffer only once, for example, when I reboot the server, I don't need
to set the global buffer again, right?
2. I read that the recommendation of global buffer is 4096, but this
value was recommended in the documentation that was release a long
time ago. The maximum global buffer is 65536. I set the global buffer
to 30720 on a server with a 4GB of RAM, is this o.k.?
3. Is there a relationship between the global buffer and the block
size?
K.S. Bhaskar
[KSB] I just happen to be checking comp.lang.mumps today and catching
up. If you want timely responses, you really should buy support.
It's available on a commercial basis with guaranteed service levels.
> 1. I'm sure' but I want to be 100% sure: I need to set the global
> buffer only once, for example, when I reboot the server, I don't need
> to set the global buffer again, right?
[KSB] Correct. However, you may want to change it in the global
directory also, so that the next time you recreate the database file,
it starts out with the right number of buffers.
> 2. I read that the recommendation of global buffer is 4096, but this
> value was recommended in the documentation that was release a long
> time ago. The maximum global buffer is 65536. I set the global buffer
> to 30720 on a server with a 4GB of RAM, is this o.k.?
[KSB] We have no recommendation on the number of global buffers. Yes,
the maximum number is 65536.
> 3. Is there a relationship between the global buffer and the block
> size?
[KSB] No. Except that the number of global buffers times the block
size affects shared memory usage.
Regards
-- Bhaskar