Dear Kingsley,

Thank you very much for answering my questions.
私の質問に回答していただきありがとうございます。

I will try to check our system, referring to what you have taught.
教えていただいたことを参考に、私達のシステムを確認しようと思います。

Best regards,
Eiji Sagawa


> -----Original Message-----
> From: Kingsley Idehen [mailto:kide...@openlinksw.com]
> Sent: Saturday, June 15, 2019 4:10 AM
> To: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-users] I want to know how much memory of virtuoso
> can be reduced.
> 
> On 6/13/19 10:13 PM, sagawa_e...@fujitsu.com wrote:
> > I want to downsize the memory of virutoso. I want to know how much memory
> of virtuoso can be reduced.
> > 私はvirutosoのメモリのダウンサイジングを行いたい。私はvirtuosoの
> メモリをどこまで縮小できるのかを知りたい。
> >
> > I know that the memory is reserved as per the NumberOfBuffer value.
> > (I saw with ps command.)
> > 私はNumberOfBuffer値の通りにメモリが確保されていることは知っている。
> (私はpsコマンドで見た。)
> >
> > However, I do not know what data is loaded on virtuoso's memory and
> whether it is fully used.
> > しかし、virtuosoのメモリ上にどのようなデータがロードしているのか、
> そしてフルに使われているのかが分からない。
> 
> 
> Hi Eiji,
> 
> >
> >
> > [私の質問]
> > [My questions]
> >
> >   1. I want to know how to find out what data is currently deployed
> in virtuoso's memory.
> >   1. 現在どのデータがどれくらいvirtuosoのメモリに展開されているか
> が把握できる手段を知りたい。
> 
> 
> The data in the database is ultimately in memory, subject to the memory
> you allocated via buffer settings in the virtuoso.ini file.
> 
> 
> >
> >   2. I want to know how to check the usage status of the memory area
> secured by virtuoso.
> >   2. virtuosoが確保したメモリ領域の利用状況を確認する手段を知りた
> い。
> 
> 
> You can use commands like top and ps commands for that, during the
> progression of your usage from initial startup to warm up stage etc..
> 
> 
> >
> >   3. Besides caching by search execution, I would like to confirm the
> method if there is a method to expand arbitrary data in virtuoso's memory
> beforehand.
> >   3. 検索実行によるキャッシュ以外に、予め任意のデータをvirtuosoの
> メモリへ展開する方法があればその手段を確認したい。
> 
> 
> You do that via buffers settings.
> 
> There is also a publicly available Google Spreadsheet about variety
> Virtuoso instance that could also be of help here.
> 
> 
> Links
> 
> [1]
> https://docs.google.com/spreadsheets/d/1-stlTC_WJmMU3xA_NxA1tSLHw6_s
> bpjff-5OITtrbFw/edit
> 
> [2] https://community.openlinksw.com/ -- our active community forum for
> additional assistance
> 
> Kingsley
> 
> >
> >
> >
> > [About server environment]
> > [サーバ環境について]
> >
> >   Physical/Virtual Type : Virtual machine
> >   物理/仮想種別:仮想マシン
> >
> >   Operating System:CentOS 7.3 (64bit)
> >
> >   Number of processors : 10
> >   プロセッサー数:10
> >
> >   OS installed memory : 512GB
> >   OS搭載メモリ:512 GB
> >
> >   Data file (virtuoso.db) size : 680GB
> >   データファイル(virtuoso.db)サイズ : 680GB
> >
> >
> > [Other]
> > [その他]
> >   I changed the NumberOfBuffer and MaxDirtyBuffers values in
> virutoso.ini and measured the search speed.
> >   私はvirutoso.iniのNumberOfBuffer値およびMaxDirtyBuffers値を変
> えて検索速度を測定した。
> >
> >   I ran several different searches. The first search has a response
> from 21 seconds to 29 seconds.
> >   私は数回の異なる検索を実行した。検索1回目は21秒〜29秒でレスポン
> スがある。
> >
> >   The second and subsequent search responses were less than one second.
> >   2回目以降の検索レスポンスはいづれの場合も1秒未満であった。
> >
> >   Search speed did not improve even if the NumberOfBuffer and
> MaxDirtyBuffers values were high.
> >   NumberOfBuffer値およびMaxDirtyBuffers値が大きくても、検索速度は
> 向上しなかった。
> >
> >   Even if virtuoso reserves memory, is it not loading data at first?
> >   virtuosoはメモリを確保していても、最初はデータをロードしていな
> い?
> >
> >
> > よろしくお願い致します。
> > Best regards,
> > Eiji Sagawa
> >
> >
> >
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >
> 
> --
> Regards,
> 
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Home Page: http://www.openlinksw.com
> Community Support: https://community.openlinksw.com Weblogs (Blogs):
> Company Blog: https://medium.com/openlink-software-blog
> Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers
> Blog:
> https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers
> 
> Personal Weblogs (Blogs):
> Medium Blog: https://medium.com/@kidehen Legacy Blogs:
> http://www.openlinksw.com/blog/~kidehen/
>               http://kidehen.blogspot.com
> 
> Profile Pages:
> Pinterest: https://www.pinterest.com/kidehen/
> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
> Twitter: https://twitter.com/kidehen
> Google+: https://plus.google.com/+KingsleyIdehen/about
> LinkedIn: http://www.linkedin.com/in/kidehen
> 
> Web Identities (WebID):
> Personal:
> http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
>         :
> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.
> ttl#this



_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to