diff options
| author | Sid Sijbrandij <sytse@gitlab.com> | 2017-08-12 00:17:50 +0000 |
|---|---|---|
| committer | Sid Sijbrandij <sytse@gitlab.com> | 2017-08-12 00:17:50 +0000 |
| commit | 2b950014c35534c817c58ebf43dcbf4bbf490b9e (patch) | |
| tree | fc141a0ba3d5b11a019e814d0a0800f4a24a1c9d | |
| parent | 1c874f71e31fdf2bbc9120fe2111b2daea320e86 (diff) | |
| parent | 057052142099cb24f103317010ca17ea64f9f2ce (diff) | |
| download | gitlab-ce-2b950014c35534c817c58ebf43dcbf4bbf490b9e.tar.gz | |
Merge branch 'sh-add-mysql-query-notes' into 'master'
Add notes about database performance for MySQL
See merge request !13516
| -rw-r--r-- | doc/install/requirements.md | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/doc/install/requirements.md b/doc/install/requirements.md index 141df55f6bc..175dfc62096 100644 --- a/doc/install/requirements.md +++ b/doc/install/requirements.md @@ -104,6 +104,10 @@ features of GitLab work with MySQL/MariaDB: See [issue #30472][30472] for more information. 1. GitLab Geo does [not support MySQL](https://docs.gitlab.com/ee/gitlab-geo/database.html#mysql-replication). 1. [Zero downtime migrations][zero] do not work with MySQL +1. GitLab [optimizes the loading of dashboard events](https://gitlab.com/gitlab-org/gitlab-ce/issues/31806) using [PostgreSQL LATERAL JOINs](https://blog.heapanalytics.com/postgresqls-powerful-new-join-type-lateral/). +1. In general, SQL optimized for PostgreSQL may run much slower in MySQL due to + differences in query planners. For example, subqueries that work well in PostgreSQL + may not be [performant in MySQL](https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html) 1. We expect this list to grow over time. Existing users using GitLab with MySQL/MariaDB are advised to |