Re: [firebird-support] Will we move when yahoo Groups close theirs doors?
https://stackoverflow.com/questions/35966337/transition-from-yahoo-groups-to-google-groups On 18.10.2019 ã. 14:45, emb_blas...@hotmail.com [firebird-support] wrote: > > Hi! > > Recently I learned that Yahoo! will close Groups. > > We will lose all the content? > > Will we move to another platform? Where? > > > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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: NVME drive optimize for firebird engine
Hi, You can try by turning Forced writes off on the database. Firebird does very frequent writes to it's transaction pages and that is overkill for SSD. Without good write cache this hurts performance a lot. I suggest you do the above only to test and see is there any difference in the performance. Another option I use is SSD in PCIE with database forced write OFF and replication of that database on regular SSD or HDD where forced write is ON. This is possible because replication does not use many transactions to transfer data between databases. There is a chance that your database can loose some data in case of power failure but that will be limited up to the data that was not replicated on the other database. Replication on every minute is OK for databases that don't process to many transactions. Also if your server is protected by UPS which should be the case for every production system then you probably can do normal shutdown procedure so the chance to loose data is decreased. On 11.4.2018 ã. 8:33, ma_go...@yahoo.com [firebird-support] wrote: > Hi! > > Do not use software RAID, it has no disc cache and IO becomes terribly > slow. You have to use harware RAID with BBU ho have disc cache and good > performance. > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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] Ryzen R7 vs Kaby Lake 7700K, which one to choose?
Hi, I just got my last piece (the motherboard) for my new Ryzen system. I'll install all the software during the next few days and will write back here about my experience with FB. I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the storage (RAID 10 with 6 HDD) so I expect there will be very decent speed up for FB. At least my personal experience shows that for well written code the biggest problem is the database storage. For classic or super classic you will get better results with Ryzen when you have multiple clients accessing your database then with KL. KL is good for super server or for small number of clients where higher IPC will help you to process queries faster. but all this is irrelevant if you have slow storage. Doychin On 23.3.2017 ã. 05:00 ÷., trsk...@yahoo.com [firebird-support] wrote: > > > Hi all, > > I am considering to upgrade my development cpu. > > Between Ryzen & KL, although Ryzen is very good at multi threaded > processing, I guest, for Firebird, KL will be faster. > > For development, mostly I used only single connection to FB, and since > FB distributed workload among cores, for a single connection, total > utilization for all cores is the same as 100% utilisation for 1 core, > and for 1 core operation, KL is more superior than Ryzen. > > Can anyone confirm this? Or has anyone here have a Ryzen and care to > share the experience using Ryzen with FB? > > Thanks & regards, > Anto > > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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/
[firebird-support] Looking for example how to use FBTraceManager api in java.
Hi, I'm looking for some example how to use TraceAPI provided in Jaybird. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
[firebird-support] how to keep history of statements per transaction?
Hi, I'm looking for easy to use solution that can help me trace statements executed inside every transaction and keep them until transaction is active. Once it is closed(commit or rollback) statements are discarded. I need this to be able to run on a production system in order to track which code path leaves open transaction or keeps transaction open for long time. Any ideas how to make this? -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird Embedded on web hosting
The only protection that I found until now is to use forced writes on the database. this can save you from real troubles. Without this option turned off you might lose some data even when your database is in perfect shape. With forced writes you have the guarantee that at least until the last transaction everything is stored on the disk and only data you might loose is the last transaction that was unable to store it's changes to the disk. If corruption is in the area where index data is stored this is not a problem. You can always backup/restore your database and rebuild the broken indexes. Also another way of protecting your data is to make regular backups. But I'm not sure how you will accomplish this in embedded mode. I always use classic server. Hope this helps. On 21.9.2015 ã. 13:24 ÷., Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > If the computer loses power (and is turned off) when Firebird is writing > to the database, the database may become corrupt. > Are there any firebird settings that can make it so that there is a > smaller chance of database corruption? > > Glenn Thomas Hvidsten > > From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: 21. september 2015 11:57 > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird Embedded on web hosting > > > > sorry but i didn't understand your point ... can you explain more please ? > > > anyway, since i cannot control where fbembedded put it's lock and trace > files, my only option now is to build firebird from source and change > the directory by hand . > > > > > Denne epost har blitt kontrollert for virus av Comendo Norge AS > This e-mail has been scanned for viruses by http://www.comendo.no > **** > > > [Non-text portions of this message have been removed] > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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] Install 2.1 on RH 6
You need to install compat-libstdc++-33 package. That package will give you the needed C++ libraries to run firebird on RHEL/CentOS 6 On Sat, Apr 18, 2015 at 10:37 PM, Emil Totev em...@tot-consult.com [firebird-support] firebird-support@yahoogroups.com wrote: I will have to install firebird 2.1 (preferably latest 2.1.7) on 64-bit RHEL/CentOS 6 based linux. (I understand 2.1 is discontinued, but some program vendors don't). The rpm and tar.gz packages from firebird.sql seem to fail [at least] because of libstdc++ - if I understand correctly, they need libstdc++.so.5 while I have libstdc++.so.6 I couldn't find an rpm or pre-compiled 2.1.7 binary for RHEL/CentOS6, but maybe I didn't know how and where to look. Can anyone suggest anything else to try before I start trying to compile from sources? (Never done that and have the impression it may not be that easy). Thanks Emil
Re: [firebird-support] Re: Simultaneous inserts / selects
On 9.10.2014 ã. 14:32 ÷., brucedickin...@wp.pl [firebird-support] wrote: Thank you guys for your input! I appreciate it! I have some doubts.. isn't TCP/IP a bottleneck here? I mean, I am sending for example 4 times (4 threads) more data to insert via network. @Doychin I do have like 2-3 indexes per table but the speed in single thread was sufficient. Thanks, I hope my quest will give me some nice results:) @Kjell Could you shed some more information about your solution? So you first insert data to external table and then you move all that data at once into the main table? @Dmitri 300 threads? The question is how many of them are hitting the database at the same time? I have one more generall question, do you perform your inserts one by one, I mean: StartTransaction; Insert; Insert; Insert; Commit; or do you generate a batch script? a text file which have in it 1000 records, or 1 or more? Can't you use insert with parameters? This way you will prepare the statement only once and just execute it many times with different parameters. Doing insert with multiple statements without parameters can hurt performance. Statement must be prepared every time and that takes time and round-trip to the server. What language/library you will use to do this job? regarding the size of batch you can do some testing. performance might depend on the number of threads in this case. You need to find the right balance because in case of failure the whole batch will fail. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing provisioning solution for Service providers PowerStor - Warehouse POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2
Hi Costantino, I did some experimenting before one year and I found that Firebird is much faster when you use page size = cluster size on the file system. So if your file system is with 4K cluster I suggest to use page size of 4K. This is very helpful when you have Forced Write = ON. Performance gain with insert only scenario is more then 10-15% from 16K page on Windows 7 with RAID 10. another thing to look for is to try to minimize the number of transactions you create. Try to put as many as possible statements into single transaction. So for this check do you use autocommit on every statement or you wrap all statements executed while processing single file in one transaction. Also when you process your lines in the input file try to group as many as possible selects into single select. for example: select field1, filed2, filed3, field4 from table1 where field1 = ? and field2 = ? into : select field1, filed2, filed3, field4 from table1 where (field1 = ? and field2 = ?) or (field1 = ? and field2 = ?) or (field1 = ? and field2 = ?) .. this way you will check for multiple values at once and that means less selects to execute on the database. If you do your query on single field then you can use IN instead of = Check also you have proper index setup on the tables. Usually execution that is IO heavy does not get much better performance by just changing the hardware. If you move from HDD to SSD this can speed up much more but HDD performance is not very different in the last 10 years. Also another thing to note is that for DB scenarios I prefer to use Read Caching and no Write caching. This gives me better guarantee that I will not end with broken database in case of power failure. Have a nice day. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing provisioning solution for Service providers PowerStor - Warehouse POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
[firebird-support] Re: Optimizing Firebird for SSD
Small size is actually value between 128-256 pages which is much more then what CS has now as default value. Be careful with that because Firebird will copy pages to its cache before referencing their contents. If you make the database cache too small, you'll spend a lot of cycles doing memory to memory copies. Lots cheaper than disk reads, of course, but not free. Good luck, Ann
RES: [firebird-support] Re: Optimizing Firebird for SSD
If you use Linux as Database OS you can create ram disk very easy. It is part of the OS. There is no limitation for the size. Only the available RAM memory is your limit. When you use RAM disk you can set the size of your database cache to some small value because all data is already in the RAM. Also there is the option of shadow files. You can create a shadow file to fast HDD instead of doing backups very often. In this case you can resume your operation by just copying the shadow file in the RAM disk on next reboot. In this scenario you will have very fast read but again slow writes. Again the best scenario is to use RAID 10 with good RAID controller. This gives you enough speed on both read and write and protection against power failure. Doychin Bondzhev --- In firebird-support@yahoogroups.com, karolbieniaszewski liviuslivius@... wrote: Here is link to good Ram Disc software http://www.romexsoftware.com/en-us/vsuite-ramdisk/download.html there is free version up to 4GB Ram Disc if you need bigger you must buy it - but price is not big Karol Bieniaszewski --- In firebird-support@yahoogroups.com, Fabiano fabianoaspro@ wrote: I mean: How to create a ram disc?
[firebird-support] Re: Optimizing Firebird for SSD
While I really enjoy a SSD in my development machine, I have no real long-time experience with higher-prized enterprise class SSDs, but I guess you are using a normal consumer SSD? Yes we used cheap SSD at the time when we decide to go this way. I'm not sure if I would use consumer SSDs as a host for Firebird databases at all. For sure not in a RAID with no TRIM support etc. Firebird is known to write very frequently e.g. on the transaction inventory page (TIP). So, even small, but a lot of writes are going on, which is a pretty serious scenario for the life-time and performance of a SSD. And due to similar life-time patterns, SSDs in a RAID might fail pretty much at the same time, although I don't have any real evidence for that. Well my experience shows exactly what you say here. And that was my initial assumption for our problems recently. That's why I initiated this thread here to see is there any way to lower the write operations to the SSD by caching changes in memory for longer period of time. Instead of ding write for each transaction to to that for 10 or even more transactions (all this depends on the rate transactions are completed) That's why I asked the question what will be the impact of FW=OFF and by using other parameters to make sure that modified pages will be written after reaching specif number or after some time. Are TIP bounded by same rules like other pages or they are always written on transaction completion? I would rather stay away from a SSD for Firebird databases and use fast HDDs instead. Ideally RAID 10 with a decent RAID controller and not one onboard of the motherboard. If you can't afford that and you need good write performance, I would at least separate the OS, the Firebird database and temp files onto separate disks. In our configuration we use dmraid on Linux and it gives us decent performance for the size of the installation. We intend to change SSD with faster HDD when prices get back to normal levels. For example WD 10K 150GB. Possibly you can invest into more RAM and use a RAM disk with the extra RAM for hosting Firebird temp files. System already has 8G RAM for what it does and is more then enough. A long-term test case with consumer SSDs hosting Firebird database would be interesting though. As I said, I have no real experience with using SSDs as server disks in production. Our experience shows that consumer SSD is not a good choice for Firebird database. Maybe if there is good RAID controller with batter to protect it's cache and with enabled write caching this might help a little.
[firebird-support] Re: CPU selection for Firebird Database
My preferred configuration for software I write is: Xeon or i7 based system + 4 or 8 GB RAM + 4 HDD in RAID 10 configuration with integrated linux RAID. If you have budget for more you can get good RAID controller. I use Adaptec 2504. It is cheap and offers enough features. Finally it all depends on the workload you have to cover with this server. I also have small installations with much older hardware with RAID 1. But for what they do they are good enough.
[firebird-support] Optimizing Firebird for SSD
hi guys, I'm having this setup here: linux 64 bit server with RAID 5 for database storage. My database is stored on raw device. Right now I'm using FW=ON for this setup. any ideas how to optimize performance for this configuration? The problem is with write operations. They take to much time and this is OLTP database so write should be very fast. I'm considering the option to migrate this RAID back to HDD in order to speed up write operations. I'm also considering the option of FW=OFF with MaxUnflushedWrites set to some low value like 100 and MaxUnflushedWriteTime set to 4-5 seconds. Any other ideas? Also what will be the effect if I use the above mentioned settings on the page writes that contain completed transactions? Thanks in advance