1 Reply Latest reply on Jan 7, 2009 10:38 PM by Ronald van Kuijk

    jbpm db size

    Nicola Gioia Newbie

      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