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?
what do you do? do you store all your domain data in the process?
processes that have ended have a date in their END_ column
Deleting those with recursion should work afaik.