Add indexes to getpersonas

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
5 years ago
3 years ago

People

(Reporter: clouserw, Unassigned)

Tracking

Details

(Reporter)

Description

5 years ago
We added a couple of indexes to getpersonas when testing this migration script and they gave us a huge speed up.  Please run these on production getpersonas.com:

> create index author_idx on personas (author);
> create index author_fav_idx on favorites (username);

Thanks
Files aren't too huge, so this can be done live:
-rw-rw---- 1 mysql mysql 188M Mar 11 12:20 personas.ibd
-rw-rw---- 1 mysql mysql 220M Mar 11 12:21 favorites.MYI
-rw-rw---- 1 mysql mysql 257M Mar 11 12:21 favorites.MYD

Done:

mysql> use personas;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> create index author_idx on personas (author);
Query OK, 0 rows affected (2 min 57.56 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> create index author_fav_idx on favorites (username);
Query OK, 9277399 rows affected (2 min 18.17 sec)
Records: 9277399  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.