text: create database if not exists test_db;
  use test_db;
  drop table if exists test_mysql_restart_with_create_collection;
  create table if not exists test_mysql_restart_with_create_collection(id int primary key auto_increment, name varchar(10), col_a float, col_b int, column1 varchar(256));
  
  insert into test_mysql_restart_with_create_collection values(1, 'name1', 11.111, 100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,1]');
  insert into test_mysql_restart_with_create_collection values(2, 'name2', 12.111, 200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2]');
  insert into test_mysql_restart_with_create_collection values(3, 'name3', 13.111, 300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,3]');
  insert into test_mysql_restart_with_create_collection values(4, 'name4', 14.111, 400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,4]');
  insert into test_mysql_restart_with_create_collection values(5, 'name5', 15.111, 500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,5]');
  insert into test_mysql_restart_with_create_collection values(6, 'name6', 16.111, 600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,6]');
  insert into test_mysql_restart_with_create_collection values(7, 'name7', 17.111, 700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,7]');
  insert into test_mysql_restart_with_create_collection values(8, 'name8', 18.111, 800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,8]');
  insert into test_mysql_restart_with_create_collection values(9, 'name9', 19.111, 900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,9]');
  insert into test_mysql_restart_with_create_collection values(10, 'name10', 20.111, 1000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,10]');
  insert into test_mysql_restart_with_create_collection values(11, 'name11', 21.111, 1100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,11]');
  insert into test_mysql_restart_with_create_collection values(12, 'name12', 22.111, 1200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,12]');
  insert into test_mysql_restart_with_create_collection values(13, 'name13', 23.111, 1300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,13]');
  insert into test_mysql_restart_with_create_collection values(14, 'name14', 24.111, 1400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,14]');
  insert into test_mysql_restart_with_create_collection values(15, 'name15', 25.111, 1500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,15]');
  insert into test_mysql_restart_with_create_collection values(16, 'name16', 26.111, 1600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,16]');
  insert into test_mysql_restart_with_create_collection values(17, 'name17', 27.111, 1700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,17]');
  insert into test_mysql_restart_with_create_collection values(18, 'name18', 28.111, 1800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,18]');
  insert into test_mysql_restart_with_create_collection values(19, 'name19', 29.111, 1900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,19]');
  insert into test_mysql_restart_with_create_collection values(20, 'name20', 30.111, 2000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,20]');
  insert into test_mysql_restart_with_create_collection values(21, 'name21', 31.111, 2100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,21]');
  insert into test_mysql_restart_with_create_collection values(22, 'name22', 32.111, 2200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,22]');
  insert into test_mysql_restart_with_create_collection values(23, 'name23', 33.111, 2300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,23]');
  insert into test_mysql_restart_with_create_collection values(24, 'name24', 34.111, 2400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,24]');
  insert into test_mysql_restart_with_create_collection values(25, 'name25', 35.111, 2500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,25]');
  insert into test_mysql_restart_with_create_collection values(26, 'name26', 36.111, 2600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,26]');
  insert into test_mysql_restart_with_create_collection values(27, 'name27', 37.111, 2700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,27]');
  insert into test_mysql_restart_with_create_collection values(28, 'name28', 38.111, 2800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,28]');
  insert into test_mysql_restart_with_create_collection values(29, 'name29', 39.111, 2900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,29]');
  insert into test_mysql_restart_with_create_collection values(30, 'name30', 40.111, 3000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,30]');
  insert into test_mysql_restart_with_create_collection values(31, 'name31', 41.111, 3100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,31]');
  insert into test_mysql_restart_with_create_collection values(32, 'name32', 42.111, 3200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,32]');
  insert into test_mysql_restart_with_create_collection values(33, 'name33', 43.111, 3300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,33]');
  insert into test_mysql_restart_with_create_collection values(34, 'name34', 44.111, 3400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,34]');
  insert into test_mysql_restart_with_create_collection values(35, 'name35', 45.111, 3500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,35]');
  insert into test_mysql_restart_with_create_collection values(36, 'name36', 46.111, 3600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,36]');
  insert into test_mysql_restart_with_create_collection values(37, 'name37', 47.111, 3700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,37]');
  insert into test_mysql_restart_with_create_collection values(38, 'name38', 48.111, 3800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,38]');
  insert into test_mysql_restart_with_create_collection values(39, 'name39', 49.111, 3900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,39]');
  insert into test_mysql_restart_with_create_collection values(40, 'name40', 50.111, 4000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,40]');
  insert into test_mysql_restart_with_create_collection values(41, 'name41', 51.111, 4100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,41]');
  insert into test_mysql_restart_with_create_collection values(42, 'name42', 52.111, 4200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,42]');
  insert into test_mysql_restart_with_create_collection values(43, 'name43', 53.111, 4300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,43]');
  insert into test_mysql_restart_with_create_collection values(44, 'name44', 54.111, 4400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,44]');
  insert into test_mysql_restart_with_create_collection values(45, 'name45', 55.111, 4500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,45]');
  insert into test_mysql_restart_with_create_collection values(46, 'name46', 56.111, 4600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,46]');
  insert into test_mysql_restart_with_create_collection values(47, 'name47', 57.111, 4700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,47]');
  insert into test_mysql_restart_with_create_collection values(48, 'name48', 58.111, 4800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,48]');
  insert into test_mysql_restart_with_create_collection values(49, 'name49', 59.111, 4900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,49]');
  insert into test_mysql_restart_with_create_collection values(50, 'name50', 60.111, 5000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,50]');
  insert into test_mysql_restart_with_create_collection values(51, 'name51', 61.111, 5100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,51]');
  insert into test_mysql_restart_with_create_collection values(52, 'name52', 62.111, 5200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,52]');
  insert into test_mysql_restart_with_create_collection values(53, 'name53', 63.111, 5300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,53]');
  insert into test_mysql_restart_with_create_collection values(54, 'name54', 64.111, 5400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,54]');
  insert into test_mysql_restart_with_create_collection values(55, 'name55', 65.111, 5500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,55]');
  insert into test_mysql_restart_with_create_collection values(56, 'name56', 66.111, 5600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,56]');
  insert into test_mysql_restart_with_create_collection values(57, 'name57', 67.111, 5700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,57]');
  insert into test_mysql_restart_with_create_collection values(58, 'name58', 68.111, 5800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,58]');
  insert into test_mysql_restart_with_create_collection values(59, 'name59', 69.111, 5900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,59]');
  insert into test_mysql_restart_with_create_collection values(60, 'name60', 70.111, 6000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,60]');
  insert into test_mysql_restart_with_create_collection values(61, 'name61', 71.111, 6100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,61]');
  insert into test_mysql_restart_with_create_collection values(62, 'name62', 72.111, 6200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,62]');
  insert into test_mysql_restart_with_create_collection values(63, 'name63', 73.111, 6300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,63]');
  insert into test_mysql_restart_with_create_collection values(64, 'name64', 74.111, 6400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,64]');
  insert into test_mysql_restart_with_create_collection values(65, 'name65', 75.111, 6500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,65]');
  insert into test_mysql_restart_with_create_collection values(66, 'name66', 76.111, 6600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,66]');
  insert into test_mysql_restart_with_create_collection values(67, 'name67', 77.111, 6700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,67]');
  insert into test_mysql_restart_with_create_collection values(68, 'name68', 78.111, 6800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,68]');
  insert into test_mysql_restart_with_create_collection values(69, 'name69', 79.111, 6900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,69]');
  insert into test_mysql_restart_with_create_collection values(70, 'name70', 80.111, 7000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,70]');
  insert into test_mysql_restart_with_create_collection values(71, 'name71', 81.111, 7100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,71]');
  insert into test_mysql_restart_with_create_collection values(72, 'name72', 82.111, 7200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,72]');
  insert into test_mysql_restart_with_create_collection values(73, 'name73', 83.111, 7300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,73]');
  insert into test_mysql_restart_with_create_collection values(74, 'name74', 84.111, 7400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,74]');
  insert into test_mysql_restart_with_create_collection values(75, 'name75', 85.111, 7500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,75]');
  insert into test_mysql_restart_with_create_collection values(76, 'name76', 86.111, 7600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,76]');
  insert into test_mysql_restart_with_create_collection values(77, 'name77', 87.111, 7700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,77]');
  insert into test_mysql_restart_with_create_collection values(78, 'name78', 88.111, 7800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,78]');
  insert into test_mysql_restart_with_create_collection values(79, 'name79', 89.111, 7900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,79]');
  insert into test_mysql_restart_with_create_collection values(80, 'name80', 90.111, 8000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,80]');
  insert into test_mysql_restart_with_create_collection values(81, 'name81', 91.111, 8100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,81]');
  insert into test_mysql_restart_with_create_collection values(82, 'name82', 92.111, 8200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,82]');
  insert into test_mysql_restart_with_create_collection values(83, 'name83', 93.111, 8300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,83]');
  insert into test_mysql_restart_with_create_collection values(84, 'name84', 94.111, 8400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,84]');
  insert into test_mysql_restart_with_create_collection values(85, 'name85', 95.111, 8500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,85]');
  insert into test_mysql_restart_with_create_collection values(86, 'name86', 96.111, 8600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,86]');
  insert into test_mysql_restart_with_create_collection values(87, 'name87', 97.111, 8700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,87]');
  insert into test_mysql_restart_with_create_collection values(88, 'name88', 98.111, 8800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,88]');
  insert into test_mysql_restart_with_create_collection values(89, 'name89', 99.111, 8900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,89]');
  insert into test_mysql_restart_with_create_collection values(90, 'name90', 100.111, 9000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,90]');
  insert into test_mysql_restart_with_create_collection values(91, 'name91', 101.111, 9100, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,91]');
  insert into test_mysql_restart_with_create_collection values(92, 'name92', 102.111, 9200, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,92]');
  insert into test_mysql_restart_with_create_collection values(93, 'name93', 103.111, 9300, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,93]');
  insert into test_mysql_restart_with_create_collection values(94, 'name94', 104.111, 9400, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,94]');
  insert into test_mysql_restart_with_create_collection values(95, 'name95', 105.111, 9500, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,95]');
  insert into test_mysql_restart_with_create_collection values(96, 'name96', 106.111, 9600, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,96]');
  insert into test_mysql_restart_with_create_collection values(97, 'name97', 107.111, 9700, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,97]');
  insert into test_mysql_restart_with_create_collection values(98, 'name98', 108.111, 9800, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,98]');
  insert into test_mysql_restart_with_create_collection values(99, 'name99', 109.111, 9900, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,99]');
  insert into test_mysql_restart_with_create_collection values(100, 'name100', 110.111, 10000, '[1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,100]');
  
  select count(*) from test_mysql_restart_with_create_collection;
  
  