diff options
| author | Amir Sarabadani <ladsgroup@gmail.com> | 2024-02-01 14:43:22 +0100 |
|---|---|---|
| committer | Amir Sarabadani <ladsgroup@gmail.com> | 2024-02-01 15:32:05 +0100 |
| commit | 616744db1d7dd4a0093c9be2c66b31714286b443 (patch) | |
| tree | 4ddea8c983ff019f7f66e01f4d0a727dc15d341d /maintenance/sqlite/tables-generated.sql | |
| parent | 0b52e864b0d9236233ffa5f5ec908e172dbb5106 (diff) | |
| download | mediawikicore-616744db1d7dd4a0093c9be2c66b31714286b443.tar.gz mediawikicore-616744db1d7dd4a0093c9be2c66b31714286b443.zip | |
Schema: Drop unused and useless indexes of sites table
This table has eight indexes plus PK. It has around 1000 rows only. Even
if it needs these indexes (which it doesn't), they are still useless.
Looking at the code, the only potential useful index is the one on
site_global_key, they are showing up in the report of unused indexes in
the db and I checked with Fandom (which might benefit from an index on
this table) and they said they don't use sites table.
Bug: T342856
Change-Id: I06b3db0f33bd35bfa68f4b418d8c2f4b9b988409
Diffstat (limited to 'maintenance/sqlite/tables-generated.sql')
| -rw-r--r-- | maintenance/sqlite/tables-generated.sql | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/maintenance/sqlite/tables-generated.sql b/maintenance/sqlite/tables-generated.sql index 772399dfa34c..b6d5ef0a5a23 100644 --- a/maintenance/sqlite/tables-generated.sql +++ b/maintenance/sqlite/tables-generated.sql @@ -373,20 +373,6 @@ CREATE TABLE /*_*/sites ( CREATE UNIQUE INDEX site_global_key ON /*_*/sites (site_global_key); -CREATE INDEX site_type ON /*_*/sites (site_type); - -CREATE INDEX site_group ON /*_*/sites (site_group); - -CREATE INDEX site_source ON /*_*/sites (site_source); - -CREATE INDEX site_language ON /*_*/sites (site_language); - -CREATE INDEX site_protocol ON /*_*/sites (site_protocol); - -CREATE INDEX site_domain ON /*_*/sites (site_domain); - -CREATE INDEX site_forward ON /*_*/sites (site_forward); - CREATE TABLE /*_*/user_newtalk ( user_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, |