Jump to content

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

Add topic
From Meta, a Wikimedia project coordination wiki

Friday, October 17, 2014

[edit]

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)Reply


The geometric mean revisions saved per R:Newly registered user is plotted by experimental bucket.
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)Reply