[11:08:14] <wikibugs>	 DBA, Patch-For-Review: Prepare mysql account and options for prometheus - https://phabricator.wikimedia.org/T128185#2421039 (jcrespo) p:Low>High
[12:47:36] <wikibugs>	 DBA: Test InnoDB compression - https://phabricator.wikimedia.org/T139055#2421237 (jcrespo) ``` MariaDB PRODUCTION s1 localhost enwiki > ALTER TABLE revision row_format=compressed key_block_size=8\G Stage: 1 of 1 'altering table'    100% of stage done Query OK, 0 rows affected (16 hours 22 min 24.83 sec) Reco...
[12:48:05] <jynus>	 but schema changes are easy! it only requires locking a table for 16 hours!
[12:56:39] <wikibugs>	 DBA: Test InnoDB compression - https://phabricator.wikimedia.org/T139055#2421240 (jcrespo) Before: ``` -rw-rw----  1 mysql mysql 267772755968 Jun 30 17:14 revision.ibd ``` After:  ``` -rw-rw---- 1 mysql mysql 110121451520 Jul  1 11:03 revision.ibd ```  With key_block=8, space used as been reduced to less tha...
[13:03:45] <wikibugs>	 DBA: Test InnoDB compression - https://phabricator.wikimedia.org/T139055#2421243 (jcrespo) By compressing 1 table we have reduced in >100GB the space used (and potentially, halved future iops, too):  https://grafana.wikimedia.org/dashboard/db/server-board?from=1467291716324&to=1467377876324&var-server=db1073...