*************************** 1. row ***************************
     Id: 1
   User: root
   Host: localhost:53871
     db: test
Command: Sleep
   Time: 9518
  State:
   Info: NULL
*************************** 2. row ***************************
     Id: 6
   User: root
   Host: localhost:53876
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: SELECT   SQL_CACHE A . `datetime_key` FROM `A` AS A LEFT JOIN `BB` AS B USING (`pk`) LIMIT 3 FOR UPD
*************************** 3. row ***************************
     Id: 7
   User: root
   Host: localhost:53877
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: SELECT HIGH_PRIORITY  SQL_NO_CACHE A . `date_nokey` FROM `DD` AS A LEFT JOIN `BB` AS B USING (`pk`)
*************************** 4. row ***************************
     Id: 8
   User: root
   Host: localhost:53878
     db: test
Command: Query
   Time: 9350
  State: Locked
   Info: ALTER  IGNORE TABLE `AA` ENGINE = MyISAM
*************************** 5. row ***************************
     Id: 9
   User: root
   Host: localhost:53879
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: INSERT LOW_PRIORITY INTO `DD` ( `varchar_nokey` ) SELECT    A . `datetime_key` FROM `BBB` AS A LEFT
*************************** 6. row ***************************
     Id: 10
   User: root
   Host: localhost:53880
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: ALTER  IGNORE TABLE `B` ENGINE = InnoDB
*************************** 7. row ***************************
     Id: 11
   User: root
   Host: localhost:53881
     db: test
Command: Query
   Time: 9332
  State: Locked
   Info: SELECT   SQL_CACHE A . `varchar_key` FROM `BBB` AS A LEFT JOIN `AA` AS B USING (`pk`) LIMIT 2 LOCK I
*************************** 8. row ***************************
     Id: 12
   User: root
   Host: localhost:53882
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT SQL_NO_CACHE A . `varchar_nokey` FROM `BB` AS A LEFT JOIN `BB` AS B USING
*************************** 9. row ***************************
     Id: 13
   User: root
   Host: localhost:53883
     db: test
Command: Query
   Time: 9342
  State: Locked
   Info: UPDATE LOW_PRIORITY IGNORE `CC` SET `time_nokey` = 5 WHERE `pk` > 7 LIMIT 9
*************************** 10. row ***************************
     Id: 14
   User: root
   Host: localhost:53884
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: ALTER   TABLE `BB` ENGINE = MyISAM
*************************** 11. row ***************************
     Id: 15
   User: root
   Host: localhost:53885
     db: test
Command: Query
   Time: 9336
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT SQL_CACHE A . `time_key` FROM `CCC` AS A LEFT JOIN `BB` AS B USING (`pk`)
*************************** 12. row ***************************
     Id: 16
   User: root
   Host: localhost:53886
     db: test
Command: Query
   Time: 9354
  State: Locked
   Info: ALTER  IGNORE TABLE `CC` ENGINE = InnoDB
*************************** 13. row ***************************
     Id: 17
   User: root
   Host: localhost:53887
     db: test
