数据库保存的group元信息数据量过大，导致mysql数据库变慢

[Qyc1990]

• [ ] 我已经在 issues 搜索过相关问题了,并没有重复的。

  你是否希望来认领这个优化建议。

  「 Y / N 」

环境信息

• KnowStreaming version : xxx
• Operating System version : xxx
• Java version : xxx

需要优化的功能点

建议如何优化

[Qyc1990]

1. row ID: 178582413 USER: know_streaming HOST: x.x.x.x:58296 DB: know_streaming COMMAND: Query TIME: 262 STATE: Sending data INFO: SELECT id,cluster_phy_id,type,name,state,member_count,topic_members,partition_assignor,coordinator_id,create_time,update_time FROM ks_km_group

WHERE (cluster_phy_id = 5)

mysql> select count() from ks_km_group; +----------+ | count() | +----------+ | 3459044 | +----------+ 1 row in set (1.40 sec)

[Qyc1990]

KnowStreaming version : KnowStreaming-3.3.0 Operating System version : CentOS Linux release 7.9.2009 (Core) Java version : jdk11.0.2