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

Hello, I'm trying to make a HTML page in which a[…]

IOS PUSH Notification

Latest Mobileios.pem already get its SSL cert expi[…]

Enabling SQL Server in Windows

Nice. https://360digitmg.com/india/ethical-hacking[…]

PM 3.5.0 supports MySQL 5.7.X configurations with […]