Dear Developers, What does each row of data in the history_node table? Or when will insert a new data into it？ Recently we found that the tps of mysql is very high, there are many history_node related operations.

Thanks for your reply. Yes, we use some loops, and what I’m trying to figure out is whether each call to activity in the workflow triggers the histry_node to add data, or whether other common operations do as well?

history_node table stores event history. As any workflow update generates events this table is constantly updated.

Thank you maxim, and I want to be more detailed so I can tell my team what code to avoid. What does ‘any workflow update’ mean exactly? Does it match the contents of this list? Events reference | Temporal Documentation

Yes, all these events are stored in the history_node table.

About history_node table

Community Support

tihomir June 15, 2022, 6:37pm 2

Would check if you might have some busy loop inside your workflow code, see this post for more info.

Topic		Replies	Views
Understanding how history_node table works Community Support java-sdk , general-impl	0	51	May 8, 2026
Handle overload History_node in database temporal-mysql Community Support go-sdk	9	1026	December 2, 2021
History_node keeps growing Community Support postgresql	12	2509	January 16, 2023
Temporal workflow/activity data in which tables? Community Support database	3	994	March 29, 2022
Check workflow execution history in database Community Support database , postgresql	6	1507	November 16, 2022

About history_node table

Related topics