cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhtyd <>
Subject [GitHub] cloudstack pull request #1670: CLOUDSTACK-9481: Convert MyISAM table to Inno...
Date Thu, 01 Sep 2016 08:30:29 GMT
Github user rhtyd commented on a diff in the pull request:
    --- 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 --
    Yes, they have existed since 4.0. I checked git history, I think there is nothing specific
to this table, they can be migrated to InnoDB. I'm running a local 4.9.0 CloudStack environment
with these changes and it is working alright.

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 or file a JIRA ticket
with INFRA.

View raw message