Re: postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
> Ubuntu 7.10: > > grep "transactions:" sysbench-clients-24|sort > transactions:1 (2354.49 per sec.) > transactions:10001 (2126.28 per sec.) > transactions:10001 (2215.52 per sec.) > tr

Re: postgresql-performance using sysbench

2008-01-28 Thread Kris Kennaway
Claus Guttesen wrote: Ubuntu 7.10: grep "transactions:" sysbench-clients-24|sort transactions:1 (2354.49 per sec.) transactions:10001 (2126.28 per sec.) transactions:10001 (2215.52 per sec.) transactions:

Re: postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
> > > Ubuntu 7.10: > > > > > > grep "transactions:" sysbench-clients-24|sort > > > transactions:1 (2354.49 per sec.) > > > transactions:10001 (2126.28 per sec.) > > > transactions:10001 (2215.52 per sec.) > > > transacti

Re: postgresql-performance using sysbench

2008-01-28 Thread Darcy Buskermolen
On Monday 28 January 2008 09:25:13 Ivan Voras wrote: > Claus Guttesen wrote: > > Ubuntu 7.10: > > > > grep "transactions:" sysbench-clients-24|sort > > transactions:1 (2354.49 per sec.) > > transactions:10001 (2126.28 per sec.) > > transactions:

Re: postgresql-performance using sysbench

2008-01-28 Thread Ivan Voras
Claus Guttesen wrote: Ubuntu 7.10: grep "transactions:" sysbench-clients-24|sort transactions:1 (2354.49 per sec.) transactions:10001 (2126.28 per sec.) transactions:10001 (2215.52 per sec.) transactions:

Re: PHP with open_basedir performance problem

2008-01-28 Thread Alexey Popov
Hi Miroslav Lachman wrote: I tried sysctl vfs.ufs.dirhash_maxmem=1024 and realpath_cache_size=512k in php.ini and sysctl vfs.lookup_shared=1 but all without any significant impact on performance with open_basedir enabled. CPU states: 8.1% user, 0.0% nice, 88.6% system, 0.2% interrupt,

postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
Hi. I have a HP DL360 G5 with a p800 controller with 512 bbwc and a msa70 cabinet with eight 15K rpm sas-disks in raid 1+0. I installed FreeBSD 7.0 stable and ubuntu 7.10 server using postgresql 8.2.5 (from ports on FreeBSD and as an install-option on ubuntu). Both releases are amd64. Postgresql o

Re: PHP with open_basedir performance problem

2008-01-28 Thread Miroslav Lachman
Antony Mawer wrote: On 28/01/2008 6:52 PM, Alexey Popov wrote: The problem is that concurrent lstat()'s are very slow on FreeBSD now. Possibly you can decrease the number of lstat() calls by tuning realpath cache size in PHP. Just add "realpath_cache_size=512k" to php.ini. However I'm not s

Re: PHP with open_basedir performance problem

2008-01-28 Thread Antony Mawer
On 28/01/2008 6:52 PM, Alexey Popov wrote: The problem is that concurrent lstat()'s are very slow on FreeBSD now. Possibly you can decrease the number of lstat() calls by tuning realpath cache size in PHP. Just add "realpath_cache_size=512k" to php.ini. However I'm not sure this cache is used

Re: PHP with open_basedir performance problem

2008-01-28 Thread Alexey Popov
The problem is that concurrent lstat()'s are very slow on FreeBSD now. Possibly you can decrease the number of lstat() calls by tuning realpath cache size in PHP. Just add "realpath_cache_size=512k" to php.ini. However I'm not sure this cache is used in open_basedir. See the following thread