Re: [firebird-support] How to change cpu utilization in Firebird engine?
Thanks for your clarification. I was planning to upgrade my cpu with a used Xeon 2683 V3 (price on my country is about the same with I7 6700K), but it has 14 cores & 35MB L3 cache. So, I guess, a single connection in Firebird 3.0 will running poorly on Xeon 2683 V3, it will only utilized about 7% cpu. I have to re evaluate again this plan. Btw, if there are 6 connection on 4 cores, how is cpu utilization calculate? Thanks & regards, Anto.
Re: [firebird-support] How to change cpu utilization in Firebird engine?
On Thu, Jan 5, 2017 at 9:54 PM, trsk...@yahoo.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > As you know, on a single connection, Firebird's cpu utilization calculate > by 100% / no of cores. > That's not an arbitrary limit. Firebird is not capable of running a single connection on multiple threads, and a single thread runs only on a single core. Firebird 3 in SuperServer mode can run different connections on different threads - a great step forward! - but when there is a single connection it runs on a single thread. Prior to V3, the only way you could use multiple cores was to run Firebird in Classic or Super Classic mode. > > On my 6 cores cpus, its only utilized 100% / 6 = 16%. > Right. That's the way it is. > During database maintenance & testing (backup, restore, testing, etc) , > sometimes, i feel it was to slow. > You could try classic, but I suspect that you're running a single connection which cannot be run on more than one core. > > I want to change cpu utilization only for my own use. I have downloaded > Firebird source code, please help me to point out which codes I should > change & if my knowledge is enough is I only have basic C? > The Firebird group does not impose the "single core per connection" limit arbitrarily just to annoy users. Breaking a query up so it runs on multiple cores is a hard problem, so I doubt very much that someone with basic C skills and little background in developing database managers would have much success implementing it. Good luck, Ann
Re: [firebird-support] How to change cpu utilization in Firebird engine?
06.01.2017 3:54, trsk...@yahoo.com [firebird-support] wrote: > please help me to point out which codes I should change & if my knowledge is > enough is I > only have basic C? No way you or someone else can do this with current Firebird architecture, sorry. -- 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/