Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
#793689
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
#793706
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.
#793775
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

The 500 Internal Server Error is the general catch[…]

Really very nice blog information for this one and[…]

This is a long, lengthy and cumbersome process. T[…]

Great read for when on the road. The book provides[…]