01tonythomas has uploaded a new change for review.
https://gerrit.wikimedia.org/r/170759
Change subject: Create table index for 'bounce_records' table
......................................................................
Create table index for 'bounce_records' table
A partial index on the email field, and then the timestamp is created.
Bug: 69100
Change-Id: I7a6ca1e33c0152d9cc911c15a806e85e6f726b6a
---
M BounceHandlerHooks.php
A sql/create_index.sql
2 files changed, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/BounceHandler
refs/changes/59/170759/1
diff --git a/BounceHandlerHooks.php b/BounceHandlerHooks.php
index c08bb15..151ec18 100644
--- a/BounceHandlerHooks.php
+++ b/BounceHandlerHooks.php
@@ -83,6 +83,7 @@
public static function LoadExtensionSchemaUpdates( DatabaseUpdater
$updater ) {
$updater->addExtensionTable( 'bounce_records', __DIR__ .
'/sql/bounce_records.sql', true );
$updater->modifyExtensionField( 'bounce_records', 'br_user',
__DIR__ . '/sql/alter_user_column.sql' );
+ $updater->addExtensionIndex( 'bounce_records', __DIR__
.'/sql/create_index.sql', true );
return true;
}
diff --git a/sql/create_index.sql b/sql/create_index.sql
new file mode 100644
index 0000000..263ce9a
--- /dev/null
+++ b/sql/create_index.sql
@@ -0,0 +1,8 @@
+-- MySQL version of the database schema for the BounceHandler extension.
+-- Licence: GNU GPL v2+
+-- Author: Tony Thomas, Legoktm, Jeff Green
+
+
+CREATE INDEX /*i*/br_mail_timestamp ON /*_*/bounce_records(br_user_email(50),
br_timestamp);
+
+
--
To view, visit https://gerrit.wikimedia.org/r/170759
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I7a6ca1e33c0152d9cc911c15a806e85e6f726b6a
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/BounceHandler
Gerrit-Branch: master
Gerrit-Owner: 01tonythomas <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
