Re: [firebird-support] Re: Question about Temp Directory
ma_golyo wrote: > Hi! > > Temp dir is used only when there is not enough free memory for dataset > ordering (ORDER BY or GROUP BY). > > --- In firebird-support@yahoogroups.com, "trskopo" wrote: >> Hi all, >> >> I set temp directory for firebird 2.5.1 Super Server in firbird.conf like >> this : >> TempDirectories =e:\;d:\temp >> >> On Win 7 64, also set environment like these : >> - FIREBIRD_TMP = e:\;d:\temp >> - TEMP = e:\ >> - TMP = e:\ >> >> How do I know, firebird using that temporary directory? >> Running a few query via flamerobin, seems that firebird not using that >> directory. >> >> Thanks and regards, >> Anto >> Hej, simply point your tempdir to something non-existant and try to restore a database. It will stop at the end and you'll not getting it done. That's what the temp dir is used for, too. hth, Marcus
[firebird-support] Re: Question about Temp Directory
Hi! Temp dir is used only when there is not enough free memory for dataset ordering (ORDER BY or GROUP BY). --- In firebird-support@yahoogroups.com, "trskopo" wrote: > > Hi all, > > I set temp directory for firebird 2.5.1 Super Server in firbird.conf like > this : > TempDirectories =e:\;d:\temp > > On Win 7 64, also set environment like these : > - FIREBIRD_TMP = e:\;d:\temp > - TEMP = e:\ > - TMP = e:\ > > How do I know, firebird using that temporary directory? > Running a few query via flamerobin, seems that firebird not using that > directory. > > Thanks and regards, > Anto >
[firebird-support] Re: Hyper Threading, should it turn on or off?
Hi! HT is not good for databases beacuse of the shared cache, so it should be turned OFF. http://blogs.msdn.com/b/slavao/archive/2005/11/12/492119.aspx --- In firebird-support@yahoogroups.com, "trskopo" wrote: > > Hi all, > > I have windows 7 64bit pro with intel I7 and firebird 2.5.1 Super Classic. > > Should I turn HT on or off to boost firebird's performance? > > On some app, when HT is on, performance decrease, what about for firebird? > > Thanks and regards, > Anto >
[firebird-support] Question about Temp Directory
Hi all, I set temp directory for firebird 2.5.1 Super Server in firbird.conf like this : TempDirectories =e:\;d:\temp On Win 7 64, also set environment like these : - FIREBIRD_TMP = e:\;d:\temp - TEMP = e:\ - TMP = e:\ How do I know, firebird using that temporary directory? Running a few query via flamerobin, seems that firebird not using that directory. Thanks and regards, Anto
[firebird-support] Hyper Threading, should it turn on or off?
Hi all, I have windows 7 64bit pro with intel I7 and firebird 2.5.1 Super Classic. Should I turn HT on or off to boost firebird's performance? On some app, when HT is on, performance decrease, what about for firebird? Thanks and regards, Anto
[firebird-support] DefaultDbCachePages, does it has effects when db placed on RAM?
Hi all, When database file placed on RAM, should I decrease or increase the value of DefaultDbCachePages? Does it has effects on performance, since database already placed on RAM? Thanks and regards, Anto
Re: [firebird-support] Re: after 2.1 to 2.5 migration, nbackup seems to slow operations unusually
-- Original Message --- From: "unordained" To: firebird-support@yahoogroups.com Sent: Thu, 11 Jul 2013 09:51:17 -0500 Subject: Re: [firebird-support] Re: after 2.1 to 2.5 migration, nbackup seems to slow operations unusually > -- Original Message --- > From: Dmitry Yemanov > > Out of curiosity, did you try playing with -D ON/OFF modes for > > nbackup? If so, does it make any difference? > > > > Dmitry > --- End of Original Message --- --- End of Original Message --- I switched to -D OFF. It did cut the amount of time spent on incremental backups in half (now around 4 minutes), but during that time, I'm seeing concurrent queries still being delayed by 15 to 220 seconds. Even starting a transaction [from tomcat connection pool, jaybird] may be delayed 10 seconds, while nbackup is running. Only a few queries were allowed to complete in the middle of the backup; most that were started during the backup only completed when the backup itself completed, which I don't think is expected behavior for nbackup. I'm interested in some comments I find in CORE-2315, such as this: "... Users working is stopped only for changing backup state. It takes time for flushing cash. After that your users should use database as before. Now merging pages from delta to main database file takes more time than in new nbackup. There is a patch to improve nbackup but on superserver it has known issues and it don't allow to apply it in firebird. At least the merging process must be faster then now. ..." What's the known issue with SS? Also, we depend a lot on heavy on-commit triggers that "fix up" data modified during the transaction; it seems like when on-commit triggers take a long time, it has a knock-on effect on other connections (particularly starting new transactions, it seems like?) Any ideas on that? Could this be a cascading event, where slowness impacts a transaction that made changes and its on-commit took longer than usual, and then that caused other transactions to fail to start right away? -Philip
[firebird-support] employee.fdb
Is there a good reason for the employee.fdb database to use character set NONE (apart from this being described in Helen's Firebird book (and it has always been like this))? DBAs using NONE seem to be met with raised eyebrows (on this NG, at least), so why not use e.g. UTF8 in the example database. -- Aage J.
Re: [firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
On Thu, 11 Jul 2013 10:15:53 +0200 John vd Waeter wrote: > On 11-7-2013 09:44, Philippe Makowski wrote: > > Le 10/07/13 16:13, John vd Waeter a écrit : > >> So I tried: > >> - get a 32 bit libfbclient.so from another 32 bit machine. > >> - put it in /lib/i386-linux-gnu > >> - made a reference in /etc/ld.so.conf.d > >> - run ldconfig > >> > > bad idea > > > >> But the ibconnection in freepascal still cannot find it. > >> Maybe this is a freepascal question... I don't know. > >> Is it enough to get libfbclient.so from a 32 bit machine or is > >> does it depend on more 32 bit libraries? > > certainly more > > > > you should better do something like : > > > > sudo dpkg --add-architecture i386 > > sudo apt-get update > > sudo apt-get install libfbclient2:i386 [...] > That last extension (:I386) did it to get the 32 bit library. I > didn't know about such extension. That's the consequence of Wheezy supporting "multi-arch" for a large extent of its code base. It's detailed in [1] which is linked to from the official release notes document [2] (which you're supposed to read before upgrading or installing). > But still "cannot load error" while starting the program. > Could it be it finds the 64 bit libfbclient.so first and throws the > "can not load default Firebird clients" error? Did you undo your hacks to the dynamic linker configuration? After undoing, try running ldd /path/to/your/program and see if it shows you all the libraries it needs w/o signalizing any errors for any of them. Also try running your program while having LD_VERBOSE or LD_DEBUG set to something sensible in your environment (refer to the ld-linux(8) manual page for more info) -- the linker will print you what happens at it tries to satisfy all the dependencies to run your program. An example to get you started: $ LD_TRACE_LOADED_OBJECTS=1 LD_VERBOSE=1 /usr/bin/gcc
Re: [firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
On Thu, 11 Jul 2013 10:15:53 +0200 John vd Waeter wrote: [...] > But still "cannot load error" while starting the program. > Could it be it finds the 64 bit libfbclient.so first and throws the > "can not load default Firebird clients" error? A quick followup on debugging the dynamic loader job -- an invocation like this one $ LD_DEBUG=libs,files /usr/bin/gcc would provide you with details on what libraries the linker tried to load, why, and from where.
[firebird-support] Re: Using stored procedure results in the WHERE clause
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær wrote: > Moreover, I don't quite follow when you say that you need a view for each > possible combination, rather, I'd say you need a new column for each possible > combination and that whether this additional field should be added to an > existing view or a new view is something to investigate for each situation. I would need a separate view for each combination because I was thinking of using a JOIN to restrict the rows returned rather than creating a computed column for the view and then just testing the value of the computed column. In fact, I didn't know that you could create computed columns on a view like that. Another way to accomplish the same goal.
Re: [firebird-support] Re: after 2.1 to 2.5 migration, nbackup seems to slow operations unusually
-- Original Message --- From: Dmitry Yemanov > Out of curiosity, did you try playing with -D ON/OFF modes for > nbackup? If so, does it make any difference? > > Dmitry --- End of Original Message --- Haven't touched it yet, I can do that this afternoon (gathering data this morning on how re-upping the lock-hash-slots to 5099, and increasing the lock-memory, affects things.) Since we're on Windows Server 2008, the nbackup default would be 'ON', right? And since we've got the cache-quota set now (default 30% of RAM), I guess the logic would be that it ought to be safe enough to let nbackup allow the OS filesystem cache to help it out, rather than brute-force it? Or is there some other logic to messing with the setting? I'm not sure why the behavior would have changed from 2.1.5 though, all else being equal... Thanks! -Philip
Re: [firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
Never mind, found it! ldd libfbclient.so showed that it depended on another library that was missing. After installing this library, everything worked. Thanks for thinking along :-) John On 11-7-2013 10:15, John vd Waeter wrote: > On 11-7-2013 09:44, Philippe Makowski wrote: >> Le 10/07/13 16:13, John vd Waeter a écrit : >>> So I tried: >>> - get a 32 bit libfbclient.so from another 32 bit machine. >>> - put it in /lib/i386-linux-gnu >>> - made a reference in /etc/ld.so.conf.d >>> - run ldconfig >>> >> bad idea >> >>> But the ibconnection in freepascal still cannot find it. >>> Maybe this is a freepascal question... I don't know. >>> Is it enough to get libfbclient.so from a 32 bit machine or is does it >>> depend on more 32 bit libraries? >> certainly more >> >> you should better do something like : >> >> sudo dpkg --add-architecture i386 >> sudo apt-get update >> sudo apt-get install libfbclient2:i386 >> >> > Hi Philippe, > > Thanks for answering. > > That last extension (:I386) did it to get the 32 bit library. I didn't > know about such extension. > But still "cannot load error" while starting the program. > Could it be it finds the 64 bit libfbclient.so first and throws the "can > not load default Firebird clients" error? > > > John > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > > >
Re: [firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
On 11-7-2013 09:44, Philippe Makowski wrote: > Le 10/07/13 16:13, John vd Waeter a écrit : >> So I tried: >> - get a 32 bit libfbclient.so from another 32 bit machine. >> - put it in /lib/i386-linux-gnu >> - made a reference in /etc/ld.so.conf.d >> - run ldconfig >> > bad idea > >> But the ibconnection in freepascal still cannot find it. >> Maybe this is a freepascal question... I don't know. >> Is it enough to get libfbclient.so from a 32 bit machine or is does it >> depend on more 32 bit libraries? > certainly more > > you should better do something like : > > sudo dpkg --add-architecture i386 > sudo apt-get update > sudo apt-get install libfbclient2:i386 > > Hi Philippe, Thanks for answering. That last extension (:I386) did it to get the 32 bit library. I didn't know about such extension. But still "cannot load error" while starting the program. Could it be it finds the 64 bit libfbclient.so first and throws the "can not load default Firebird clients" error? John
[firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
Le 10/07/13 16:13, John vd Waeter a écrit : > So I tried: > - get a 32 bit libfbclient.so from another 32 bit machine. > - put it in /lib/i386-linux-gnu > - made a reference in /etc/ld.so.conf.d > - run ldconfig > bad idea > But the ibconnection in freepascal still cannot find it. > Maybe this is a freepascal question... I don't know. > Is it enough to get libfbclient.so from a 32 bit machine or is does it > depend on more 32 bit libraries? certainly more you should better do something like : sudo dpkg --add-architecture i386 sudo apt-get update sudo apt-get install libfbclient2:i386
[firebird-support] Re: Freepascal 32 bit service on debian amd64 / 64 bit firebird?
Le 10/07/13 16:13, John vd Waeter a écrit : > So I tried: > - get a 32 bit libfbclient.so from another 32 bit machine. > - put it in /lib/i386-linux-gnu > - made a reference in /etc/ld.so.conf.d > - run ldconfig > bad idea > But the ibconnection in freepascal still cannot find it. > Maybe this is a freepascal question... I don't know. > Is it enough to get libfbclient.so from a 32 bit machine or is does it > depend on more 32 bit libraries? certainly more you should better do something like : sudo dpkg --add-architecture i386 sudo apt-get update sudo apt-get install libfbclient2:i386