Pinned Loading

1. deleterows.sql deleterows.sql

   1

   DECLARE @BATCHSIZE INT, @WAITFORVAL VARCHAR(8), @ITERATION INT, @TOTALROWS INT, @MAXRUNTIME VARCHAR(8), @BSTOPATMAXTIME BIT, @MSG VARCHAR(500)

   2

   SET DEADLOCK_PRIORITY LOW;

   3

   SET @BATCHSIZE = 4000

   4

   SET @WAITFORVAL = '00:00:10' -- 24AM START

   5

   SET @MAXRUNTIME = '08:00:00' -- 08AM FINISH

2. deletetables.sql deletetables.sql

   1

   SET FOREIGN_KEY_CHECKS = 0; 

   2

   SET @tables = NULL;

   3

   SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`') INTO @tables

   4

     FROM information_schema.tables 

   5

     WHERE table_schema = 'database_name';