Research talk:The sudden decline of Italian Wikipedia

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

slow-parse.log[edit]

reedy@fluorine:/a/mw-log$ grep -c "itwiki" slow-parse.log
13279
reedy@fluorine:/a/mw-log$ grep -c "dewiki" slow-parse.log
6962
reedy@fluorine:/a/mw-log$ grep -c "enwiki" slow-parse.log
157638
reedy@fluorine:/a/mw-log$ grep -c "frwiki" slow-parse.log
41041
reedy@fluorine:/a/mw-log$ grep -c "ruwiki" slow-parse.log
14459

Reedy (talk) 21:21, 31 May 2014 (UTC)

reedy@fluorine:/a/mw-log/archive$ zgrep -c "itwiki" slow-parse.log-201*
slow-parse.log-20131202.gz:13858
slow-parse.log-20131203.gz:12673
slow-parse.log-20131204.gz:13698
slow-parse.log-20131205.gz:15534
slow-parse.log-20131206.gz:18704
slow-parse.log-20131207.gz:19253
slow-parse.log-20131208.gz:20521
slow-parse.log-20131209.gz:14634
slow-parse.log-20131210.gz:14825
slow-parse.log-20131211.gz:14120
slow-parse.log-20131212.gz:15578
slow-parse.log-20131213.gz:15348
slow-parse.log-20131214.gz:13338
slow-parse.log-20131215.gz:14235
slow-parse.log-20131216.gz:14945
slow-parse.log-20131217.gz:17543
slow-parse.log-20131218.gz:18464
slow-parse.log-20131219.gz:17592
slow-parse.log-20131220.gz:17252
slow-parse.log-20131221.gz:23068
slow-parse.log-20131222.gz:19108
slow-parse.log-20131223.gz:24995
slow-parse.log-20131224.gz:18185
slow-parse.log-20131225.gz:14312
slow-parse.log-20131226.gz:18863
slow-parse.log-20131227.gz:19486
slow-parse.log-20131228.gz:18781
slow-parse.log-20131229.gz:31220
slow-parse.log-20131230.gz:25579
slow-parse.log-20131231.gz:32302
slow-parse.log-20140101.gz:19241
slow-parse.log-20140102.gz:16758
slow-parse.log-20140103.gz:16363
slow-parse.log-20140104.gz:16574
slow-parse.log-20140105.gz:21008
slow-parse.log-20140106.gz:19178
slow-parse.log-20140107.gz:31328
slow-parse.log-20140108.gz:30645
slow-parse.log-20140109.gz:19635
slow-parse.log-20140110.gz:23194
slow-parse.log-20140111.gz:20055
slow-parse.log-20140112.gz:15892
slow-parse.log-20140113.gz:15264
slow-parse.log-20140114.gz:11759
slow-parse.log-20140115.gz:18933
slow-parse.log-20140116.gz:27450
slow-parse.log-20140117.gz:17797
slow-parse.log-20140118.gz:13688
slow-parse.log-20140119.gz:9048
slow-parse.log-20140120.gz:32549
slow-parse.log-20140121.gz:14542
slow-parse.log-20140122.gz:12851
slow-parse.log-20140123.gz:14961
slow-parse.log-20140124.gz:7129
slow-parse.log-20140125.gz:6478
slow-parse.log-20140126.gz:13868
slow-parse.log-20140127.gz:24515
slow-parse.log-20140128.gz:20493
slow-parse.log-20140129.gz:28362
slow-parse.log-20140130.gz:15852
slow-parse.log-20140131.gz:13169
slow-parse.log-20140201.gz:24168
slow-parse.log-20140202.gz:9865
slow-parse.log-20140203.gz:19154
slow-parse.log-20140204.gz:24551
slow-parse.log-20140205.gz:11749
slow-parse.log-20140206.gz:11587
slow-parse.log-20140207.gz:13448
slow-parse.log-20140208.gz:12680
slow-parse.log-20140209.gz:27742
slow-parse.log-20140210.gz:14076
slow-parse.log-20140211.gz:18791
slow-parse.log-20140212.gz:27304
slow-parse.log-20140213.gz:12035
slow-parse.log-20140214.gz:26425
slow-parse.log-20140215.gz:11178
slow-parse.log-20140216.gz:8727
slow-parse.log-20140217.gz:19688
slow-parse.log-20140218.gz:13491
slow-parse.log-20140219.gz:8986
slow-parse.log-20140220.gz:27775
slow-parse.log-20140221.gz:12692
slow-parse.log-20140222.gz:33509
slow-parse.log-20140223.gz:16214
slow-parse.log-20140224.gz:21272
slow-parse.log-20140225.gz:11016
slow-parse.log-20140226.gz:8844
slow-parse.log-20140227.gz:6727
slow-parse.log-20140228.gz:15756
slow-parse.log-20140301.gz:13825
slow-parse.log-20140302.gz:7339
slow-parse.log-20140303.gz:24620
slow-parse.log-20140304.gz:12065
slow-parse.log-20140305.gz:13076
slow-parse.log-20140306.gz:6285
slow-parse.log-20140307.gz:6788
slow-parse.log-20140308.gz:7066
slow-parse.log-20140309.gz:10085
slow-parse.log-20140310.gz:31514
slow-parse.log-20140311.gz:11480
slow-parse.log-20140312.gz:13145
slow-parse.log-20140313.gz:34254
slow-parse.log-20140314.gz:42025
slow-parse.log-20140315.gz:14423
slow-parse.log-20140316.gz:11736
slow-parse.log-20140317.gz:24087
slow-parse.log-20140318.gz:9893
slow-parse.log-20140319.gz:7716
slow-parse.log-20140320.gz:8978
slow-parse.log-20140321.gz:15238
slow-parse.log-20140322.gz:7857
slow-parse.log-20140323.gz:11655
slow-parse.log-20140324.gz:18725
slow-parse.log-20140325.gz:8889
slow-parse.log-20140326.gz:13181
slow-parse.log-20140327.gz:24659
slow-parse.log-20140328.gz:16124
slow-parse.log-20140329.gz:23194
slow-parse.log-20140330.gz:25479
slow-parse.log-20140331.gz:21685
slow-parse.log-20140401.gz:13280
slow-parse.log-20140402.gz:6314
slow-parse.log-20140403.gz:6731
slow-parse.log-20140404.gz:10171
slow-parse.log-20140405.gz:7680
slow-parse.log-20140406.gz:6893
slow-parse.log-20140407.gz:6875
slow-parse.log-20140408.gz:8303
slow-parse.log-20140409.gz:19181
slow-parse.log-20140410.gz:19068
slow-parse.log-20140411.gz:15796
slow-parse.log-20140412.gz:9370
slow-parse.log-20140413.gz:10826
slow-parse.log-20140414.gz:19718
slow-parse.log-20140415.gz:9738
slow-parse.log-20140416.gz:8620
slow-parse.log-20140417.gz:9182
slow-parse.log-20140418.gz:10713
slow-parse.log-20140419.gz:8265
slow-parse.log-20140420.gz:10081
slow-parse.log-20140421.gz:18302
slow-parse.log-20140422.gz:20356
slow-parse.log-20140423.gz:19024
slow-parse.log-20140424.gz:14379
slow-parse.log-20140425.gz:9986
slow-parse.log-20140426.gz:10050
slow-parse.log-20140427.gz:14163
slow-parse.log-20140428.gz:12527
slow-parse.log-20140429.gz:13250
slow-parse.log-20140430.gz:13731
slow-parse.log-20140501.gz:21318
slow-parse.log-20140502.gz:26424
slow-parse.log-20140503.gz:37473
slow-parse.log-20140504.gz:15414
slow-parse.log-20140505.gz:11450
slow-parse.log-20140506.gz:18353
slow-parse.log-20140507.gz:11235
slow-parse.log-20140508.gz:9271
slow-parse.log-20140509.gz:8309
slow-parse.log-20140510.gz:24756
slow-parse.log-20140511.gz:14255
slow-parse.log-20140512.gz:14892
slow-parse.log-20140513.gz:10050
slow-parse.log-20140514.gz:14400
slow-parse.log-20140515.gz:26832
slow-parse.log-20140516.gz:15850
slow-parse.log-20140517.gz:12061
slow-parse.log-20140518.gz:11605
slow-parse.log-20140519.gz:25307
slow-parse.log-20140520.gz:20401
slow-parse.log-20140521.gz:11146
slow-parse.log-20140522.gz:10054
slow-parse.log-20140523.gz:10792
slow-parse.log-20140524.gz:13333
slow-parse.log-20140525.gz:13077
slow-parse.log-20140526.gz:18341
slow-parse.log-20140527.gz:15646
slow-parse.log-20140528.gz:13708
slow-parse.log-20140529.gz:14009
slow-parse.log-20140530.gz:15493
slow-parse.log-20140531.gz:36499
reedy@fluorine:/a/mw-log/archive$

