Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

15.11.2011 2:11, Thomas Steinmaurer wrote: > > I guess the same applies to MON$IO_STATS.MON$PAGE_FETCHES? If so, isn't > comparing MON$PAGE_READS with MON$PAGE_FETCHES a bit misleading if one > wants to check to possibly increase the database page buffers? I bet you're thinking about the "cache hi

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> >> PS Snapshot (concurrency) transaction guarantees that once read > >> record could be read again and will be the same. So, in theory, we > >> can just re-read same data page when looking for next record. > > > > Why "in theory"? > > Because i want to be careful and don't want to make too

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> Vlad, > >> PS Snapshot (concurrency) transaction guarantees that once read record >> could be read again and will be the same. So, in theory, we can just >> re-read same data page when looking for next record. > > Why "in theory"? Because i want to be careful and don't want to make too ear

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

>> It would be also interesting if "reads" exposed in various places (isql, >> monitoring tables, trace api) are pure physical reads from disk and/or >> fetched from the OS file system cache. >> >> I guess, it could be also from the file system cache, because I've seen >> situations where execution

Re: [Firebird-devel] Trace API - Service names in include filter?

>>> Perhaps this is worth to be mentioned in fbtrace.conf, because one could >>> think, due to the provided list, to use Database Stats (without quotes) >>> etc. as filter? >> >> Hmm... it was so obvious for me that i even can't imagine such case ;) > > I wasn't for me, as I didn't know Vulca

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> It would be also interesting if "reads" exposed in various places (isql, > monitoring tables, trace api) are pure physical reads from disk and/or > fetched from the OS file system cache. > > I guess, it could be also from the file system cache, because I've seen > situations where execution t

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

Vlad, > PS Snapshot (concurrency) transaction guarantees that once read record > could be read again and will be the same. So, in theory, we can just > re-read same data page when looking for next record. Why "in theory"? I don't see how the DP could change for the purposes of the next record fo

Re: [Firebird-devel] Trace API - Service names in include filter?

> - Original Message - > From: "Thomas Steinmaurer" > To: "For discussion among Firebird > Developers" > Sent: Tuesday, November 15, 2011 12:43 AM > Subject: Re: [Firebird-devel] Trace API - Service names in include filter? > > the fbtrace.conf sample file has examples on what service

Re: [Firebird-devel] Trace API - Service names in include filter?

- Original Message - From: "Thomas Steinmaurer" To: "For discussion among Firebird Developers" Sent: Tuesday, November 15, 2011 12:43 AM Subject: Re: [Firebird-devel] Trace API - Service names in include filter? >>> the fbtrace.conf sample file has examples on what services names one

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

>>> In your example we see 7149 physical reads and 214192 times this >>> pages was referenced by the engine. To read a record engine needs to >>> access pointer page and (at least one) data page. You have ~100K records >> so we can explain ~200K fetches. >> >> Ok, but is there a way then to t

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> On Mon, Nov 14, 2011 at 5:11 PM, Thomas Steinmaurer > wrote: > > > Ok, but is there a way then to tell how many pages have been fetched > from the cache as the number above for fetched is more likely > "referenced" and not real number of pages fetched fr

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> Hi Vlad, > > >>In your example we see 7149 physical reads and 214192 times this pages >> was >> referenced by the engine. To read a record engine needs to access pointer >> page and >> (at least one) data page. You have ~100K records so we can explain ~200K >> fetches. >> >> > I think that

Re: [Firebird-devel] Trace API - Service names in include filter?

>> the fbtrace.conf sample file has examples on what services names one >> can/should use when using e.g. the include filter. I'm not sure if the >> following is ok or as designed, thus I'm checking here ... >> >> I want to trace Database Stats and I tried the following include filter >> samples: >

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

On Mon, Nov 14, 2011 at 5:26 PM, Leyne, Sean wrote: > > > In your example we see 7149 physical reads and 214192 times this > > The ideal statistic that would help in knowing whether the cache needs to > be increased would be "disk re-reads", but that would require that the > engine track a li

Re: [Firebird-devel] Trace API - Service names in include filter?

> the fbtrace.conf sample file has examples on what services names one > can/should use when using e.g. the include filter. I'm not sure if the > following is ok or as designed, thus I'm checking here ... > > I want to trace Database Stats and I tried the following include filter > samples: >

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

Hi Vlad, >In your example we see 7149 physical reads and 214192 times this pages > was > referenced by the engine. To read a record engine needs to access pointer > page and > (at least one) data page. You have ~100K records so we can explain ~200K > fetches. > > I think that when doing an ex

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

Ann, > On Mon, Nov 14, 2011 at 4:40 PM, Thomas Steinmaurer > wrote: > > > So, the numbers I see is number of pages? > > > For reads and writes. Marks and Fetches are recorded each time a page > is referenced in cache. So if you read 20 records on a page, you'll

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

