Replies: 4 comments 4 replies
-
With --rows you can reduce the insert size.
Reference: https://github.com/mydumper/mydumper#defaults-file |
Beta Was this translation helpful? Give feedback.
4 replies
-
It is a shared hosting.
For session i get info that it is read-only.
For GLOBAL i get info that i need super-user
pon., 18 wrz 2023, 21:17 użytkownik David Ducos ***@***.***>
napisał:
… why do you say that you cannot change the max_allowed_packet as it is a
session variable?
—
Reply to this email directly, view it on GitHub
<#1303 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AFKO7AC2GM7IM54XMUOVDOLX3CM3XANCNFSM6AAAAAA44652QQ>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
0 replies
-
Session variable is read only
"
max_allowed_packet on the command line or in an option file.
The session value of this variable is read only
"
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
|
Beta Was this translation helpful? Give feedback.
0 replies
-
You can use on mydumper:
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Since insert statements can be easily cut into smaller ones or grouped into bigger ones it would be great to provide such functionality in myloader. It would help loading into dbs with different max_allowed_packet setting without the need to dump the same data multiple times (with different settings).
Beta Was this translation helpful? Give feedback.
All reactions