https://bugzilla.wikimedia.org/show_bug.cgi?id=66111
Bug ID: 66111
Summary: watchlist needs a surrogate primary key
Product: MediaWiki
Version: 1.23-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: sprin...@wikimedia.org
Web browser: ---
Mobile Platform: ---
CREATE TABLE watchlist (
wl_user int(5) unsigned NOT NULL DEFAULT '0',
wl_namespace int(11) NOT NULL DEFAULT '0',
wl_title varbinary(255) NOT NULL DEFAULT '',
wl_notificationtimestamp varbinary(14) DEFAULT NULL,
UNIQUE KEY wl_user (wl_user,wl_namespace,wl_title),
KEY namespace_title (wl_namespace,wl_title)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
InnoDB uses the unique key wl_user as a primary key. Since PK is clustered,
secondary indexes contain hidden copies of the PK columns, potentially making
them quite large.
Bug 66089 adds another secondary index, wl_user_notificationtimestamp, so it's
time to consider adding a surrogate primary key wl_id.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
