Page MenuHomePhabricator

Add global to prevent writing to wb_changes database table
Closed, ResolvedPublic

Description

The wb_changes table on wikidatawiki reached 1GB today. As this is currently not used, it's wasted space, and truncating the table doesn't free the used disk space (dropping and reimporting the database would be necessary). However, truncating it will mean the space on will not grow until the tables once again fill all that disk space.

On this note, it'd be really handy to have a global to disable/enable writing to that table. In the current setup, this is un-needed and unused, and according to Denny, is subject to major change soon. It does save numerous of large insert statements to the master, saving some overhead


Version: unspecified
Severity: enhancement

Details

Reference
bz41593

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 12:59 AM
bzimport set Reference to bz41593.
bzimport added a subscriber: Unknown Object (MLST).
  • Bug 41594 has been marked as a duplicate of this bug. ***

Fix posted as I2348d008.

Set $wgWBSettings['useChangesTable'] = false; to disable the wb_changes table.