db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4152) mailjdbc test database grows very fast with 10.5
Date Tue, 14 Apr 2009 21:25:14 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698945#action_12698945
] 

Kathey Marsden commented on DERBY-4152:
---------------------------------------

I did just a quick ten minute run (by my watch) with 10.4 and trunk and compared some data
points.  I don't know that this short run really means much of anything except that clearly
both versions are growing faster than they should, given the data that is in the database.

10.6.0.0 alpha sane
8 primary key violations. (ERROR 23505)

du -sk mailsdb
   122764 mailsdb

last assessment in Activity.out
: INFO :Backup Thread : dbsize after compress : 88571904

[C:/kmarsden/repro/derby-4152/trunk] wc performance.out
    177    2213   12269    performance.out

ij> connect 'jdbc:derby:mailsdb';
ij>  select sum(length(message)) from refresh.inbox;
1
-----------
18592990

ij> select count(*) from refresh.inbox;
1
-----------
10

ij>  select * from new org.apache.derby.diag.SpaceTable('REFRESH','INBOX') t;
CONGLOMERATENAME
        |ISIND&|NUMALLOCATEDPAGES   |NUMFREEPAGES        |NUMUNFILLEDPAGES    |PAGESIZE
  |ESTIMSPACESAVING
------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
INBOX
        |0     |1015                |155                 |24                  |32768     
|5079040
SQL090414131918880
        |1     |1                   |0                   |1                   |4096      
|0
TO_DELETE_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
TO_NAME_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
DATE_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
ATTACH_INDEX
        |1     |1                   |0                   |1                   |4096      
|0

6 rows selected
ij>



ij> select count(*) from refresh.attach;
1
-----------
2
ij> select sum(length(attachment)) from refresh.attach;
1
-----------
4436906

1 row selected

ij> select * from new org.apache.derby.diag.SpaceTable('REFRESH','ATTACH') t;
CONGLOMERATENAME
        |ISIND&|NUMALLOCATEDPAGES   |NUMFREEPAGES        |NUMUNFILLEDPAGES    |PAGESIZE
  |ESTIMSPACESAVING
-----------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
ATTACH
        |0     |1676                |82                  |10                  |32768     
|2686976
SQL090414131918990
        |1     |1                   |0                   |1                   |4096      
|0
SQL090414131918991
        |1     |1                   |0                   |1                   |4096      
|0
ATTACH_AT_INDEX
        |1     |1                   |0                   |1                   |4096      
|0

4 rows selected


10.4.2.1 (head of 10.4 branch)
4 primary key violations (ERROR 23505)

du -sk mailsdb 
  85603 mailsdb

last assesment in Activity.out 
: INFO :Backup Thread : dbsize after compress : 45776896

[C:/kmarsden/repro/derby-4152/10.4] wc performance.out
    179    2219   12363    performance.out
ij> select sum(length(message)) from refresh.inbox;
1
-----------
7895585



ij> select count(*) from refresh.inbox;
1
-----------
9

ij>  select * from new org.apache.derby.diag.SpaceTable('REFRESH','INBOX') t;
CONGLOMERATENAME
        |ISIND&|NUMALLOCATEDPAGES   |NUMFREEPAGES        |NUMUNFILLEDPAGES    |PAGESIZE
  |ESTIMSPACESAVING
------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
INBOX
        |0     |319                 |635                 |13                  |32768     
|20807680
SQL090414133519540
        |1     |1                   |0                   |1                   |4096      
|0
TO_DELETE_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
TO_NAME_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
DATE_INDEX
        |1     |1                   |0                   |1                   |4096      
|0
ATTACH_INDEX
        |1     |1                   |0                   |1                   |4096      
|0

6 rows selected

ij> select count(*) from refresh.attach;
1
-----------
0

ij>  select * from new org.apache.derby.diag.SpaceTable('REFRESH','ATTACH') t;
CONGLOMERATENAME
        |ISIND&|NUMALLOCATEDPAGES   |NUMFREEPAGES        |NUMUNFILLEDPAGES    |PAGESIZE
  |ESTIMSPACESAVING
------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
ATTACH
        |0     |528                 |133                 |3                   |32768     
|4358144
SQL090414133519630
        |1     |1                   |0                   |1                   |4096      
|0
SQL090414133519631
        |1     |1                   |0                   |1                   |4096      
|0
ATTACH_AT_INDEX
        |1     |1                   |0                   |1                   |4096      
|0

4 rows selected
ij>


> mailjdbc test database  grows very fast with 10.5
> -------------------------------------------------
>
>                 Key: DERBY-4152
>                 URL: https://issues.apache.org/jira/browse/DERBY-4152
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.5.1.0
>         Environment: java version "1.6.0"
> Java(TM) SE Runtime Environment (build pwi3260sr3-20081106_07(SR3))
> IBM J9 VM (build 2.4, J2RE 1.6.0 IBM J9 2.4 Windows 2000 x86-32 jvmwi3260-200811
> 05_25433 (JIT enabled, AOT enabled)
> J9VM - 20081105_025433_lHdSMr
> JIT  - r9_20081031_1330
> GC   - 20081027_AB)
> Windows 2000 5.00.2195 /Service pack 4
> 4 CPU 3.00GHz
>            Reporter: Kathey Marsden
>            Priority: Critical
>
> When I ran the mailjdbc test on 10.5.1.0 RC I found that the mailsdb database grew to
16GB after two days.  On 10.4.2.0  on the same machine with the same configuration (no derby.properties)
it grew to only 1.7GB after 7 days.  Both were sane builds.
> This is with the embedded configuration:
> java org.apache.derbyTesting.system.mailjdbc.MailJdbc embedded

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message