MySQL - Set maximum number of result sets per query

Question

When running a large stored procedure mysql script, I am getting the following error The maximum number of result sets per query is reached (100).

After looking around I have found a few articles that say I can change that limit specifically in mysql workbench, but I am looking for a config option for my my.ini file to apply it across the entire server I am running.

It would be awesome to simply do something like max_result_set=5000 or something.

Thanks for all help, in advance.

Answer 1

Huge thanks to Spencer for the thought to check the client settings! (duh!)

There was a setting burried deep in the Advanced tab of the Data Sources and Drivers configuration box. Just for anyone also using that Jetbrain Database Tools and SQL plugin (https://www.jetbrains.com/datagrip/)