[prev in list] [next in list] [prev in thread] [next in thread] 

List:       wikitech-l
Subject:    Re: [Wikitech-l] Indexing sha1 hashes in mysql
From:       Tim Starling <tstarling () wikimedia ! org>
Date:       2012-09-26 4:12:35
Message-ID: k3tvbi$ua2$1 () ger ! gmane ! org
[Download RAW message or body]

On 26/09/12 12:11, Tim Starling wrote:
> On 26/09/12 03:54, Asher Feldman wrote:
>> <tl;dr> Where an index is desired on a mysql column of base36 encoded sha1
>> hashes, I recommend ADD INDEX (sha1column(10)).  Shorter indexes will be
>> sufficient in many cases, but this is still provides a >2/3 space savings
>> while covering a huge (2^51.43) space.
> 
> We usually don't put update patches in MediaWiki for index size
> changes. You can change the indexes on existing Wikimedia wikis at
> your leisure, and we will change it in tables.sql for the benefit of
> new wikis.

Done in https://gerrit.wikimedia.org/r/#/c/25218/

-- Tim Starling


_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[prev in list] [next in list] [prev in thread] [next in thread]