849463 - Add indexes to getpersonas

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Wil Clouser [:clouserw]]

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

Comment 1

[Sheeri Cabral [:sheeri]]

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