[firebird-support] How do return the number of object in a Firebird database
Greetings All, v1.5.3 I need to know how many tables, indicies, functions, stored procedures, etc are in my Firebird database. Is there a quick way to determine this? Thanks, Mike [Non-text portions of this message have been removed]
Re: [firebird-support] How do return the number of object in a Firebird database
On 17.7.2013 13:55, Softtech Support wrote: Greetings All, v1.5.3 I need to know how many tables, indicies, functions, stored procedures, etc are in my Firebird database. Is there a quick way to determine this? -- stored procedures SELECT COUNT(*) FROM rdb$procedures WHERE rdb$system_flag=0 -- functions SELECT COUNT(*) FROM rdb$functions WHERE rdb$system_flag=0 -- indices SELECT COUNT(*) FROM rdb$indices WHERE rdb$system_flag=0 -- tables SELECT COUNT(*) FROM rdb$relations WHERE rdb$system_flag=0 AND rdb$view_blr IS NULL -- views SELECT COUNT(*) FROM rdb$relations WHERE rdb$system_flag=0 AND rdb$view_blr IS NOT NULL Josef ++ 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 * 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] How do return the number of object in a Firebird database
On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote: ** Greetings All, v1.5.3 I need to know how many tables, indicies, functions, stored procedures, etc are in my Firebird database. Is there a quick way to determine this? See here, this should provide you with enough information: http://www.alberton.info/firebird_sql_meta_info.html [Non-text portions of this message have been removed]
Re: [firebird-support] How do return the number of object in a Firebird database
Thanks Markus and Josef, just what I needed. Much Appreciated - Original Message - From: Markus Ostenried To: firebird-support@yahoogroups.com Sent: Wednesday, July 17, 2013 7:13 AM Subject: Re: [firebird-support] How do return the number of object in a Firebird database On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote: ** Greetings All, v1.5.3 I need to know how many tables, indicies, functions, stored procedures, etc are in my Firebird database. Is there a quick way to determine this? See here, this should provide you with enough information: http://www.alberton.info/firebird_sql_meta_info.html [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[firebird-support] NBackup problem, causing deadlock
Hello, im from Brazil and our company use NBackup, but we having some issues. I tried to google it, but nothing usefull came, so I decide to talk to the designer. We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our database file has 2GB, we schedule nbackup every 20 minutes to make a incremental backup, after implantation we had a problem, on average once a day and happens deadlock and the firebird service stops and we have to kill on the task manager to start again. If I disable NBackup not happen deadlock. Sorry by bad english. Thanks, Matthias Bebber Breda Programador +55 54 3292 AT Info Soluções em Sistemas mailto:matth...@atinfosistemas.com.br matth...@atinfosistemas.com.br http://www.atinfosistemas.com.br/ http://www.atinfosistemas.com.br [Non-text portions of this message have been removed]
Re: [firebird-support] How do return the number of object in a Firebird database
I find that quickly connecting to the DB with flamerobin GUI. On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote: ** Greetings All, v1.5.3 I need to know how many tables, indicies, functions, stored procedures, etc are in my Firebird database. Is there a quick way to determine this? Thanks, Mike [Non-text portions of this message have been removed] -- Regards Andrew Gargan [Non-text portions of this message have been removed]
[firebird-support] NBackup problem, causing deadlock and stopping firebird
Hello, i'm from Brazil and our company use NBackup, but we having some issues. I tried to google it, but nothing usefull came, so I decide to talk to the designer. We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our database file has 2GB, we schedule nbackup every 20 minutes to make a incremental backup, after implantation we had a problem, on average once a day and happens deadlock and the firebird service stops and we have to kill on the task manager to start again. If I disable NBackup not happen deadlock. Sorry by bad english. Thanks, Matthias Bebber Breda
RE: [firebird-support] NBackup problem, causing deadlock
Matthias, We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our database file has 2GB, we schedule nbackup every 20 minutes to make a incremental backup, after implantation we had a problem, on average once a day and happens deadlock and the firebird service stops and we have to kill on the task manager to start again. If I disable NBackup not happen deadlock. Please explain your meaning of deadlock. Nbackup can significantly consume available disk IO resources while it is running. Please provide details on the disk subsystem which you are running on. Sean
Re: [firebird-support] Help, tunning database
On 15-7-2013 16:31, trskopo wrote: Hi all, I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K. When data grows, Firebird Server starting to slow down. I shutdown Firebird Server, starting again without changing anything and Firebird Server became smooth again. Any ideas, what is the problem with this? Firebird.conf mostly on its default values except for cpuaffinity set to 15 and DefaultDbCachePages set to 4096. Setting CpuAffinity to anything other than 2^n is a bad idea as it can cause slow down because of migrating threads to other cores. DefaultDbCachePages controls the number of pages in cache per database (if no specific value is configured for the database itself). With 4k pages, the value of 4096 means a page cache of only 16MB. With 16k pages: 64MB You might want to consider increasing it a bit more, or switching to classic or superclassic server. As you use Windows 7 64, you might actually be bitten by the filesystem cache issue, where Windows tries to cache beyond the available physical memory. See http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#rnfb25-fbconf-fscache for settings to control this (although I believe you shouldn't be affected with the default setting). Mark -- Mark Rotteveel
Re: [firebird-support] Have a lots memory, but FB could not take advantages
On 15-7-2013 18:38, trskopo wrote: Hi all, I have a 16GB RAM and since my database file is small size, it can completely runs on RAM. The problem is I can not set FB SuperClasic 2.5.1 on WinXp 64 to take advantages of it. Setting Page Size and Page Buffers is useless. Performance seems just the same whether Page Size set to maximum (16384) or minimum (4096). Same with DefaultDbCachePages, I even set it to zero in firebird.conf. When Page Size and Page Buffers set to minimum value, memory consumption for firebird server also minimum, without any decrease in performance. Page Size and Page Buffers setting only useful when database file set on disk. Any hints, how to take advantage these memory? Page size decides the size of the database pages, DefaultDbCachePages decides the number of pages to cache. Setting it to 0 either disables it or uses some kind of minimum value. As I mentioned in my previous email, using small values will only lead to a small cache on superserver (where the cache is system wide per database, not per connection). So either try a larger number of DefaultDbCachePages, switch to classic, or check if your database doesn't actually have its own value configured (in which case playing around with this setting has no effect). Mark -- Mark Rotteveel
[firebird-support] Re: NBackup problem, causing deadlock
In the log file of the firebird, a second before stopping all users, have this line: SRVHYPERV2 Tue Jul 16 08:40:11 2013 Database: D:\WORK\DATA.FDB deadlock internal Firebird consistency check (Can't lock alloc table for reading) Thereafter, the system uses the database stopped on all machines and process nBackup just stood, had to terminate the processes, start the firebird and merge the delta file. Sorry again about my english. --- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: Matthias, We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our database file has 2GB, we schedule nbackup every 20 minutes to make a incremental backup, after implantation we had a problem, on average once a day and happens deadlock and the firebird service stops and we have to kill on the task manager to start again. If I disable NBackup not happen deadlock. Please explain your meaning of deadlock. Nbackup can significantly consume available disk IO resources while it is running. Please provide details on the disk subsystem which you are running on. Sean
RE: [firebird-support] Re: NBackup problem, causing deadlock
In the log file of the firebird, a second before stopping all users, have this line: SRVHYPERV2Tue Jul 16 08:40:11 2013 Database: D:\WORK\DATA.FDB deadlock internal Firebird consistency check (Can't lock alloc table for reading) Thereafter, the system uses the database stopped on all machines and process nBackup just stood, had to terminate the processes, start the firebird and merge the delta file. This is a very unusual error message, you should look to post this to the Firebird Developer mailing list for quicker reply. Sean
Re: [firebird-support] Re: NBackup problem, causing deadlock
Em 17/7/2013 16:38, matthiasbreda escreveu: In the log file of the firebird, a second before stopping all users, have this line: SRVHYPERV2Tue Jul 16 08:40:11 2013 Database: D:\WORK\DATA.FDB deadlock internal Firebird consistency check (Can't lock alloc table for reading) Thereafter, the system uses the database stopped on all machines and process nBackup just stood, had to terminate the processes, start the firebird and merge the delta file. Sorry again about my english. The first thing I would try is to recreate this database, perhaps it has some kind of corruption. use gbak to create a back-up and restore it to *another* place, so you could be sure the back-up is not corrupted. If you could restore the back-up, replace the production database with the freshly restored one, and look if nbackup has problems after that. Of course.. with everyone disconnected from the database... see you !
[firebird-support] Forced write
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 was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. Thanks
RE: [firebird-support] Forced write
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 was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. None of those operations, on their own, will change the forced write flag setting. The setting can be changed thru gfix command or API call. Sean P.S. A restore would not change the setting on its own -- it would restore using the setting that was present from the backup.
[firebird-support] Software speed issue
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 that can be used. We did this and saw little to no increase in speed. Our database is 120 GIG and we have 96 gig of RAM available which we are only using 5 gig of that 96 gig. Can anyone suggest settings that can be changed/activated (they originally had all of the commands in the firebird.config file commented out so they were not active) and what values we can try to increase the speed? We want their software to be much faster than it is and they have no other ideas. Thank you cid:image001.jpg@01CD7BBF.0BEF1400 Confidential HAR-KEL, INC. Information: This E-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail and destroy the original and all copies of the original message. [Non-text portions of this message have been removed]
RE: [firebird-support] Software speed issue
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 that can be used. We did this and saw little to no increase in speed. Our database is 120 GIG and we have 96 gig of RAM available which we are only using 5 gig of that 96 gig. Can anyone suggest settings that can be changed/activated (they originally had all of the commands in the firebird.config file commented out so they were not active) and what values we can try to increase the speed? We want their software to be much faster than it is and they have no other ideas. Thank you What OS/bitness are you running? What engine version (SuperClassic) are you running? What are the database page cache settings? How many active database connection are their? SL
[firebird-support] Re: Forced write
rddymanohar wrote: 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 was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. None of those operations, on their own, will change the forced write flag setting. The setting can be changed thru gfix command or API call. Sean P.S. A restore would not change the setting on its own -- it would restore using the setting that was present from the backup. Could it be that for Fb/1.5 any user can change this setting? If so, an impatient user might be tempted to increase performance... -- Aage J.
Re: [firebird-support] Forced write
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 was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. None of the above will change the Forced Write setting. However, in the very ancient version of Firebird that you are using, a client can do it, via the connection API. The very first thing I would recommend is to examine closely the connection settings on all client applications. A common source of this problem is Delphi applications that provide properties and/or arrays of properties in the connection component (connection alone, or database component). If this is your case, look at *both* the property in question (ForcedWrites TRUE/FALSE) and *also* the Params property of the connection/database component. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
Re: [firebird-support] Software speed issue
At 08:32 a.m. 18/07/2013, Dom Kasony wrote: [..] Can anyone suggest settings that can be changed/activated (they originally had all of the commands in the firebird.config file commented out so they were not active) Not true. If a setting is commented out then it is the default and thus active. The rider here would be that, if someone had activated a non-default setting at some point and then someone later came and commented that out, the configuration for that parameter would revert to the default. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
[firebird-support] Re: Forced write
We found it the ibo components was set to forced write no and that was causing the problem. Thanks --- In firebird-support@yahoogroups.com, Helen Borrie helebor@... 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 was restored turned it on. However on checking the next day forced write was again turned off. We do daily sweep, reindex and backup on the database as maintenance at the the eod. Will any of this cause forced write to be turned off. None of the above will change the Forced Write setting. However, in the very ancient version of Firebird that you are using, a client can do it, via the connection API. The very first thing I would recommend is to examine closely the connection settings on all client applications. A common source of this problem is Delphi applications that provide properties and/or arrays of properties in the connection component (connection alone, or database component). If this is your case, look at *both* the property in question (ForcedWrites TRUE/FALSE) and *also* the Params property of the connection/database component. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
[firebird-support] RSB$USER_PRIVILEGES vs RDB$SECURITY_CLASS
Hi ! Can someone explain me what's the diference between these two tables ? I did the following test: create table foo( a integer, b varchar(10)); grant select on foo to public; grant insert on foo to Alexandre; grant update (a) on foo to Pedro; grant delete on foo to Maria; commit; First let's take a look on RDB$USER_PRIVILEGES: select * from rdb$USER_PRIVILEGES where RDB$RELATION_NAME = 'FOO'; RDB$USER RDB$GRANTOR RDB$PRIVILEGE RDB$GRANT_OPTION RDB$RELATION_NAME RDB$FIELD_NAME RDB$USER_TYPE RDB$OBJECT_TYPE SYSDBA SYSDBAS 1 FOO [null] 80 SYSDBA SYSDBAI 1 FOO [null] 80 SYSDBA SYSDBAU 1 FOO [null] 80 SYSDBA SYSDBAD 1 FOO [null] 80 SYSDBA SYSDBAR 1 FOO [null] 80 PUBLIC SYSDBAS 0 FOO [null] 80 ALEXANDRE SYSDBAI 0 FOO [null] 80 PEDRO SYSDBAU 0 FOO A80 MARIA SYSDBAD 0 FOO [null] 80 well... From the above I can see that: SYSDBA has (S)elect, (I)nsert, (U)pdate, (D)elete and (R)eference privileges, all with GRANT OPTION PUBLIC has (S)elect only no GRANT OPTION ALEXANDRE has (S)elect (because of public) and (I)nsert without GRANT OPTION PEDRO has (S)elect (because of public) and (U)pdate on column A without GRANT OPTION MARIA has (S)elect (because of public) and (D)elete without GRANT OPTION All the privileges granted above is represented completely in this table Now let's see what is on RDB$SECURITY_CLASS, but first we need to now what secutiry class is applied to each object: select RDB$RELATION_NAME, RDB$SECURITY_CLASS, RDB$DEFAULT_CLASS from RDB$RELATIONS where RDB$RELATION_NAME = 'FOO'; RDB$RELATION_NAME RDB$SECURITY_CLASSRDB$DEFAULT_CLASS FOO SQL$8 SQL$DEFAULT5 and select RDB$RELATION_NAME, RDB$FIELD_NAME, RDB$SECURITY_CLASS from RDB$RELATION_FIELDS where RDB$RELATION_NAME = 'FOO'; RDB$RELATION_NAMERDB$FIELD_NAME RDB$SECURITY_CLASS FOO A SQL$GRANT9 FOO B [null] So we need to check SQL$8, SQL$DEFAULT5 and SQL$GRANT9 select RDB$SECURITY_CLASS, cast(RDB$ACL as varchar(2000)) from RDB$SECURITY_CLASSES; (formatted for a better reading) RDB$SECURITY_CLASS RDB$ACL SQL$8ACL version 1 person: SYSDBA, privileges: (PCDWR) person: ALEXANDRE, privileges: (IR) person: MARIA, privileges: (ER) person: PEDRO, privileges: (UR) all users: (*.*), privileges: (R) SQL$DEFAULT5 ACL version 1 person: SYSDBA, privileges: (PCDWR) person: ALEXANDRE, privileges: (IR) person: MARIA, privileges: (ER) all users: (*.*), privileges: (R) SQL$GRANT9 ACL version 1 person: SYSDBA, privileges: (PCDWR) person: ALEXANDRE, privileges: (IR) person: MARIA, privileges: (ER) person: PEDRO, privileges: (UR) all users: (*.*), privileges: (R) I don't know why SQL$DEFAULT5 misses person: PEDRO, privileges: (UR) that is on SQL$8 that refers to the table too, perhaps this indicates that UPDATE has a special record on RDB$RELATION_FIELDS.RDB$SECURITY_CLASS Let me try to interpret that data: all users (Public) can (R)read ALEXANDRE can (I)nsert and (R)ead MARIA can (E)rase and (R)read PEDRO can (U)pdate (column A, that is the field that has SQL$GRANT9) and (R)ead SYSDBA has P, C, D, W and R privileges, wich I don't know the meaning, but of course it is administrative/owner rights Besides SQL$8 lists person: PEDRO, privileges: (UR) a further check must be in place to see if he can alter each field... Trying to put the information above on the same terms, I get: From RDB$USER_PRIVILEGES: SYSDBA has (S)elect, (I)nsert, (U)pdate, (D)elete and (R)eference privileges, all with GRANT OPTION PUBLIC has (S)elect only no GRANT OPTION ALEXANDRE has (S)elect (because of public) and (I)nsert without GRANT OPTION PEDRO has (S)elect (because of public) and (U)pdate on column A without GRANT OPTION MARIA has (S)elect (because of public) and (D)elete without GRANT OPTION From RDB$SECURITY_CLASSES: SYSDBA ??? PUBLIC has (S)elect only ALEXANDRE has (S)elect and (I)nsert PEDRO has (S)elect (U)pdate on column A MARIA has (S)elect(D)elete -- No information about
[firebird-support] How to maximize cpu usage for Firebird?
Hi all, 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? Thanks and regrads, Anto
[firebird-support] Re: RSB$USER_PRIVILEGES vs RDB$SECURITY_CLASS
18.07.2013 6:02, Alexandre Benson Smith wrote: Can someone give some info about the role of each table ? As far as I can see RDB$USER_PRIVILEGES has all the information needed and RDB$SECURITY_CLASS dos not have all the information (misses GRANT OPTION) but have some info for SYSDBA that I don't know the meaning... RDB$USER_PRIVILEGES is kinda public interface for RDB$SECURITY_CLASSES, the latter is mostly a lower level representation of the former. RDB$SECURITY_CLASSES defines ACLs actually used by the engine to validate permissions. It includes not only SQL permissions but also some special ones like control, protect and delete that are assigned to the object owner. RDB$USER_PROCEDURES is used only when we need to grant something or show/export the grants, as it lists only grantable permissions and includes the grant option. Dmitry
RE: [firebird-support] How to maximize cpu usage for Firebird?
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? 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?
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
Re: [firebird-support] Re: RSB$USER_PRIVILEGES vs RDB$SECURITY_CLASS
Em 18/7/2013 00:20, Dmitry Yemanov escreveu: 18.07.2013 6:02, Alexandre Benson Smith wrote: Can someone give some info about the role of each table ? As far as I can see RDB$USER_PRIVILEGES has all the information needed and RDB$SECURITY_CLASS dos not have all the information (misses GRANT OPTION) but have some info for SYSDBA that I don't know the meaning... RDB$USER_PRIVILEGES is kinda public interface for RDB$SECURITY_CLASSES, the latter is mostly a lower level representation of the former. RDB$SECURITY_CLASSES defines ACLs actually used by the engine to validate permissions. It includes not only SQL permissions but also some special ones like control, protect and delete that are assigned to the object owner. RDB$USER_PROCEDURES is used only when we need to grant something or show/export the grants, as it lists only grantable permissions and includes the grant option. Dmitry Thank you Dmitry ! I think you meant RDB$USER_PRIVILEGES where you wrote RDB$USER_PROCEDURES, right ? see you !
[firebird-support] Rename a key through write to a system table
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 have this itch I would like to scratch, where I created a primary key of a table with a bad name... The target Firebird versions are 2.1 and 2.5. Thanks, Pepak ++ 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 * 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: http://docs.yahoo.com/info/terms/
[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: Forced write
We found it the ibo components was set to forced write no and that was causing the problem. What is the IBO version you are using? -- 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?
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