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

2012-11-20 Thread marius adrian popa
wrote: > > >> -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 an

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

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 pr

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

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

2012-11-19 Thread Doychin Bondzhev
On 19.11.2012 г. 16: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

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).

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

2012-11-14 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 a

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

2012-11-14 Thread Alex Peshkoff
On 11/14/12 15:25, Poul Dige wrote: >> -Oprindelig meddelelse- >> Fra: Alex Peshkoff [mailto:peshk...@mail.ru] >> Sendt: 14. november 2012 07:15 >> Til: firebird-devel@lists.sourceforge.net >> Emne: Re: [Firebird-devel] True SMP support in SuperClassic and V3

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

2012-11-14 Thread Poul Dige
> -Oprindelig meddelelse- > Fra: Alex Peshkoff [mailto:peshk...@mail.ru] > Sendt: 14. november 2012 07:15 > Til: firebird-devel@lists.sourceforge.net > Emne: Re: [Firebird-devel] True SMP support in SuperClassic and V3 > > On 11/13/12 18:18, Poul Dige wrote: &g

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

2012-11-13 Thread Alex Peshkoff
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 at a gaze. We see exactly the same kind of > usage, 8 cores are

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 wrote: > > I could put a screen dump here of the Windows 2008R2/63 task manager > with > >

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 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 > kind of usage

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

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 doin

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, 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

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'

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. Perh

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 Alex Peshkoff
On 11/12/12 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. CPUAffinityMask makes no difference (as > stated in

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

2012-11-12 Thread Carlos H. Cantu
Title: Re: [Firebird-devel] True SMP support in SuperClassic and V3 Vince, FB 3 snapshot is already available for download, so you can check it by yourself (and if so, please report the results here). Actually, with such "heavy" server, I think you can help the "Project" a

[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. Window