Research talk:HHVM newcomer engagement experiment/Work log/2014-10-17

Friday, October 17, 2014

Today, I'm checking on the data and generating new user stats.

First, I want to make sure that even user_id'd users have HHVM enabled and odd user_id'd users have PHP5.

SELECT
    event_isSelfMade,
    event_displayMobile,
    wiki,
    event_userId % 2,
    ct_tag,
    count(*)
FROM log.ServerSideAccountCreation_5487345
INNER JOIN enwiki.revision ON
    rev_user = event_userId
LEFT JOIN enwiki.change_tag ON
    rev_id = ct_rev_id
WHERE
    wiki = "enwiki" AND
    timestamp BETWEEN "20141008000000" AND "20141015999999" AND
    (ct_tag = "HHVM" OR ct_tag IS NULL)
GROUP BY 1,2,3,4,5;

+------------------+---------------------+--------+------------------+--------+----------+
| event_isSelfMade | event_displayMobile | wiki   | event_userId % 2 | ct_tag | COUNT(*) |
+------------------+---------------------+--------+------------------+--------+----------+
|                0 |                   0 | enwiki |                0 | HHVM   |      126 |
|                0 |                   0 | enwiki |                1 | NULL   |      126 |
|                0 |                   0 | enwiki |                1 | HHVM   |       15 |
|                0 |                   1 | enwiki |                0 | HHVM   |       97 |
|                0 |                   1 | enwiki |                1 | NULL   |       23 |
|                0 |                   1 | enwiki |                1 | HHVM   |        2 |
|                1 |                   0 | enwiki |                0 | NULL   |       35 |
|                1 |                   0 | enwiki |                0 | HHVM   |    17983 |
|                1 |                   0 | enwiki |                1 | NULL   |    15837 |
|                1 |                   0 | enwiki |                1 | HHVM   |      980 |
|                1 |                   1 | enwiki |                0 | NULL   |        4 |
|                1 |                   1 | enwiki |                0 | HHVM   |     4879 |
|                1 |                   1 | enwiki |                1 | NULL   |      477 |
|                1 |                   1 | enwiki |                1 | HHVM   |      130 |
+------------------+---------------------+--------+------------------+--------+----------+
14 rows in set (1 hour 18.59 sec)

^^^ Taking longer thank expected. --Halfak (WMF) (talk) 00:35, 18 October 2014 (UTC) ^^^ Done and waiting for me this morning --Halfak (WMF) (talk) 15:16, 18 October 2014 (UTC)

---

Revisions saved by condition. The geometric mean revisions saved per R:Newly registered user is plotted by experimental bucket.

So, that doesn't make any sense. It looks like HHVM increases engagement for mobile editors, but decreases engagement for desktop editors. Will need to dig into this more later. That's all for today. --Halfak (WMF) (talk) 22:55, 17 October 2014 (UTC)