Closed Bug 516044 Opened 15 years ago Closed 15 years ago

[AMO] Update production database

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: clouserw, Assigned: fox2mike)

Details

(Whiteboard: 09/15/2009) 

We need to add a column in production for stat gathering (bug 507221).  Please run the following query:

alter table download_counts add column `src` text default null after `count`;

It took 2 min 15 seconds on dev.
Assignee: server-ops → shyam
Whiteboard: 09/15/2009
Wil, I missed this for downtime tonight.  Any reason this can't be done Wednesday morning?  Or push to Thursday night?
Flags: needs-downtime+
Oops, didn't see mrz's update and ran this anyway, looks okay :

mysql> alter table download_counts add column `src` text default null after `count`;
Query OK, 3634326 rows affected (2 min 30.07 sec)
Records: 3634326  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.