SELECT 'Creating "Tester" database';
DROP DATABASE IF EXISTS `Tester`;

CREATE DATABASE `Tester`;
                                                                                                                 
USE `Tester`;                                                                                                    
                                                                                                                 
CREATE TABLE `Test` (                                                                                            
  `TestId` int(11) NOT NULL AUTO_INCREMENT,                                                                      
  `Message` varchar(1000) NOT NULL,                                                                              
  PRIMARY KEY (`TestId`)                                                                                         
) ENGINE=InnoDB AUTO_INCREMENT=1225104 DEFAULT CHARSET=latin1 COMMENT='Test';                                    

SELECT 'Create test data';

INSERT INTO `Test` (Message) VALUES ('Swamping Message Swamping Message Swamping Message Swamping Message');	-- first row
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 2 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 4 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 8 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 16 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 32 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 64 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 128 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 256 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 512 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 1024 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 2048 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 4096 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 8192 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 16384 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 32768 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 65536 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 131072 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 262144 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId;	-- 524288 rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 475712;	-- 1,000,000 million rows
SELECT COUNT(*) FROM Test;

SELECT 'Update data';

-- 1.1 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.2 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.2 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.3 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.4 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.5 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.6 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.7 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.8 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 1.9 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.0 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.1 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.2 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.2 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.3 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.4 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.5 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.6 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.7 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.8 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 2.9 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.0 million rows
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
SELECT COUNT(*) FROM Test;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.1 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.2 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.2 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.3 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.4 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.5 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.6 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.7 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.8 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';

-- 3.9 million rows
SELECT COUNT(*) FROM Test;
INSERT INTO `Test` (Message) SELECT Message FROM Test ORDER BY TestId LIMIT 100000;
UPDATE Test SET Message = 'Swamping Message Swamping Message Swamping Message Swamping Message';