Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual cores 16% means that you are using 1 Core to the maxmimum Try running several Queries from different connections on classic server then you will use more cores Super Classic will Use 1 Core per Database , so that is all you get for your setup Per Connection not per database. Super Classic will only benefit you if you have several Databases You mean SuperServer here. Check out my FB 2.5 architecture comparison sheet: http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Re: How to maximize cpu usage for Firebird?
How do you know that you are CPU and not I/O bound? SuperClassic is capable to utilize SMP environments, but simplified one core per database connection. If you increase the number of database connections with CPU bound stuff, you should see an increase of CPU utilization. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Thanks for your reply. I run a few queries, all almost stuck at 16% cpu's utilization, so I guess, file I/O is ok. I have only 1 database in this machine. You said SuperClassic use 1 core per database connection. For 1 connection I got cpu's utilization about 16%, so, if there are 8 connection to the same database, running the same task, cpu's utilization will jump to 100%? Regards, Anto
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
How do you know that you are CPU and not I/O bound? SuperClassic is capable to utilize SMP environments, but simplified one core per database connection. If you increase the number of database connections with CPU bound stuff, you should see an increase of CPU utilization. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Thanks for your reply. I run a few queries, all almost stuck at 16% cpu's utilization, so I guess, file I/O is ok. I have only 1 database in this machine. You said SuperClassic use 1 core per database connection. For 1 connection I got cpu's utilization about 16%, so, if there are 8 connection to the same database, running the same task, cpu's utilization will jump to 100%? I doubt 100%, but more than 16%, if the other connections/workloads forces the Firebird server process to be CPU bound. Check out my following demo video here, discussing SMP utilization with different Firebird architectures: http://www.iblogmanager.com/download/demos/firebird/fb25_architectures_smp.html -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
On Thu, 18 Jul 2013 05:37:29 -, trskopo trsk...@yahoo.com wrote: --- In firebird-support@yahoogroups.com, Alexandre Benson Smith iblist@... wrote: Perhaps the bottleneck is not the CPU, maybe your disk subsystem can't provide information as fast as the CPU can process it. I think your CPU is sitting idle while waiting the disc provides the data. I/O bound x CPU bound process... see you ! Thanks for your reply. My database is on RAM, as I know it is the most fastest I/O for Firebird. I was watching cpu's utilization via window's task manager, almost constantly at 16%. If there was a bottleneck in I/O, whenever I/O processing finished, I should saw some raising in cpu's utilization. I though this was no bottleneck, it just seems that FB Server couldn't utilized more power from cpu. You are using SuperServer (based on a previous message of yours), that will only use a single core. That is even if you configure CpuAffinity to a different value, but then it will jump between cores which is detrimental to performance. You will need to switch to classic server to get more out of your number of cores. Mark
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
Hello, trskopo! Thursday, July 18, 2013, 10:39:04 AM, you wrote: t I have only 1 database in this machine. You said SuperClassic use 1 core per database connection. t For 1 connection I got cpu's utilization about 16%, so, if there t are 8 connection to the same database, running the same task, cpu's utilization will t jump to 100%? Classic and SuperClassic uses cores for multiple users, SuperServer - use only one core. But, if you use Classic or Superclassic, it does not guarantee that you will have 100% CPU load. RDBMS is not a calculator to load only CPU. RDBMS mostly cracks data. And data is on disk or in memory. So, if you have bad disk or memory I/O, CPU will mostly lower than 100%, because CPU load depends on what Firbird engine is doing to execute your query. -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: How to maximize cpu usage for Firebird?
I doubt 100%, but more than 16%, if the other connections/workloads forces the Firebird server process to be CPU bound. Check out my following demo video here, discussing SMP utilization with different Firebird architectures: http://www.iblogmanager.com/download/demos/firebird/fb25_architectures_smp.html -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Thanks for your video, very informative. Regards, Anto
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual cores 16% means that you are using 1 Core to the maxmimum Try running several Queries from different connections on classic server then you will use more cores Super Classic will Use 1 Core per Database , so that is all you get for your setup Per Connection not per database. Super Classic will only benefit you if you have several Databases You mean SuperServer here. Check out my FB 2.5 architecture comparison sheet: http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf Hi, You say that SS can utilize more CPU when connecting to diffren databases but Your comparison consider FB 2.5. Is this also true for FB 2.1 SS. As I remember setting CpuAffinityMask to more than 1 was not recommend earlier. Are firebird made some progress between FB 2.5 SS and FB 2.1 SS in this subject? Best Regards, macma
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual cores 16% means that you are using 1 Core to the maxmimum Try running several Queries from different connections on classic server then you will use more cores Super Classic will Use 1 Core per Database , so that is all you get for your setup Per Connection not per database. Super Classic will only benefit you if you have several Databases You mean SuperServer here. Check out my FB 2.5 architecture comparison sheet: http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf Hi, You say that SS can utilize more CPU when connecting to diffren databases but Your comparison consider FB 2.5. Is this also true for FB 2.1 SS. As I remember setting CpuAffinityMask to more than 1 was not recommend earlier. Are firebird made some progress between FB 2.5 SS and FB 2.1 SS in this subject? Yes. There is a difference between 2.5 SS and 2.1 SS. Also check out the 2.5 release notes p. 7ff. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Re: How to maximize cpu usage for Firebird?
Sorry, It it FB 2.5.2 You didn't mention which FB version you are running. While SuperClassic is the future for FB, I must say that we only use/deploy Classic for all our installs (100+ servers around the world). Sean
[firebird-support] Re: How to maximize cpu usage for Firebird?
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith iblist@... wrote: Perhaps the bottleneck is not the CPU, maybe your disk subsystem can't provide information as fast as the CPU can process it. I think your CPU is sitting idle while waiting the disc provides the data. I/O bound x CPU bound process... see you ! Thanks for your reply. My database is on RAM, as I know it is the most fastest I/O for Firebird. I was watching cpu's utilization via window's task manager, almost constantly at 16%. If there was a bottleneck in I/O, whenever I/O processing finished, I should saw some raising in cpu's utilization. I though this was no bottleneck, it just seems that FB Server couldn't utilized more power from cpu. Anto
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
Hello trskopo, you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual cores 16% means that you are using 1 Core to the maxmimum Try running several Queries from different connections on classic server then you will use more cores Super Classic will Use 1 Core per Database , so that is all you get for your setup Super Classic will only benefit you if you have several Databases --- In firebird-support@yahoogroups.com, Alexandre Benson Smith iblist@... wrote: Perhaps the bottleneck is not the CPU, maybe your disk subsystem can't provide information as fast as the CPU can process it. I think your CPU is sitting idle while waiting the disc provides the data. I/O bound x CPU bound process... see you ! Thanks for your reply. My database is on RAM, as I know it is the most fastest I/O for Firebird. I was watching cpu's utilization via window's task manager, almost constantly at 16%. If there was a bottleneck in I/O, whenever I/O processing finished, I should saw some raising in cpu's utilization. I though this was no bottleneck, it just seems that FB Server couldn't utilized more power from cpu. Anto ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Mit freundlichen GrĂ¼ssen Hannes Streichermailto:hstreic...@gmx.de