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 us
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 saturda
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, really
> 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
>
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?
Regards,
Alexey
> 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 T
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
Hello,
is it possible to extract the last complete word from a string until the
last blank? For example "I would like to eat a bacon" In this case I would
like to have the "bacon" as result.
Thank you.
Thanks, I had a more complicated version tested now
for select arbeitsgang from tarbg into :agbefore do
begin
agafter = reverse(agbefore);
agafter = left(agafter, position(' ',agafter));
agafter = reverse(agafter);
suspend;
end
-Ursprüngliche Nachricht-
Von: firebird
12.04.2016 17:00, 'Checkmail' check_m...@satron.de [firebird-support] wrote:
> is it possible to extract the last complete word from a string until the last
> blank? For
> example “I would like to eat a bacon” In this case I would like to have the
> “bacon” as result.
RIGHT(string, POSITION('
As I can install firebird 3 RC2 superclasic in linux?
I want to try it on devuan, I do not know as installing superclasic.
Best Regards
| ISMAEL |
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.
PS
Hi Ann,
This is the crux of the matter
“Index entries for the old and new versions of a record all contain the DBKey
of the primary (newest) record version. When doing an indexed lookup,
Firebird walks backward through the record versions until it finds one that
the current transaction can see, t
gbak:activating and creating deferred index K_MERCURY_EMAIL
gbak:cannot commit index K_MERCURY_EMAIL
gbak: ERROR:operating system directive CreateFile failed
gbak: ERROR:The system cannot find the path specified.
Database restore canceled 21:17:19 due to IBPP exception:
*** IBP
Hi!
> gbak:activating and creating deferred index K_MERCURY_EMAIL
>
> gbak:cannot commit index K_MERCURY_EMAIL
>
> gbak: ERROR:operating system directive CreateFile failed
Any chance that you are running out of disk where your TEMP directory is
located?
--
With regards,
Thomas Steinmaurer
I'm now trying to restore it with "ignore validity constraints" off in
flamerobin.
It's a production database but this restore is for a side-project (email
logging). I clearly need to get to the root of the problem.
The offending index is added to using a generated integer within a trigg
12.04.2016 23:04, tomconl...@gmail.com [firebird-support] wrote:
> It's a production database but this restore is for a side-project (email
> logging). I
> clearly need to get to the root of the problem.
You run out of temp space. Buy new HDD.
--
WBR, SD.
---
There is 77GB free out of 148GB at the minute and it has restored 9GB so far,
final size ~33GB so on the surface looks adequate unless very large temp files
are created when the indexes are reactivated?
> There is 77GB free out of 148GB at the minute and it has restored 9GB so
> far, final size ~33GB so on the surface looks adequate unless very large
> temp files are created when the indexes are reactivated?
Yes. This may happen, depending on the index size. Are you sure that
temp space is actua
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
Hey Alexey,
thanks you for our input. I think what you say is correct, and we reviewed our
disk setup again.
We are utilizing mechnical discs so it's kinda hard to compare SSD performance
to them.
But they should provide enought IOPS for our load.
Unfortunatly we can't just switch to a single
Hey Thomas,
thanks for your extensive reply.
Unfortunatly we'r still bound to some old 32bit UDF functionality which we
can't get in 64bit.
I think you know about the use of SuperClassic with 32bit Server - 2GB RAM
Limit :)
It's not impossible, but also not really a fast route we can go. But for
Hi,
You wrote:
>The thing is, sure this numbers look really low. But >the system never uses
>it. The monitoring of the >SAN show's that this load's are never used
You are confusing the reason and the result.
Monitoring shows low numbers because spinning drives cannot provide fast enough
random r
Patrick,
Definetely you need to compare real life loads.
--
Regards,
Alexey Kovyazin
IBSurgeon среда, 13 апреля 2016г., 04:47 +03:00 от " thetr...@yahoo.com
[firebird-support]" < firebird-support@yahoogroups.com> :
>
>
>Hey Alexey,
>thanks you for our input. I think what you say is correct, and
24 matches
Mail list logo