[sgkalluri]

Hello everyone,

Is it possible to compress ProcessMaker's MySQL Database / Tables after installation and in regular use, in a safe manner?

Is it advisable to do so, even if there is a method?

Best wishes,
SGK

[amosbatto]

If you are using the InnoDB database engine then you can compress the table. See:
https://www.lullabot.com/articles/squee ... ompression

However, you are probably using MyISAM databases (which are the default in MySQL). It is possible to convert to InnoDB with this command:
ALTER TABLE table_name ENGINE=InnoDB;
See: https://dev.mysql.com/doc/refman/5.7/en ... nnodb.html

However, using InnoDB is untested with PM. In theory it should work, but definitely make a backup of your system before trying it. Let us know how it goes if you test it.

[sgkalluri]

Thanks Amos. I'll try this out sometime during the next few days. - SGK

[sgkalluri]

Hello Amos,

I converted a few important tables (application, app_delegation, app_cache_view, app_history) to InnoDB format. Seems ok till now. No dramatic changes in PM performance as of now.

Will keep the group updated as and when I get the time to test this out.

Best wishes,
SGK

[amosbatto]

Glad to hear that it works. This link might help you:
https://stackoverflow.com/questions/385 ... nto-innodb