[GitHub] cloudstack pull request #1670: CLOUDSTACK-9481: Convert MyISAM table to Inno...

[koushik-das <gi...@git.apache.org>]

Github user koushik-das commented on a diff in the pull request:

    https://github.com/apache/cloudstack/pull/1670#discussion_r77118387
  
    --- Diff: setup/db/db/schema-490to491.sql ---
    @@ -23,3 +23,11 @@
     UPDATE `cloud`.`roles` SET `description`='Default user role' WHERE `id`=4 AND `role_type`='User' AND `description`='Default Root Admin role';
     
     
    +ALTER TABLE cloud.load_balancer_cert_map ENGINE=INNODB;
    +ALTER TABLE cloud.monitoring_services ENGINE=INNODB;
    +ALTER TABLE cloud.nic_ip_alias ENGINE=INNODB;
    +ALTER TABLE cloud.sslcerts ENGINE=INNODB;
    +ALTER TABLE cloud.op_lock ENGINE=INNODB;
    +ALTER TABLE cloud.op_nwgrp_work ENGINE=INNODB;
    --- End diff --
    
    For op_lock and op_nwgrp_work tables engine is MEMORY, not sure of the reason. Was there any perf. issues addressed? These exists since the start.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---