Re: [firebird-support] Re: Firebird temp files
>>Either some GTT was used or temporary >>blob storage was requested. Why do >>you want it to be prevented? RAM is fast disc is slow and i have plenty of free RAM. Also i have bigger cache then database pages count and this operations can be all done in memory. >>In SS, it will be closed/deleted as soon as >>all connections are gone. I use SS then it never happen to me.. Regards,Karol Bieniaszewski null
Re: [firebird-support] Re: Firebird temp files
Yes, you have right but i really try to avoid RAM disc which consume memory always i prefer if some resource free memory it is available to be consumed by any process. Do you know why this file is created at all and especially why its handle is still active in firebird process few days? Regards,Karol Bieniaszewski null
Re: [firebird-support] Re: Firebird temp files
10.05.2018 8:47, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Thank you for the suggestion. We will consider RAM disc uses but first we > must be sure how > big it should be to catch all cases. It, actually, doesn't matter. If you configure several temporary locations, starting from your RAM drive, Firebird will switch to next one when the first is full. -- 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: Firebird temp files
Hi, Thank you for the suggestion. We will consider RAM disc uses but first we must be sure how big it should be to catch all cases. It should be docummented how temp tables work (maybe it is somwhere?) with temp files. Regards,Karol Bieniaszewski null
RE: [firebird-support] Re: Firebird temp files
Hi Karol, we have chosen the following solution to avoid temp disk writes: * Firebird 2.5.8 classic default configuration (with 2 changes see below) * 456 databases (~379 GB) * average ~4000 fb_inet_server processes * 10 GB ramdisk (/ramdisk/fb_temp) for external files and for tempdirectories (chmod 700 for firebird user): * ExternalFileAccess = /ramdisk/fb_temp;/hdd_path/fb_temp * TempDirectories = /ramdisk/fb_temp;/hdd_path/fb_temp This 10 GB more than enough for us. Based on the monitoring system data, it has never been completely full. András
Re: [firebird-support] Re: Firebird temp files
Ok, i understand temp file caching but why Firebird create this temp file at all and how to prevent this? And second question, why file handle is still active? Is this file for particular temporary table or it is a buffor for all temporary tables? Regards,Karol Bieniaszewski null
Re: [firebird-support] Re: Firebird temp files
>> No, caching is left up to OS. i do not understand above. I have dissabled os caching in firebird.conf. Also file is created by Firebird not OS. Can you explain this more? Regards,Karol Bieniaszewski null
Re: [firebird-support] Re: Firebird temp files
Thank you for the info Is there particular settings to go always into RAM or some buffer settings which i can increase to avoid going to disc? I have nowTempCacheLimit = 800MMentioned file is 29MB in size and dated 2 days old and its handle is still in use by Firebird process Regards,Karol Bieniaszewski null