https://bugzilla.wikimedia.org/show_bug.cgi?id=22883
Summary: WMF wikis need consistent MySQL data types for
page.page_title and image.img_name
Product: Wikimedia
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: Site requests
AssignedTo: [email protected]
ReportedBy: [email protected]
This is related to https://jira.toolserver.org/browse/TS-549
Certain WMF slaves are using varchar(255) for page.page_title and
image.img_name (possibly other columns as well), while other slaves/wiki
databses are using varbinary(255). This has to do with MySQL 5 treating
varbinary as the same as varchar, from what I understand.
The issue that we've run into on the Toolserver is that comparing varchar
fields to varbinary fields is incredibly slow. For example,
enwiki_p.page.page_title is varbinary while commonswiki_p.image.img_name is
varchar, so the following query takes an incredibly long time to run:
SELECT
page_title
FROM page
WHERE NOT EXISTS (SELECT
img_name
FROM commonswiki_p.image
WHERE img_name = page_title)
LIMIT 1;
The Toolserver folks are hesitant to alter the tables on their side, and it
would probably be better all around for there to be consistency among the WMF
databases and slaves.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- 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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
