I ran old version of script (wmf22) ContentTranslation/scripts/manage-lists.php in testwiki to fill the data. To refill new data, old data from wikishared/cx_suggestions and cx_lists need to remove.
Please document the procedure too.
Description
Description
Event Timeline
Comment Actions
As a one time update, given the current size an traffic of those tables, and that a DBA can immediately check for metadata locking and other things that could go badly with a DML query, I will run
TRUNCATE TABLE wikishared.cx_suggestions; TRUNCATE TABLE wikishared.cx_lists;
on x1-master.
For unattended maintenance, tables with continuous read operations or large tables, the usage of runBatchedQuery.php is encouraged, with incremental DELETE...LIMIT. That is safer, (no metadata locking, slower garbage collection, etc), and it is not considered a schema change, just regular maintenace.
Comment Actions
I've made a backup of those tables, do I have the green light to run the above command now or does it depend on a code commit?
Comment Actions
MariaDB [wikishared]> SELECT count(*) FROM cx_suggestions; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) MariaDB [wikishared]> SELECT count(*) FROM cx_lists; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec)