appengine/monorail/tools/null-comment-table-strings.sql

-- Copyright 2016 The Chromium Authors
-- Use of this source code is governed by a BSD-style license that can be
-- found in the LICENSE file.


DROP PROCEDURE IF EXISTS NullCommentTableStrings;

delimiter //

CREATE PROCEDURE NullCommentTableStrings(
    IN in_start INT, IN in_stop INT, IN in_step INT)
BEGIN
  comment_loop: LOOP
    IF in_start >= in_stop THEN
      LEAVE comment_loop;
    END IF;

    SELECT in_start AS StartingAt;
    SELECT count(*)
    FROM Comment
    WHERE Comment.id >= in_start
    AND Comment.id < in_start + in_step;

    UPDATE Comment
    SET content = NULL, inbound_message = NULL
    WHERE Comment.id >= in_start
    AND Comment.id < in_start + in_step;

    SET in_start = in_start + in_step;

  END LOOP;

END;


//


delimiter ;


-- Copy and paste these individually and verify that the site is still responsive.
-- the first one, takes about 30 sec, then 4-7 minutes for each of the rest.
-- CALL NullCommentTableStrings(           0, 13 * 1000000, 10000);
-- CALL NullCommentTableStrings(13 * 1000000, 16 * 1000000, 10000);
-- CALL NullCommentTableStrings(16 * 1000000, 17 * 1000000, 10000);
-- CALL NullCommentTableStrings(17 * 1000000, 18 * 1000000, 10000);
-- CALL NullCommentTableStrings(18 * 1000000, 19 * 1000000, 10000);
-- CALL NullCommentTableStrings(19 * 1000000, 20 * 1000000, 10000);
-- CALL NullCommentTableStrings(20 * 1000000, 21 * 1000000, 10000);
-- CALL NullCommentTableStrings(21 * 1000000, 22 * 1000000, 10000);
-- CALL NullCommentTableStrings(22 * 1000000, 23 * 1000000, 10000);
-- CALL NullCommentTableStrings(23 * 1000000, 24 * 1000000, 10000);
-- CALL NullCommentTableStrings(24 * 1000000, 25 * 1000000, 10000);
-- CALL NullCommentTableStrings(25 * 1000000, 26 * 1000000, 10000);
-- CALL NullCommentTableStrings(26 * 1000000, 27 * 1000000, 10000);
-- CALL NullCommentTableStrings(27 * 1000000, 28 * 1000000, 10000);
-- CALL NullCommentTableStrings(28 * 1000000, 29 * 1000000, 10000);
-- CALL NullCommentTableStrings(29 * 1000000, 30 * 1000000, 10000);
-- CALL NullCommentTableStrings(30 * 1000000, 40 * 1000000, 10000);