[
https://issues.apache.org/jira/browse/DERBY-7086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17247056#comment-17247056
]
Vamsavardhana Reddy commented on DERBY-7086:
--------------------------------------------
Richard,
thank you for your response. Our "appliance" restart actually kills the derby
server JVM. Let me see if a graceful shutdown can be performed.
The doc link you provided about storage and recovery talks about periodic
checkpoints to keep the log size small. Is there a way to configure a time
interval for it?
Thanks,
Vamsi
> Derby opera DB growing fast
> ---------------------------
>
> Key: DERBY-7086
> URL: https://issues.apache.org/jira/browse/DERBY-7086
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.8.1.2, 10.8.2.2, 10.8.3.0
> Environment: Derby on CentOS8
> Reporter: Gobi
> Priority: Major
>
> Hi Team,
>
> Greetings to you!
>
> We use Derby database version 10.8
>
> Our observation is that there is not much table data but the disk size is too
> large. Large space occupied by a /log folder . We would like to check with
> Derby team what this could be holding.
>
> We replaced the customer Opera DB, Our analysis given below which is before
> and after replacement.
> BEFORE opening in ij.sh
> [g0-7540c/Standalone od-issue]# du -h var
> 48K
> var/db/opera/files/B88A9E5185C464BF6DEC15CEE45E40AC/B3C4E02E5379FEBA0FBB40DB4FE840C0
> 52K var/db/opera/files/B88A9E5185C464BF6DEC15CEE45E40AC
> 4.0K var/db/opera/files/AFA9712BE7E8196E70F62B08ABDE44B9
> 4.0K var/db/opera/files/9FDC6EC9F5ECC99A86E8B36E23BA42A8
> 4.0K var/db/opera/files/9876690C43C63886472E8093CC5040F6
> 4.0K var/db/opera/files/94D70757CE7B1A374A8D2F05178E48DF
> 40K
> var/db/opera/files/BDE828C23CFC92DCD76249734B9B424C/A3D7B6B3515E1E97E58CDE057B664EBF
> 44K var/db/opera/files/BDE828C23CFC92DCD76249734B9B424C
> 4.0K var/db/opera/files/94C9A9659E044849CE9CA52E58E74E0D
> 384K
> var/db/opera/files/A0A1F400944A7444460F0345B18540CE/AF0E0325DECF1EB322DECCA2CC9A4D2E
> 388K var/db/opera/files/A0A1F400944A7444460F0345B18540CE
> 40K
> var/db/opera/files/92AFC3101442985C97DB95407FD34F1E/8AAA75548D79A21EC53680FBB23443FB
> 44K var/db/opera/files/92AFC3101442985C97DB95407FD34F1E
> 552K var/db/opera/files
> 4.0K var/db/opera/derby/tmp
> 11M var/db/opera/derby/seg0
> 626M var/db/opera/derby/log
> 636M var/db/opera/derby
> 637M var/db/opera
> 637M var/db
> 637M var
>
> [g0-7540c/Standalone od-issue]# cd var
> [g0-7540c/Standalone var]# cd db
>
> [g0-7540c/Standalone db]# ij.sh
> ij version 10.8
> ij> connect 'jdbc:derby:opera/derby';
> ij> quit;
> [g0-7540c/Standalone db]# cd ../..
>
> AFTER
> [g0-7540c/Standalone od-issue]# du -h var
> 48K
> var/db/opera/files/B88A9E5185C464BF6DEC15CEE45E40AC/B3C4E02E5379FEBA0FBB40DB4FE840C0
> 52K var/db/opera/files/B88A9E5185C464BF6DEC15CEE45E40AC
> 4.0K var/db/opera/files/AFA9712BE7E8196E70F62B08ABDE44B9
> 4.0K var/db/opera/files/9FDC6EC9F5ECC99A86E8B36E23BA42A8
> 4.0K var/db/opera/files/9876690C43C63886472E8093CC5040F6
> 4.0K var/db/opera/files/94D70757CE7B1A374A8D2F05178E48DF
> 40K
> var/db/opera/files/BDE828C23CFC92DCD76249734B9B424C/A3D7B6B3515E1E97E58CDE057B664EBF
> 44K var/db/opera/files/BDE828C23CFC92DCD76249734B9B424C
> 4.0K var/db/opera/files/94C9A9659E044849CE9CA52E58E74E0D
> 384K
> var/db/opera/files/A0A1F400944A7444460F0345B18540CE/AF0E0325DECF1EB322DECCA2CC9A4D2E
> 388K var/db/opera/files/A0A1F400944A7444460F0345B18540CE
> 40K
> var/db/opera/files/92AFC3101442985C97DB95407FD34F1E/8AAA75548D79A21EC53680FBB23443FB
> 44K var/db/opera/files/92AFC3101442985C97DB95407FD34F1E
> 552K var/db/opera/files
> 11M var/db/opera/derby/seg0
> 1.1M var/db/opera/derby/log
> 12M var/db/opera/derby
> 12M var/db/opera
> 12M var/db
> 12M var
>
> [g0-7540c/Standalone db]# ij.sh
> ij version 10.8
> ij> connect 'jdbc:derby:opera/derby';
> ij> show tables;
> TABLE_SCHEM |TABLE_NAME |REMARKS
> ------------------------------------------------------------------------
> SYS |SYSALIASES |
> SYS |SYSCHECKS |
> SYS |SYSCOLPERMS |
> SYS |SYSCOLUMNS |
> SYS |SYSCONGLOMERATES |
> SYS |SYSCONSTRAINTS |
> SYS |SYSDEPENDS |
> SYS |SYSFILES |
> SYS |SYSFOREIGNKEYS |
> SYS |SYSKEYS |
> SYS |SYSPERMS |
> SYS |SYSROLES |
> SYS |SYSROUTINEPERMS |
> SYS |SYSSCHEMAS |
> SYS |SYSSEQUENCES |
> SYS |SYSSTATEMENTS |
> SYS |SYSSTATISTICS |
> SYS |SYSTABLEPERMS |
> SYS |SYSTABLES |
> SYS |SYSTRIGGERS |
> SYS |SYSVIEWS |
> SYSIBM |SYSDUMMY1 |
> APP |CONTEXT_HOLDER |
> APP |CONTEXT_VALUE |
> APP |GLOBAL_CONTEXT_VALUE |
> APP |REF_COUNT |
> APP |VARIABLE |
> APP |XML_BINARY |
> APP |XML_DOCUMENT |
> APP |XML_STRING |
>
> 30 rows selected
> ij> select count(*) from APP.CONTEXT_HOLDER;
> 1
> -----------
> 255
>
> 1 row selected
> ij> select count(*) from APP.CONTEXT_VALUE;
> 1
> -----------
> 160
>
> 1 row selected
> ij> select count(*) from GLOBAL_CONTEXT_VALUE;
> 1
> -----------
> 0
>
> 1 row selected
> ij> select count(*) from REF_COUNT;
> 1
> -----------
> 18
>
> 1 row selected
> ij> select count(*) from VARIABLE;
> 1
> -----------
> 65
>
> 1 row selected
> ij> select count(*) from XML_BINARY;
> 1
> -----------
> 0
>
> 1 row selected
> ij> select count(*) from XML_DOCUMENT;
> 1
> -----------
> 18
>
> 1 row selected
> ij> select count(*) from XML_STRING;
> 1
> -----------
> 35
>
> 1 row selected
> ij> quit;
>
> Please let us know is there any known issues we have around this issue.
>
> Thanks & Regards,
> Gobi S,
> Cast Iron / App Connect Professional L3 Support,
> IBM India pvt Ltd.
> Email: gobis...@in.ibm.com
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
