RE: [firebird-support] Firebird 2.5 classic performance issue on linux64
Andreas, this is the one thing I am getting when I am connecting to the database. I am not the one working productively on the system, so I can't really tell wether this has become faster or is still the same. LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 7048576, Used: 540536 Flags: 0x0001 Enqs: 5031, Converts:113, Rejects: 8, Blocks: 11 Deadlock scans: 0, Deadlocks: 0, Scan interval: 10 Acquires: 7695, Acquire blocks: 3, Spin count: 0 Mutex wait: 0.0% Hash slots: 30011, Hash lengths (min/avg/max):0/ 0/ 4 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (3):forward: 252920, backward: 490968 Free owners: *empty* Free locks (5):forward: 254960, backward: 519480 Free requests (6):forward: 540344, backward: 403464 Lock Ordering: Enabled This is what the fb_lock_print output looks like. Those numbers look to be very good. Q: Why are you running Classic server? How many users/connections are there usually to the database? Perhaps SuperServer provide better performance - it would allow you to "blow up" the page cache size.
Re: [firebird-support] Firebird 2.5 classic performance issue on linux64
Hi Sean, this is the one thing I am getting when I am connecting to the database. I am not the one working productively on the system, so I can't really tell wether this has become faster or is still the same. LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 7048576, Used: 540536 Flags: 0x0001 Enqs: 5031, Converts:113, Rejects: 8, Blocks: 11 Deadlock scans: 0, Deadlocks: 0, Scan interval: 10 Acquires: 7695, Acquire blocks: 3, Spin count: 0 Mutex wait: 0.0% Hash slots: 30011, Hash lengths (min/avg/max):0/ 0/ 4 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (3):forward: 252920, backward: 490968 Free owners: *empty* Free locks (5):forward: 254960, backward: 519480 Free requests (6):forward: 540344, backward: 403464 Lock Ordering: Enabled This is what the fb_lock_print output looks like. Andreas On 27.02.2017 00:25, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote: > > > Hi Sean, > > that's what I am saying. It never really is 'under load'. It is just > taking forever to select a clients data-page. > > I would blame bad design and shrug it off, but this was way faster on > the ancient w2k server, so I have no idea where it gets stuck. > > Andreas > > > On 26.02.2017 23:54, 'Leyne, Sean' s...@broadviewsoftware.com > [firebird-support] wrote: >> >> >> >> >> > Sean: fb_lock_print seems to have some trouble: >> > >> > Unable to access lock table. >> > operating system directive shmem_data->sh_mem_length_mapped is 0 >> > failed -Success >> > >> > This is what I am getting from fb_lock_print -d filename.db0 >> >> You need to specific the full/local path to the database and as well >> as the database filename. >> >> You really want to look at the fb_lock_print numbers when the >> database/server is under load. >> >> Sean >> > >
[firebird-support] Issue
Hello, I'm having an issue with the firebird guardian version 1.5 and I was hoping if you can help me out. Thanks in advance Jony -- [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird 2.5 classic performance issue on linux64
Hi Mark, thanks for the info. Someone already told me that the first message is moderated. It's the first time I joined a yahoo group for a project like that. Most of the open source projects have mailman or some sourceforge stuff setup and you can just post away :) Andreas On 27.02.2017 12:05, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 26-2-2017 17:46, andreasmzel...@yahoo.de [firebird-support] wrote: > > I originally tried to post to this like I would to a normal mailing > list. I've never seen an open source project that required me to have > a yahoo account ;) I have a firebird-related problem however. > > You don't need an Yahoo account, subscribing to the normal mailing list > is sufficient, however - afaik - first posts will need to be approved by > the moderator, and that can take some time, especially on weekends. > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] Firebird 2.5 classic performance issue on linux64
On 26-2-2017 17:46, andreasmzel...@yahoo.de [firebird-support] wrote: > I originally tried to post to this like I would to a normal mailing list. > I've never seen an open source project that required me to have a yahoo > account ;) I have a firebird-related problem however. You don't need an Yahoo account, subscribing to the normal mailing list is sufficient, however - afaik - first posts will need to be approved by the moderator, and that can take some time, especially on weekends. Mark -- Mark Rotteveel
Re: [firebird-support] Re: Starting auditing session
> In which DLL are the isc_action_svc_trace_* functions located? I am > planning to call it from a Lazarus project As i already wrote, you should work with Services API. If you never works with it before i suggest to read IB6 "API Guide" https://www.firebirdsql.org/en/reference-manuals/ https://www.firebirdsql.org/en/reference-manuals/ and corresponding docs for Lazarus access components you used to work with Firebird. isc_action_svc_trace_* is not a functions exported from DLL. This is numeric constants (tags) used to work with Services API. Hope it helps, Vlad PS avoid overquoting, please