ApsaraDB / PolarDB-for-PostgreSQL

A cloud-native database based on PostgreSQL developed by Alibaba Cloud.
https://apsaradb.github.io/PolarDB-for-PostgreSQL/zh/
Apache License 2.0
2.86k stars 457 forks source link

数据库进程持续占用CPU 接近100%,即便在没有访问的情况下 #521

Open hecor opened 1 month ago

hecor commented 1 month ago

Describe the problem 数据库持续占用CPU 接近100%,即便在没有访问的情况下。

image

polardb-bot[bot] commented 1 month ago

Hi @hecor ~ Thanks for opening this issue! 🎉

Please make sure you have provided enough information for subsequent discussion.

We will get back to you as soon as possible. ❤️

liuchengshan-lcs commented 1 month ago

Describe the problem 数据库持续占用CPU 接近100%,即便在没有访问的情况下。

image

收到反馈,麻烦和您确认几个问题。 1..麻烦pstack一下高负载的进程。 2.您的机器规格如何 3.ps看下连接情况(目的是确认下是否有很多空闲连接/使用中的连接)

hecor commented 1 month ago
  1. pstack高负载进程 image

  2. 机器规格 阿里云 2核(vCPU) 8GiB

  3. ps情况 image