Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mydumper dump big table failed, because of dumping time longer than max_execution_time #257

Closed
dbakit opened this issue Jul 14, 2020 · 3 comments

Comments

@dbakit
Copy link

dbakit commented Jul 14, 2020

ERROR content is:

[ERROR] - Could not read data from ****.***: Query execution was interrupted, maximum statement execution time exceeded

To fix it, Now I must login a Super User, and set global max_execution_time=0, but In fact
we only need set the variable with SESSION scope;
So I suggest add a new argument, like --max_execution_time, and set the variable with SESSION scope at the beginning , like:

set session max_execution_time=0;
@davidducos
Copy link
Member

Hi @ting425,

I think that it is better to have a file with all the variable that we want to use for SET SESSION statements, instead of having one per variable or we could have a list of variables, something like --set-session="max_execution_time=0,other_variable=2", What do you think?

@davidducos davidducos added this to the Release 0.10.9 milestone Apr 16, 2021
@dbakit
Copy link
Author

dbakit commented Aug 5, 2021

That's wonderful!

@davidducos
Copy link
Member

Check #370, it is already merged into master. We can close it.

@dbakit dbakit closed this as completed Aug 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants