Page MenuHomePhabricator
Paste P7867

Number of MediaWiki action API requests that use MobileFrontend's parse module extension
ActivePublic

Authored by phuedx on Nov 29 2018, 11:08 AM.
+------------+---------+-------------+
| n | n_mfmt | n_mfmt_pct |
+------------+---------+-------------+
| 656646289 | 619970 | 0.0944 |
+------------+---------+-------------+
select
sum(1) as n,
# Testing for %mobileformat% catches
#
# ?action=parse...&mobileformat&...
# ?action=parse...&mobileformat=...&...
#
# The presence of the mobileformat parameter implies the presence of action=parse.
sum(if(uri_query like '%mobileformat%', 1, 0)) as n_mfmt,
round(100 * sum(if(uri_query like '%mobileformat%', 1, 0)) / sum(1), 4) as n_mfmt_pct
from
wmf.webrequest
where
year = 2018
and month = 11
and day = 28
and uri_path = '/w/api.php'
;

Event Timeline

phuedx changed the title of this paste from The number of "Action API" requests that use MobileFrontend's parse API extensions to The number of MediaWiki action API requests that use MobileFrontend's parse API extension.Nov 30 2018, 11:56 AM
phuedx changed the title of this paste from The number of MediaWiki action API requests that use MobileFrontend's parse API extension to Number of MediaWiki action API requests that use MobileFrontend's parse module extension.Nov 30 2018, 1:33 PM
phuedx edited the content of this paste. (Show Details)