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_sbpjff-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
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users