bugzilla.mozilla.org has resumed normal operation. Attachments prior to 2014 will be unavailable for a few days. This is tracked in Bug 1475801.
Please report any other irregularities here.

Make Treeherder's RDS parameter group settings match the SCL3 MySQL config

RESOLVED FIXED

Status

Tree Management
Treeherder: Infrastructure
P1
normal
RESOLVED FIXED
2 years ago
2 years ago

People

(Reporter: emorley, Assigned: emorley)

Tracking

Details

Attachments

(2 attachments)

(Assignee)

Description

2 years ago
The SCL3 instances are actually using a custom MySQL config, that differs slightly from the MySQL 5.6 defaults.

Most of the settings involve paths/buffer sizes/other settings that are not relevant on RDS, however there are some that are.
(Assignee)

Comment 2

2 years ago
Relevant settings we should probably keep:

character_set_server=utf8
-> default is 'latin1' (http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_character-set-server)

collation_server=utf8_bin
-> default is 'latin1_swedish_ci' (http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_collation-server)

slow_query_log = 1
-> default is 0 ie off (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_slow_query_log)

long_query_time=2
-> default is 10 seconds (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_long_query_time)


We don't need to keep 'ft_min_word_len=2' since that only applies to MyIASM tables:
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_ft_min_word_len
http://dev.mysql.com/doc/refman/5.6/en/fulltext-fine-tuning.html
(Assignee)

Comment 3

2 years ago
Created attachment 8796900 [details] [review]
devservices-aws PR #2
Attachment #8796900 - Flags: review?(jwatkins)
(Assignee)

Updated

2 years ago
Blocks: 1303767
Looks good.  Merged and applied.

aws_db_instance.treeherder-heroku: Modifying...
  parameter_group_name: "default.mysql5.6" => "treeherder"
aws_db_instance.treeherder-stage-rds: Modifying...
  parameter_group_name: "default.mysql5.6" => "treeherder"
Attachment #8796900 - Flags: review?(jwatkins)
Attachment #8796900 - Flags: review+
Attachment #8796900 - Flags: checkin+
(Assignee)

Comment 5

2 years ago
Many thanks!

I've rebooted the two RDS instances to pick up the slow query log changes, since they aren't dynamic settings.

I used the failover option on one to compare: with failover reboot took 55 seconds, without 11 seconds. Not bad either way :-)
Status: ASSIGNED → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
(Assignee)

Updated

2 years ago
Depends on: 1308970
(Assignee)

Updated

2 years ago
Blocks: 1313236
You need to log in before you can comment on or make changes to this bug.