Reedy (talk) 21:22, 31 May 2014 (UTC)

Abuse filter[edit]

Number of actions prevented[edit]

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(afl_timestamp, 1, 6) AS MONTH,
    ->   COUNT(afl_id) AS edits
    -> FROM abuse_filter_log
    -> WHERE afl_action = 'edit'
    -> AND afl_actions LIKE '%disallow%'
    -> GROUP BY MONTH;
+--------+-------+
| MONTH  | edits |
+--------+-------+
| 200908 |    67 |
| 200909 |    77 |
| 200910 |   124 |
| 200911 |   125 |
| 200912 |    88 |
| 201001 |   189 |
| 201002 |   137 |
| 201003 |   144 |
| 201004 |   206 |
| 201005 |   177 |
| 201006 |   177 |
| 201007 |   213 |
| 201008 |   479 |
| 201009 |   294 |
| 201010 |   183 |
| 201011 |   281 |
| 201012 |   197 |
| 201101 |   299 |
| 201102 |   290 |
| 201103 |   394 |
| 201104 |   271 |
| 201105 |   111 |
| 201106 |     8 |
| 201108 |     2 |
| 201109 |    36 |
| 201110 |    16 |
| 201111 |    22 |
| 201112 |     7 |
| 201201 |    10 |
| 201202 |     3 |
| 201203 |     5 |
| 201204 |    10 |
| 201205 |    14 |
| 201206 |     4 |
| 201207 |     3 |
| 201208 |   106 |
| 201209 |    15 |
| 201210 |    60 |
| 201211 |   128 |
| 201212 |   119 |
| 201301 |   106 |
| 201302 |   104 |
| 201303 |    83 |
| 201304 |    84 |
| 201305 |    91 |
| 201306 |   104 |
| 201307 |    97 |
| 201308 |    61 |
| 201309 |   218 |
| 201310 |   156 |
| 201311 |   214 |
| 201312 |   117 |
| 201401 |  1304 |
| 201402 |  1807 |
| 201403 |  1949 |
| 201404 |  1759 |
| 201405 |  1989 |
| 201406 |    42 |
+--------+-------+
58 rows in set (0.25 sec)

Number of edits hindered[edit]

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(afl_timestamp, 1, 6) AS MONTH,
    ->   COUNT(afl_id) AS edits
    -> FROM abuse_filter_log
    -> WHERE afl_action = 'edit'
    -> AND afl_actions RLIKE '.*(throttle|warn|disallow).*'
    -> GROUP BY MONTH;
+--------+-------+
| MONTH  | edits |
+--------+-------+
| 200908 |   712 |
| 200909 |  1429 |
| 200910 |  1858 |
| 200911 |  1719 |
| 200912 |  1352 |
| 201001 |  2187 |
| 201002 |  2227 |
| 201003 |  2238 |
| 201004 |  2526 |
| 201005 |  2458 |
| 201006 |  1690 |
| 201007 |  1369 |
| 201008 |  1683 |
| 201009 |  1684 |
| 201010 |  1856 |
| 201011 |  1989 |
| 201012 |  1649 |
| 201101 |  2273 |
| 201102 |  2357 |
| 201103 |  2589 |
| 201104 |  2089 |
| 201105 |  1943 |
| 201106 |  1648 |
| 201107 |  1263 |
| 201108 |  1191 |
| 201109 |  1707 |
| 201110 |  1726 |
| 201111 |  2083 |
| 201112 |  1670 |
| 201201 |  2205 |
| 201202 |  2157 |
| 201203 |  2038 |
| 201204 |  1886 |
| 201205 |  2198 |
| 201206 |  1604 |
| 201207 |  1370 |
| 201208 |  1591 |
| 201209 |  1551 |
| 201210 |  1885 |
| 201211 |  2114 |
| 201212 |  1865 |
| 201301 |  2254 |
| 201302 |  2049 |
| 201303 |  2299 |
| 201304 |  2151 |
| 201305 |  2516 |
| 201306 |  2094 |
| 201307 |  1534 |
| 201308 |  1517 |
| 201309 |  1293 |
| 201310 |  1313 |
| 201311 |  1630 |
| 201312 |  1368 |
| 201401 |  2922 |
| 201402 |  3135 |
| 201403 |  3380 |
| 201404 |  3179 |
| 201405 |  3277 |
| 201406 |    63 |
+--------+-------+
59 rows in set (0.71 sec)

Number of users hit[edit]

MariaDB [itwiki_p]> SELECT
    ->  MONTH,
    ->  USERS
    ->  FROM (SELECT
    ->    SUBSTR(afl_timestamp, 1, 6) AS MONTH,
    ->    COUNT(DISTINCT(afl_user_text)) AS USERS
    ->    FROM abuse_filter_log
    ->    WHERE afl_actions RLIKE '.*(throttle|warn|disallow|blockautopromote|block|degroup).*' /* everything but tag, flag */
    ->    GROUP BY MONTH
    ->    ORDER BY afl_id ASC)
    ->    AS logs;
