Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-19 Thread Poul Dige
Fra: Alex Peshkoff [mailto:peshk...@mail.ru] On 11/13/12 18:18, Poul Dige wrote: I could put a screen dump here of the Windows 2008R2/63 task manager with AMD Opteron 6274, 2x16 core running FB2.5.1 SC/32 bit (due to some 32 bit UDF). I don't know if you are interested

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-19 Thread Alex Peshkoff
On 11/19/12 18:59, Poul Dige wrote: Fra: Alex Peshkoff [mailto:peshk...@mail.ru] On 11/13/12 18:18, Poul Dige wrote: I could put a screen dump here of the Windows 2008R2/63 task manager with AMD Opteron 6274, 2x16 core running FB2.5.1 SC/32 bit (due to some 32 bit UDF). I don't know if

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-19 Thread Adriano dos Santos Fernandes
On 19-11-2012 14:39, Alex Peshkoff wrote: Are there any suggestions what I should try to do next? We have actually 2 similar servers, both running 2.5.1SC (for now). The other server COULD be equipped with CS instead, if that would make a lot of sence as a trial. Even SS, as it primarily

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-19 Thread Poul Dige
-Oprindelig meddelelse- Fra: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] Sendt: 19. november 2012 17:47 Til: For discussion among Firebird Developers Emne: Re: [Firebird-devel] True SMP support in SuperClassic and V3 On 19-11-2012 14:39, Alex Peshkoff wrote

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-13 Thread Poul Dige
Fra: Dmitry Yemanov [mailto:firebi...@yandex.ru] 12.11.2012 16:52, vince.dug...@virginactive.co.za wrote: When running under load (150+ busy connections) SuperClassic clearly uses only one NUMA node (threads are spread across 16 cores), while Classic is spread evenly across all 64

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-13 Thread Mark Rotteveel
On Tue, 13 Nov 2012 14:18:22 +, Poul Dige p...@tabulex.dk wrote: I could put a screen dump here of the Windows 2008R2/63 task manager with AMD Opteron 6274, 2x16 core running FB2.5.1 SC/32 bit (due to some 32 bit UDF). I don't know if you are interested at a gaze. We see exactly the same

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-13 Thread Poul Dige
Fra: Mark Rotteveel [mailto:m...@lawinegevaar.nl] Emne: Re: [Firebird-devel] True SMP support in SuperClassic and V3 On Tue, 13 Nov 2012 14:18:22 +, Poul Dige p...@tabulex.dk wrote: I could put a screen dump here of the Windows 2008R2/63 task manager with AMD Opteron 6274, 2x16

[Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread vince . duggan
Hi all, I have been doing a lot of testing on a monster Windows server so that we can move from a Solaris 2.1.3 build (thanks Paul) to 2.5 on preferably Windows, or perhaps Linux. The box has 8 processors, each with 8 cores. These are arranged into 4 NUMA nodes, each with 2 processors.

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread Ivan Arabadzhiev
I might have a theory on that subject. With HT you share the same execution blocks among two pipelines (meaning you are trying to balance twice as many threads/instructions and so on, without increasing reorder caches/registers/data and instruction caches and other important factors). On a

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread Dmitry Yemanov
12.11.2012 16:52, vince.dug...@virginactive.co.za wrote: When running under load (150+ busy connections) SuperClassic clearly uses only one NUMA node (threads are spread across 16 cores), while Classic is spread evenly across all 64 cores. Weird, I'd expect them behaving the same way. Perhaps

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread vince . duggan
Hi all, Thanks for the replies and comments. Vince, FB 3 snapshot is already available for download, so you can check it by yourself (and if so, please report the results here). I have V3 running on a much smaller VM, just to test if my stress tests run at all - short answer : they don't

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread Alex Peshkoff
On 11/12/12 19:18, vince.dug...@virginactive.co.za wrote: Hi all, Thanks for the replies and comments. Vince, FB 3 snapshot is already available for download, so you can check it by yourself (and if so, please report the results here). I have V3 running on a much smaller VM, just to test

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread Carlos H. Cantu
IA When you have a single user (filling the info in the database) you don`t IA feel the difference because it is basically the same CPU core doing the IA work. Here is more information (from my logs and memory): The LOAD was set to simulate 10 users inserting information at the same time so,

Re: [Firebird-devel] True SMP support in SuperClassic and V3

2012-11-12 Thread Carlos H. Cantu
Sorry, the affinity setting was about SS, not SC. Wrong copy/paste ;-) []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br IA When you have a single user (filling the info in the database) you don`t IA feel the difference because it is basically the same CPU core doing