MySQL client ran out of memory error.

Hi,

I'm getting this MySQL client ran out of memory error when running a batch macro with a few Connect In-DB tools with corresponding Data Stream Outs, combined with a single Union tool.

I have already requested for additional memory, but is there anything else that I can do from my end? Configurations, maybe?

Thank you!

Workflow

Developer

Developer Tools

Settings

Error Message

Connectors

Best Practices

Batch Macro

In Database

Database Connection

Scheduler

In-Database

Accepted answers

gautiergodard

hey @RonGatmaitan

Have you tried increasing your memory settings within Alteryx's user settings?

All comments

gautiergodard

hey @RonGatmaitan

Have you tried increasing your memory settings within Alteryx's user settings?

RonGatmaitan

Hi @gautiergodard,

Not yet. Will look into that. I would assume I would have to tick that "Override System Settings" box, right?

gautiergodard

@RonGatmaitan Yes correct this is how you would enable this setting.

RonGatmaitan

Sorry for the delay in reply. I had to wait for it to run in Alteryx Scheduler, just to be very sure. Worked like a charm! Thanks, @gautiergodard! Setting your answer as solution. Thanks again.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703