Executes schedule routines, and triggers alerts via telegram
Tags
MySQL
TelegramRelated workflows
See all MySQL→
Join data from Postgres and MySQL
query data from two different databases handle and unify in a single return
Create a table in MySQL and insert data
Companion workflow for MySQL node docs
Purge n8n execution history located in Mysql
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 execution_entity table that contains the history of the executed workflows. If you have multiple tasks executed every minute, 1024 rows will be created every day (60 minutes x 24 hours) per every task. This will increase the table size fastly. SQL query deletes entries older than 30 days taking stoppedAt column as a reference for date calculations. You only have to setup Mysql connection properly and config cron to execute once per day in a low traffic hour, this way