subscan-essentials subscan observer exhausts MySQL resources

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?

Mar 10 '21 03:03 armorsun

@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

Mar 10 '21 07:03 freehere107

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

Screen Shot 2021-03-12 at 16 37 19

Mar 12 '21 08:03 armorsun

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

Jun 24 '21 02:06 freehere107