Page MenuHomePhabricator

Manually set "max_allowed_packet" to 1GB for "mysqldump"
ClosedPublic

Authored by epriestley on Dec 20 2017, 5:50 PM.
Tags
None
Referenced Files
Unknown Object (File)
Sat, Dec 21, 12:29 AM
Unknown Object (File)
Wed, Dec 18, 12:38 PM
Unknown Object (File)
Tue, Nov 26, 10:17 PM
Unknown Object (File)
Sat, Nov 23, 10:18 AM
Unknown Object (File)
Sat, Nov 23, 6:46 AM
Unknown Object (File)
Fri, Nov 22, 7:27 PM
Unknown Object (File)
Nov 18 2024, 4:34 AM
Unknown Object (File)
Nov 13 2024, 11:47 PM
Subscribers
None

Details

Summary

We have one production instance with failing database backups since they recently uploaded a 52MB hunk. The production configuration specifies a 64MB "max_allowed_packet" in [mysqld], but this doesn't apply to mysqldump (we'd need to specify it in a separate [mysqldump] section) and mysqldump runs with an effective limit of the default (16MB).

We could change our production config to specify a value in [mysqldump], but just change it unconditionally at execution time since there's no reason for any user to ever want this command to fail because they have too much data.

Test Plan

Dumped locally, will verify production backup goes through cleanly.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

This revision is now accepted and ready to land.Dec 20 2017, 6:22 PM
This revision was automatically updated to reflect the committed changes.

I deployed this narrowly to the affected shard and verified the backlog flushed and database dumped properly.