High CPU Usage Issue in n8n with Frequent Workflow Executions

[Asuwini_P]

We are running more than 15 workflows, each executing every minute to check for new data in MySQL. If new data is detected, the full workflow executes.

Each workflow queries different tables for different projects, which adds to the processing load.

However, we are constantly facing 100% CPU utilization, especially during peak execution times.

Our current setup:

• 2-core server (which seems insufficient).

• Even when increasing to 4 cores, CPU usage still spikes, and we anticipate the same issue as workflows increase.

We are looking for best practices to optimize CPU usage.

Would appreciate any insights from the community!

Information on your n8n setup

• n8n version: Version 0.225.2

• Database (default: SQLite): MySQL

• n8n EXECUTIONS_PROCESS setting (default: own, main): own

• Running n8n via (Docker, npm, n8n cloud, desktop app): : docker

• Operating system: Ubuntu 22.04.2 LTS

[barn4k]

hello @Asuwini_P

Please, share the workflow.

You can select all nodes with ctrl+a, copy it with ctrl+c. Then past the content here after pressing button </> with ctrl+v.

And your n8n version is too old (more than 2 years old)

[Asuwini_P]

Hi @barn4k

Thank you for your response.

I have multiple workflows running in production, so I’m unable to share them at the moment.

As I mentioned earlier, all workflows execute MySQL queries every minute (using a scheduler trigger) to check for new data.