Re: [firebird-support] Implicit path for Database
On 9/2/2017 11:49 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: >> Will be good also a way to specify the path where the databses are store >> if I not specify a path in connect string. > In firebird.conf set DatabaseAccess to Restrict. Databases will be > created in the first > directory in list. > > That really works. Thanks. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Sort error No free space found in temporary...
Hi Thomas, > From what i can read on the internet TempCacheLimit, is per server > process, and not per attachment. In SuperServer architecture, right, but if I remember correctly, you have mentioned in one of your first posts that you are using SuperClassic, right? > http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html Talking about SuperServer. > https://www.mail-archive.com/firebird-support@yahoogroups.com/msg10199.html Talking about SuperClassic with answers that it is per connection. > > > I believe I have found the statements that caused the problem, first one > was executede about 400/second and contained a union, that was replaced > by union all in the hope that would eliminate the need for temp cache. UNION vs. UNION ALL. UNION is removing duplicates, thus some sort of applying DISTINCT with first sorting to remove duplicates is applied. DISTINCT, sorting, group by (internally first doing a sort) will internally produce temporary data. > The second statement is a really nasty dynamically build common table > expression containing upwards of 10 union.. Here we are in the process > of moving this search to Elastisearch. > > We just purchased FB TraceManager at our company to weed performance > issues - Thanks for a great product : ) Great to hear. Thanks. :-) -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Re: Sort error No free space found in temporary...
Hey From what i can read on the internet TempCacheLimit, is per server process, and not per attachment. http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html http://firebird.1100200.n4.nabble.com/TempCacheLimit-td4309475.html https://www.mail-archive.com/firebird-support@yahoogroups.com/msg10199.html https://www.mail-archive.com/firebird-support@yahoogroups.com/msg10199.html I believe I have found the statements that caused the problem, first one was executede about 400/second and contained a union, that was replaced by union all in the hope that would eliminate the need for temp cache. The second statement is a really nasty dynamically build common table expression containing upwards of 10 union.. Here we are in the process of moving this search to Elastisearch. We just purchased FB TraceManager at our company to weed performance issues - Thanks for a great product : )
Re: [firebird-support] Implicit path for Database
01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: > Will be good also a way to specify the path where the databses are store > if I not specify a path in connect string. In firebird.conf set DatabaseAccess to Restrict. Databases will be created in the first directory in list. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Sort error No free space found in temporary...
Hi, > Thanks for the advise Thomas I will increase the value. > After we changed TempCacheLimit to 567108864, we saw the problem once > under heavy load - for a very sourt perio this time. Increased TempCacheLimit value as a side-effect of serving more temp stuff through RAM instead of spilling onto disk, thus somehow makes sense to see the too many open files less frequent then. > Is it correct > understood that once TempCacheLimit was reached Firebird used /tmp/ > until the proccess reached the max open files? Sounds reasonable, yes. > Regarding TempBlockSize and TempCacheLimit do you or any other know of a > way to monitor if the configured value is too low or the limit is about > to be reached? No, but I became a bit rusty regarding Firebird lately. :-) > Since the server has plenty of RAM i was thinking about configuring > TempCacheLimit to 2, 4 or 6 Gb, if this has no negative effect? As you have mentioned that you are using SuperClassic, mind that TempCacheLimit is maximum memory for temp stuff PER client connections in this architecture, thus if configured too high with a high number of concurrent connections, you may end up in exhausting host RAM, resulting in swapping to disk if hitting boundaries. > Likewise if there is no negative effect, is there anything to gain from > increasing TempBlockSize from 2 megabytes to perhaps 4 or 6? I doubt you will see a real difference. Beside that, perhaps you are able to pin the SQL statement producing the temp data load e.g. by using the Trace API. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Re: [firebird-support] Connect to FB database through VPN
On 1-9-2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support] wrote: > I have FB3 database at a customer site and was able to log in remotely > because they had Port Forwarding set on their router for Port 3050 and I > used the connection string - IP Address:Database Alias. Now they have > moved to a VPN (OpenVPN) and removed the Port Forwarding on port 3050. > I have setup OpenVPN on the remote computer and they have provided me > with the clientbundle for the SSL stuff. I can open the VPN and log onto > their server but when I try to connect to the database I get the error: > > > Unable to complete network request to host xxx.xxx.xxx.xx. Failed to > establish connection. > > Is there something different I should be doing to connect to a FB > database through a VPN? > > Any help would be appreciated. I think it would be better if you ask this on a forum that knows how OpenVPN works, because I would guess this might not be a Firebird problem. Are you sure you are using the right hostname (or IP address), is this IP address actually accessible/routed over the VPN, is the server actually listening on a port that is accessible from your host (eg could the Firebird server only be listening on 127.0.0.1, or at least not on the IP address available to you), a firewall could be blocking access, etc. Note that you can could try to discern if it is a Firebird problem, or a network/VPN problem: From your host telnet to the right IP address + port for the Firebird server. Eg on Windows (with the telnet client installed), do telnet If you get (almost immediately) a clear screen with a cursor waiting for input, then there is something listening (could be Firebird, could be something else). If you get a "Could not open connection" error almost immediately then the IP address is - likely - accessible but the port is not open, if it takes a few seconds before you get that same error then the IP address does not exist or is not accessible to you (because the network doesn't route it, or because a firewall 'blackholes' the port. Mark -- Mark Rotteveel