skeema / skeema / 7053843812

92%

push

github

docker: additional performance improvements

This commit provides further perf improvements for workspace=docker and
integration testing, in addition to the recent work in 22d4b9b and 766efc3:

* Dockerized databases now disable the InnoDB adaptive hash index, since it
  is not beneficial at all for Skeema's DDL-heavy workload. (MariaDB disables
  it by default already in MariaDB 10.5+, but it is harmless to redundantly
  set this on the command-line.)

* Dockerized MySQL 8.0.22+ databases now disable innodb_log_writer_threads
  since this variable is consistently harmful to the performance of Skeema's
  workspace workload. (This variable does not exist in other flavors, but is
  disabled using the "loose-" prefix to ensure this doesn't cause errors.)

* The ephemeral container created by TestTempSchemaBinlog now uses tmpfs on
  Linux; this was accidentally omitted in 766efc3.

As before, the settings in the first two bullets are only applied to newly-
created Docker containers. If you have existing Skeema-managed containers
(either from workspace=docker without docker-cleanup=destroy, or from Skeema
integration tests), you must manually remove them first, if you wish for
Skeema to recreate them with the new settings applied.

6 of 6 new or added lines in 1 file covered. (100.0%)

9568 of 10254 relevant lines covered (93.31%)

1.11 hits per line