Comment 1 for bug 968596

Here is the exact SQL of each nibble:

# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.000233 Lock_time: 0.000033 Rows_sent: 1 Rows_examined: 0
SET timestamp=1333052916;
EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `actor_id`, `actor_id`, `film_id` FROM `sakila`.`film_actor` FORCE INDEX(`PRIMARY`) WHERE ((`actor_id` > '198') OR (`actor_id` = '198' AND `film_id` >= '406')) ORDER BY `actor_id`, `film_id` LIMIT 100, 2 /*next chunk boundary*/;
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.000260 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 62
SET timestamp=1333052916;
SELECT /*!40001 SQL_NO_CACHE */ `actor_id`, `actor_id`, `film_id` FROM `sakila`.`film_actor` FORCE INDEX(`PRIMARY`) WHERE ((`actor_id` > '198') OR (`actor_id` = '198' AND `film_id` >= '406')) ORDER BY `actor_id`, `film_id` LIMIT 99, 2 /*next chunk boundary*/;
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.000314 Lock_time: 0.000032 Rows_sent: 1 Rows_examined: 0
SET timestamp=1333052916;
EXPLAIN SELECT `actor_id`, `film_id`, `last_update` FROM `sakila`.`film_actor` FORCE INDEX(`PRIMARY`) WHERE ((`actor_id` > '198') OR (`actor_id` = '198' AND `film_id` >= '406')) AND ((`actor_id` < '200') OR (`actor_id` = '200' AND `film_id` <= '993')) /*explain pt-online-schema-change 6398 copy nibble*/;
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.001491 Lock_time: 0.000040 Rows_sent: 0 Rows_examined: 62
SET timestamp=1333052916;
INSERT LOW_PRIORITY IGNORE INTO `sakila`.`_film_actor_new` (`actor_id`, `film_id`, `last_update`) SELECT `actor_id`, `film_id`, `last_update` FROM `sakila`.`film_actor` FORCE INDEX(`PRIMARY`) WHERE ((`actor_id` > '198') OR (`actor_id` = '198' AND `film_id` >= '406')) AND ((`actor_id` < '200') OR (`actor_id` = '200' AND `film_id` <= '993')) /*pt-online-schema-change 6398 copy nibble*/;
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.000715 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1333052916;
SHOW WARNINGS;
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.000446 Lock_time: 0.000022 Rows_sent: 1 Rows_examined: 1
SET timestamp=1333052916;
SHOW GLOBAL STATUS LIKE 'Threads_running';
# User@Host: msandbox[msandbox] @ localhost [127.0.0.1]
# Query_time: 0.004201 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 0