subscan observer exhausts MySQL resources

[armorsun]

Hi I use the docker-compose method to start the Subscan-observer and Subscan-api, they work fine until synced about 2000000 blocks. After synced about 2000000 blocks, the MySQL container started to consume a lot of CPU resources
(100%) and I observed that the MySQL connections exceed 2000. After stopped the Subscan-observer, the MySQL container became normal.

Is the 2000 connections to MySQL normal? Is there a recommendation hardware requirement for the MySQL?

[freehere107]

@armorsun Thank you reply, we have not encountered this problem. you can use MySQL console when CPU 100 ,

show processlis maybe can find some issue

[armorsun]

Currently I am using an instance with 20 core CPU and the CPU utilization is about 95%. The attached image is the result of show processlist

[freehere107]

@armorsun hello, I haven't had a similar situation, have you run it recently?