How to Troubleshoot Sudden Increase in TiFlash Memory Usage

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何排查tiflash内存占用瞬间提高的原因

| username: 青木科技-熊猛

In the production environment, it was found that two TiFlash nodes occupied 12G of memory within half a minute, but after searching through the entire documentation, I still don’t know how to locate the cause. There were no corresponding slow query SQLs at that time. Is there a good way to locate this kind of memory increase issue? For example, which SQLs are occupying more memory?

| username: WalterWj | Original post link

If you can’t find the slow SQL, are you using TiSpark? You can check the slow logs to see if there are any statements using the TiFlash engine.

| username: 青木科技-熊猛 | Original post link

Not using TiSpark. This kind of issue is indeed difficult to track.

| username: 有猫万事足 | Original post link

Take a look at this. Although the title mentions CPU, scanning more keys can also lead to increased memory usage. From my observation in TiFlash, the increase in CPU and memory usage is generally consistent.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.