Closed
Bug 849463
Opened 11 years ago
Closed 11 years ago
Add indexes to getpersonas
Categories
(Data & BI Services Team :: DB: MySQL, task)
Data & BI Services Team
DB: MySQL
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: clouserw, Unassigned)
Details
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•11 years ago
|
||
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
Closed: 11 years ago
Resolution: --- → FIXED
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•