Subject | Re: Large database performance on Firebird 1.5.2 CS with 130+ clien |
---|---|
Author | lins_kun |
Post date | 2005-03-24T16:01:30Z |
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@i...>
wrote:
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
wrote:
> Hi,No, the DB is used alway under ClassicServer
>
> [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.
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