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