Command: Query
   Time: 9366
  State: Locked
   Info: INSERT HIGH_PRIORITY INTO `BB` ( `datetime_nokey` ) SELECT HIGH_PRIORITY  SQL_NO_CACHE A . `time_nok
*************************** 14. row ***************************
     Id: 18
   User: root
   Host: localhost:53888
     db: test
Command: Query
   Time: 9354
  State: Locked
   Info: DELETE LOW_PRIORITY QUICK  FROM `CC` WHERE `pk` > 1 LIMIT 3
*************************** 15. row ***************************
     Id: 19
   User: root
   Host: localhost:53889
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: SELECT   SQL_CACHE A . `date_nokey` FROM `BB` AS A LEFT JOIN `BBB` AS B USING (`pk`) LIMIT 2
*************************** 16. row ***************************
     Id: 20
   User: root
   Host: localhost:53890
     db: test
Command: Query
   Time: 9348
  State: Locked
   Info: SELECT    A . `int_key` FROM `B` AS A LEFT JOIN `BB` AS B USING (`pk`) LIMIT 7 LOCK IN SHARE MODE
*************************** 17. row ***************************
     Id: 21
   User: root
   Host: localhost:53891
     db: test
Command: Query
   Time: 9364
  State: Locked
   Info: ALTER  IGNORE TABLE `BB` ENGINE = MEMORY
*************************** 18. row ***************************
     Id: 22
   User: root
   Host: localhost:53892
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: ALTER   TABLE `B` ENGINE = MyISAM
*************************** 19. row ***************************
     Id: 23
   User: root
   Host: localhost:53893
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: ALTER  IGNORE TABLE `B` ENGINE = MEMORY
*************************** 20. row ***************************
     Id: 24
   User: root
   Host: localhost:53894
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: ALTER  IGNORE TABLE `AA` ENGINE = MyISAM
*************************** 21. row ***************************
     Id: 25
   User: root
   Host: localhost:53895
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: DELETE LOW_PRIORITY  IGNORE FROM `B` WHERE `pk` > 7 LIMIT 0
*************************** 22. row ***************************
     Id: 26
   User: root
   Host: localhost:53896
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: UPDATE LOW_PRIORITY IGNORE `A` SET `time_nokey` = 3 WHERE `pk` > 9 LIMIT 8
*************************** 23. row ***************************
     Id: 27
   User: root
   Host: localhost:53897
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: DELETE LOW_PRIORITY  IGNORE FROM `CC` WHERE `pk` > 7 LIMIT 5
*************************** 24. row ***************************
     Id: 28
   User: root
   Host: localhost:53898
     db: test
Command: Query
   Time: 9366
  State: Locked
   Info: SELECT HIGH_PRIORITY SQL_BUFFER_RESULT SQL_NO_CACHE A . `int_key` FROM `CC` AS A LEFT JOIN `CC` AS B
*************************** 25. row ***************************
     Id: 29
   User: root
   Host: localhost:53899
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: ALTER   TABLE `AA` ENGINE = InnoDB
*************************** 26. row ***************************
     Id: 30
   User: root
   Host: localhost:53900
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: INSERT LOW_PRIORITY INTO `A` ( `date_key` ) VALUES ( 0 ) ON DUPLICATE KEY UPDATE `time_nokey` = 5
*************************** 27. row ***************************
     Id: 31
   User: root
   Host: localhost:53901
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: SELECT HIGH_PRIORITY  SQL_CACHE A . `int_nokey` FROM `CC` AS A LEFT JOIN `AA` AS B USING (`pk`) LIMI
*************************** 28. row ***************************
     Id: 32
   User: root
   Host: localhost:53902
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: SELECT   SQL_CACHE A . `datetime_nokey` FROM `A` AS A LEFT JOIN `CCC` AS B USING (`pk`) LIMIT 4 LOCK
*************************** 29. row ***************************
     Id: 33
   User: root
   Host: localhost:53903
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: UPDATE  IGNORE `AA` SET `date_nokey` = 1 WHERE `pk` > 3 LIMIT 0
*************************** 30. row ***************************
     Id: 34
   User: root
   Host: localhost:53904
     db: test
Command: Query
   Time: 9354
  State: Locked
   Info: UPDATE  IGNORE `BB` SET `datetime_nokey` = 5 WHERE `pk` > 8 LIMIT 2
*************************** 31. row ***************************
     Id: 35
   User: root
   Host: localhost:53905
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: DELETE    FROM `AA` WHERE `pk` > 6 LIMIT 4
*************************** 32. row ***************************
     Id: 36
   User: root
   Host: localhost:53906
     db: test
Command: Query
   Time: 9356
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT SQL_NO_CACHE A . `date_key` FROM `AAA` AS A LEFT JOIN `AA` AS B USING (`pk
*************************** 33. row ***************************
     Id: 37
   User: root
   Host: localhost:53907
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: SELECT    A . `date_key` FROM `E` AS A LEFT JOIN `B` AS B USING (`pk`) LIMIT 5 FOR UPDATE UNION SELE
*************************** 34. row ***************************
     Id: 38
   User: root
   Host: localhost:53908
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: DELETE LOW_PRIORITY   FROM `CC` WHERE `pk` > 9 LIMIT 3
*************************** 35. row ***************************
     Id: 39
   User: root
   Host: localhost:53909
     db: test
Command: Query
   Time: 9350
  State: Locked
   Info: UPDATE   `AA` SET `date_key` = 8 WHERE `pk` > 4 LIMIT 3
*************************** 36. row ***************************
     Id: 40
   User: root
   Host: localhost:53910
     db: test
