[
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.
