[00:50:49] 10Quarry, 10Cloud-Services, 10Community-Wikimetrics, 10DBA, and 2 others: Evaluate future of wmf puppet module "mysql" - https://phabricator.wikimedia.org/T165625#4071489 (10Dzahn) stopped using on in mediawiki_deployment_server role: https://gerrit.wikimedia.org/r/#/c/421197/
[22:08:24] Does anyone use Mariadb's median function?
[22:14:10] I don't believe there is a median function in MariaDB O.o
[22:14:13] News to me if there is.
[22:14:37] I found https://mariadb.com/kb/en/library/median/
[22:14:59] At the same time, I got this error: ERROR 1305 (42000): FUNCTION median does not exist
[22:15:52] Ahh. Maybe it's an older version of MariaDB
[22:16:05] Also, it could be that it's disabled because it's intensely performance consuming.
[22:17:31] Yeah, I checked the version and it's fine. Trying to figure out how to see if it's disabled.
[22:18:13] (I would really like to be able to get those medians. The means aren't as useful. I got the mode, though.)
[22:21:04] The cumulative distribution would also have been nice :/
[22:21:24] Oh, well.
[22:31:34] guillom, do you need the median for something that is skewed?
[22:31:42] You might find a robust statistic in the geometric mean.
[22:31:43] :)
[22:32:48] halfak: yes, very skewed (donation amounts)
[22:33:39] Ahh. So not a perfect fit for a log-normal, but not bad.
[22:34:00] SELECT EXP(AVG(LOG(value))) AS geom_mean_value FROM ...
[22:34:43] * guillom tries.
[22:37:23] ok, that works. Now I need to go figure out exactly what the geometric mean gives me :)