Add index on logging.log_user_text
authorJackmcbarn <jackmcbarn@gmail.com>
Mon, 9 Dec 2013 21:11:06 +0000 (16:11 -0500)
committerSpringle <springle@wikimedia.org>
Thu, 19 Dec 2013 03:13:05 +0000 (03:13 +0000)
commit65a304c44451d0a62d01b809f3ef24c921286702
tree1b545e1b283eb71494d1ee9cd7305a0b3f1f5f12
parent0fba444861f80e0dcc4a85f306b4df0436c19d3d
Add index on logging.log_user_text

Fixing bug #54404 requires querying against logging.log_user_text, which
is currently unindexed. Add an index, to prevent performance from being
adversely affected by the fix.

Bug: 54432
Change-Id: I6b2af65c75bbee57377cb1ec2e75ea41a5091f80
12 files changed:
includes/installer/MysqlUpdater.php
includes/installer/OracleUpdater.php
includes/installer/PostgresUpdater.php
includes/installer/SqliteUpdater.php
maintenance/archives/patch-logging_user_text_time_index.sql [new file with mode: 0644]
maintenance/archives/patch-logging_user_text_type_time_index.sql [new file with mode: 0644]
maintenance/mssql/tables.sql
maintenance/oracle/archives/patch-logging_user_text_time_index.sql [new file with mode: 0644]
maintenance/oracle/archives/patch-logging_user_text_type_time_index.sql [new file with mode: 0644]
maintenance/oracle/tables.sql
maintenance/postgres/tables.sql
maintenance/tables.sql