On Mon, Nov 14, 2011 at 5:11 PM, Thomas Steinmaurer wrote: > > Ok, but is there a way then to tell how many pages have been fetched > from the cache as the number above for fetched is more likely > "referenced" and not real number of pages fetched from memory? > Pages aren't fetched from cache.

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> > In your example we see 7149 physical reads and 214192 times this > > pages was referenced by the engine. To read a record engine needs to > > access pointer page and (at least one) data page. You have ~100K records > so we can explain ~200K fetches. > > Ok, but is there a way then to tell

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

On Mon, Nov 14, 2011 at 4:40 PM, Thomas Steinmaurer wrote: > > So, the numbers I see is number of pages? > For reads and writes. Marks and Fetches are recorded each time a page is referenced in cache. So if you read 20 records on a page, you'll probably get 40 fetches - one for each reference

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

- Original Message - From: "Thomas Steinmaurer" To: "For discussion among Firebird Developers" Sent: Tuesday, November 15, 2011 12:11 AM Subject: Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...) > Hi Vlad, > > as the subject says. What's the u

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

Hi Vlad, as the subject says. What's the unit for the resulting values for number of reads, writes, fetches, marks? Just want to be sure if a particular result makes sense here. ;-) >>> >>> Same as for isql's statistics - number of operations. Note, we have no >>> operations o

Re: [Firebird-devel] Trace - Character set in output

> Hello, > > I have the following character set (ISO88591) information in the trace > output: > > 2011-10-27T20:58:16.5210 (920:00D4DA30) COMMIT_TRANSACTION > fbtm_unittest.fdb (ATT_2, FBTM:NONE, ISO88591, TCPv4:127.0.0.1) > G:\Development\FBTraceManager\svn\trunk\qa\unittest\isq

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> Hi Vlad, > >>> as the subject says. What's the unit for the resulting values for number >>> of reads, writes, fetches, marks? Just want to be sure if a particular >>> result makes sense here. ;-) >> >> Same as for isql's statistics - number of operations. Note, we have no >> operations on g

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

Hi Vlad, >> as the subject says. What's the unit for the resulting values for number >> of reads, writes, fetches, marks? Just want to be sure if a particular >> result makes sense here. ;-) > > Same as for isql's statistics - number of operations. Note, we have no > operations on group of pa

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

> as the subject says. What's the unit for the resulting values for number > of reads, writes, fetches, marks? Just want to be sure if a particular > result makes sense here. ;-) Same as for isql's statistics - number of operations. Note, we have no operations on group of pages, so, for ex.

[Firebird-devel] Trace API - What's the unit for number of (reads | fetches ...)

Hello, as the subject says. What's the unit for the resulting values for number of reads, writes, fetches, marks? Just want to be sure if a particular result makes sense here. ;-) Thanks, Thomas -- RSA(R) Conference 2

Re: [Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

14.11.2011 23:15, Damyan Ivanov wrote: > # session 1 > $ FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb > Database: dbd-firebird-test.fdb > SQL> > > # session 2, from another terminal, running in the same working > # directory > FIREBIRD=. FIREBIRD_LOCK=. isql-fb dbd-firebird-test.fdb >

[Firebird-devel] second embedded connect hangs on armel, ia64, kfreebsd and s390

This came from the test suite of the Perl Firebird driver, DBD::Firebird, but I am able to reproduce it with plain isql, so the problem seems to be somewhere else -- either Firebird or libc. Firebird is 2.5.1.26351 from the Debian package, running on unstable. Embedded server. The rest of DBD:

[Firebird-devel] [FB-Tracker] Created: (CORE-3663) add new trigger-level variable (for example, :TABLE) to be passed as argument into common SP from several triggers

add new trigger-level variable (for example, :TABLE) to be passed as argument into common SP from several triggers Key: CORE-3663 URL: http://tr

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

On 14-11-2011 04:54, Alex Peshkoff wrote: > >> So, it's just a fact of allow it with the new API. And then there must >> be a way to libraries uses bits of the new API mixed with old one. >> > > May be I do not understand what you mean here... Why mix? > Because then previously written applicat

Re: [Firebird-devel] Still on the ext4 slowness...

On 14-11-2011 05:31, Vlad Khorsun wrote: > > My doubt is that we will write more pages than necessary. Imagine small > cache (CS) > and set of actively modifying pages. Currently we will write them one-by-one > when new > buffer is required. You offer to write, say, 2 pages at time and rep

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

On Sun, 13 Nov 2011 20:59:58 -0200, Adriano dos Santos Fernandes wrote: > On 13-11-2011 19:48, Alexandre Benson Smith wrote: >> >> I understand that such improvement could be hard to implement because of >> the changes on the API and that the access libraries must be recoded for >> such change,