kine periodic query causes MySQL CPU 100% load

k3s-io / kine

Run Kubernetes on MySQL, Postgres, sqlite, dqlite, not etcd.

Apache License 2.0

1.49k stars 226 forks source link

kine periodic query causes MySQL CPU 100% load #283

Closed lidh15 closed 4 months ago

lidh15 commented 4 months ago

IMG_2902.HEIC.jpg

the query in the screen shot was executed periodically and caused CPU 100% used how should I cut this peak usage?

brandond commented 4 months ago

That is a pretty normal list query. Queries similar to that one are constantly executed in response to get/list requests. If that is causing your database server to hit 100% cpu utilization, you may need to provide it with more CPU or memory.