@Merl , is this database in active use? If not, would it be possible to empty it?
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Declined | None | T87716 Missing rows from categorylinks on production servers (dewiki) | |||
| Invalid | Feature | None | T69556 merl tools (tracking) | ||
| Resolved | jcrespo | T132431 labsdb1001 and labsdb1003 short on available space | |||
| Resolved | • Marostegui | T133325 s51127__dewiki_lists (merlbot) database using 13G on labsdb1001 (enwiki) |
Event Timeline
Comment Actions
Merl is inactive since about one year. The crontabs have been commented out one year ago. My first suggestion would be: create a dump, so that the table can get restored, if needed, and then cleanup the DB.
Comment Actions
Thanks @Luke081515 - we expanded the partitions some months ago so disk space isn't an issue here anymore, but it is always good to clean up things.
As the user never replied:
I have taken a backup of this user's db and placed it on: labsdb1001:/srv/T133325
Probably on Monday I will drop it and if we need to recreate it:
labsdb1001: cat /srv/T133325/s51127__dewiki_lists.sql | mysql --skip-ssl
Comment Actions
And I have dropped this:
mysql:root@localhost [s51127__dewiki_lists]> drop database if exists s51127__dewiki_lists; Query OK, 64 rows affected (0.25 sec)
If we want to add it back:
labsdb1001: cat /srv/T133325/s51127__dewiki_lists.sql | mysql --skip-ssl