Subject Re: Large database performance on Firebird 1.5.2 CS with 130+ clien
Author lins_kun
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@i...>
wrote:
> Hi,
>
> [snip]
>
> > any suggest ?
>
> What's the page size of the database and what is the value for page
> buffers? Run gstat -h to get these values.
>
> Possibly it is a database previously used under SuperServer, now using
> Classic, and due to a somewhat high page buffers value (in combination
> with 130+ connections), the cachable memory exceeds the maximum
> available memory?
>
> Just a thought.

No, the DB is used alway under ClassicServer

This is the gstat log:

This is a gstat of older "Large" DB :

Database header page information:
Flags 0
Checksum 12345
Generation 11824495
Page size 8192
ODS version 10.1
Oldest transaction 11820752
Oldest active 11824393
Oldest snapshot 11824393
Next transaction 11824395
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 24, 2004 13:04:10
Attributes

Variable header data:
Sweep interval: 0
*END*



And the firebird.log report this voice :

FIREBIRD Sat Mar 19 13:42:26 2005
SERVER/process_packet: broken port, server exiting

FIREBIRD Sat Mar 19 13:42:26 2005
INET/inet_error: send errno = 104

FIREBIRD Sat Mar 19 13:42:26 2005
SERVER/process_packet: broken port, server exiting

FIREBIRD Sat Mar 19 13:42:26 2005
INET/inet_error: send errno = 104

FIREBIRD Sat Mar 19 13:42:26 2005
SERVER/process_packet: broken port, server exiting

FIREBIRD Sat Mar 19 13:42:36 2005
INET/inet_error: read errno = 104

FIREBIRD Sat Mar 19 13:49:53 2005
INET/inet_error: read errno = 104