Thanks Aaron,

I don't have access to rt itself, I've been sending requests by email before. Should this go to ops-requests@rt.wikimedia.org or to another rt address? I was unable to find a list of those rt email addresses that I presume send the request to the right team/project in rt.

On Mon, May 12, 2014 at 11:40 AM, Aaron Halfaker <ahalfaker@wikimedia.org> wrote:

Hi Gilles,

We don't have a documented process yet. I'd be happy to be the contact for adding indexes since I need indexes so often myself. I've asked springle if this would be acceptable.

In the meantime, you could file a ticket in rt requesting the index.

-Aaron

On May 12, 2014 11:13 AM, "Gilles Dubuc" <gilles@wikimedia.org> wrote:

Is it possible? What's the process for it?

Some of the tables on db1047 I'm dealing with are getting massive (the main offender is 27.8GB) and some of our daily queries used to build tsvs are badly in need on indexes.

The SQL credentials I have access to don't have the rights to alter those tables.

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics