Load test Sync 1.5 with MariaDB 5.5.41 and TokuDB 7.5.3

VERIFIED FIXED

Status

Cloud Services
Operations: Deployment Requests
VERIFIED FIXED
3 years ago
3 years ago

People

(Reporter: bobm, Assigned: bobm)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Assignee)

Description

3 years ago
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.
(Assignee)

Comment 1

3 years ago
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?
(Assignee)

Comment 3

3 years ago
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.
(Assignee)

Comment 5

3 years ago
Tentatively scheduled for 2:00 PM PST - 3:00 PM PST 2014/1/21.
(Assignee)

Comment 6

3 years ago
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.
Status: ASSIGNED → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
(Assignee)

Comment 7

3 years ago
(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
(Assignee)

Updated

3 years ago
See Also: → bug 1124523
Marking VERIFIED to get this off my to-do query.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.