Page MenuHomePhabricator
Create Task
Maniphest T110504

defragment db1015, db1035 and db1027
Closed, ResolvedPublic
Actions

Description

db1015, db1035 and db1027 hit the alert of 10% available space. Defragment by doing a logical dump and restore or changing the innodb_file_per_table option.

This will not work forever, only delay the inevitable and T106847 is the permanent solution.

Related Objects

Event Timeline

jcrespo created this task.Aug 27 2015, 10:18 AM
jcrespo claimed this task.
jcrespo raised the priority of this task from to Medium.
jcrespo updated the task description. (Show Details)
jcrespo added projects: DBA, acl*sre-team.
jcrespo subscribed.
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptAug 27 2015, 10:18 AM
jcrespo moved this task from Triage to Backlog on the DBA board.Aug 27 2015, 1:40 PM
jcrespo renamed this task from defragment db1015 to defragment db1015 and db1035.Sep 8 2015, 10:41 AM
jcrespo updated the task description. (Show Details)
jcrespo set Security to None.
jcrespo renamed this task from defragment db1015 and db1035 to defragment db1015, db1035 and db1027.Sep 28 2015, 2:19 PM
jcrespo updated the task description. (Show Details)
jcrespo mentioned this in T106847: New hardware for production core mysql cluster.Sep 28 2015, 2:21 PM
Krenair subscribed.Sep 28 2015, 3:18 PM
RobH mentioned this in Unknown Object (Task).Nov 9 2015, 1:56 PM
jcrespo added a comment.Nov 12 2015, 8:56 PM

db1035 defragmented and in production, 2 to go :-P

jcrespo added a comment.Nov 16 2015, 11:04 AM

db1015 defragmented and updated. Only db1027 pending.

jcrespo added a comment.Nov 17 2015, 2:02 PM

db1027 defragmented and ready to be deployed. Only blocked by T118848.

jcrespo closed this task as Resolved.Nov 17 2015, 2:03 PM
jcrespo mentioned this in T153739: Defragment db1015.Dec 21 2016, 8:50 AM
jcrespo mentioned this in T153826: Defragment db1044.
Stashbot subscribed.Jan 19 2017, 1:21 PM

Mentioned in SAL (#wikimedia-operations) [2017-01-19T13:20:59Z] <marostegui> Compressing revision,pagelinks and templatelinks tables on db1035 - T110504

Marostegui subscribed.Jan 20 2017, 7:07 AM

db1035 looks good now

root@db1035:/srv/sqldata# df -hT /srv/
Filesystem            Type  Size  Used Avail Use% Mounted on
/dev/mapper/tank-data xfs   1.6T  1.1T  585G  64% /srv
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL