Hi, > Hi, > >> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >> >> Performance related changes in firebird.conf are: >> >> DB Page Size = 8K >> DefaultDbCachePages = 128K (DB specific page buffers = 0) >> TempCacheLimit = 1024M >> LockHashSlots = 22111 >> >> anything else is default (except TCP port). >> >> When running oltp-emul with 100 concurrent users (only) by: >> >> 1run_oltp_emul.bat 30 100 >> >> I see Firebird server CPU usage < 4% only and IO < 3MB/s all the time, >> thus mainly random I/O bound, I guess, without having a proof, thus >> could also be code related. >> >> What's weird is that e.g. additional attachment requests, e.g. via isql >> may take > 10s then. This does not make sense and makes SS entirely >> unusable. >> >> I haven't tried SC or CS under that scenario yet. > > Re-run: > > 1run_oltp_emul.bat 30 100 > > with SuperClassic and firebird.conf changes: > > DefaultDbCachePages = 1024 > TempCacheLimit = 8M > > An entirely different picture now. Although CPU usage is still < 5%, > disk I/O (read+write) throughput (according to Process Explorer) is > 20MB/s or even more
Could be related to the shared page cache in SS, thus massive less reads in the SS scenario (without having a proof *g*), but below attachment request blocking still remains. Thanks, Thomas > and more importantly, additional attachment requests > are instant. > > Looks to me like a serious lock contention bug/regression in SuperServer. > > > Thomas > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
