[cloudstack] branch addIndexToResolveSlowMysqlQueryBrowsingNetworks updated: add index to speed up querying IPs in the network-tab

[da...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

dahn pushed a commit to branch addIndexToResolveSlowMysqlQueryBrowsingNetworks
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/addIndexToResolveSlowMysqlQueryBrowsingNetworks by this push:
     new c05de57e69a add index to speed up querying IPs in the network-tab
c05de57e69a is described below

commit c05de57e69a1334394bdc9c2e6c2b612b0161744
Author: Daan Hoogland <da...@onecht.net>
AuthorDate: Tue Dec 27 15:12:18 2022 +0100

    add index to speed up querying IPs in the network-tab
---
 engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql b/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
index fc27d1045c4..fa08f8a8df5 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
@@ -869,3 +869,6 @@ WHERE   usage_unit = 'Policy-Month';
 
 -- delete configuration task.cleanup.retry.interval #6910
 DELETE FROM `cloud`.`configuration` WHERE name='task.cleanup.retry.interval';
+
+--- #6888 add index to speed up querying IPs in the network-tab
+ALTER TABLE `user_ip_address` ADD KEY `fk_user_ip_address__state` (`state`);
\ No newline at end of file