Command: Query
   Time: 9418
  State: Locked
   Info: SELECT    A . `varchar_nokey` FROM `AA` AS A LEFT JOIN `CC` AS B USING (`pk`) LIMIT 5 FOR UPDATE
*************************** 37. row ***************************
     Id: 41
   User: root
   Host: localhost:53911
     db: test
Command: Query
   Time: 9338
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT  A . `int_nokey` FROM `BB` AS A LEFT JOIN `C` AS B USING (`pk`) LIMIT 8  U
*************************** 38. row ***************************
     Id: 42
   User: root
   Host: localhost:53912
     db: test
Command: Query
   Time: 9308
  State: Locked
   Info: ALTER   TABLE `CC` ENGINE = InnoDB
*************************** 39. row ***************************
     Id: 43
   User: root
   Host: localhost:53913
     db: test
Command: Query
   Time: 9318
  State: Locked
   Info: ALTER  IGNORE TABLE `BB` ENGINE = InnoDB
*************************** 40. row ***************************
     Id: 44
   User: root
   Host: localhost:53914
     db: test
Command: Query
   Time: 9330
  State: Locked
   Info: ALTER   TABLE `BB` ENGINE = MEMORY
*************************** 41. row ***************************
     Id: 45
   User: root
   Host: localhost:53915
     db: test
Command: Query
   Time: 9356
  State: Locked
   Info: ALTER  IGNORE TABLE `BB` ENGINE = InnoDB
*************************** 42. row ***************************
     Id: 46
   User: root
   Host: localhost:53916
     db: test
Command: Query
   Time: 9336
  State: Locked
   Info: ALTER  IGNORE TABLE `DD` ENGINE = InnoDB
*************************** 43. row ***************************
     Id: 47
   User: root
   Host: localhost:53917
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: ALTER   TABLE `DD` ENGINE = InnoDB
*************************** 44. row ***************************
     Id: 48
   User: root
   Host: localhost:53918
     db: test
Command: Query
   Time: 9342
  State: Locked
   Info: ALTER  IGNORE TABLE `AA` ENGINE = MyISAM
*************************** 45. row ***************************
     Id: 49
   User: root
   Host: localhost:53919
     db: test
Command: Query
   Time: 9344
  State: Locked
   Info: DELETE LOW_PRIORITY QUICK  FROM `AA` WHERE `pk` > 4 LIMIT 5
