Using Firebird Super Classic in Win 7 64 on I7 2600K, I noticed that on a
high load, Firebird server never utilize cpu more than 16%.
Since the machine is a dedicated Firebird Server, are there any settings so
Firebird server can utilize more cpu?
How do you know that you are CPU and not
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
On 18.7.2013 7:08, Josef Kokeš wrote:
Hi!
I realize that the official answer to can I rename an index is no,
and that directly writing to the system tables is generally a poor idea.
But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in
RDB$INDICES and RDB$INDEX_SEGMENTS? I
I realize that the official answer to can I rename an index is no,
and that directly writing to the system tables is generally a poor idea.
But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in
RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to
scratch, where
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
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
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
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
On Thu, 18 Jul 2013 09:20:58 +1200, Helen Borrie hele...@iinet.net.au
wrote:
At 08:55 a.m. 18/07/2013, rddymanohar wrote:
Hi,
We are on Firebird 1.56 and recently encountered database corruption
problem with a customer. Found that forced write was turned off on the
database and after the database
On Thu, 18 Jul 2013 09:20:58 +1200, Helen Borrie hele...@iinet.net.au
wrote:
At 08:55 a.m. 18/07/2013, rddymanohar wrote:
Hi,
We are on Firebird 1.56 and recently encountered database corruption
problem with a customer. Found that forced write was turned off on the
database and after the
18.07.2013 8:57, Alexandre Benson Smith wrote:
I think you meant RDB$USER_PRIVILEGES where you wrote
RDB$USER_PROCEDURES, right ?
Sure. Just a sync error between head.sys and hands.sys ;-)
Dmitry
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:
A
nyone?
-- Forwarded message --
Hi,
(running 2.1.5 on centos) I tried to kill a exceptionally long-running
query (several hours) by deleting the row from MON$STATEMENT, no errors but
it didn't delete. I was connected via isql as sysdba, the query wasn't
using sysdba
select *
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
If it is classic server you can you find the PID and kill the process?
-steve
--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139
www.specializedbusinesssoftware.com
www.docunym.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936
On
Hi Steve, that's what I did in the end but I would really like to know why
removing the row didn't work
On 18 July 2013 14:43, Steve Wiser st...@specializedbusinesssoftware.comwrote:
If it is classic server you can you find the PID and kill the process?
-steve
--
Steve Wiser
President
On Thu, 18 Jul 2013 14:47:40 +0100, Nick Upson n...@telensa.com wrote:
Hi Steve, that's what I did in the end but I would really like to know
why
removing the row didn't work
It looks like http://tracker.firebirdsql.org/browse/CORE-3977 which will
be fixed in 2.5.3
Deleting the attachment from
1. Windows 2008 R2 Enterprise 64bit
2. Not sure on the version all they said was 2.5.2 when they upgraded
us.
3. FileSystemCacheSize = 70. They put this in at the very end of the
conf file with NO # signs around it. Every other line in the conf file
starts with #.
Example:
#
On Wed, 17 Jul 2013 16:32:19 -0400, Dom Kasony d...@harkel.com wrote:
We are running Firebird 2.5.2 and the software we use that utilizes
firebird
is very slow in some areas such as compiling reports. Do to caching and
speed, they suggested that we increase the page size and percent of RAM
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
20 matches
Mail list logo
