Generatechangelog in 4.7.1 is slow

General Discussion
1

Hi, i have a question,
i run the generatechangelog in liquibase 4.7.1, but it takes around 2-3hours
while using liquibase 3.6.2 only takes 5-10minutes.
why it takes longer than version 3.6.2?

2

I have the same problem, I used 3.6.3 now. When I upgrade to 4.7.1 the genaragechangelog is never done, very slow. Any idea what’s going on here?

3

after I checked again the problem seem because the query liquibase on table INFORMATION_SCHEMA on mysql very slow.
the query to INFORMATION_SCHEMA in 3.6.3 and 4.7.1 seem different now

4

I have the same problem on 4.4.2 and above. It takes less than 1 minute to run Generatechangelog() if there is only one schema in mysql. After I create 15 schemas, it takes around 8 minutes to for the same job. It seems it’s related to the query performance of information_schema table. Thanks in advance if anyone can give some hint.