Hi Alexey,
Can you try setting "DefaultIsolation = 2" in the "[Parameters]" section of the
INI file, restart the server and repeat the load test with an empty database.
DefaultIsolation = 2 sets the isolation level to read committed which
minimises occurrence of locks during read/write operations, as detailed at :
http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoWikiWeb/ChangeVirtuosoSDefaultTransactionIsolationLevelBest Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 28 Jun 2013, at 13:56, Alexey Zakhlestin <indey...@gmail.com> wrote: > > On 28.06.2013, at 17:00, Hugh Williams <hwilli...@openlinksw.com> wrote: > >> Hi Alexey, >> >> How much memory is on your server as I thought you said it was 2GB >> previously, yet I see your buffers are set to 2000000 from the status output: >> >> 2000000 buffers, 1918813 used >> >> Which is way to high for a 2GB RAM system which should have about 170000 >> allocated as detailed at: >> >> >> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning >> >> Please confirm ? >> >> As is this is the case then most of the memory being allocated would be in >> swap, which means you load is mainly going to be to disk, which will always >> kill performance … > > I wrote previously, that I switched to larger VM with 30Gb of RAM > All data refers to this new VM. > > Original 2G VM got stuck too early to be usable > > -- > Alexey Zakhlestin > CTO at Grids.by/you > https://github.com/indeyets > PGP key: http://indeyets.ru/alexey.zakhlestin.pgp.asc > > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Windows: > > Build for Windows Store. > > http://p.sf.net/sfu/windows-dev2dev > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
