[jboss-user] [JBoss jBPM] - jbpm db size

[io80gioia]

Hi all.
I've a problem with an installation of jbpm that use mysql as persistence db.

The db is growing much and in 20 days of work it reached 60 GB of size.

The only tables of big dimension are: byteBlock 20GB of tables and 1 GB of index; 
variableinstance reached 10 GB of size plus 20 GB of indexes.
 byteArray is very bigger in number of rows , but has not a real big size.

I can't truncate the tables, because they contain important information about running process.... but how can I discover what to delete without clean processes in running state?

Thanks

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200091#4200091

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200091