| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| 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 |
|
#2
| |||
| |||
| 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 at http://www.fidelityinfoservices.com/..._set_cmmd.html (you will need stand-alone access to the database). Regards -- Bhaskar |
|
#3
| |||
| |||
| 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. 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? |
|
#4
| |||
| |||
| On Sep 12, 1:27*am, dip...@gmail.com wrote: > 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 |
|
#5
| |||
| |||
| On Sep 12, 4:20*pm, "K.S. Bhaskar" <ksbhas...@gmail.com> wrote: > On Sep 12, 1:27*am, dip...@gmail.com wrote: > > > > > 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 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? |
|
#6
| |||
| |||
| On Sep 12, 4:20*pm, "K.S. Bhaskar" <ksbhas...@gmail.com> wrote: > On Sep 12, 1:27*am, dip...@gmail.com wrote: > > > > > 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 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? |
|
#7
| |||
| |||
| On Sep 12, 9:39*am, dip...@gmail.com wrote: > On Sep 12, 4:20*pm, "K.S. Bhaskar" <ksbhas...@gmail.com> wrote: > > > > > On Sep 12, 1:27*am, dip...@gmail.com wrote: > > > > 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 > > Thanks again for the quick replay :-) [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 |
![]() |
| Thread Tools | |
| Display Modes | |
In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.