[
https://issues.apache.org/jira/browse/CLOUDSTACK-9481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15454757#comment-15454757
]
ASF GitHub Bot commented on CLOUDSTACK-9481:
--------------------------------------------
Github user rhtyd commented on a diff in the pull request:
https://github.com/apache/cloudstack/pull/1670#discussion_r77133791
--- 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.
> Convert MyISAM table to InnoDB for consistency
> ----------------------------------------------
>
> Key: CLOUDSTACK-9481
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9481
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Management Server
> Affects Versions: 4.9.0
> Reporter: Abhinandan Prateek
> Assignee: Abhinandan Prateek
> Fix For: 4.9.1
>
>
> These following tables in cloud schema
> load_balancer_cert_map
> monitoring_services
> nic_ip_alias
> sslcerts
> and following in cloud_usage schema
> quota_account
> use MyISAM. There is not reason that these few tables use MyISAM and these
> should be altered to use Innodb
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