+--------+-------+
| MONTH  | USERS |
+--------+-------+
| 200908 |   511 |
| 200909 |  1220 |
| 200910 |  1575 |
| 200911 |  1454 |
| 200912 |  1192 |
| 201001 |  1835 |
| 201002 |  1840 |
| 201003 |  1892 |
| 201004 |  1983 |
| 201005 |  2100 |
| 201006 |  1376 |
| 201007 |  1013 |
| 201008 |  1043 |
| 201009 |  1267 |
| 201010 |  1470 |
| 201011 |  1533 |
| 201012 |  1288 |
| 201101 |  1802 |
| 201102 |  1858 |
| 201103 |  2019 |
| 201104 |  1697 |
| 201105 |  1751 |
| 201106 |  1502 |
| 201107 |  1148 |
| 201108 |  1071 |
| 201109 |  1377 |
| 201110 |  1563 |
| 201111 |  1846 |
| 201112 |  1482 |
| 201201 |  1977 |
| 201202 |  1939 |
| 201203 |  1817 |
| 201204 |  1768 |
| 201205 |  2164 |
| 201206 |  1499 |
| 201207 |  1265 |
| 201208 |  1286 |
| 201209 |  1380 |
| 201210 |  1709 |
| 201211 |  1917 |
| 201212 |  1676 |
| 201301 |  2076 |
| 201302 |  1731 |
| 201303 |  1974 |
| 201304 |  1841 |
| 201305 |  2204 |
| 201306 |  1679 |
| 201307 |  1262 |
| 201308 |  1008 |
| 201309 |  1095 |
| 201310 |  1159 |
| 201311 |  1296 |
| 201312 |  1209 |
| 201401 |  1969 |
| 201402 |  1600 |
| 201403 |  1754 |
| 201404 |  1604 |
| 201405 |  1597 |
| 201406 |    32 |
+--------+-------+
59 rows in set (1.38 sec)

MediaWiki namespace edits[edit]

MariaDB [itwiki_p]> SELECT
    ->   rev_id,
    ->   rev_timestamp,
    ->   page_title,
    ->   rev_comment,
    ->   rev_len
    -> FROM
    ->   revision
    -> JOIN
    ->   page ON revision.rev_page = page.page_id
    -> WHERE page.page_namespace = 8
    -> AND page.page_title RLIKE '.+(css|js)$'
    -> AND NOT page.page_title LIKE 'Gadget-tb-%'
    -> AND rev_timestamp > 20130601000000
    -> ORDER BY rev_id DESC
    -> LIMIT 250;
