cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-9481) Convert MyISAM table to InnoDB for consistency
Date Thu, 01 Sep 2016 06:09:21 GMT

    [ 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)

Mime
View raw message