>>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
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.
But currently this is not about
Hi,
just curious – why not superserver?
I do not know what your system do and if it is cpu intensive –
but i always use superserver because of big cache and this is for me biggest
speed up.
I use superserver in environment with ~400 connections (near constant) and high
load without problem.
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
> 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
> 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
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,
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
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
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
>
10 matches
Mail list logo