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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

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

Reply via email to