[ https://issues.apache.org/jira/browse/CLOUDSTACK-9481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15454445#comment-15454445
]
ASF GitHub Bot commented on CLOUDSTACK-9481:
--------------------------------------------
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.
> 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)
|