Many thanks. No there is no transaction open. Actually there are no transactions at all, only SELECT queries. We tried to increase MAX_MEMORY_ROWS_DISTINCT and it seems working. What is the exact meaning of this parameter?
Thanks again for your help Il giorno lunedì 10 luglio 2017 21:01:42 UTC+2, Anna Cochetti ha scritto: > > Hi, > we are using H2 in version 1.3.176 from quite some time without any > probleam. Recently without any apparent change file .db has started to > grow quite a lot with no apparent reason. > Note that this happens even with the the flow of transactions (i.e. > INSERT/UPDATE/DELETE) is stopped. > So we have come to the conclusion that the space is needed for SELECT > management. > We have some quite heavy views but these do not return that many rows > (~13000). A couple of tables involved in the views have ~1000 columns > > When the DB is not stressed with queries the db file is less than 50MB but > when some queries are run on the views the db file grows with a pace of > ~80/150MB at each query until it finishes the file system capacity (which > is about 18,5GB). > > Some notes: > we are using this version because there is a requirement to use Java 6 > the OS is red hat linux > the Recovery tool gives as statistics the following (at 3.2 GB) > ---- Statistics ---- > --* page count: 1631834, free: 1585744* * ****** > -- page data bytes: head 854070, empty 35048525, rows 24994685 (43% full) > -- free 76%, 1256019 page(s) > -- data leaf 1%, 29735 page(s) > -- data node 0%, 188 page(s) > -- data overflow 0%, 241 page(s) > -- btree leaf 0%, 3100 page(s) > -- btree node 0%, 62 page(s) > -- free list 0%, 120 page(s) > -- stream trunk 0%, 673 page(s) > -- stream data 20%, 341719 page(s) > > ******* Why does the size increases even if it has got so many free pages? > Any workaround (also ugly is OK!)? > Shutdown defragment would work but it does shutdown all the connections > which creates problems to the clients... > > Many thanks > Anna > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
