Ok. Mostly ingnore #32. I was able to reproduce it even with FOR BACKUP removed.
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+-----------------------------+-----------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+----+-----------------+-----------+------+---------+------+-----------------------------+-----------------------------------------------------------------
| 1 | event_scheduler | localhost | NULL | Daemon | 11 | Waiting for next activation | NULL | 0 | 0 |
| 6 | root | localhost | test | Query | 648 | creating table | CREATE TABLE `table500_tokudb_default_key_pk_parts_2_int_autoinc` (
`c17` text CHARACTER SET latin1, | 0 | 0 |
| 45 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 |
+----+-----------------+-----------+------+---------+------+-----------------------------+-----------------------------------------------------------------
Leave reducer running. Once it reproduces it will be clear. Either # of queries will be significantly less for one thread (when using ./status.sh) and no progressing or eventually only one thread will be left;
=== Verify stages progress per mysqld, only relevant for initial simplification during the verify stage ([V])
Verify attempt #1
=== Queries processed per mysqld
Queries 5669/22781
=== Client version strings for easy access
/sda/Percona-Server-5.6.21-rel70.0-693.Linux.x86_64-debug/bin/mysql --socket=/dev/shm/1416780157/subreducer/20/socket.sock -uroot
This was after it had progressed from 25 to 30 threads. Recommendation; start it, check it every half hour/hour orso for a stalled mysqld.
Ok. Mostly ingnore #32. I was able to reproduce it even with FOR BACKUP removed.
mysql> show processlist; ------- ------- --+---- ------- +------ +------ ---+--- ---+--- ------- ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- -
| Rows_sent | Rows_examined | ------- ------- --+---- ------- +------ +------ ---+--- ---+--- ------- ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- -
| 0 | 0 | tokudb_ default_ key_pk_ parts_2_ int_autoinc` (
| 0 | 0 | ------- ------- --+---- ------- +------ +------ ---+--- ---+--- ------- ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- -
+----+-
| Id | User | Host | db | Command | Time | State | Info
+----+-
| 1 | event_scheduler | localhost | NULL | Daemon | 11 | Waiting for next activation | NULL
| 6 | root | localhost | test | Query | 648 | creating table | CREATE TABLE `table500_
`c17` text CHARACTER SET latin1, | 0 | 0 |
| 45 | root | localhost | NULL | Query | 0 | init | show processlist
+----+-
Leave reducer running. Once it reproduces it will be clear. Either # of queries will be significantly less for one thread (when using ./status.sh) and no progressing or eventually only one thread will be left;
=== Verify stages progress per mysqld, only relevant for initial simplification during the verify stage ([V]) Server- 5.6.21- rel70.0- 693.Linux. x86_64- debug/bin/ mysql --socket= /dev/shm/ 1416780157/ subreducer/ 20/socket. sock -uroot
Verify attempt #1
=== Queries processed per mysqld
Queries 5669/22781
=== Client version strings for easy access
/sda/Percona-
This was after it had progressed from 25 to 30 threads. Recommendation; start it, check it every half hour/hour orso for a stalled mysqld.