Run a load test on Sync 1.5 stage with MariaDB 5.5.41 and TokuDB 7.5.3. There are a number of bug fixes, and performance improvements available. See the change logs here: https://mariadb.com/kb/en/mariadb/development/changelogs/mariadb-5541-changelog/ http://docs.tokutek.com/tokudb/tokudb-release-notes.html Determine if this resolves problem in Bug 1057892.
See bug 1089945 for previous run. This has been deployed to Sync 1.5 stage.
Bob, do you want to do this during the week that :rfkelly's away, or should we wait for his return?
This is something we can do while he's away. Also, depending on how well this goes. I'd like to run a follow on load test with a slight change in DB schema, using clustering indexes, to make a comparison. If we have the time and inclination next week. I would make a separate ticket for that.
Excellent. Block out some time on the calendar, and let's get this done.
Tentatively scheduled for 2:00 PM PST - 3:00 PM PST 2014/1/21.
Collective performance during the load tests (1 x 2hr and 1 x 6hr): Query min max mean std_deviation 200 Status 0.001 8.356 0.122 0.117 4xx Status 0.001 0.866 0.018 0.035 5xx Status 0.000 0.000 Closing this as a success, and filing a bug for production.
(In reply to Bob Micheletto [:bobm] from comment #6) Adding this bit of information about volume used for the load: Host Rows Space sync1 137778930 21G sync2 137717825 21G sync3 137837227 21G sync4 138036955 21G
Marking VERIFIED to get this off my to-do query.