abdelouahabb edited a comment on issue #4781: URL: https://github.com/apache/cloudstack/issues/4781#issuecomment-796268931
@weizhouapache I reinstalled openjdk 14 and same lag, for the mysql, I tried to get deeper logs about the fact it is too slow, I enabled the warnings and here is some of warnings I get, maybe this is due to `mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))` which is the default and not the `version 5` which was long ago default with ubuntu ? ``` mysql> \W Show warnings enabled. mysql> source /usr/share/cloudstack-management/setup/create-database.sql; Query OK, 0 rows affected, 1 warning (0.09 sec) Note (Code 1305): PROCEDURE mysql.cloud_drop_users_if_exists does not exist Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected, 1 warning (0.03 sec) Note (Code 1008): Can't drop database 'billing'; database doesn't exist Query OK, 0 rows affected (0.16 sec) Note (Code 1008): Can't drop database 'cloud'; database doesn't exist Query OK, 1 row affected (0.14 sec) mysql> source /usr/share/cloudstack-management/setup/create-schema.sql Query OK, 0 rows affected (0.00 sec) Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Query OK, 0 rows affected, 1 warning (0.05 sec) Note (Code 1051): Unknown table 'cloud.port_forwarding_rules_view' Query OK, 0 rows affected (0.44 sec) Query OK, 0 rows affected, 1 warning (0.12 sec) Note (Code 1051): Unknown table 'cloud.ip_forwarding' Query OK, 0 rows affected, 1 warning (0.18 sec) Note (Code 1051): Unknown table 'cloud.management_agent' Query OK, 0 rows affected (1.30 sec) Note (Code 1051): Unknown table 'cloud.host_zone_ref' Query OK, 0 rows affected, 1 warning (0.09 sec) Note (Code 1051): Unknown table 'cloud.data_ceneter' Query OK, 0 rows affected (0.39 sec) Query OK, 0 rows affected, 1 warning (0.04 sec) Note (Code 1051): Unknown table 'cloud.storage' Query OK, 0 rows affected (0.43 sec) Query OK, 0 rows affected, 1 warning (0.04 sec) Note (Code 1051): Unknown table 'cloud.pricing' Query OK, 0 rows affected (0.39 sec) Warning (Code 3719): 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. ``` Edit: unistalled mysql 8 and installed mariadb 10.3 `(mysql Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2)` halfed the time to ``` real 3m4.760s user 0m1.271s sys 0m0.353s ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
