[firebird-support] RE: High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-10 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 

I forgot to add, the disk subsystem that the database running on supports 
200,000+ 8KB IOPS, so slow disk performance is not likely.

> We have a client with 320GB database (running FB CS v2.5) reporting
> performance issues, while we are investigating possible application sources, I
> have been reviewing their Firebird config.
> 
> Yesterday, I ran fb_lock_print to check on the database and found a "Mutex
> wait" value of 20.9%, which I knew that a "bad thing".  So, I increased (by
> 50%) the "Hash slots" value from 60011 to 90001.
> 
> Now, today, I checked the lock print values again, and got even worse
> numbers!!!
> 
>     LOCK_HEADER BLOCK
>     Version: 145, Active owner:  0, Length: 67108864, Used: 
> 32723368
>     Flags: 0x0001
>     Enqs: 712175161, Converts: 9327661, Rejects: 1440802, Blocks:
> 15963765
>     Deadlock scans:  9, Deadlocks:  0, Scan interval:  10
>     Acquires: 1133127873, Acquire blocks: 256464312, Spin count:  
>  0
>     Mutex wait: 22.6%
>     Hash slots: 90001, Hash lengths (min/avg/max):    0/   0/   5
>     Remove node:  0, Insert queue:  0, Insert prior:  > 0
>     Owners (288):   forward: 732776, backward: 29775680
>     Free owners (400):  forward: 9817904, backward: 9548560
>     Free locks (28162): forward: 20344528, backward: 18378944
>     Free requests (293517): forward: 7727280, backward: 23127520
>     Lock Ordering: Enabled
> 
> 
> Any suggestions on how I can improve the numbers?
> 
> Thanks in advance
> 
> Sean
>

[firebird-support] High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-10 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 

We have a client with 320GB database (running FB CS v2.5) reporting performance 
issues, while we are investigating possible application sources, I have been 
reviewing their Firebird config.

Yesterday, I ran fb_lock_print to check on the database and found a "Mutex 
wait" value of 20.9%, which I knew that a "bad thing".  So, I increased (by 
50%) the "Hash slots" value from 60011 to 90001.

Now, today, I checked the lock print values again, and got even worse numbers!!!

LOCK_HEADER BLOCK
Version: 145, Active owner:  0, Length: 67108864, Used: 
32723368
Flags: 0x0001
Enqs: 712175161, Converts: 9327661, Rejects: 1440802, Blocks: 
15963765
Deadlock scans:  9, Deadlocks:  0, Scan interval:  10
Acquires: 1133127873, Acquire blocks: 256464312, Spin count:   0
Mutex wait: 22.6%
Hash slots: 90001, Hash lengths (min/avg/max):0/   0/   5
Remove node:  0, Insert queue:  0, Insert prior:  0
Owners (288):   forward: 732776, backward: 29775680
Free owners (400):  forward: 9817904, backward: 9548560
Free locks (28162): forward: 20344528, backward: 18378944
Free requests (293517): forward: 7727280, backward: 23127520
Lock Ordering: Enabled


Any suggestions on how I can improve the numbers?

Thanks in advance

Sean

Re: [firebird-support] Interbase vs Firebird

2017-03-10 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread hv...@users.sourceforge.net [firebird-support] 

 

---In firebird-support@yahoogroups.com,  wrote :

 On 10.03.2017 15:35, hvlad@... mailto:hvlad@... [firebird-support] wrote:

> So setting FIREBIRD environment variable is the correct and only way to 
> define the Firebird/plugin path at runtime?
 
  Correct - yes, only - no (explained already), easy - yes. 
To be exact: it defines Firebird root directory, not plugin path.

Regards,
Vlad

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 2017-03-10 14:56, Martin Schreiber mse00...@gmail.com 
[firebird-support] wrote:
> On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] 
> wrote:
>  >
>  >
>  > ---In firebird-support@yahoogroups.com,  wrote :
>  >
>  >
>  >> Are ther other possibilities to set the Firebird path than setting
>  >> %FIREBIRD%? A parameter to attachDatabase() maybe?
>  >
>  >   SetEnvironmentVariable.
>  >
>  >
>  >
> https://msdn.microsoft.com/en-us/library/windows/desktop/ms686206(v=vs.85).aspx
>  >
>  >   Use it before attempt to establish very first connection, or 
> before
>  > attempt to load fbclient.dll (if it is possible in your app).
>  >
> So setting FIREBIRD environment variable is the correct and only way to
> define the Firebird/plugin path at runtime?

The other option is to put fbclient.dll and the plugin and intl folders 
in the same folder as your executable.

