Re: Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-13 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
>>Hey, >>not sure how you can survive with superserver :) >>I can't see that working with our kind of load (realtime-data-processing, >>reports, mostly write IOPS) >>It's a long time ago (Fb 1.5) since we used superserver but we didn't have >>the best time with it back then.   I do not know what

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread thetr...@yahoo.com [firebird-support]
rebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Sent: Monday, April 11, 2016 2:55 PM To: firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Subject: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing ha

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread liviusliv...@poczta.onet.pl [firebird-support]
: mailto:firebird-support@yahoogroups.com Sent: Monday, April 11, 2016 2:55 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware hi, recently we had some strange performance issues with our Firebird

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hi Patrick, > Hi Thomas, nice to get a response from you. We already met in ~2010 in Linz at > your office :) > (ex. SEM GmbH, later Playmonitor GmbH) I know. XING (Big Brother) is watching you. Nice to see that you are still running with Firebird. ;-) > First, sorry for posting a mixed state

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Thomas, >> >> I doubt, Firebird is IO-bound (limited by disk IO). >> > > Sorry, I don't understand your comment, can you please clarify what you > mean? I think, disk IO isn't the limiting factor in that environment. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Hi Patrick, > > If you say that problem occurred recently, I would suggest you to check > SAN disks health. > > However, these values > >>Average system IOPS under load read: 100 > >Average system IOPS under load write: 550 > >Backup Restore IOPS read: 1700 > >Backup Restore IOPS write: 250

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Patrick, If you say that problem occurred recently, I would suggest you to check SAN disks health. However, these values Average system IOPS under load read: 100 >Average system IOPS under load write: 550 >Backup Restore IOPS read: 1700 >Backup Restore IOPS write: 250 are really,

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread thetr...@yahoo.com [firebird-support]
Hi Thomas, nice to get a response from you. We already met in ~2010 in Linz at your office :) (ex. SEM GmbH, later Playmonitor GmbH) First, sorry for posting a mixed state of informations. The config settings i postet are the current settings. But the Lock-Table-Header was from last

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-04-11 13:55, thetr...@yahoo.com [firebird-support] wrote: > hi, > > recently we had some strange performance issues with our Firebird DB > server. > > We would be very grateful if anyone can give us hints where we can > search further. > > Or someone has similar experiences to share with

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-11 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Patrick, > recently we had some strange performance issues with our Firebird DB server. > > On high load, our server started to slow down. Select and update SQL > query times did go up by more than 500% on average, > > but reaching unreasonable high execution times at worst case. (several >

[firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-11 Thread thetr...@yahoo.com [firebird-support]
hi, recently we had some strange performance issues with our Firebird DB server. On high load, our server started to slow down. Select and update SQL query times did go up by more than 500% on average, but reaching unreasonable high execution times at worst case. (several minutes instead of <