summaryrefslogtreecommitdiff
path: root/changelogs
diff options
context:
space:
mode:
authorStan Hu <stanhu@gmail.com>2018-03-06 13:30:10 -0800
committerStan Hu <stanhu@gmail.com>2018-03-07 21:39:20 -0800
commit609a434c6dc2c6d4aafb359348c129fc01d264e3 (patch)
tree260d371bd3e6b82edbc0c87704b5a59ad65f76ce /changelogs
parent7734e85bc6592c5ad3330c611c5f83a051b680b0 (diff)
downloadgitlab-ce-609a434c6dc2c6d4aafb359348c129fc01d264e3.tar.gz
Adding missing indexes on taggings tablesh-add-missing-acts-as-taggable-indices
API requests were timing out because `tag_id` was missing an index. These migrations were imported by running https://github.com/mbleigh/acts-as-taggable-on#post-installation: ``` bundle exec rake acts_as_taggable_on_engine:install:migrations ``` It looks like the `acts-as-tagglable` gem added the indexes in v4.0.0, but when we upgraded from v3.5.0 (back in 2016 via f571aeb5ce38dce1a9e5f58d76360836d4a8f8a0) we did not add them. On staging, there are about 10.7 million rows on the `taggings` table. It took about 30 seconds for each index to be created. On production, there are about 17.4 million rows, so I suspect the time to be about a minute per index. Closes #43927
Diffstat (limited to 'changelogs')
-rw-r--r--changelogs/unreleased/sh-add-missing-acts-as-taggable-indices.yml5
1 files changed, 5 insertions, 0 deletions
diff --git a/changelogs/unreleased/sh-add-missing-acts-as-taggable-indices.yml b/changelogs/unreleased/sh-add-missing-acts-as-taggable-indices.yml
new file mode 100644
index 00000000000..d9a1a0db9e8
--- /dev/null
+++ b/changelogs/unreleased/sh-add-missing-acts-as-taggable-indices.yml
@@ -0,0 +1,5 @@
+---
+title: Adding missing indexes on taggings table
+merge_request:
+author:
+type: performance