Mark

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support] 
On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] wrote:
 >
 >
 > ---In firebird-support@yahoogroups.com,  wrote :
 >
 >
 >> Are ther other possibilities to set the Firebird path than setting
 >> %FIREBIRD%? A parameter to attachDatabase() maybe?
 >
 >   SetEnvironmentVariable.
 >
 >
 > 
https://msdn.microsoft.com/en-us/library/windows/desktop/ms686206(v=vs.85).aspx
 >
 >   Use it before attempt to establish very first connection, or before
 > attempt to load fbclient.dll (if it is possible in your app).
 >
So setting FIREBIRD environment variable is the correct and only way to 
define the Firebird/plugin path at runtime?

Martin

[firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread hv...@users.sourceforge.net [firebird-support] 
---In firebird-support@yahoogroups.com,  wrote :
 
> Are ther other possibilities to set the Firebird path than setting 
 > %FIREBIRD%? A parameter to attachDatabase() maybe?
 
  SetEnvironmentVariable. 

  
https://msdn.microsoft.com/en-us/library/windows/desktop/ms686206(v=vs.85).aspx 
https://msdn.microsoft.com/en-us/library/windows/desktop/ms686206(v=vs.85).aspx

  Use it before attempt to establish very first connection, or before 
attempt to load fbclient.dll (if it is possible in your app).


Regards,
Vlad

[firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support] 


On 10.03.2017 08:41, Martin Schreiber wrote:
> Hi,
> I want to use FB 3 in embedded mode in an application:
> https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM
> (under construction).
> It works well on Linux. On Windows 7 64 bit I installed
> Firebird-3.0.1.32609_0_x64.exe
> When I set %FIREBIRD% to the FB install directory connecting the database by 
> attachDatabase() shows the error
> "
> unavailable database
> ".

Got it working, there was a problem with the file path.
Are ther other possibilities to set the Firebird path than setting 
%FIREBIRD%? A parameter to attachDatabase() maybe?

Martin

Re: [firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
10.03.2017 13:59, lis...@warmboot.com.br [firebird-support] wrote:
> If you are speaking about Change Views feature, I understand its main
> purpose is to help mobile applications to update local copies of
> (changed) data easily.

   Yes, this is the main purpose of Change View (sorry, I messed the name), but 
in the 
article they claim that it is a multipurpose replication.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


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:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support] 
Hi,

Dne 10.3.2017 v 13:59 lis...@warmboot.com.br [firebird-support] napsal(a):
> If you are speaking about Change Views feature, I understand its main
>  purpose is to help mobile applications to update local copies of
>  (changed) data easily.

Similar thing could be implemented in your app. using Firebird 3.0 
RDB$RECORD_VERSION pseudo-column. See 
https://www.ibphoenix.com/resources/documents/search/doc_393

Change View has one significant advantage - can trace deletes out of the 
box. Smaller advantage is that it can detect and signal which columns 
were changed and you can even filter output on that. But although it's 
lovely feature I don't think its worth the cost it has. Detecting simple 
changes at row level is imho good enough for most cases and that's what 
we (silently) have (except deletes). Reconciliation could be done at 
app. level with no significant additional cost with greater flexibility. 
But I agree that Change Views feature looks great - on paper.

best regards
Pavel Cisar
IBPhoenix

[firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread lis...@warmboot.com.br [firebird-support] 
If you are speaking about Change Views feature, I understand its main
 purpose is to help mobile applications to update local copies of
 (changed) data easily.
 

 []s
 Carlos
 Migration Guide to Firebird 3 - 
http://www.firebirdnews.org/migration-guide-to-firebird-3/ 
http://www.firebirdnews.org/migration-guide-to-firebird-3/

Re: [firebird-support] Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
10.03.2017 9:39, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> But there is some performance/scaling problem showed and i am interested 
> about your opinion

   It is funny that they think that their Changes Tracking API can be used for 
replication 
of something bigger that employee.ib.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


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:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support] 
Hi,
I want to use FB 3 in embedded mode in an application:
https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM
(under construction).
It works well on Linux. On Windows 7 64 bit I installed 
Firebird-3.0.1.32609_0_x64.exe
When I set %FIREBIRD% to the FB install directory connecting the database by 
attachDatabase() shows the error
"
unavailable database
".
Without %FIREBIRD% it shows 
"
Unable to complete network request to host "windowsmse".
-Failed to locate host machine.
-The specified name was not found in the hosts file or Domain Name Services.
"
What could be wrong?

Thanks, Martin

[firebird-support] Interbase vs Firebird

2017-03-10 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] 
Hi,

I got info from Embarcadero ;-)

https://www.embarcadero.com/products/interbase/compare/interbase_firebird

Yes i know this is sales advertisement.
And if we compare what Firebird have and Interbase have not ...

But there is some performance/scaling problem showed and i am interested about 
your opinion

Regards,
Karol Bieniaszewski