[00:50:49] <wikibugs>	 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] <guillom>	 Does anyone use Mariadb's median function?
[22:14:10] <halfak>	 I don't believe there is a median function in MariaDB  O.o
[22:14:13] <halfak>	 News to me if there is. 
[22:14:37] <guillom>	 I found https://mariadb.com/kb/en/library/median/
[22:14:59] <guillom>	 At the same time, I got this error: ERROR 1305 (42000): FUNCTION median does not exist
[22:15:52] <halfak>	 Ahh.  Maybe it's an older version of MariaDB
[22:16:05] <halfak>	 Also, it could be that it's disabled because it's intensely performance consuming. 
[22:17:31] <guillom>	 Yeah, I checked the version and it's fine. Trying to figure out how to see if it's disabled.
[22:18:13] <guillom>	 (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] <guillom>	 The cumulative distribution would also have been nice :/
[22:21:24] <guillom>	 Oh, well.
[22:31:34] <halfak>	 guillom, do you need the median for something that is skewed?
[22:31:42] <halfak>	 You might find a robust statistic in the geometric mean. 
[22:31:43] <halfak>	 :) 
[22:32:48] <guillom>	 halfak: yes, very skewed (donation amounts)
[22:33:39] <halfak>	 Ahh.  So not a perfect fit for a log-normal, but not bad.  
[22:34:00] <halfak>	 SELECT EXP(AVG(LOG(value))) AS geom_mean_value FROM ...
[22:34:43] * guillom tries.
[22:37:23] <guillom>	 ok, that works. Now I need to go figure out exactly what the geometric mean gives me :)