*************************** 46. row ***************************
     Id: 50
   User: root
   Host: localhost:53920
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: SELECT HIGH_PRIORITY  SQL_CACHE A . `varchar_nokey` FROM `BBB` AS A LEFT JOIN `CCC` AS B USING (`pk`
*************************** 47. row ***************************
     Id: 51
   User: root
   Host: localhost:53921
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: UPDATE  IGNORE `BB` SET `datetime_key` = 8 WHERE `pk` > 1 LIMIT 7
*************************** 48. row ***************************
     Id: 52
   User: root
   Host: localhost:53922
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: ALTER  IGNORE TABLE `CC` ENGINE = MyISAM
*************************** 49. row ***************************
     Id: 53
   User: root
   Host: localhost:53923
     db: test
Command: Query
   Time: 9314
  State: Locked
   Info: UPDATE  IGNORE `DD` SET `datetime_nokey` = 2 WHERE `pk` > 3 LIMIT 4
*************************** 50. row ***************************
     Id: 54
   User: root
   Host: localhost:53924
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: ALTER   TABLE `BB` ENGINE = InnoDB
*************************** 51. row ***************************
     Id: 55
   User: root
   Host: localhost:53925
     db: test
Command: Query
   Time: 9476
  State: Locked
   Info: INSERT HIGH_PRIORITY INTO `DD` ( `pk` ) SELECT   SQL_CACHE A . `int_nokey` FROM `AA` AS A LEFT JOIN
*************************** 52. row ***************************
     Id: 56
   User: root
   Host: localhost:53926
     db: test
Command: Query
   Time: 9364
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT  A . `date_key` FROM `C` AS A LEFT JOIN `DD` AS B USING (`pk`) LIMIT 7  UN
*************************** 53. row ***************************
     Id: 57
   User: root
   Host: localhost:53927
     db: test
Command: Query
   Time: 9354
  State: Locked
   Info: SELECT   SQL_CACHE A . `int_nokey` FROM `A` AS A LEFT JOIN `CC` AS B USING (`pk`) LIMIT 4 FOR UPDATE
*************************** 54. row ***************************
     Id: 58
   User: root
   Host: localhost:53928
     db: test
Command: Query
   Time: 9344
  State: Locked
   Info: UPDATE  IGNORE `AA` SET `int_nokey` = 9 WHERE `pk` > 8 LIMIT 1
*************************** 55. row ***************************
     Id: 59
   User: root
   Host: localhost:53929
     db: test
Command: Query
   Time: 9356
  State: Locked
   Info: INSERT HIGH_PRIORITY INTO `BB` ( `datetime_key` ) SELECT HIGH_PRIORITY SQL_BUFFER_RESULT SQL_NO_CACH
*************************** 56. row ***************************
     Id: 60
   User: root
   Host: localhost:53930
     db: test
Command: Query
   Time: 9314
  State: Locked
   Info: SELECT HIGH_PRIORITY   A . `int_nokey` FROM `A` AS A LEFT JOIN `E` AS B USING (`pk`) LIMIT 5 FOR UPD
*************************** 57. row ***************************
     Id: 61
   User: root
   Host: localhost:53931
     db: test
Command: Query
   Time: 9360
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT  A . `varchar_key` FROM `BB` AS A LEFT JOIN `DD` AS B USING (`pk`) LIMIT 7
*************************** 58. row ***************************
     Id: 62
   User: root
   Host: localhost:53932
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT  A . `datetime_nokey` FROM `BB` AS A LEFT JOIN `DD` AS B USING (`pk`) LIMI
*************************** 59. row ***************************
     Id: 63
   User: root
   Host: localhost:53933
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: UPDATE   `CC` SET `date_key` = 8 WHERE `pk` > 3 LIMIT 9
*************************** 60. row ***************************
     Id: 64
   User: root
   Host: localhost:53934
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: SELECT   SQL_CACHE A . `int_key` FROM `DD` AS A LEFT JOIN `CC` AS B USING (`pk`) LIMIT 7 FOR UPDATE
*************************** 61. row ***************************
     Id: 65
   User: root
   Host: localhost:53935
     db: test
Command: Query
   Time: 9420
  State: Locked
   Info: SELECT HIGH_PRIORITY SQL_BUFFER_RESULT SQL_NO_CACHE A . `varchar_key` FROM `CCC` AS A LEFT JOIN `BBB
*************************** 62. row ***************************
     Id: 66
   User: root
   Host: localhost:53936
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: ALTER   TABLE `CC` ENGINE = MyISAM
*************************** 63. row ***************************
     Id: 67
   User: root
   Host: localhost:53937
     db: test
Command: Query
   Time: 9356
  State: Locked
   Info: DELETE LOW_PRIORITY QUICK  FROM `CC` WHERE `pk` > 2 LIMIT 3
*************************** 64. row ***************************
     Id: 68
   User: root
   Host: localhost:53938
     db: test
Command: Query
   Time: 9366
  State: Locked
   Info: UPDATE   `AA` SET `date_nokey` = 6 WHERE `pk` > 7 LIMIT 5
*************************** 65. row ***************************
     Id: 69
   User: root
   Host: localhost:53939
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: UPDATE   `A` SET `varchar_key` = 5 WHERE `pk` > 2 LIMIT 3
*************************** 66. row ***************************
     Id: 70
   User: root
   Host: localhost:53940
     db: test
Command: Query
   Time: 9312
  State: Locked
   Info: ALTER  IGNORE TABLE `AA` ENGINE = MyISAM
*************************** 67. row ***************************
     Id: 71
   User: root
   Host: localhost:53941
     db: test
Command: Query
   Time: 9308
  State: Locked
   Info: UPDATE LOW_PRIORITY  `CC` SET `date_key` = 9 WHERE `pk` > 7 LIMIT 7
*************************** 68. row ***************************
     Id: 72
   User: root
   Host: localhost:53942
     db: test
Command: Query
   Time: 9374
  State: Locked
   Info: SELECT HIGH_PRIORITY   A . `varchar_nokey` FROM `BBB` AS A LEFT JOIN `CC` AS B USING (`pk`) LIMIT 6
*************************** 69. row ***************************
     Id: 73
   User: root
   Host: localhost:53943
     db: test
Command: Query
   Time: 9346
  State: Locked
   Info: ALTER   TABLE `CC` ENGINE = MEMORY
*************************** 70. row ***************************
     Id: 74
   User: root
   Host: localhost:53944
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: ALTER   TABLE `B` ENGINE = InnoDB
*************************** 71. row ***************************
     Id: 75
   User: root
   Host: localhost:53945
     db: test
Command: Query
   Time: 9366
  State: Locked
   Info: INSERT LOW_PRIORITY INTO `A` ( `pk` ) SELECT  SQL_BUFFER_RESULT  A . `time_key` FROM `AA` AS A LEFT
*************************** 72. row ***************************
     Id: 76
   User: root
   Host: localhost:53946
     db: test
Command: Query
   Time: 9356
  State: Locked
   Info: UPDATE LOW_PRIORITY  `CC` SET `date_key` = 1 WHERE `pk` > 5 LIMIT 7
*************************** 73. row ***************************
     Id: 77
   User: root
   Host: localhost:53947
     db: test
Command: Query
   Time: 9340
  State: Locked
   Info: ALTER   TABLE `A` ENGINE = InnoDB
*************************** 74. row ***************************
     Id: 78
   User: root
   Host: localhost:53948
     db: test
Command: Query
   Time: 9392
  State: Locked
   Info: INSERT LOW_PRIORITY INTO `CC` ( `datetime_key` ) SELECT HIGH_PRIORITY  SQL_NO_CACHE A . `varchar_nok
*************************** 75. row ***************************
     Id: 79
   User: root
   Host: localhost:53949
     db: test
Command: Query
   Time: 9354
  State: Locked
   Info: ALTER   TABLE `AA` ENGINE = InnoDB
*************************** 76. row ***************************
     Id: 80
   User: root
   Host: localhost:53950
     db: test
Command: Query
   Time: 9314
  State: Locked
   Info: SELECT HIGH_PRIORITY  SQL_NO_CACHE A . `datetime_nokey` FROM `CC` AS A LEFT JOIN `A` AS B USING (`pk
*************************** 77. row ***************************
     Id: 81
   User: root
   Host: localhost:53951
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: INSERT HIGH_PRIORITY INTO `D` ( `datetime_nokey` ) SELECT HIGH_PRIORITY   A . `varchar_key` FROM `AA
*************************** 78. row ***************************
     Id: 82
   User: root
   Host: localhost:53952
     db: test
Command: Query
   Time: 9352
  State: Locked
   Info: ALTER  IGNORE TABLE `B` ENGINE = MyISAM
*************************** 79. row ***************************
     Id: 83
   User: root
   Host: localhost:53953
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: UPDATE LOW_PRIORITY IGNORE `BB` SET `varchar_key` = 9 WHERE `pk` > 5 LIMIT 2
*************************** 80. row ***************************
     Id: 84
   User: root
   Host: localhost:53954
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: UPDATE  IGNORE `DD` SET `datetime_nokey` = 1 WHERE `pk` > 0 LIMIT 8
*************************** 81. row ***************************
     Id: 85
   User: root
   Host: localhost:53955
     db: test
Command: Query
   Time: 9320
  State: Locked
   Info: DELETE  QUICK  FROM `AA` WHERE `pk` > 9 LIMIT 9
*************************** 82. row ***************************
     Id: 86
   User: root
   Host: localhost:53956
     db: test
Command: Query
   Time: 9362
  State: Locked
   Info: ALTER  IGNORE TABLE `B` ENGINE = InnoDB
*************************** 83. row ***************************
     Id: 87
   User: root
   Host: localhost:53957
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: UPDATE   `DD` SET `int_key` = 2 WHERE `pk` > 0 LIMIT 9
*************************** 84. row ***************************
     Id: 88
   User: root
   Host: localhost:53958
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: SELECT HIGH_PRIORITY  SQL_NO_CACHE A . `int_key` FROM `E` AS A LEFT JOIN `DD` AS B USING (`pk`) LIMI
*************************** 85. row ***************************
     Id: 89
   User: root
   Host: localhost:53959
     db: test
Command: Query
   Time: 9346
  State: Locked
   Info: SELECT HIGH_PRIORITY   A . `int_nokey` FROM `BB` AS A LEFT JOIN `AAA` AS B USING (`pk`) LIMIT 5  UNI
*************************** 86. row ***************************
     Id: 90
   User: root
   Host: localhost:53960
     db: test
Command: Query
   Time: 9396
  State: Locked
   Info: SELECT HIGH_PRIORITY SQL_BUFFER_RESULT SQL_CACHE A . `date_nokey` FROM `B` AS A LEFT JOIN `DD` AS B
*************************** 87. row ***************************
     Id: 91
   User: root
   Host: localhost:53961
     db: test
Command: Query
   Time: 9348
  State: Locked
   Info: UPDATE   `BB` SET `datetime_key` = 3 WHERE `pk` > 4 LIMIT 5
*************************** 88. row ***************************
     Id: 92
   User: root
   Host: localhost:53962
     db: test
Command: Query
   Time: 9396
  State: Locked
   Info: SELECT   SQL_NO_CACHE A . `time_key` FROM `BBB` AS A LEFT JOIN `AA` AS B USING (`pk`) LIMIT 9 FOR UP
*************************** 89. row ***************************
     Id: 93
   User: root
   Host: localhost:53963
     db: test
Command: Query
   Time: 9332
  State: Locked
   Info: ALTER   TABLE `BB` ENGINE = InnoDB
*************************** 90. row ***************************
     Id: 94
   User: root
   Host: localhost:53964
     db: test
Command: Query
   Time: 9340
  State: Locked
   Info: SELECT   SQL_CACHE A . `int_key` FROM `A` AS A LEFT JOIN `DD` AS B USING (`pk`) LIMIT 2 LOCK IN SHAR
*************************** 91. row ***************************
     Id: 95
   User: root
   Host: localhost:53965
     db: test
Command: Query
   Time: 9350
  State: Locked
   Info: ALTER   TABLE `BB` ENGINE = MEMORY
*************************** 92. row ***************************
     Id: 96
   User: root
   Host: localhost:53966
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: ALTER   TABLE `CC` ENGINE = InnoDB
*************************** 93. row ***************************
     Id: 97
   User: root
   Host: localhost:53967
     db: test
Command: Query
   Time: 9454
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT SQL_CACHE A . `datetime_key` FROM `CCC` AS A LEFT JOIN `D` AS B USING (`pk
*************************** 94. row ***************************
     Id: 98
   User: root
   Host: localhost:53968
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: UPDATE LOW_PRIORITY IGNORE `DD` SET `date_key` = 2 WHERE `pk` > 3 LIMIT 7
*************************** 95. row ***************************
     Id: 99
   User: root
   Host: localhost:53969
     db: test
Command: Query
   Time: 9358
  State: Locked
   Info: DELETE LOW_PRIORITY  IGNORE FROM `B` WHERE `pk` > 6 LIMIT 1
*************************** 96. row ***************************
     Id: 100
   User: root
   Host: localhost:53970
     db: test
Command: Query
   Time: 9374
  State: Locked
   Info: SELECT  SQL_BUFFER_RESULT SQL_CACHE A . `int_key` FROM `B` AS A LEFT JOIN `C` AS B USING (`pk`) LIMI
*************************** 97. row ***************************
     Id: 101
   User: root
   Host: localhost:53971
     db: test
Command: Query
   Time: 9344
  State: Locked
   Info: ALTER   TABLE `A` ENGINE = MEMORY
*************************** 98. row ***************************
     Id: 102
   User: root
   Host: localhost:53972
     db: test
Command: Query
   Time: 9352
  State: Locked
   Info: ALTER   TABLE `CC` ENGINE = InnoDB
*************************** 99. row ***************************
     Id: 103
   User: root
   Host: localhost:53973
     db: test
Command: Query
   Time: 9328
  State: Locked
   Info: ALTER  IGNORE TABLE `AA` ENGINE = MyISAM
*************************** 100. row ***************************
     Id: 104
   User: root
   Host: localhost:53974
     db: test
Command: Query
   Time: 9326
  State: Locked
   Info: ALTER   TABLE `AA` ENGINE = MEMORY
*************************** 101. row ***************************
     Id: 105
   User: root
   Host: localhost:53975
     db: test
Command: Query
   Time: 9322
  State: Locked
   Info: REPLACE LOW_PRIORITY INTO `DD` ( `datetime_key` ) VALUES ( 3 )
*************************** 102. row ***************************
     Id: 110
   User: root
   Host: localhost:53208
     db: test
Command: Query
   Time: 0
  State: NULL
   Info: show processlist