+----------+----------------+--------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
| rev_id   | rev_timestamp  | page_title                                       | rev_comment                                                                                                                                                                                            | rev_len |
+----------+----------------+--------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
| 66261076 | 20140601160855 | Monobook.js                                      | mwCustomEditButtons è stato rimosso da mediawiki, vedi http://bugzilla.wikimedia.org/show_bug.cgi?id=50310                                                                                             |      94 |
| 65794941 | 20140506092405 | Gadget-UserEditCount.js                          | fix ripetizione link sulle proprie pagine utente                                                                                                                                                       |     871 |
| 65794304 | 20140506083651 | Gadget-nav-requisiti.js                          | Nuovo gadget                                                                                                                                                                                           |    3800 |
| 65505276 | 20140422182614 | Common.js                                        | Aggiorno gestione barra laterale di interprogetto - vedi discussione in Discussioni_MediaWiki:Common.js#Modifica_codice_per_l.27interprogetto                                                          |   31121 |
| 65505259 | 20140422182512 | Monobook.js                                      | Aggiorno gestione barra laterale di interprogetto - vedi discussione in Discussioni_MediaWiki:Common.js#Modifica_codice_per_l.27interprogetto                                                          |     475 |
| 65505238 | 20140422182324 | Vector.js                                        | Aggiorno gestione barra laterale di interprogetto - vedi discussione in Discussioni_MediaWiki:Common.js#Modifica_codice_per_l.27interprogetto                                                          |       0 |
| 65253240 | 20140409090750 | Gadget-CatWatch.js                               | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-CatWatch.js]] a [[MediaWiki:Gadget-CatWatch.js]] senza lasciare redirect                                                                   |    8137 |
| 65251985 | 20140409081721 | Gadget-CatWatch.js                               | fix encodeURIComponent in createWatchlistEl                                                                                                                                                            |    8137 |
| 65227522 | 20140408071129 | Gadget-nav-bot.js                                | per Rotpunkt: riscrittura del gadget                                                                                                                                                                   |     615 |
| 64945517 | 20140324095339 | Gadget-collegamentipersonali.js                  | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-collegamentipersonali.js]] a [[MediaWiki:Gadget-collegamentipersonali.js]] senza lasciare redirect                                         |    8064 |
| 64945513 | 20140324095330 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13803 |
| 64945220 | 20140324093426 | Gadget-collegamentipersonali.js                  | fix width table                                                                                                                                                                                        |    8064 |
| 64945200 | 20140324093326 | Gadget-pulsantipersonali.js                      | fix width table                                                                                                                                                                                        |   13803 |
| 64945079 | 20140324092434 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13704 |
| 64945077 | 20140324092431 | Gadget-collegamentipersonali.js                  | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-collegamentipersonali.js]] a [[MediaWiki:Gadget-collegamentipersonali.js]] senza lasciare redirect                                         |    8005 |
| 64944954 | 20140324091620 | Gadget-collegamentipersonali.js                  | aggiunta possibilità di riordinare gli elementi                                                                                                                                                        |    8005 |
| 64944924 | 20140324091410 | Gadget-pulsantipersonali.js                      | aggiunta possibilità di riordinare gli elementi                                                                                                                                                        |   13704 |
| 64895496 | 20140321143751 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   11661 |
| 64831362 | 20140319131901 | Common.css                                       | nascondo anche i link "modifica" delle sezioni dello "sportello". Vedi discussione.                                                                                                                    |   40999 |
| 64827324 | 20140319094048 | Gadget-Since.js                                  | fixata scadenza del cookie. Era a livello di sessione                                                                                                                                                  |     995 |
| 64827277 | 20140319093847 | Gadget-Since.js                                  |                                                                                                                                                                                                        |    1138 |
| 64730447 | 20140314044811 | Common.css                                       | come sugerito in disc                                                                                                                                                                                  |   40747 |
| 64607610 | 20140307151254 | Gadget-WikEd.js                                  | test                                                                                                                                                                                                   |     446 |
| 64569989 | 20140305082837 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   12403 |
| 64534117 | 20140303165510 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   12377 |
| 64528651 | 20140303112511 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   12333 |
| 64526682 | 20140303082402 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   12333 |
| 64526635 | 20140303081642 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   12434 |
| 64493335 | 20140301085804 | Gadget-LiveRC_1x.js                              | adding 'addSectionTitle' items                                                                                                                                                                         |   11598 |
| 64474379 | 20140227210605 | Gadget-LiveRCSiteConfig.js                       | [[WP:LRC|LiveRC]] : Aggiornamento configurazione Mediawiki locale                                                                                                                                      |   65401 |
| 64462204 | 20140227085111 | Gadget-LiveRCSiteConfig.js                       | [[WP:LRC|LiveRC]] : Aggiornamento configurazione Mediawiki locale                                                                                                                                      |   65340 |
| 64449919 | 20140226135255 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   10798 |
| 64449885 | 20140226135036 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   10902 |
| 64449862 | 20140226134854 | Gadget-LiveRC_1x.js                              |                                                                                                                                                                                                        |   10899 |
| 64449517 | 20140226132709 | Gadget-LiveRC_1x.js                              | [[WP:OA|←]]Nuova pagina: // Script di LiveRC // Vedi [[Wikipedia:Monobook.js/LiveRC/Documentazione]] jQuery(document).ready(function($){     mw.util.addPortletLink('p-tb', '//it.wikipedia.org/w...   |   10833 |
| 64449507 | 20140226132623 | Gadget-LiveRC.js                                 | Annullate le modifiche di [[Special:Contributions/Jalo|Jalo]] ([[User talk:Jalo|discussione]]), riportata alla versione precedente di [[User:.anaconda|.anaconda]]                                     |     314 |
| 64449498 | 20140226132605 | Gadget-LiveRC.js                                 |                                                                                                                                                                                                        |   10833 |
| 64266619 | 20140218082308 | Gadget-LiveRCSiteConfig.js                       | [[WP:LRC|LiveRC]] : Mise à jour de la configuration Mediawiki locale                                                                                                                                   |   65348 |
| 63872724 | 20140131110349 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13078 |
| 63872192 | 20140131102333 | Gadget-pulsantipersonali.js                      | fix newline in expr                                                                                                                                                                                    |   13078 |
| 63504548 | 20140112155343 | Gadget-UserEditCount.js                          | sostituisco toolserver con Labs                                                                                                                                                                        |     827 |
| 63480218 | 20140110213219 | Common.js                                        | per [[Discussioni_template:Coord#Mappe_extraterrestri]]                                                                                                                                                |   30925 |
| 63340068 | 20140102135753 | Gadget-Base.js                                   | Obsoleto, non più usato                                                                                                                                                                                |       0 |
| 63340064 | 20140102135735 | Gadget-Base.css                                  | Obsoleto, non più usato                                                                                                                                                                                |       0 |
| 63340024 | 20140102135515 | Gadget-strumentivari.js                          | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-strumentivari.js]] a [[MediaWiki:Gadget-strumentivari.js]] senza lasciare redirect                                                         |    6627 |
| 63339375 | 20140102131907 | Gadget-strumentivari.js                          | Nuovo gadget                                                                                                                                                                                           |    6627 |
| 63298168 | 20131230153014 | Gadget-VFonLine.js                               | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-VFonLine.js]] a [[MediaWiki:Gadget-VFonLine.js]] senza lasciare redirect                                                                   |    7340 |
| 63289302 | 20131229232449 | Gadget-VFonLine.js                               | nome parametro                                                                                                                                                                                         |    7340 |
| 63278026 | 20131229113634 | Gadget-VFonLine.js                               | Nuovo gadget                                                                                                                                                                                           |    7334 |
| 63171277 | 20131222180230 | Gadget-CompletaTemplate.js                       | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-CompletaTemplate.js]] a [[MediaWiki:Gadget-CompletaTemplate.js]] senza lasciare redirect                                                   |    2936 |
| 63164301 | 20131222103249 | Gadget-CompletaTemplate.js                       | +tabDefault                                                                                                                                                                                            |    2936 |
| 63158631 | 20131221211935 | Gadget-CompletaTemplate.js                       | spazi                                                                                                                                                                                                  |    2833 |
| 63158605 | 20131221211812 | Gadget-CompletaTemplate.js                       | +compatibilità con Firefox, Chrome, IE8, Safari                                                                                                                                                        |    2837 |
| 63146010 | 20131221095438 | Gadget-CompletaTemplate.js                       | +wpUploadDescription                                                                                                                                                                                   |    2540 |
| 63144058 | 20131221004610 | Gadget-CompletaTemplate.js                       | spazi                                                                                                                                                                                                  |    2523 |
| 63143618 | 20131220232736 | Gadget-CompletaTemplate.js                       | apici                                                                                                                                                                                                  |    2521 |
| 63143070 | 20131220223712 | Gadget-CompletaTemplate.js                       | fix regex                                                                                                                                                                                              |    2521 |
| 63142856 | 20131220222402 | Gadget-CompletaTemplate.js                       | Nuovo gadget                                                                                                                                                                                           |    2530 |
| 63131749 | 20131220081528 | Gadget-collegamentipersonali.js                  | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-collegamentipersonali.js]] a [[MediaWiki:Gadget-collegamentipersonali.js]] senza lasciare redirect                                         |    7546 |
| 63131748 | 20131220081519 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13074 |
| 63130344 | 20131220000948 | Gadget-collegamentipersonali.js                  | -global myLinks                                                                                                                                                                                        |    7546 |
| 63130330 | 20131220000822 | Gadget-pulsantipersonali.js                      | -global myButtons                                                                                                                                                                                      |   13074 |
| 63130241 | 20131219235424 | Gadget-collegamentipersonali.js                  | fix controllo myLinks                                                                                                                                                                                  |    7555 |
| 63130227 | 20131219235253 | Gadget-pulsantipersonali.js                      | fix controllo myButtons                                                                                                                                                                                |   13085 |
| 63123858 | 20131219162012 | Gadget-collegamentipersonali.js                  | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-collegamentipersonali.js]] a [[MediaWiki:Gadget-collegamentipersonali.js]] senza lasciare redirect                                         |    7548 |
| 63123833 | 20131219161852 | Gadget-DeleteSection.js                          | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-DeleteSection.js]] a [[MediaWiki:Gadget-DeleteSection.js]] senza lasciare redirect                                                         |    2368 |
| 63123832 | 20131219161850 | Gadget-QuickDelete.js                            | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-QuickDelete.js]] a [[MediaWiki:Gadget-QuickDelete.js]] senza lasciare redirect                                                             |    4850 |
| 63123203 | 20131219154014 | Gadget-DeleteSection.js                          | fix confronti, jslint compliant                                                                                                                                                                        |    2368 |
| 63123123 | 20131219153409 | Gadget-QuickDelete.js                            | +mw.config.get, jslint compliant                                                                                                                                                                       |    4850 |
| 63117214 | 20131219083854 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13078 |
| 63113763 | 20131218224110 | Gadget-collegamentipersonali.js                  | commento                                                                                                                                                                                               |    7548 |
| 63113591 | 20131218222855 | Gadget-collegamentipersonali.js                  | aggiornata updatePortletLinks                                                                                                                                                                          |    7544 |
| 63113512 | 20131218222400 | Gadget-collegamentipersonali.js                  | Nuovo gadget                                                                                                                                                                                           |    7543 |
| 63110325 | 20131218193016 | Gadget-pulsantipersonali.js                      | +jQuery.each                                                                                                                                                                                           |   13078 |
| 63109381 | 20131218183324 | Gadget-pulsantipersonali.js                      | fix regex                                                                                                                                                                                              |   13095 |
| 63105354 | 20131218151134 | Gadget-CatWatch.js                               | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-CatWatch.js]] a [[MediaWiki:Gadget-CatWatch.js]] senza lasciare redirect                                                                   |    8096 |
| 63105135 | 20131218145941 | Gadget-CatWatch.js                               | jslint compliant                                                                                                                                                                                       |    8096 |
| 63099300 | 20131218095921 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   13094 |
| 63099062 | 20131218094025 | Gadget-pulsantipersonali.js                      | fix replace newline                                                                                                                                                                                    |   13094 |
| 63088560 | 20131217180755 | Gadget-pulsantipersonali.js                      | +modo di inserimento, jslint compliant                                                                                                                                                                 |   13178 |
| 63058714 | 20131215194134 | Common.js                                        | Modifiche richieste in [[wp:RA|RA]] per fix problema con le voci di qualità negli interlink                                                                                                            |   30775 |
| 63039709 | 20131214165433 | Gadget-CatWatch.js                               | correzioni da parte di Rotpunkt                                                                                                                                                                        |    7784 |
| 63039555 | 20131214164557 | Gadget-CatWatch.js                               | refuso                                                                                                                                                                                                 |    7784 |
| 63039472 | 20131214164025 | Gadget-CatWatch.js                               | +ultime modifiche raggruppate, bugfix                                                                                                                                                                  |    7794 |
| 62968289 | 20131209223546 | Gadget-CatWatch.js                               | correzioni da parte di Rotpunkt                                                                                                                                                                        |    7129 |
| 62968093 | 20131209222418 | Gadget-CatWatch.js                               | Nuovo gadget                                                                                                                                                                                           |    7129 |
| 62955957 | 20131209092111 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    7105 |
| 62955948 | 20131209092027 | Gadget-CatWatch.js/CategorieOsservateTemplate.js | Jalo ha spostato la pagina [[Utente:Jalo/CategorieOsservateTemplate.js]] a [[MediaWiki:Gadget-CatWatch.js/CategorieOsservateTemplate.js]] senza lasciare redirect                                      |     619 |
| 62955937 | 20131209091909 | Gadget-CatWatch.js                               | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-CatWatch.js]] a [[MediaWiki:Gadget-CatWatch.js]] senza lasciare redirect                                                                   |    7119 |
| 62955841 | 20131209090635 | Gadget-pulsantipersonali.js                      | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-pulsantipersonali.js]] a [[MediaWiki:Gadget-pulsantipersonali.js]] senza lasciare redirect                                                 |   10457 |
| 62950949 | 20131208201522 | Gadget-contribsrange.js                          |                                                                                                                                                                                                        |   11361 |
| 62949763 | 20131208190538 | Gadget-CatWatch.js                               | nomi variabile                                                                                                                                                                                         |    7119 |
| 62949750 | 20131208190445 | Gadget-CatWatch.js                               | nomi variabile                                                                                                                                                                                         |    7115 |
| 62949480 | 20131208184313 | Gadget-CatWatch.js                               | punto e virgola                                                                                                                                                                                        |    7107 |
| 62948924 | 20131208182234 | Gadget-CatWatch.js                               | +dataType json                                                                                                                                                                                         |    7105 |
| 62948849 | 20131208182029 | Gadget-CatWatch.js                               | +callback fail                                                                                                                                                                                         |    7076 |
| 62948783 | 20131208181537 | Gadget-pulsantipersonali.js                      | +dataType                                                                                                                                                                                              |   10457 |
| 62948563 | 20131208180033 | Gadget-contribsrange.js                          | funzioni deprecate                                                                                                                                                                                     |   11361 |
| 62948297 | 20131208174157 | Gadget-CatWatch.js                               | +dataType                                                                                                                                                                                              |    6894 |
| 62946930 | 20131208155313 | Gadget-CatWatch.js                               | Annullata la modifica 62946923 di [[Special:Contributions/Rotpunkt|Rotpunkt]] ([[User talk:Rotpunkt|discussione]])                                                                                     |    6862 |
| 62946923 | 20131208155257 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    7105 |
| 62943382 | 20131208120553 | Gadget-pulsantipersonali.js                      | apici                                                                                                                                                                                                  |   10425 |
| 62941158 | 20131208085217 | Gadget-pulsantipersonali.js                      | Nuovo gadget                                                                                                                                                                                           |   10425 |
| 62916601 | 20131206153856 | Common.css                                       |                                                                                                                                                                                                        |   40579 |
| 62916260 | 20131206152312 | Common.css                                       |                                                                                                                                                                                                        |   40624 |
| 62916177 | 20131206151909 | Common.css                                       |                                                                                                                                                                                                        |   40618 |
| 62914821 | 20131206143600 | Common.css                                       |                                                                                                                                                                                                        |   40570 |
| 62914339 | 20131206142329 | Common.css                                       | prova sinottico_immagine                                                                                                                                                                               |   40550 |
| 62908490 | 20131206094944 | Common.js                                        |                                                                                                                                                                                                        |   30716 |
| 62907234 | 20131206083846 | Common.js                                        | https://it.wikipedia.org/w/index.php?title=Discussioni_MediaWiki:Common.js&oldid=62903367#Link_.27modifica.27_delle_sezioni                                                                            |   30534 |
| 62890620 | 20131205091756 | Gadget-QuickDelete.js                            |                                                                                                                                                                                                        |    4352 |
| 62890577 | 20131205091329 | Gadget-QuickDelete.js                            | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-QuickDelete.js]] a [[MediaWiki:Gadget-QuickDelete.js]] senza lasciare redirect                                                             |    4353 |
| 62819148 | 20131202133957 | Gadget-DeleteSection.js                          | Jalo ha spostato la pagina [[Utente:Rotpunkt/Gadgets/Gadget-DeleteSection.js]] a [[MediaWiki:Gadget-DeleteSection.js]] senza lasciare redirect: nuovo gadget                                           |    2221 |
| 62809960 | 20131202085456 | Common.js                                        | Rollback da popup. Ripristinata la versione di Jalo                                                                                                                                                    |   32034 |
| 62780450 | 20131201115436 | Gadget-DeleteSection.js                          | +commento                                                                                                                                                                                              |    2221 |
| 62779215 | 20131201111956 | Gadget-DeleteSection.js                          | fix split                                                                                                                                                                                              |    2213 |
| 62778888 | 20131201110915 | Gadget-DeleteSection.js                          | Nuovo gadget                                                                                                                                                                                           |    2201 |
| 62776432 | 20131201094518 | Gadget-CatWatch.js                               | fix mese                                                                                                                                                                                               |    6862 |
| 62773988 | 20131201004119 | Gadget-CatWatch.js                               | spazi                                                                                                                                                                                                  |    6862 |
| 62773971 | 20131201003816 | Gadget-CatWatch.js                               | spazi                                                                                                                                                                                                  |    6730 |
| 62773961 | 20131201003616 | Gadget-CatWatch.js                               | fix watchlistAdd                                                                                                                                                                                       |    6829 |
| 62773650 | 20131201000446 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    6778 |
| 62773443 | 20131130235721 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    6828 |
| 62773374 | 20131130235438 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    6863 |
| 62773341 | 20131130235329 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    6869 |
| 62773311 | 20131130235217 | Gadget-CatWatch.js                               |                                                                                                                                                                                                        |    6867 |
| 62773074 | 20131130234427 | Gadget-CatWatch.js                               | +span                                                                                                                                                                                                  |    6823 |
| 62773012 | 20131130234244 | Gadget-CatWatch.js                               | test                                                                                                                                                                                                   |    6778 |
| 62757430 | 20131130122027 | Gadget-CatWatch.js                               | commento                                                                                                                                                                                               |    6776 |
| 62757325 | 20131130121602 | Gadget-CatWatch.js                               | Nuovo gadget                                                                                                                                                                                           |    6744 |
| 62742657 | 20131129130850 | Gadget-nav-invert.js                             | [[WP:OA|←]]Nuova pagina: $(function() {     mw.util.addPortletLink('p-navigation', '/wiki/Categoria:Inversioni di redirect richieste', 'Inversioni di redirect', ''); });                              |     144 |
| 62741617 | 20131129115715 | Gadget-nav-lastnewbies.js                        | [[WP:OA|←]]Nuova pagina: $(function() {     mw.util.addPortletLink('p-navigation', '/wiki/Speciale:Contributi/newbies', 'Contributi nuovi utenti', ''); });                                            |     130 |
| 62740787 | 20131129110635 | Gadget-RivelatoreDisambigua.js                   |                                                                                                                                                                                                        |    7312 |
| 62740758 | 20131129110500 | Gadget-RivelatoreDisambigua.js                   | update                                                                                                                                                                                                 |    7347 |
| 62722416 | 20131128123957 | Gadget-QuickDelete.js                            | Riscritto e ottimizzato da Rotpunkt                                                                                                                                                                    |    4352 |
| 62721956 | 20131128120515 | Gadget-QuickDelete.js                            | spazi                                                                                                                                                                                                  |    4353 |
| 62721930 | 20131128120250 | Gadget-QuickDelete.js                            |                                                                                                                                                                                                        |    4351 |
| 62721916 | 20131128120123 | Gadget-QuickDelete.js                            | refuso                                                                                                                                                                                                 |    4349 |
| 62721891 | 20131128120039 | Gadget-QuickDelete.js                            | migliore selector                                                                                                                                                                                      |    4418 |
| 62721098 | 20131128110130 | Gadget-QuickDelete.js                            |                                                                                                                                                                                                        |    4310 |
| 62720884 | 20131128104905 | Gadget-QuickDelete.js                            | Nuovo gadget                                                                                                                                                                                           |    4310 |
| 62691379 | 20131126175755 | Common.js                                        | non funziona                                                                                                                                                                                           |   31899 |
| 62691249 | 20131126175052 | Common.js                                        | https://it.wikipedia.org/w/index.php?title=Discussioni_MediaWiki:Common.js&oldid=62689729#Ricerca_in_Wikidata                                                                                          |   32034 |
| 62544787 | 20131118221643 | Common.js                                        |                                                                                                                                                                                                        |   31899 |
| 62381078 | 20131109151119 | Gadget-RivelatoreDisambigua.js                   |                                                                                                                                                                                                        |    7312 |
| 62381025 | 20131109150920 | Gadget-RivelatoreDisambigua.js                   | modificato come da richiesta in [[WP:RA]]                                                                                                                                                              |    7310 |
| 62345719 | 20131107125146 | Gadget-stru-whois.js                             | ita                                                                                                                                                                                                    |     266 |
| 62029289 | 20131018225813 | Gadget-stru-whois.js                             |                                                                                                                                                                                                        |     267 |
| 61656981 | 20130925133029 | Common.js                                        |                                                                                                                                                                                                        |   31762 |
| 61471365 | 20130912191218 | Gadget-contribsrange.js                          | ritraduco                                                                                                                                                                                              |   11356 |
| 61471191 | 20130912190428 | Gadget-contribsrange.js                          | import dalla versione attuale su en.wiki                                                                                                                                                               |   11249 |
| 60626444 | 20130806135804 | Common.css                                       | vedi [[Discussioni_aiuto:Libri#Richiamo_versione_stampa_dei_parametri]]                                                                                                                                |   40385 |
| 60364449 | 20130725063701 | Vector.js                                        |                                                                                                                                                                                                        |    2854 |
| 60039317 | 20130711064443 | Gadget-lockUpperBars.css                         |                                                                                                                                                                                                        |     223 |
| 59798452 | 20130701094324 | Gadget-EDTitle.js                                | re-fix                                                                                                                                                                                                 |    2951 |
| 59723569 | 20130628062804 | Gadget-EDTitle.js                                | Rollback da popup. Ripristinata la versione di Jalo                                                                                                                                                    |    2086 |
| 59514080 | 20130617222359 | Gadget-MultiDiffConsecutive.js                   |                                                                                                                                                                                                        |    3638 |
| 59513976 | 20130617221548 | Gadget-MultiDiffConsecutive.js                   |                                                                                                                                                                                                        |    3574 |
| 59513973 | 20130617221519 | Gadget-MultiDiffConsecutive.js                   |                                                                                                                                                                                                        |    3281 |
| 59513941 | 20130617221221 | Gadget-MultiDiffConsecutive.js                   | credits: [[m:user:hoo man]]                                                                                                                                                                            |    2513 |
| 59497592 | 20130617064936 | Gadget-EDTitle.js                                | [[Wikipedia:Malfunzionamenti#Accessorio_.22Titolo_editabile.22]]                                                                                                                                       |    2435 |
| 59371700 | 20130611061744 | Common.js                                        |                                                                                                                                                                                                        |   31755 |
+----------+----------------+--------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+
162 rows in set (0.01 sec)

VisualEditor[edit]

So, just throwing ideas in case we'll have future research on VE - it'd be interesting to compare Nemo's findings, once we all agree on what he found!, to wikis which had a different VE "setup" (switched tabs - renamed tabs - VE not available to IPs and so on); however this should be aimed at quite a longer term - it's a beta product, but it's already way better than how it was last year. --Elitre (talk) 20:19, 12 June 2014 (UTC)

Number of edits[edit]

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rev_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rev_id) AS edits
    -> FROM revision
    -> JOIN change_tag ON ct_rev_id = rev_id
    -> WHERE ct_tag LIKE '%visualeditor%'
    -> GROUP BY MONTH;
+--------+-------+
| MONTH  | edits |
+--------+-------+
| 201304 |    26 |
| 201305 |    40 |
| 201306 |   383 |
| 201307 |  8522 |
| 201308 | 37328 |
| 201309 | 35233 |
| 201310 | 35138 |
| 201311 | 36006 |
| 201312 | 36825 |
| 201401 | 44299 |
| 201402 | 38852 |
| 201403 | 38968 |
| 201404 | 39061 |
| 201405 | 40959 |
| 201406 |  1237 |
+--------+-------+
15 rows in set (3.90 sec)

Of which, not by newbies[edit]

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rev_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rev_id) AS edits
    -> FROM revision
    -> JOIN change_tag ON ct_rev_id = rev_id
    -> JOIN user ON rev_user = user_id
    -> WHERE ct_tag LIKE '%visualeditor%'
    -> AND user_editcount > 1000
    -> GROUP BY MONTH;
+--------+-------+
| MONTH  | edits |
+--------+-------+
| 201304 |    25 |
| 201305 |    38 |
| 201306 |   359 |
| 201307 |  4680 |
| 201308 |  6018 |
| 201309 |  3752 |
| 201310 |  3249 |
| 201311 |  2668 |
| 201312 |  3142 |
| 201401 |  3002 |
| 201402 |  2502 |
| 201403 |  2303 |
| 201404 |  1970 |
| 201405 |  2327 |
| 201406 |    62 |
+--------+-------+
15 rows in set (3.54 sec)

Edit size[edit]

Edit count is not everything: diff size is interesting as well: maybe VisualEditor brings less edits, but with more content? Note, biggest diffs (positive or negative) are usually noise: blankings and their reverts, text moves between pages; negative diff noise is mostly on newbie accounts and – even worse – unregistered users, positive diff noise (reverts) on power-accounts.

Newbie edits with visualeditor (1) have bigger diffs on average, more than their similars not using VE (2) and than non-newbies using VE (3) as well as unregistered users using VE (which are the bulk of VE users) (4) or unregistered users in general (5). The following monthly data is partial because RC spans 30 days only.

Comparison:

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
    -> WHERE ct_tag = 'visualeditor'
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 | 41830 |  676472635 |  679168196 |      64.4409 |
| 201406 | 18760 |  353033045 |  354453326 |      75.7079 |
+--------+-------+------------+------------+--------------+
2 rows in set (4.05 sec)

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc/*
   /*> JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
   /*> WHERE ct_tag = 'visualeditor'*/
    -> GROUP BY MONTH;
+--------+--------+------------+------------+--------------+
| MONTH  | edits  | rc_old_len | rc_new_len | diff_len_avg |
+--------+--------+------------+------------+--------------+
| 201405 | 901584 | 8801584108 | 8860669185 |      65.5347 |
| 201406 | 330270 | 4500153529 | 4537237708 |     112.2844 |
+--------+--------+------------+------------+--------------+
2 rows in set (2.16 sec)

1:


MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
    -> JOIN user ON rc_user = user_id
    -> WHERE ct_tag = 'visualeditor'
    -> AND user_editcount < 1000
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 |  6447 |  122724843 |  124021354 |     201.1030 |
| 201406 |  3572 |   64003234 |   64584339 |     162.6834 |
+--------+-------+------------+------------+--------------+
2 rows in set (3.73 sec)

2:

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> LEFT OUTER JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
    -> JOIN user ON rc_user = user_id
    -> WHERE ct_tag <> 'visualeditor'
    -> AND user_editcount < 1000
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 |  2906 |   69503940 |   70007197 |     173.1786 |
| 201406 |  1810 |   45445798 |   45740371 |     162.7475 |
+--------+-------+------------+------------+--------------+
2 rows in set (2.29 sec)

3:

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
    -> JOIN user ON rc_user = user_id
    -> WHERE ct_tag = 'visualeditor'
    -> AND user_editcount > 1000
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 |  1492 |   25498928 |   25622772 |      83.0054 |
| 201406 |   764 |   13881426 |   13945918 |      84.4136 |
+--------+-------+------------+------------+--------------+
2 rows in set (3.50 sec)

4:

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> JOIN change_tag ON ct_rev_id = rc.rc_this_oldid
    -> WHERE ct_tag = 'visualeditor'
    -> AND rc_user = 0
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 | 33747 |  526872198 |  528147412 |      37.7875 |
| 201406 | 14428 |  275380834 |  276155908 |      53.7201 |
+--------+-------+------------+------------+--------------+
2 rows in set (3.49 sec)

5:

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rc_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rc_id) AS edits,
    ->   SUM(rc_old_len) AS rc_old_len,
    ->   SUM(rc_new_len) AS rc_new_len,
    ->   (SUM(rc_new_len) - SUM(rc_old_len)) / COUNT(rc_id) AS diff_len_avg
    -> FROM recentchanges rc
    -> WHERE rc_user = 0
    -> AND rc_type < 5 /* exclude Wikidata */
    -> GROUP BY MONTH;
+--------+-------+------------+------------+--------------+
| MONTH  | edits | rc_old_len | rc_new_len | diff_len_avg |
+--------+-------+------------+------------+--------------+
| 201405 | 63426 | 1481513485 | 1488832036 |     115.3872 |
| 201406 | 38935 |  913983229 |  918527516 |     116.7147 |
+--------+-------+------------+------------+--------------+
2 rows in set (0.99 sec)

With stray nowiki[edit]

MariaDB [itwiki_p]> SELECT
    ->   SUBSTR(rev_timestamp, 1, 6) AS MONTH,
    ->   COUNT(rev_id) AS edits
    -> FROM change_tag as a
    -> JOIN change_tag as b ON a.ct_rev_id = b.ct_rev_id
    -> JOIN revision ON rev_id = a.ct_rev_id
    -> WHERE a.ct_tag = 'nowiki'
    -> AND b.ct_tag = 'visualeditor'
    -> GROUP BY MONTH;
+--------+-------+
| MONTH  | edits |
+--------+-------+
| 201307 |   319 |
| 201308 |   976 |
| 201309 |   494 |
| 201310 |   564 |
| 201311 |   409 |
| 201312 |   406 |
| 201401 |   469 |
| 201402 |   432 |
| 201403 |   405 |
| 201404 |   410 |
| 201405 |   503 |
| 201406 |    15 |
+--------+-------+
12 rows in set (0.12 sec)

(On fr.wiki it's twice as many.)

Readers should be aware that the filter linked in the title incorrectly attributes all the nowiki tags to VE edits. --Elitre (talk) 16:54, 12 June 2014 (UTC)
On the other hand, when nowiki tags get added they obviously add up bytes as well, so I think I don't have a way to tell if editors really add more real content or not with VE right now. Which wouldn't be a surprise at all anyway, because in the end it allows editors to focus more on content and enjoy their writing. --Elitre (talk) 17:03, 12 June 2014 (UTC)
Sure, I believe the page summarises the numbers on nowikis as inconclusive and irrelevant as regards the matter of the research. --Nemo 13:31, 14 June 2014 (UTC)
An unwanted pair of nowiki tags is going to add 17 extra characters. Most people using VisualEditor don't trigger them, and most true newbies (in particular) don't (because they don't know any wikitext markup, so they miss an entire class of opportunities for triggering it). Most edits had only one pair of nowiki tags or occasionally two. Nowiki tags are running about 5% of en.wp edits with VisualEditor when I checked last week, and most of the nowiki tags being added were being added in VisualEditor. (However, there was also a new bug triggering some of these, so I don't know if the rate is always quite that high at en.wp.)
So if you take the typical increase (17 characters, sometimes 34) and the current rate at en.wp (5% of all edits in VisualEditor), and assume that it.wp is similar, then nowiki tags would add an average of 1 extra byte per edit. Whatamidoing (WMF) (talk) 19:00, 17 June 2014 (UTC)
I think I recall nowikis being more frequent for languages like Italian at least in the past, probably because of bugs with apostrophes and accented/other weird letters which we use a lot, nonetheless you're probably right that they wouldn't add so much noise. Thanks for your message. --Elitre (talk) 06:36, 20 June 2014 (UTC)

Activity of VE-(un)touched articles[edit]

Not really significant[1] [2]: just posting queries here.

SELECT
  SUBSTR(rev_timestamp, 1, 6) AS MONTH,
  COUNT(rev_id) AS edits
FROM revision r
INNER JOIN (
  SELECT DISTINCT(rev_page)
  FROM revision
  JOIN change_tag ON rev_id = ct_rev_id
  JOIN page ON rev_page = page_id
  WHERE ct_tag = 'visualeditor'
  AND page_namespace = 0
) as VE ON r.rev_page = VE.rev_page
GROUP BY MONTH;

vs.

SELECT
  SUBSTR(rev_timestamp, 1, 6) AS MONTH,
  COUNT(rev_id) AS edits
FROM revision
JOIN page ON rev_page = page_id
WHERE page_namespace = 0
GROUP BY MONTH;

Breakdown of monthly active editors & rates[edit]

My work today will involve breaking down the active editors in itwiki into sub-groups and looking at their activation/survival rates over time.

First, some ASCII art/math:

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MAE =       MNAE                +                              MSNAE              +                         MOAE              +        MRAE
             |                                                   |                                           |                           |    
(new_editors * activation_rate) + (last_month_new_active_editors * survival_rate) + (last_old_active_editors * survival_rate) + (re-activated_editors)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Active editor
A registered editors that saves 5+ edits in a calendar month.
MAE
The total number of active editors in a month.
MNAE
Monthly new active editors – editors who are new (register this month) and is active in the current calendar month(m)
MSNAE
Monthly surviving new active editors – editors who were new active editors in the last calendar month(m-1) and active in the current calendar month(m)
MOAE
Monthly surviving old active editors -- editors who were active in the last month(m-1), but did not register in that month and continue to be active this month(m).
MRAE
Monthly re-activated editors (for lack of a better term) – editors who are active in the current month(m) but don’t fit into the other three categories.

Now the figures.

Sub-populations of total active editors in itwiki are plotted by month.
Monthly active editors (sub-groups). Sub-populations of total active editors in itwiki are plotted by month.
The activation and re-activation rates of sub-populations in itwiki are plotted by month.
Monthly active editor (rates). The activation and re-activation rates of sub-populations in itwiki are plotted by month.

#Monthly active editors (sub-groups) plots the total number of active editors split into the the four sub-groups defined above. Note the large proportion of editors who were not active in the preceding month (reactivated editors) and the small proportion of regularly active editors. For reference, these proportions match enwiki pretty well, see Research_talk:Modeling_monthly_active_editors/Work_log/2014-06-06.

#Monthly active editor (rates) plots the rates that newly registered users activate (5+ edits in their first month), the rate at which those new active users continue to be active in their second month of editing and the rate at which old active editors in the previous month continue to be active in the current month. Note that values are not plotted for new editor activation before Dec. 2005 since before that point, registration dates were not stored in the database.

Summary[edit]

It looks like the population that saw the biggest month-to-month decline are non-new reactivated users. Surprisingly new editor's activation and survival rates are holding relatively constant -- or at least remain in line with the linear decline that has been present since 2006.

Future work[edit]

I'd like to dig into the re-activated users group and split them up by the year that they registered to see if it's a particular cohort that represents the decline.

--EpochFail (talk) 19:16, 14 June 2014 (UTC)

Some quick follow-up. I split the active editor groups into different plots so that it is easier to visualize trends and used a en:Local_regression smoothing strategy to draw a dashed line over the major trend. Note how the only group sloping down is the reactivated editors.
Sub-populations of total active editors in itwiki are plotted by month with en:Local_regression smoothing overlaid.
Monthly active editors (split). Sub-populations of total active editors in itwiki are plotted by month with en:Local_regression smoothing overlaid.

--EpochFail (talk) 19:28, 14 June 2014 (UTC)

Thank you immensely, these work is fantastic. All in all the breakdown seems to confirm our worst fear: we lost editors from the pool of the (semi)regulars, right? Alexmar983 suspects this drop may be consistent in the 250+ edits/month pool as well, and dated March 2013. More questions arise...
  1. Why is the total of all groups max 2500 in the first graph? WikiStats' tops are over 3000.
  2. How comes the "surving new active" population is constant when the "new active survival" seems to drop from ~0.2 to ~0.15 in Q2/Q3 2013 (aligned to the drop in "new wikipedians")? And the drop is all in "reactivated" despite "old active survival" looking remarkably constant?
  3. How can we exclude a Wikidata effect, e.g. a noise of editors from other wikis who may have used to fix 5+ interwikis in a month every now and then and now don't? Will splitting by year help? Perhaps the easiest is recalculating all these graphs for the 100+ edits class.
But now it's getting too late. --Nemo 00:42, 15 June 2014 (UTC)

Mobile[edit]

About Research:The sudden decline of Italian Wikipedia#Causes: I wonder what effect today's switch from the desktop site to the mobile interface on all tablets will have. Whatamidoing (WMF) (talk) 18:50, 17 June 2014 (UTC)

Big in Japan Combating Systemic Bias Through Mobile Editing
The Wikimania presentation by user:Ironholds about mobile editing is quite interesting: Italy seems to have a lot of exclusively mobile editors... darker green, like India... --Atlasowa (talk) 15:36, 31 August 2014 (UTC)
Yes, but remember that this is proportionate to mobile editors, not to editors: that is, it's still quite a small number. I'm planning on regenerating a lot of that data with some friends at the Oxford Internet Institute to generate ratios as well as absolutes. Ironholds (talk) 16:00, 3 September 2014 (UTC)

For reference: It.m.wikipedia.org, WikimediaMobile: Anonymous editing and Italian Wikipedia --Atlasowa (talk) 18:36, 15 December 2014 (UTC)

Suggested parameter to look into[edit]

The retention rate of the "addicted" contributers could be an important parameter to study in order to understand this issue. In svwp the retention rate if 5% when an editor has made 38000 edits and 40% when below, enwp has a similar critical number but being higher around 80000 edits. If the retention rate is rising for these commited contributers you have a serious problem, like the roots being infected on a plant. If not the problem need not be that serious.Anders Wennersten (talk) 04:17, 16 May 2015 (UTC)

Do you mean "loss" rather than "retention"? Retention means that they survive/keep editing. Anyway, I trust your numbers, that's more or less the order of magnitude of the difference. For very active editors which went inactive, an outreach campaign is being designed by the community: Research:Formerly active editors survey. --Nemo 06:44, 16 May 2015 (UTC)