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
[firebird-support] Re: Firebird temp files
09.05.2018 20:02, liviuslivius wrote: > Ok, i understand temp file caching but why Firebird create this temp > file at all and how to prevent this? Either some GTT was used or temporary blob storage was requested. Why do you want it to be prevented? > And second question, why file handle is still active? In SS, it will be closed/deleted as soon as all connections are gone. Dmitry
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
[firebird-support] Re: Firebird temp files
09.05.2018 17:15, liviuslivius wrote: > >> 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? You've disabled file-level caching for the database file, but this setting doesn't affect temporary files. While they're created by Firebird, Windows is asked to aggressively cache them if possible: Quoting MSDN: "Specifying the FILE_ATTRIBUTE_TEMPORARY attribute causes file systems to avoid writing data back to mass storage if sufficient cache memory is available, because an application deletes a temporary file after a handle is closed. In that case, the system can entirely avoid writing the data. Although it does not directly control data caching in the same way as the previously mentioned flags, the FILE_ATTRIBUTE_TEMPORARY attribute does tell the system to hold as much as possible in the system cache without writing and therefore may be of concern for certain applications." There's no such a hint on Linux though, the default file-caching policy is used there. To ensure in-memory storage, TempDirectories may be tuned to redirect writes to tmpfs, for example. Dmitry
[firebird-support] Re: Firebird temp files
09.05.2018 11:41, liviuslivius wrote: > Is there particular settings to go always into RAM or some buffer > settings which i can increase to avoid going to disc? No, caching is left up to OS. > I have now > TempCacheLimit = 800M It doesn't affect GTTs. Dmitry
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
[firebird-support] Re: Firebird temp files
09.05.2018 10:25, liviuslivius wrote: > > what is the purpose of temp file named e.g. > fb_table_yfz4x5? Storage for global temporary tables. Dmitry
