Purge n8n execution history located in Mysql
Needs changesWhat this workflow does
This workflow has 3 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects MySQL.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- MySQL: run a query
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Cron | Schedule Trigger |
Nodes used (3)
- Manual Trigger
n8n-nodes-base.manualTrigger - MySQL
n8n-nodes-base.mySql - Cron
n8n-nodes-base.cron
From the author
This workflow is useful if you have lots of tasks running daily. MySQL node (or the database used to save data shown in n8n - could be Mongo, Postgres, ... -) remove old entries from executionentity table that contains the history of the executed workflows.…