Investigating why doing a SELECT COUNT(*) followed by a TRUNCATE or DROP is far faster than those DDL operations alone

mysql_8_0_23_investigation.md

Examining MySQL 8.0.23 with strace during SELECT COUNT(*), TRUNCATE TABLE, and DROP TABLE operations

Notes

• Ran on a Proxmox VM on a Dell R620 with dual E5-2650 v2, all 32 cores given to the VM, and 64 GiB of RAM allocated
• Disk was an ext4 filesystem on an HDD-based virtual disk, presented via a ZFS array in another physical server
• Captured with strace -T -ff -o /usr/local/mysql/trace /usr/local/mysql/bin/mysqld

Tests

This is running a SELECT COUNT(*), then a TRUNCATE, then a DROP, with FOREIGN_KEY_CHECKS=OFF

mysql> SELECT COUNT(*) FROM zapiermain.drip_sentdrip;
+----------+
| COUNT(*) |
+----------+
|  1000000 |
+----------+
1 row in set (9.18 sec)

mysql> TRUNCATE zapiermain.drip_sentdrip;
Query OK, 0 rows affected (0.65 sec)

mysql> DROP TABLE zapiermain.drip_sentdrip;
Query OK, 0 rows affected (0.36 sec)

Below is the strace of the COUNT(*) section

$ awk '/SELECT/,/sendto/' combined-trace.7381

recvfrom(38, "\3\0\1SELECT COUNT(*) FROM zapierma"..., 48, MSG_DONTWAIT, NULL, NULL) = 48 <0.000171>
mprotect(0x7f540c021000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000154>
mprotect(0x7f540c022000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c023000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000113>
mprotect(0x7f540c024000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000122>
mprotect(0x7f540c025000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c026000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000124>
mprotect(0x7f540c027000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000134>
mprotect(0x7f540c028000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000117>
mprotect(0x7f540c029000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000147>
mprotect(0x7f540c02a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000140>
mprotect(0x7f540c02b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c02c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c02d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c02e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c02f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c030000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000102>
mprotect(0x7f540c031000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000196>
mprotect(0x7f540c032000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000073>
mprotect(0x7f540c035000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c036000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c037000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c03a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c03b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c03c000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c03e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000122>
mprotect(0x7f540c03f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000102>
mprotect(0x7f540c040000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000117>
mprotect(0x7f540c042000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c043000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000142>
mprotect(0x7f540c045000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c046000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c047000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c048000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c049000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c04a000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c04c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c04d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c04e000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000116>
mprotect(0x7f540c050000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000134>
mprotect(0x7f540c053000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c054000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000109>
mprotect(0x7f540c056000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c057000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000167>
mprotect(0x7f540c059000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c05a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c05b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c05c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c05d000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c060000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c061000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c063000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000104>
mprotect(0x7f540c064000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000118>
mprotect(0x7f540c066000, 61440, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c075000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c076000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c077000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c078000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c07b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c07c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
mprotect(0x7f540c07d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c07e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c07f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c080000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c082000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c083000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c085000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c087000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c088000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c089000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c08a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c08b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c08c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000139>
mprotect(0x7f540c08d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c08e000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c092000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000152>
mprotect(0x7f540c093000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000134>
pread64(27, "\20\1\307\273\0\0\1\326\0\0\1\325\377\377\377\377\0\0\0\0R?\217\25E\277\0\0\0\0\0\0"..., 16384, 7700480) = 16384 <0.000178>
mprotect(0x7f540c094000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000130>
mprotect(0x7f540c098000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000125>
mprotect(0x7f540c099000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000129>
mprotect(0x7f540c09a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c09b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000148>
mprotect(0x7f540c09c000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000141>
mprotect(0x7f540c0a0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0a1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c0a2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000137>
mprotect(0x7f540c0a3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000129>
mprotect(0x7f540c0a4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
mprotect(0x7f540c0a5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000144>
mprotect(0x7f540c0a6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c0a7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0a8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000152>
mprotect(0x7f540c0a9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0aa000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0ab000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0ac000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0ad000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000104>
mprotect(0x7f540c0ae000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0af000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000130>
pread64(27, "R\262/\20\0\0\0\25\377\377\377\377\377\377\377\377\0\0\0\0\0$\354\342E\277\0\0\0\0\0\0"..., 16384, 344064) = 16384 <0.000194>
pread64(27, "\233\0015\255\0\0\0\26\377\377\377\377\377\377\377\377\0\0\0\0\0$\360\320E\277\0\0\0\0\0\0"..., 16384, 360448) = 16384 <0.000194>
pread64(27, "\31C\262\350\0\0\0\27\377\377\377\377\377\377\377\377\0\0\0\0\0$\364\276E\277\0\0\0\0\0\0"..., 16384, 376832) = 16384 <0.000211>
mprotect(0x7f540c0b0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000153>
mprotect(0x7f540c0b1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0b2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000144>
mprotect(0x7f540c0b3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c0b4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c0b5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0b6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c0b7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000116>
mprotect(0x7f540c0b8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c0b9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c0ba000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0bb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0bc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c0bd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000131>
mprotect(0x7f540c0be000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0bf000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0c0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0c1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0c2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000099>
mprotect(0x7f540c0c3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c0c4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0c5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000183>
mprotect(0x7f540c0c6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c0c7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000097>
mprotect(0x7f540c0c8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c0c9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000101>
mprotect(0x7f540c0ca000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000118>
mprotect(0x7f540c0cb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000100>
mprotect(0x7f540c0cc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000098>
mprotect(0x7f540c0cd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0ce000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c0d0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0d1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000136>
mprotect(0x7f540c0d2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000140>
mprotect(0x7f540c0d3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000125>
mprotect(0x7f540c0d4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000124>
mprotect(0x7f540c0d5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0d6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000100>
mprotect(0x7f540c0d7000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000098>
mprotect(0x7f540c0db000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0dc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c0dd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0de000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c0e2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c0e3000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0e7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0e8000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0ec000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000142>
mprotect(0x7f540c0ed000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c0ee000, 9469952, PROT_READ|PROT_WRITE) = 0 <0.000131>
mprotect(0x7f540c9f6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000130>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000113>
sched_yield()                           = 0 <0.000125>
futex(0x7f54ac1c32b8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000684>
futex(0x7f54ac1c3268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000070>
futex(0x7f54b42f45f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000117>
sched_yield()                           = 0 <0.000232>
futex(0x7f54ac1c35d8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000563>
futex(0x7f54ac1c3588, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000102>
mprotect(0x7f540c9f7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000093>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000102>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000192>
sched_yield()                           = 0 <0.000151>
futex(0x7f54ac1c38f8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000153>
futex(0x7f54ac1c38a8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000166>
futex(0x7f54ac1c38a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000181>
futex(0x7f54b42f4738, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000214>
sched_yield()                           = 0 <0.000188>
futex(0x7f54ac1c3c18, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.002128>
futex(0x7f54ac1c3bc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000180>
mprotect(0x7f540c9f8000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c9fa000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000089>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000132>
sched_yield()                           = 0 <0.000272>
futex(0x7f54ac1c3f38, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000953>
futex(0x7f54ac1c3ee8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000076>
futex(0x7f54ac1c3ee8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000160>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000109>
sched_yield()                           = 0 <0.000176>
futex(0x7f54ac1c4258, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.001299>
futex(0x7f54ac1c4208, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000186>
mprotect(0x7f540c9fc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000151>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000171>
sched_yield()                           = 0 <0.000109>
futex(0x7f54ac1c4578, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000425>
futex(0x7f54ac1c4528, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000115>
futex(0x7f54b42f47d8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000173>
sched_yield()                           = 0 <0.000193>
futex(0x7f54ac1c4898, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000724>
futex(0x7f54ac1c4848, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000147>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000139>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000071>
sched_yield()                           = 0 <0.000277>
futex(0x7f54b42f45fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000140>
sched_yield()                           = 0 <0.000115>
futex(0x7f54ac1c4ed8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000595>
futex(0x7f54ac1c4e88, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000074>
futex(0x7f54ac1c4e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000128>
futex(0x7f54b400c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000064>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000127>
sched_yield()                           = 0 <0.000061>
futex(0x7f54ac1c51f8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000545>
futex(0x7f54ac1c51a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000100>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000116>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000158>
sched_yield()                           = 0 <0.000403>
mprotect(0x7f540c9fd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000187>
sched_yield()                           = 0 <0.000168>
futex(0x7f54ac1c5838, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000615>
futex(0x7f54ac1c57e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000164>
futex(0x7f54b42f473c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000190>
futex(0x7f54b42f46e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000125>
sched_yield()                           = 0 <0.000131>
mprotect(0x7f540c9fe000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000165>
mprotect(0x7f540ca00000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000129>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000168>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000087>
sched_yield()                           = 0 <0.000312>
futex(0x7f54b42f4738, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000137>
sched_yield()                           = 0 <0.000077>
futex(0x7f54ac1c6198, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000260>
futex(0x7f54ac1c6148, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000404>
futex(0x7f54ac1c6148, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000103>
mprotect(0x7f540ca02000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540ca03000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000138>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f54077ff000 <0.000162>
mprotect(0x7f5407800000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000151>
clone(child_stack=0x7f5407ffedb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7382], tls=0x7f5407fff700, child_tidptr=0x7f5407fff9d0) = 7382 <0.000714>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f5406ffe000 <0.000156>
mprotect(0x7f5406fff000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000187>
clone(child_stack=0x7f54077fddb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7383], tls=0x7f54077fe700, child_tidptr=0x7f54077fe9d0) = 7383 <0.000491>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f54067fd000 <0.000136>
mprotect(0x7f54067fe000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000135>
clone(child_stack=0x7f5406ffcdb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7384], tls=0x7f5406ffd700, child_tidptr=0x7f5406ffd9d0) = 7384 <0.000723>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f5405ffc000 <0.000124>
mprotect(0x7f5405ffd000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000112>
clone(child_stack=0x7f54067fbdb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7385], tls=0x7f54067fc700, child_tidptr=0x7f54067fc9d0) = 7385 <0.000508>
futex(0x7f540c0af178, FUTEX_WAKE_PRIVATE, 2147483647) = 3 <0.000313>
futex(0x7f540c0af128, FUTEX_WAKE_PRIVATE, 1) = 1 <0.000243>
futex(0x7f540c0e3130, FUTEX_WAIT, 2147483648, NULL) = 0 <8.993843>
sendto(38, "\1\0\0\1\1\36\0\0\2\3def\0\0\0\10COUNT(*)\0\f?\0\25\0\0"..., 62, MSG_DONTWAIT, NULL, 0) = 62 <0.000132>

The largest wait above is in the last futex(FUTEX_WAIT), looking at memory location 0x7f540c0e3130

Counting the time spent here totals 9.04 seconds - nearly identical to the 9.18 seconds mysql reports

$ awk '/SELECT/,/sendto/ { gsub("<",""); gsub(">",""); s+=$NF } END { print s }' combined*
9.03561

Below is the strace of the TRUNCATE section

$ awk '/TRUNCATE/,/sendto/' combined-trace*

recvfrom(38, "\3\0\1TRUNCATE zapiermain.drip_sent"..., 36, MSG_DONTWAIT, NULL, NULL) = 36 <0.000135>
pread64(27, "A\223[\356\0\0\0_\377\377\377\377\377\377\377\377\0\0\0\0R?Q\316E\277\0\0\0\0\0\0"..., 16384, 1556480) = 16384 <0.000162>
pread64(27, "\261\345\23\26\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0R?\0252\0\5\0\0\0\0\0\0"..., 16384, 16384) = 16384 <0.000141>
pread64(27, "\325v\203W\0\0\0]\377\377\377\377\377\377\377\377\0\0\0\0R?R\231E\277\0\0\0\0\0\0"..., 16384, 1523712) = 16384 <0.000156>
mprotect(0x7f540ca04000, 1355776, PROT_READ|PROT_WRITE) = 0 <0.000138>
mprotect(0x7f540cb4f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000149>
mprotect(0x7f540cb50000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000165>
mprotect(0x7f540cb51000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000144>
mprotect(0x7f540cb52000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540cb56000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000129>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=465567744, ...}) = 0 <0.000179>
stat("./zapiermain/#sql-ib1081-1074994838.ibd", 0x7f54b8087380) = -1 ENOENT (No such file or directory) <0.000163>
pread64(27, "\240\315\266l\0\0\0\t\377\377\377\377\377\377\377\377\0\0\0\0R?\227\351E\277\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000205>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000154>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000151>
futex(0x7f54b5cca938, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=87246849}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001005>
futex(0x7f54b5cca8e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000095>
futex(0x7f54b5cca938, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=88776737}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001140>
futex(0x7f54b5cca8e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5cca938, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=90407495}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001097>
futex(0x7f54b5cca8e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000148>
futex(0x7f54b5cca938, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=93095635}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002013>
futex(0x7f54b5cca8e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000101>
futex(0x7f54b5cca938, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=95679299}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001722>
futex(0x7f54b5cca8e8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000137>
futex(0x7f54b5cca8e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000163>
pread64(13, "\21\10\277\327\0\0\0\10\0\0\0\0\0\0\0\0\0\0\0\0_\31\351\312\0\6\0\0\0\0\0\0"..., 16384, 131072) = 16384 <0.000133>
pread64(13, "4\336\35]\0\0\0\225\0\0\0\0\0\0\0\0\0\0\0\0R?\346\367\0\2\0\0\0\0\0\0"..., 16384, 2441216) = 16384 <0.000090>
close(34)                               = 0 <0.000134>
getcwd("/mnt/mysql", 4096)              = 11 <0.000148>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000599>
stat("./zapiermain/#sql-ib1081-1074994838.ibd", 0x7f54b8086920) = -1 ENOENT (No such file or directory) <0.000255>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=465567744, ...}) = 0 <0.000113>
rename("./zapiermain/drip_sentdrip.ibd", "./zapiermain/#sql-ib1081-1074994838.ibd") = 0 <0.000240>
getcwd("/mnt/mysql", 4096)              = 11 <0.000140>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000096>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000237>
futex(0x7f54b54995a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000152>
futex(0x7f54b5cca9dc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=110044262}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001014>
futex(0x7f54b5cca988, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000113>
futex(0x7f54b5cca9dc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=111689915}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001052>
futex(0x7f54b5cca988, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000076>
futex(0x7f54b5cca9dc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=113172150}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000803>
futex(0x7f54b5cca988, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000153>
futex(0x7f54b5cca9d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=115615084}, FUTEX_BITSET_MATCH_ANY) = 0 <0.002085>
futex(0x7f54b5cca988, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000763>
pread64(13, "\1\220\271G\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0_F\314\320\0\6\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000181>
pread64(13, "@\272\\\32\0\0\0\221\0\0\0\0\0\0\0\0\0\0\0\0R?\350\222\0\2\0\0\0\0\0\0"..., 16384, 2375680) = 16384 <0.000278>
futex(0x7f54b400c4ac, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000265>
futex(0x7f54b400c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000261>
futex(0x7f54b400c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000388>
futex(0x7f54ac000d28, FUTEX_WAKE_PRIVATE, 2147483647) = 2 <0.000146>
futex(0x7f54ac000d2c, FUTEX_WAKE_PRIVATE, 2147483647) = 2 <0.000132>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000196>
futex(0x7f54b5499648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000120>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=145460645}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001051>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000151>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=147287672}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001102>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000254>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=149049866}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000942>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000080>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=151601259}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002540>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000226>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=154724337}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001985>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000098>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=157288141}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001997>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000049>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=159595922}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002140>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000217>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=164285206}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.004107>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000078>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=168674830}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.004139>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000102>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=173280916}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.004075>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5ccad98, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=177860215}, FUTEX_BITSET_MATCH_ANY) = 0 <0.003719>
futex(0x7f54b5ccad48, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000174>
sched_yield()                           = 0 <0.000174>
futex(0x7f54ac58b55c, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.015315>
futex(0x7f54ac58b508, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000091>
futex(0x7f54ac58b508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000243>
mprotect(0x7f540cb5a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000141>
pread64(27, "\316J\2226\0\0\0^\377\377\377\377\377\377\377\377\0\0\0\0R?R\351E\277\0\0\0\0\0\0"..., 16384, 1540096) = 16384 <0.000157>
pread64(27, "\315Ic\21\0\0\0`\377\377\377\377\377\377\377\377\0\0\0\0R?R\"E\277\0\0\0\0\0\0"..., 16384, 1572864) = 16384 <0.000142>
pread64(9, "\3671^s\0\0\0\7\0\0\0\0\0\0\0\0\0\0\0\0R?I\333\0\6\0\0\0\0\0\0"..., 16384, 114688) = 16384 <0.000177>
stat("./zapiermain/drip_sentdrip.ibd", 0x7f54b8086380) = -1 ENOENT (No such file or directory) <0.000149>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000173>
futex(0x7f54b5ccb158, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=212259476}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001019>
futex(0x7f54b5ccb108, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000083>
futex(0x7f54b5ccb158, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=213725157}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001059>
futex(0x7f54b5ccb108, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000066>
futex(0x7f54b5ccb158, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=215178445}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001012>
futex(0x7f54b5ccb108, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000092>
futex(0x7f54b5ccb158, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=217540273}, FUTEX_BITSET_MATCH_ANY) = 0 <0.002014>
futex(0x7f54b5ccb108, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000072>
futex(0x7f54b5ccb108, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000082>
stat("./zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000141>
openat(AT_FDCWD, "./zapiermain/drip_sentdrip.ibd", O_RDWR|O_CREAT|O_EXCL, 0640) = 34 <0.000273>
fcntl(34, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000145>
getcwd("/mnt/mysql", 4096)              = 11 <0.000117>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000090>
mprotect(0x7f540cb5b000, 94208, PROT_READ|PROT_WRITE) = 0 <0.000045>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 114688, 0) = 114688 <0.001698>
fsync(34)                               = 0 <0.006808>
fallocate(34, FALLOC_FL_KEEP_SIZE|FALLOC_FL_PUNCH_HOLE, 0, 16384) = 0 <0.000142>
fallocate(34, FALLOC_FL_KEEP_SIZE|FALLOC_FL_PUNCH_HOLE, 0, 114688) = 0 <0.000233>
pwrite64(34, "\377F\372\272\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000165>
fsync(34)                               = 0 <0.004165>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=114688, ...}) = 0 <0.000097>
close(34)                               = 0 <0.000081>
pread64(13, "\205\35\340\301\0\0\0\n\0\0\0\0\0\0\0\0\0\0\0\0_sX\231\0\6\0\0\0\0\0\0"..., 16384, 163840) = 16384 <0.000096>
pread64(13, "\35r_\237\0\0\1\10\0\0\0\0\0\0\0\0\0\0\0\0\33\362\35\344\0\2\0\0\0\0\0\0"..., 16384, 4325376) = 16384 <0.000077>
futex(0x7f54b400c4a8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000103>
futex(0x7f54b5ccb518, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=249271970}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001103>
futex(0x7f54b5ccb4c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000275>
futex(0x7f54b5ccb518, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=251185530}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001190>
futex(0x7f54b5ccb4c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000223>
futex(0x7f54b5ccb518, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=253287266}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001060>
futex(0x7f54b5ccb4c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000450>
futex(0x7f54b400c4ac, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000557>
futex(0x7f54b400c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000406>
futex(0x7f54b400c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000300>
futex(0x7f54b5ccb798, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=263405665}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001001>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000062>
futex(0x7f54b5ccb798, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=265086161}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000938>
futex(0x7f54b5ccb748, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000121>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000107>
sched_yield()                           = 0 <0.000549>
openat(AT_FDCWD, "./zapiermain/drip_sentdrip.ibd", O_RDWR) = 34 <0.000142>
fcntl(34, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000184>
getcwd("/mnt/mysql", 4096)              = 11 <0.000107>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000092>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000042>
lseek(34, 0, SEEK_END)                  = 114688 <0.000075>
lseek(34, 0, SEEK_SET)                  = 0 <0.000094>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000059>
futex(0x7f54b5ccb79c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=271520085}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001054>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000093>
futex(0x7f54b5ccb79c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=273003145}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001027>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000315>
futex(0x7f54b5ccb79c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=274957135}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000495>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000233>
futex(0x7f54b5ccb798, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=277264826}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002229>
futex(0x7f54b5ccb748, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000276>
futex(0x7f54b5ccb748, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000057>
fallocate(34, 0, 114688, 16384)         = 0 <0.000148>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 114688) = 16384 <0.000135>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000080>
lseek(34, 0, SEEK_END)                  = 131072 <0.000138>
lseek(34, 0, SEEK_SET)                  = 0 <0.000210>
fsync(34)                               = 0 <0.006250>
pread64(13, "$\221\201i\0\0\0\v\0\0\0\0\0\0\0\0\0\0\0\0_\237\215t\0\6\0\0\0\0\0\0"..., 16384, 180224) = 16384 <0.000125>
pread64(13, "\365A\266\373\0\0\1\t\0\0\0\0\0\0\0\0\0\0\0\0\35M\241\260\0\2\0\0\0\0\0\0"..., 16384, 4341760) = 16384 <0.000068>
futex(0x7f54b5ccb978, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=292311023}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000856>
futex(0x7f54b5ccb928, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000210>
futex(0x7f54b5ccb978, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=295240832}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001091>
futex(0x7f54b5ccb928, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000062>
futex(0x7f54b5ccb978, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=296839290}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001165>
futex(0x7f54b5ccb928, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000058>
futex(0x7f54b5ccb978, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=299357497}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001701>
futex(0x7f54b5ccb928, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000111>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000296>
lseek(34, 0, SEEK_END)                  = 131072 <0.000169>
lseek(34, 0, SEEK_SET)                  = 0 <0.000154>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000118>
futex(0x7f54b54995a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000142>
futex(0x7f54b5ccba18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=304654507}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001949>
futex(0x7f54b5ccb9c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000153>
futex(0x7f54b5ccba18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=307344363}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000733>
futex(0x7f54b5ccb9c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000112>
futex(0x7f54b5ccba18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=308923295}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000948>
futex(0x7f54b5ccb9c8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000222>
fallocate(34, 0, 131072, 16384)         = 0 <0.000250>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 131072) = 16384 <0.000144>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000278>
lseek(34, 0, SEEK_END)                  = 147456 <0.000153>
lseek(34, 0, SEEK_SET)                  = 0 <0.000142>
fsync(34)                               = 0 <0.004836>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=322612756}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001132>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000099>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=324093431}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001314>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=325808482}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001029>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000103>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=328232596}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001335>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000068>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000105>
lseek(34, 0, SEEK_END)                  = 147456 <0.000088>
lseek(34, 0, SEEK_SET)                  = 0 <0.000118>
futex(0x7f54b5ccbbfc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=331331504}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001100>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000083>
futex(0x7f54b5ccbbfc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=332783388}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001088>
futex(0x7f54b5ccbba8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000084>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000060>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=334508715}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001095>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000067>
futex(0x7f54b5ccbbf8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=336952543}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001612>
futex(0x7f54b5ccbba8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000115>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000100>
futex(0x7f54b5ccbbfc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=339452097}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000339>
futex(0x7f54b5ccbba8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000102>
futex(0x7f54b5ccbba8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000114>
fallocate(34, 0, 147456, 16384)         = 0 <0.000880>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000172>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000116>
lseek(34, 0, SEEK_END)                  = 163840 <0.000128>
lseek(34, 0, SEEK_SET)                  = 0 <0.000104>
fsync(34)                               = 0 <0.007453>
pread64(13, "\263\23{\257\0\0\0\f\0\0\0\0\0\0\0\0\0\0\0\0_\314\26\26\0\6\0\0\0\0\0\0"..., 16384, 196608) = 16384 <0.000113>
pread64(13, "\275\345\272\35\0\0\1\6\0\0\0\0\0\0\0\0\0\0\0\0\35M\241\326\0\2\0\0\0\0\0\0"..., 16384, 4292608) = 16384 <0.000139>
futex(0x7f54b5ccbe78, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=355522156}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001085>
futex(0x7f54b5ccbe28, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000369>
futex(0x7f54b5ccbe78, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=357276137}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000954>
futex(0x7f54b5ccbe28, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5ccbe78, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=358727481}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001145>
futex(0x7f54b5ccbe28, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000411>
mprotect(0x7f540cb72000, 57344, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540cb80000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000104>
mprotect(0x7f540cb90000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000089>
mprotect(0x7f540cba0000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000120>
futex(0x7f54b5ccc058, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=380995631}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001112>
futex(0x7f54b5ccc008, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5ccc058, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=382513365}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001039>
futex(0x7f54b5ccc008, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000086>
futex(0x7f54b5ccc058, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=383968950}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001159>
futex(0x7f54b5ccc008, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000142>
pread64(13, "\317\314Z2\0\0\0\r\0\0\0\0\0\0\0\0\0\0\0\0_\370g\4\0\6\0\0\0\0\0\0"..., 16384, 212992) = 16384 <0.000108>
pread64(13, "|\305\230\321\0\0\1\25\0\0\0\0\0\0\0\0\0\0\0\0006\316*\35\0\2\0\0\0\0\0\0"..., 16384, 4538368) = 16384 <0.000100>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000139>
futex(0x7f54b5ccc558, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=406975854}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001116>
futex(0x7f54b5ccc508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000118>
futex(0x7f54b5ccc558, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=408599318}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000767>
futex(0x7f54b5ccc508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000170>
futex(0x7f54b5ccc55c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=410308716}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001056>
futex(0x7f54b5ccc508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000205>
futex(0x7f54b5ccc55c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=413015323}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001053>
futex(0x7f54b5ccc508, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000103>
futex(0x7f54b5ccc508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000106>
pread64(27, "\350i\215/\0\0\0R\377\377\377\377\377\377\377\377\0\0\0\0\1\r\272\326E\277\0\0\0\0\0\0"..., 16384, 1343488) = 16384 <0.000102>
pread64(27, "\222\316\5\340\0\0\0T\377\377\377\377\377\377\377\377\0\0\0\0R?\227\5E\277\0\0\0\0\0\0"..., 16384, 1376256) = 16384 <0.000095>
pread64(27, "\306\34\367\3\0\0\1\240\0\0\1\203\377\377\377\377\0\0\0\0R?\2245E\277\0\0\0\0\0\0"..., 16384, 6815744) = 16384 <0.000098>
pread64(27, "\350\37\367\25\0\0\0+\377\377\377\377\377\377\377\377\0\0\0\0R:]\317E\277\0\0\0\0\0\0"..., 16384, 704512) = 16384 <0.000412>
mprotect(0x7f540cbb0000, 53248, PROT_READ|PROT_WRITE) = 0 <0.000165>
mprotect(0x7f540cbbd000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000141>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000307>
futex(0x7f54b54995a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000206>
futex(0x7f54b5ccce18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=461481673}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000987>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000281>
futex(0x7f54b5ccce18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=463323537}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000837>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000323>
futex(0x7f54b5ccce18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=465262346}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001069>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000310>
futex(0x7f54b5ccce18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=468235126}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001986>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000065>
futex(0x7f54b5ccce18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=470739430}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001611>
futex(0x7f54b5cccdc8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000194>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000190>
write(36, "j\35yc\"\1\0\0\0M\0\0\0\351\0\0\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0"..., 185) = 185 <0.000150>
fdatasync(36)                           = 0 <0.004391>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000061>
futex(0x7f54b54995a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000049>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000186>
futex(0x7f54b5ccce1c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=480126792}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001035>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
futex(0x7f54b5ccce1c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=481609480}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000943>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000073>
futex(0x7f54b5ccce1c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=483157163}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002327>
futex(0x7f54b5cccdc8, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000419>
futex(0x7f54b5cccdc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000080>
futex(0x7f54b400c4a8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000182>
futex(0x7f54b400c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000291>
futex(0x7f54b400c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000473>
sched_yield()                           = 0 <0.000172>
futex(0x7f54ac58b558, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000191>
futex(0x7f54ac58b508, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000183>
futex(0x7f54ac58b508, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000202>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000107>
futex(0x7f54b5ccceb8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=499238281}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001156>
futex(0x7f54b5ccce68, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000092>
futex(0x7f54b5ccceb8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=500860375}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001052>
futex(0x7f54b5ccce68, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000137>
futex(0x7f54b5ccceb8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=502531869}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001018>
futex(0x7f54b5ccce68, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000068>
futex(0x7f54b5cccebc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=505305095}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000546>
futex(0x7f54b5ccce68, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000272>
getcwd("/mnt/mysql", 4096)              = 11 <0.000141>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000244>
stat("./zapiermain/#sql-ib1081-1074994838.cfg", 0x7f54b8086ee0) = -1 ENOENT (No such file or directory) <0.000190>
getcwd("/mnt/mysql", 4096)              = 11 <0.000213>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000219>
stat("./zapiermain/#sql-ib1081-1074994838.cfp", 0x7f54b8086ee0) = -1 ENOENT (No such file or directory) <0.000143>
getcwd("/mnt/mysql", 4096)              = 11 <0.000145>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000085>
unlink("./zapiermain/#sql-ib1081-1074994838.ibd") = 0 <0.184762>
pread64(27, "~9(\211\0\0\0\5\377\377\377\377\377\377\377\377\0\0\0\0l\204\313TE\277\0\0\0\0\0\0"..., 16384, 81920) = 16384 <0.000117>
pread64(27, ",/\347E\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R;#\302\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000108>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000201>
futex(0x7f54b5499648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000086>
futex(0x7f54b5cccf58, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=699745012}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001095>
futex(0x7f54b5cccf08, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000101>
futex(0x7f54b5cccf58, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=701395486}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001005>
futex(0x7f54b5cccf08, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000053>
futex(0x7f54b5cccf58, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=702720888}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001059>
futex(0x7f54b5cccf08, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000048>
futex(0x7f54b5cccf58, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=705052293}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002042>
futex(0x7f54b5cccf08, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000176>
futex(0x7f54b5cccf58, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10888, tv_nsec=707565244}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000324>
futex(0x7f54b5cccf08, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000078>
sendto(38, "\7\0\0\1\0\0\0\2\0\0\0", 11, MSG_DONTWAIT, NULL, 0) = 11 <0.000095>

Counting the time spent here totals 0.38 seconds - roughly half of the 0.65 seconds mysql reports

$ awk '/TRUNCATE/,/sendto/ { gsub("<",""); gsub(">",""); s+=$NF } END { print s }' combined*
0.376405

Below is the strace of the DROP section

$ awk '/DROP/,/sendto/' combined*

recvfrom(38, "\3\0\1DROP zapiermain.drip_sentdrip", 32, MSG_DONTWAIT, NULL, NULL) = 32 <0.000072>
sendto(38, "\263\0\0\1\377(\4#42000You have an error i"..., 183, MSG_DONTWAIT, NULL, 0) = 183 <0.000078>
recvfrom(38, "\3\0\1DROP TABLE zapiermain.drip_se"..., 38, MSG_DONTWAIT, NULL, NULL) = 38 <0.000252>
pread64(27, "\4\246S\243\0\0\0\32\377\377\377\377\377\377\377\377\0\0\0\0\1\23M\35E\277\0\0\0\0\0\0"..., 16384, 425984) = 16384 <0.000076>
pread64(27, "2O4=\0\0\3\254\0\0\1\272\377\377\377\377\0\0\0\0R?\20\241E\277\0\0\0\0\0\0"..., 16384, 15400960) = 16384 <0.000050>
pread64(27, "\274BH\177\0\0\0c\377\377\377\377\377\377\377\377\0\0\0\0\0\367\215oE\277\0\0\0\0\0\0"..., 16384, 1622016) = 16384 <0.000059>
pread64(27, "\353\266\275^\0\0\0C\377\377\377\377\377\377\377\377\0\0\0\0\1\24\361\363E\277\0\0\0\0\0\0"..., 16384, 1097728) = 16384 <0.000054>
pread64(27, "\315`@\310\0\0\0\21\377\377\377\377\377\377\377\377\0\0\0\0\0$\3358E\277\0\0\0\0\0\0"..., 16384, 278528) = 16384 <0.000053>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000085>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000121>
futex(0x7f54b5cccff8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=671862894}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001301>
futex(0x7f54b5cccfa8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000854>
futex(0x7f54b5cccff8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=674907645}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001055>
futex(0x7f54b5cccfa8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000053>
futex(0x7f54b5cccff8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=676332204}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001080>
futex(0x7f54b5cccfa8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000048>
futex(0x7f54b5cccff8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=678725036}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002246>
futex(0x7f54b5cccfa8, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000452>
futex(0x7f54b5cccfa8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000109>
pread64(13, "\304\333\300X\0\0\0\17\0\0\0\0\0\0\0\0\0\0\0\0`Q\237\r\0\6\0\0\0\0\0\0"..., 16384, 245760) = 16384 <0.000118>
pread64(13, "\352\210\322\7\0\0\0\235\0\0\0\0\0\0\0\0\0\0\0\0R?\355\324\0\2\0\0\0\0\0\0"..., 16384, 2572288) = 16384 <0.000122>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000130>
futex(0x7f54b5ccd3b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=688536036}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001071>
futex(0x7f54b5ccd368, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000107>
futex(0x7f54b5ccd3b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=690295845}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001023>
futex(0x7f54b5ccd368, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000116>
futex(0x7f54b5ccd3b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=691964549}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001045>
futex(0x7f54b5ccd368, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000110>
pread64(13, "\177\276\226t\0\0\0\16\0\0\0\0\0\0\0\0\0\0\0\0`$\311\262\0\6\0\0\0\0\0\0"..., 16384, 229376) = 16384 <0.000074>
pread64(27, "E\250A\3\0\0\1\247\0\0\0x\0\0\3\264\0\0\0\0R?\224\331E\277\0\0\0\0\0\0"..., 16384, 6930432) = 16384 <0.000057>
sched_yield()                           = 0 <0.000291>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDONLY) = 39 <0.000308>
getcwd("/mnt/mysql", 4096)              = 11 <0.001755>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000103>
lseek(39, 0, SEEK_CUR)                  = 0 <0.000128>
lseek(39, 0, SEEK_END)                  = 18874368 <0.000318>
lseek(39, 0, SEEK_SET)                  = 0 <0.000062>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 1024, 0) = 1024 <0.056541>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000115>
close(39)                               = 0 <0.000097>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDWR) = 39 <0.000136>
fcntl(39, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000103>
getcwd("/mnt/mysql", 4096)              = 11 <0.000086>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000102>
futex(0x7f54b42e60c8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000121>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000178>
mprotect(0x7f540cbcd000, 20480, PROT_READ|PROT_WRITE) = 0 <0.000096>
mprotect(0x7f540cbd2000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000082>
pread64(39, "3\323\252<\0\0\0\3\377\377\377\377\377\377\377\377\0\0\0\0Q\257\226\222E\275\0\0\0\0\0\0"..., 16384, 49152) = 16384 <0.000129>
pread64(27, "\335\214\202a\0\0\0%\377\377\377\377\377\377\377\377\0\0\0\0R?#\207E\277\0\0\0\0\0\0"..., 16384, 606208) = 16384 <0.000135>
pread64(27, "&\35\36s\0\0\0(\377\377\377\377\377\377\377\377\0\0\0\0R?\"\224E\277\0\0\0\0\0\0"..., 16384, 655360) = 16384 <0.000093>
pread64(27, "\302*\30\224\0\0\0,\377\377\377\377\377\377\377\377\0\0\0\0R; $E\277\0\0\0\0\0\0"..., 16384, 720896) = 16384 <0.000129>
pread64(27, "\263'9\332\0\0\1\263\0\0\1\211\377\377\377\377\0\0\0\0R?\35WE\277\0\0\0\0\0\0"..., 16384, 7127040) = 16384 <0.000103>
pread64(27, "\313\224\222\211\0\0\3\263\0\0\3\204\0\0\0\272\0\0\0\0R?\16RE\277\0\0\0\0\0\0"..., 16384, 15515648) = 16384 <0.000349>
pread64(27, "T\220\201\371\0\0\0\35\377\377\377\377\377\377\377\377\0\0\0\0R;#sE\277\0\0\0\0\0\0"..., 16384, 475136) = 16384 <0.000283>
pread64(27, "\373\331\250\32\0\0\3\223\0\0\0\271\0\0\3\204\0\0\0\0R?\7]E\277\0\0\0\0\0\0"..., 16384, 14991360) = 16384 <0.000433>
pread64(27, "\226z\360 \0\0\0V\377\377\377\377\377\377\377\377\0\0\0\0R?\3\365E\277\0\0\0\0\0\0"..., 16384, 1409024) = 16384 <0.000130>
pread64(27, "\26\244\235E\0\0\0Z\377\377\377\377\377\377\377\377\0\0\0\0R?\4YE\277\0\0\0\0\0\0"..., 16384, 1474560) = 16384 <0.000256>
pread64(27, "\211\237\244\375\0\0\3\257\377\377\377\377\0\0\3\261\0\0\0\0\34\206\306*E\277\0\0\0\0\0\0"..., 16384, 15450112) = 16384 <0.000114>
pread64(27, "\31\265\211\327\0\0\0\247\377\377\377\377\0\0\0\250\0\0\0\0\0^:\322E\277\0\0\0\0\0\0"..., 16384, 2736128) = 16384 <0.000110>
pread64(27, "~\230\217\366\0\0\0\31\377\377\377\377\377\377\377\377\0\0\0\0R;\212NE\277\0\0\0\0\0\0"..., 16384, 409600) = 16384 <0.000111>
pread64(27, "\339\321\371\0\0\0p\0\0\0o\0\0\0q\0\0\0\0\0+\0065E\277\0\0\0\0\0\0"..., 16384, 1835008) = 16384 <0.000158>
pread64(27, "\206\367\253\256\0\0\0002\377\377\377\377\377\377\377\377\0\0\0\0\0%_DE\277\0\0\0\0\0\0"..., 16384, 819200) = 16384 <0.000127>
pread64(27, "\30\24\35}\0\0\0.\0\0\0\0\0\0\0\0\0\0\0\0\34\206\306*\0\3\0\0\0\0\0\0"..., 16384, 753664) = 16384 <0.000103>
pread64(27, "\253\260\304\324\0\0\0t\0\0\0q\0\0\0v\0\0\0\0\0,\272jE\277\0\0\0\0\0\0"..., 16384, 1900544) = 16384 <0.000148>
pread64(27, "\206\260\300\25\0\0\1\203\0\0\1\202\0\0\1\240\0\0\0\0\0\333\271oE\277\0\0\0\0\0\0"..., 16384, 6340608) = 16384 <0.000155>
pread64(27, "\246\365M\251\0\0\0Q\377\377\377\377\377\377\377\377\0\0\0\0\0%\332\311E\277\0\0\0\0\0\0"..., 16384, 1327104) = 16384 <0.000122>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000122>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000055>
futex(0x7f54b5cce2b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=931788053}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001062>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000089>
futex(0x7f54b5cce2b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=933340011}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001128>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000082>
futex(0x7f54b5cce2b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=934885713}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001072>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000119>
futex(0x7f54b5cce2b8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=937357558}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000229>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000048>
write(36, "w\35yc\"\1\0\0\0M\0\0\0\242\1\0\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0"..., 230) = 230 <0.000093>
fdatasync(36)                           = 0 <0.003051>
futex(0x7f54b5cce2bc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=942677422}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000989>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000080>
futex(0x7f54b5cce2bc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=944053285}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001041>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000120>
futex(0x7f54b5cce2bc, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=945616397}, FUTEX_BITSET_MATCH_ANY) = -1 EAGAIN (Resource temporarily unavailable) <0.000066>
futex(0x7f54b5cce268, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000333>
futex(0x7f54b5cce268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000085>
futex(0x7f54b54995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000107>
futex(0x7f54b549969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000112>
futex(0x7f54b5cce358, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=968588993}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001021>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000102>
futex(0x7f54b5cce358, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=970071655}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001103>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000083>
futex(0x7f54b5cce358, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=971624187}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001025>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000081>
futex(0x7f54b5cce358, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=974018390}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001440>
futex(0x7f54b5cce308, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000048>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000068>
getcwd("/mnt/mysql", 4096)              = 11 <0.000089>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000073>
stat("./zapiermain/drip_sentdrip.cfg", 0x7f54b8086020) = -1 ENOENT (No such file or directory) <0.000087>
getcwd("/mnt/mysql", 4096)              = 11 <0.000055>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000098>
stat("./zapiermain/drip_sentdrip.cfp", 0x7f54b8086020) = -1 ENOENT (No such file or directory) <0.000072>
close(34)                               = 0 <0.000090>
getcwd("/mnt/mysql", 4096)              = 11 <0.000068>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000082>
unlink("./zapiermain/drip_sentdrip.ibd") = 0 <0.000469>
futex(0x7f54b54995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000095>
futex(0x7f54b5499698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000102>
futex(0x7f54b5cce35c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=980485566}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001039>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000081>
futex(0x7f54b5cce35c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=981870079}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001068>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000071>
futex(0x7f54b5cce35c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=983282331}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001051>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000074>
futex(0x7f54b5cce35c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=985656014}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002116>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000080>
futex(0x7f54b5cce35c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=10900, tv_nsec=988110906}, FUTEX_BITSET_MATCH_ANY) = 0 <0.002047>
futex(0x7f54b5cce308, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000138>
futex(0x7f54b5cce308, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000064>
sendto(38, "\7\0\0\1\0\0\0\2\0\0\0", 11, MSG_DONTWAIT, NULL, 0) = 11 <0.000164>

Counting the time spent here totals 0.1 seconds - roughly one third that of the 0.36 seconds mysql reports

$ awk '/DROP/,/sendto/ { gsub("<",""); gsub(">",""); s+=$NF } END { print s }' combined*
0.100308

Comparatively, here is a single DROP TABLE operation, without any SELECT COUNT(*) or TRUNCATE

mysql> DROP TABLE zapiermain.drip_sentdrip;
Query OK, 0 rows affected (0.50 sec)

$ awk '/DROP/,/sendto/' drop*

recvfrom(38, "\3\0\1DROP TABLE zapiermain.drip_se"..., 38, MSG_DONTWAIT, NULL, NULL) = 38 <0.000100>
mprotect(0x7f21fc021000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000083>
mprotect(0x7f21fc022000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000079>
mprotect(0x7f21fc023000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000071>
mprotect(0x7f21fc024000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000046>
mprotect(0x7f21fc025000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000064>
mprotect(0x7f21fc026000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000084>
mprotect(0x7f21fc027000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000051>
mprotect(0x7f21fc028000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000062>
mprotect(0x7f21fc029000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000068>
mprotect(0x7f21fc02a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000061>
mprotect(0x7f21fc02b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000066>
mprotect(0x7f21fc02c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc02d000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc02f000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc031000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000018>
mprotect(0x7f21fc032000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc033000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc036000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc037000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc038000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000073>
mprotect(0x7f21fc03b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000019>
mprotect(0x7f21fc03c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc03d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc03e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc03f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc040000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc041000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc043000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc044000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc046000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc047000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc048000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc04a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc04b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc04c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc04d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc04e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc04f000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc051000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc054000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc055000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc057000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc058000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc05a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000129>
mprotect(0x7f21fc05b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000044>
mprotect(0x7f21fc05c000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000019>
mprotect(0x7f21fc05e000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc061000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc062000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc063000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc064000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc065000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc066000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc076000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc077000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc078000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc07c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc07d000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc07f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc080000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc081000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc083000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc084000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc085000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc086000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000069>
mprotect(0x7f21fc087000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc088000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc089000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc08a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc08b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc08c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc08d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc08e000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc092000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc093000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc094000, 20480, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc099000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc09a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc09b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc09c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc09d000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000030>
mprotect(0x7f21fc0a3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0a7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0a8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc0a9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0aa000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0ac000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0ae000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0b0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0b1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0b2000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0b4000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0b7000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0b9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0ba000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0be000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0bf000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0c3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0c4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0c5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0c6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0c7000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0c9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0ca000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0cb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0cc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0cd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc0ce000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000014>
mprotect(0x7f21fc0cf000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0d0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000015>
mprotect(0x7f21fc0d1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0d2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
pread64(27, "R\262/\20\0\0\0\25\377\377\377\377\377\377\377\377\0\0\0\0\0$\354\342E\277\0\0\0\0\0\0"..., 16384, 344064) = 16384 <0.000058>
mprotect(0x7f21fc0d3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000018>
pread64(27, "\31C\262\350\0\0\0\27\377\377\377\377\377\377\377\377\0\0\0\0\0$\364\276E\277\0\0\0\0\0\0"..., 16384, 376832) = 16384 <0.000037>
mprotect(0x7f21fc0d4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0d5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0d6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0d7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0d8000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000018>
mprotect(0x7f21fc0da000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0dc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000016>
mprotect(0x7f21fc0dd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0de000, 20480, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0e3000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000017>
mprotect(0x7f21fc0e7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000018>
mprotect(0x7f21fc0e8000, 20480, PROT_READ|PROT_WRITE) = 0 <0.000029>
futex(0x7f22b14995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000031>
futex(0x7f22b149969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000018>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=325507317}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000968>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000014>
futex(0x7f22b1499648, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000351>
futex(0x7f22b1499648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000168>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=327552896}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000926>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000024>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=328798572}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001059>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000013>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=331003530}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002086>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000071>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=333363506}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002049>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000056>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=335695198}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002222>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000100>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=338378493}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002305>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000101>
futex(0x7f22b1cb6b18, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=343193682}, FUTEX_BITSET_MATCH_ANY) = 0 <0.002384>
futex(0x7f22b1cb6ac8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000112>
futex(0x7f22b14995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000213>
futex(0x7f22b1cb6ed8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=346982645}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000934>
futex(0x7f22b1cb6e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000288>
futex(0x7f22b1cb6ed8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=348711236}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000867>
futex(0x7f22b1cb6e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000073>
futex(0x7f22b1cb6ed8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=350107654}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001077>
futex(0x7f22b1cb6e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000066>
futex(0x7f22b1cb6ed8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=352604659}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002040>
futex(0x7f22b1cb6e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000411>
futex(0x7f22b1cb6ed8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=355978704}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001112>
futex(0x7f22b1cb6e88, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000238>
futex(0x7f22b1cb6e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000527>
pread64(27, "\326}4\216\0\0\0\t\377\377\377\377\377\377\377\377\0\0\0\0m\33\226\251E\277\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000278>
futex(0x7f22b000c4a8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000284>
futex(0x7f22b000c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000315>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000115>
futex(0x7f22b000c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000195>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000127>
futex(0x7f22b000c4a8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000054>
futex(0x7f22b000c458, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000260>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000102>
futex(0x7f22b000c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000138>
mprotect(0x7f21fc0ed000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000101>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000286>
mprotect(0x7f21fc0ee000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000120>
futex(0x7f22b000c4a8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000280>
mprotect(0x7f21fc0f2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
futex(0x7f22b000c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000231>
mprotect(0x7f21fc0f3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000114>
futex(0x7f22b000c4a8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000055>
futex(0x7f22b000c458, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000326>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000129>
mprotect(0x7f21fc0f4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000054>
futex(0x7f22b000c4ac, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000184>
futex(0x7f22b000c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000189>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000160>
mprotect(0x7f21fc0f5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f21fc0f6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000085>
mprotect(0x7f21fc0f7000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f21fc0fb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000152>
futex(0x7f22b000c458, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000215>
futex(0x7f22b000c4a8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000191>
futex(0x7f22b000c458, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000359>
mprotect(0x7f21fc0fc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f21fc0fd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000080>
mprotect(0x7f21fc0fe000, 32768, PROT_READ|PROT_WRITE) = 0 <0.000131>
mprotect(0x7f21fc106000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000109>
mprotect(0x7f21fc10a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000130>
futex(0x7f22b000c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000104>
mprotect(0x7f21fc10b000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000084>
mprotect(0x7f21fc10f000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000101>
mprotect(0x7f21fc111000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000082>
mprotect(0x7f21fc121000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000054>
mprotect(0x7f21fc123000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000036>
mprotect(0x7f21fc126000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000042>
mprotect(0x7f21fc12a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000038>
mprotect(0x7f21fc12b000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000067>
mprotect(0x7f21fc12f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000058>
mprotect(0x7f21fc130000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000096>
sched_yield()                           = 0 <0.000030>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDONLY) = 39 <0.000057>
getcwd("/mnt/mysql", 4096)              = 11 <0.000050>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000041>
lseek(39, 0, SEEK_CUR)                  = 0 <0.000034>
lseek(39, 0, SEEK_END)                  = 18874368 <0.000031>
lseek(39, 0, SEEK_SET)                  = 0 <0.000031>
pread64(39, ")>\263\275\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0m\26\7\235\0\10\0\0\0\0\0\0"..., 1024, 0) = 1024 <0.037728>
pread64(39, ")>\263\275\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0m\26\7\235\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000070>
close(39)                               = 0 <0.000042>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDWR) = 39 <0.000063>
fcntl(39, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000040>
getcwd("/mnt/mysql", 4096)              = 11 <0.000030>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000041>
pread64(39, ")>\263\275\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0m\26\7\235\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000041>
mprotect(0x7f21fc133000, 49152, PROT_READ|PROT_WRITE) = 0 <0.000041>
mprotect(0x7f21fc13f000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000088>
mprotect(0x7f21fc14f000, 65536, PROT_READ|PROT_WRITE) = 0 <0.000071>
pread64(39, "F4\317n\0\0\0\3\377\377\377\377\377\377\377\377\0\0\0\0l\213\217\215E\275\0\0\0\0\0\0"..., 16384, 49152) = 16384 <0.000063>
pread64(27, "|\221\303\216\0\0\0\272\0\0\3\263\0\0\1\242\0\0\0\0m\33\21\313E\277\0\0\0\0\0\0"..., 16384, 3047424) = 16384 <0.000087>
pread64(27, "\206\367\253\256\0\0\0002\377\377\377\377\377\377\377\377\0\0\0\0\0%_DE\277\0\0\0\0\0\0"..., 16384, 819200) = 16384 <0.000051>
pread64(27, "\246\365M\251\0\0\0Q\377\377\377\377\377\377\377\377\0\0\0\0\0%\332\311E\277\0\0\0\0\0\0"..., 16384, 1327104) = 16384 <0.000079>
futex(0x7f22b14995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000067>
futex(0x7f22b149969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000060>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=512740842}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001064>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000071>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=514032212}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001062>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000033>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=515284823}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001049>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000032>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=517616090}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000275>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000025>
write(36, "\\;yc\"\1\0\0\0M\0\0\0\351\0\0\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0"..., 230) = 230 <0.000099>
fdatasync(36)                           = 0 <0.004941>
futex(0x7f22b14995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000037>
futex(0x7f22b14995a8, FUTEX_WAKE_PRIVATE, 1) = 1 <0.000042>
futex(0x7f22b149969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000054>
futex(0x7f22b1cb7d3c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=523743027}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001042>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000049>
futex(0x7f22b1cb7d3c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=525001660}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001069>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000052>
futex(0x7f22b1cb7d3c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=526305943}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001080>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000060>
futex(0x7f22b1cb7d3c, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=528623795}, FUTEX_BITSET_MATCH_ANY) = 0 <0.000161>
futex(0x7f22b1cb7ce8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000044>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000043>
futex(0x7f22b14995fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000148>
futex(0x7f22b149969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000193>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=564874467}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001156>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000212>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=566732875}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000991>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000066>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=568185173}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001117>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000061>
futex(0x7f22b1cb7d38, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=570598107}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002121>
futex(0x7f22b1cb7ce8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000108>
futex(0x7f22b1cb7ce8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000437>
getcwd("/mnt/mysql", 4096)              = 11 <0.000459>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000438>
stat("./zapiermain/drip_sentdrip.cfg", 0x7f22b425e020) = -1 ENOENT (No such file or directory) <0.000357>
getcwd("/mnt/mysql", 4096)              = 11 <0.000168>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000760>
stat("./zapiermain/drip_sentdrip.cfp", 0x7f22b425e020) = -1 ENOENT (No such file or directory) <0.000139>
close(34)                               = 0 <0.000088>
getcwd("/mnt/mysql", 4096)              = 11 <0.000149>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000289>
unlink("./zapiermain/drip_sentdrip.ibd") = 0 <0.181558>
futex(0x7f22b14995f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000184>
futex(0x7f22b149969c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000209>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=765410689}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.000945>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000063>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=766864139}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001027>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000119>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=768429494}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.001010>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000285>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=771121105}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.002047>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000317>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=774136079}, FUTEX_BITSET_MATCH_ANY) = -1 ETIMEDOUT (Connection timed out) <0.003156>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000290>
futex(0x7f22b1cb82d8, FUTEX_WAIT_BITSET_PRIVATE, 0, {tv_sec=18554, tv_nsec=778488202}, FUTEX_BITSET_MATCH_ANY) = 0 <0.001223>
futex(0x7f22b1cb8288, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000474>
futex(0x7f22b1cb8288, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000667>
sendto(38, "\7\0\0\1\0\0\0\2\0\0\0", 11, MSG_DONTWAIT, NULL, 0) = 11 <0.000366>

Counting the time spent here totals 0.28 seconds - roughly half that of the entire operation reported by mysql

$ awk '/DROP/,/sendto/ { gsub("<",""); gsub(">",""); s+=$NF } END { print s }' drop*
0.287513

Other observations

SELECT COUNT(*)

This is protecting 4 KB chunks of memory, for a total of 41 MiB

$ awk '/SELECT/,/sendto/' combined-trace.7381 | awk -F"," '/mprotect/,/futex/ {if ($1 ~ /mprotect/) {s+=$2}} END {print s / 2^20}'
41.8867

recvfrom(38, "\3\0\1SELECT COUNT(*) FROM zapierma"..., 48, MSG_DONTWAIT, NULL, NULL) = 48 <0.000171>
mprotect(0x7f540c021000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000154>
mprotect(0x7f540c022000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c023000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000113>
mprotect(0x7f540c024000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000122>
mprotect(0x7f540c025000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c026000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000124>
mprotect(0x7f540c027000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000134>
mprotect(0x7f540c028000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000117>
mprotect(0x7f540c029000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000147>
mprotect(0x7f540c02a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000140>
mprotect(0x7f540c02b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c02c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c02d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c02e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c02f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c030000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000102>
mprotect(0x7f540c031000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000196>
mprotect(0x7f540c032000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000073>
mprotect(0x7f540c035000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c036000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c037000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c03a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c03b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c03c000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c03e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000122>
mprotect(0x7f540c03f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000102>
mprotect(0x7f540c040000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000117>
mprotect(0x7f540c042000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c043000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000142>
mprotect(0x7f540c045000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c046000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c047000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c048000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c049000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c04a000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c04c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c04d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c04e000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000116>
mprotect(0x7f540c050000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000134>
mprotect(0x7f540c053000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c054000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000109>
mprotect(0x7f540c056000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c057000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000167>
mprotect(0x7f540c059000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c05a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c05b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c05c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c05d000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c060000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c061000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c063000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000104>
mprotect(0x7f540c064000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000118>
mprotect(0x7f540c066000, 61440, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c075000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c076000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c077000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c078000, 12288, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c07b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c07c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
mprotect(0x7f540c07d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c07e000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c07f000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c080000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000132>
mprotect(0x7f540c082000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c083000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c085000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000114>
mprotect(0x7f540c087000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c088000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c089000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c08a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c08b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c08c000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000139>
mprotect(0x7f540c08d000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c08e000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c092000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000152>
mprotect(0x7f540c093000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000134>
pread64(27, "\20\1\307\273\0\0\1\326\0\0\1\325\377\377\377\377\0\0\0\0R?\217\25E\277\0\0\0\0\0\0"..., 16384, 7700480) = 16384 <0.000178>
mprotect(0x7f540c094000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000130>
mprotect(0x7f540c098000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000125>
mprotect(0x7f540c099000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000129>
mprotect(0x7f540c09a000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c09b000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000148>
mprotect(0x7f540c09c000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000141>
mprotect(0x7f540c0a0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0a1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c0a2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000137>
mprotect(0x7f540c0a3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000129>
mprotect(0x7f540c0a4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
mprotect(0x7f540c0a5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000144>
mprotect(0x7f540c0a6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c0a7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0a8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000152>
mprotect(0x7f540c0a9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0aa000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0ab000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0ac000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0ad000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000104>
mprotect(0x7f540c0ae000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0af000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000130>
pread64(27, "R\262/\20\0\0\0\25\377\377\377\377\377\377\377\377\0\0\0\0\0$\354\342E\277\0\0\0\0\0\0"..., 16384, 344064) = 16384 <0.000194>
pread64(27, "\233\0015\255\0\0\0\26\377\377\377\377\377\377\377\377\0\0\0\0\0$\360\320E\277\0\0\0\0\0\0"..., 16384, 360448) = 16384 <0.000194>
pread64(27, "\31C\262\350\0\0\0\27\377\377\377\377\377\377\377\377\0\0\0\0\0$\364\276E\277\0\0\0\0\0\0"..., 16384, 376832) = 16384 <0.000211>
mprotect(0x7f540c0b0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000153>
mprotect(0x7f540c0b1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0b2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000144>
mprotect(0x7f540c0b3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c0b4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000128>
mprotect(0x7f540c0b5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0b6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000112>
mprotect(0x7f540c0b7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000116>
mprotect(0x7f540c0b8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000123>
mprotect(0x7f540c0b9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000119>
mprotect(0x7f540c0ba000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0bb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0bc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000133>
mprotect(0x7f540c0bd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000131>
mprotect(0x7f540c0be000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0bf000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c0c0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0c1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000115>
mprotect(0x7f540c0c2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000099>
mprotect(0x7f540c0c3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000106>
mprotect(0x7f540c0c4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0c5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000183>
mprotect(0x7f540c0c6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c0c7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000097>
mprotect(0x7f540c0c8000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000143>
mprotect(0x7f540c0c9000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000101>
mprotect(0x7f540c0ca000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000118>
mprotect(0x7f540c0cb000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000100>
mprotect(0x7f540c0cc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000098>
mprotect(0x7f540c0cd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0ce000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c0d0000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000110>
mprotect(0x7f540c0d1000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000136>
mprotect(0x7f540c0d2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000140>
mprotect(0x7f540c0d3000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000125>
mprotect(0x7f540c0d4000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000124>
mprotect(0x7f540c0d5000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000107>
mprotect(0x7f540c0d6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000100>
mprotect(0x7f540c0d7000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000098>
mprotect(0x7f540c0db000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0dc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000127>
mprotect(0x7f540c0dd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0de000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540c0e2000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000103>
mprotect(0x7f540c0e3000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0e7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000108>
mprotect(0x7f540c0e8000, 16384, PROT_READ|PROT_WRITE) = 0 <0.000105>
mprotect(0x7f540c0ec000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000142>
mprotect(0x7f540c0ed000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000121>
mprotect(0x7f540c0ee000, 9469952, PROT_READ|PROT_WRITE) = 0 <0.000131>
mprotect(0x7f540c9f6000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000130>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000113>
sched_yield()                           = 0 <0.000125>
futex(0x7f54ac1c32b8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000684>
futex(0x7f54ac1c3268, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000070>
futex(0x7f54b42f45f8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000117>
sched_yield()                           = 0 <0.000232>
futex(0x7f54ac1c35d8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000563>
futex(0x7f54ac1c3588, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000102>
mprotect(0x7f540c9f7000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000093>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000102>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000192>
sched_yield()                           = 0 <0.000151>
futex(0x7f54ac1c38f8, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000153>
futex(0x7f54ac1c38a8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000166>
futex(0x7f54ac1c38a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000181>
futex(0x7f54b42f4738, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000214>
sched_yield()                           = 0 <0.000188>
futex(0x7f54ac1c3c18, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.002128>
futex(0x7f54ac1c3bc8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000180>
mprotect(0x7f540c9f8000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000126>
mprotect(0x7f540c9fa000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000089>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000132>
sched_yield()                           = 0 <0.000272>
futex(0x7f54ac1c3f38, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000953>
futex(0x7f54ac1c3ee8, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000076>
futex(0x7f54ac1c3ee8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000160>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000109>
sched_yield()                           = 0 <0.000176>
futex(0x7f54ac1c4258, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.001299>
futex(0x7f54ac1c4208, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000186>
mprotect(0x7f540c9fc000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000151>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000171>
sched_yield()                           = 0 <0.000109>
futex(0x7f54ac1c4578, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000425>
futex(0x7f54ac1c4528, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000115>
futex(0x7f54b42f47d8, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000173>
sched_yield()                           = 0 <0.000193>
futex(0x7f54ac1c4898, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000724>
futex(0x7f54ac1c4848, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000147>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000139>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000071>
sched_yield()                           = 0 <0.000277>
futex(0x7f54b42f45fc, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000140>
sched_yield()                           = 0 <0.000115>
futex(0x7f54ac1c4ed8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000595>
futex(0x7f54ac1c4e88, FUTEX_WAIT_PRIVATE, 2, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000074>
futex(0x7f54ac1c4e88, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000128>
futex(0x7f54b400c4ac, FUTEX_WAKE_PRIVATE, 2147483647) = 0 <0.000064>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000127>
sched_yield()                           = 0 <0.000061>
futex(0x7f54ac1c51f8, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000545>
futex(0x7f54ac1c51a8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000100>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000116>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000158>
sched_yield()                           = 0 <0.000403>
mprotect(0x7f540c9fd000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000156>
futex(0x7f54b42f4698, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000187>
sched_yield()                           = 0 <0.000168>
futex(0x7f54ac1c5838, FUTEX_WAIT_PRIVATE, 0, NULL) = 0 <0.000615>
futex(0x7f54ac1c57e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000164>
futex(0x7f54b42f473c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000190>
futex(0x7f54b42f46e8, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000125>
sched_yield()                           = 0 <0.000131>
mprotect(0x7f540c9fe000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000165>
mprotect(0x7f540ca00000, 8192, PROT_READ|PROT_WRITE) = 0 <0.000129>
futex(0x7f54b42f469c, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000168>
futex(0x7f54b42f4648, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000087>
sched_yield()                           = 0 <0.000312>
futex(0x7f54b42f4738, FUTEX_WAKE_PRIVATE, 2147483647) = 1 <0.000137>
sched_yield()                           = 0 <0.000077>
futex(0x7f54ac1c6198, FUTEX_WAIT_PRIVATE, 0, NULL) = -1 EAGAIN (Resource temporarily unavailable) <0.000260>
futex(0x7f54ac1c6148, FUTEX_WAIT_PRIVATE, 2, NULL) = 0 <0.000404>
futex(0x7f54ac1c6148, FUTEX_WAKE_PRIVATE, 1) = 0 <0.000103>
mprotect(0x7f540ca02000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000111>
mprotect(0x7f540ca03000, 4096, PROT_READ|PROT_WRITE) = 0 <0.000138>

This is allocating 8 MiB chunks of RAM, and initializing them to 0

Then, processes are cloned, assigning that mapped area as the children's stack

(0x7f5407ffedb0 - 0x7f54077ff000 = 0x7ffdb0 ~= 8 MiB)

mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f54077ff000 <0.000162>
mprotect(0x7f5407800000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000151>
clone(child_stack=0x7f5407ffedb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7382], tls=0x7f5407fff700, child_tidptr=0x7f5407fff9d0) = 7382 <0.000714>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f5406ffe000 <0.000156>
mprotect(0x7f5406fff000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000187>
clone(child_stack=0x7f54077fddb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7383], tls=0x7f54077fe700, child_tidptr=0x7f54077fe9d0) = 7383 <0.000491>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f54067fd000 <0.000136>
mprotect(0x7f54067fe000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000135>
clone(child_stack=0x7f5406ffcdb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7384], tls=0x7f5406ffd700, child_tidptr=0x7f5406ffd9d0) = 7384 <0.000723>
mmap(NULL, 8392704, PROT_NONE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f5405ffc000 <0.000124>
mprotect(0x7f5405ffd000, 8388608, PROT_READ|PROT_WRITE) = 0 <0.000112>
clone(child_stack=0x7f54067fbdb0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tid=[7385], tls=0x7f54067fc700, child_tidptr=0x7f54067fc9d0) = 7385 <0.000508>

8.99 seconds is spent waiting for a memory location to change

futex(0x7f540c0af178, FUTEX_WAKE_PRIVATE, 2147483647) = 3 <0.000313>
futex(0x7f540c0af128, FUTEX_WAKE_PRIVATE, 1) = 1 <0.000243>
futex(0x7f540c0e3130, FUTEX_WAIT, 2147483648, NULL) = 0 <8.993843>
sendto(38, "\1\0\0\1\1\36\0\0\2\3def\0\0\0\10COUNT(*)\0\f?\0\25\0\0"..., 62, MSG_DONTWAIT, NULL, 0) = 62 <0.000132>

Truncate operation

recvfrom(38, "\3\0\1TRUNCATE zapiermain.drip_sent"..., 36, MSG_DONTWAIT, NULL, NULL) = 36 <0.000135>
pread64(27, "A\223[\356\0\0\0_\377\377\377\377\377\377\377\377\0\0\0\0R?Q\316E\277\0\0\0\0\0\0"..., 16384, 1556480) = 16384 <0.000162>
pread64(27, "\261\345\23\26\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0R?\0252\0\5\0\0\0\0\0\0"..., 16384, 16384) = 16384 <0.000141>
pread64(27, "\325v\203W\0\0\0]\377\377\377\377\377\377\377\377\0\0\0\0R?R\231E\277\0\0\0\0\0\0"..., 16384, 1523712) = 16384 <0.000156>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=465567744, ...}) = 0 <0.000179>
stat("./zapiermain/#sql-ib1081-1074994838.ibd", 0x7f54b8087380) = -1 ENOENT (No such file or directory) <0.000163>
pread64(27, "\240\315\266l\0\0\0\t\377\377\377\377\377\377\377\377\0\0\0\0R?\227\351E\277\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000205>
pread64(13, "\21\10\277\327\0\0\0\10\0\0\0\0\0\0\0\0\0\0\0\0_\31\351\312\0\6\0\0\0\0\0\0"..., 16384, 131072) = 16384 <0.000133>
pread64(13, "4\336\35]\0\0\0\225\0\0\0\0\0\0\0\0\0\0\0\0R?\346\367\0\2\0\0\0\0\0\0"..., 16384, 2441216) = 16384 <0.000090>
close(34)                               = 0 <0.000134>
getcwd("/mnt/mysql", 4096)              = 11 <0.000148>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000599>
stat("./zapiermain/#sql-ib1081-1074994838.ibd", 0x7f54b8086920) = -1 ENOENT (No such file or directory) <0.000255>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=465567744, ...}) = 0 <0.000113>
rename("./zapiermain/drip_sentdrip.ibd", "./zapiermain/#sql-ib1081-1074994838.ibd") = 0 <0.000240>
getcwd("/mnt/mysql", 4096)              = 11 <0.000140>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000096>
pread64(13, "\1\220\271G\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0_F\314\320\0\6\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000181>
pread64(13, "@\272\\\32\0\0\0\221\0\0\0\0\0\0\0\0\0\0\0\0R?\350\222\0\2\0\0\0\0\0\0"..., 16384, 2375680) = 16384 <0.000278>
pread64(27, "\316J\2226\0\0\0^\377\377\377\377\377\377\377\377\0\0\0\0R?R\351E\277\0\0\0\0\0\0"..., 16384, 1540096) = 16384 <0.000157>
pread64(27, "\315Ic\21\0\0\0`\377\377\377\377\377\377\377\377\0\0\0\0R?R\"E\277\0\0\0\0\0\0"..., 16384, 1572864) = 16384 <0.000142>
pread64(9, "\3671^s\0\0\0\7\0\0\0\0\0\0\0\0\0\0\0\0R?I\333\0\6\0\0\0\0\0\0"..., 16384, 114688) = 16384 <0.000177>
stat("./zapiermain/drip_sentdrip.ibd", 0x7f54b8086380) = -1 ENOENT (No such file or directory) <0.000149>
stat("./zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000141>
openat(AT_FDCWD, "./zapiermain/drip_sentdrip.ibd", O_RDWR|O_CREAT|O_EXCL, 0640) = 34 <0.000273>
fcntl(34, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000145>
getcwd("/mnt/mysql", 4096)              = 11 <0.000117>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000090>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 114688, 0) = 114688 <0.001698>
fsync(34)                               = 0 <0.006808>
fallocate(34, FALLOC_FL_KEEP_SIZE|FALLOC_FL_PUNCH_HOLE, 0, 16384) = 0 <0.000142>
fallocate(34, FALLOC_FL_KEEP_SIZE|FALLOC_FL_PUNCH_HOLE, 0, 114688) = 0 <0.000233>
pwrite64(34, "\377F\372\272\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000165>
fsync(34)                               = 0 <0.004165>
stat("./zapiermain/drip_sentdrip.ibd", {st_mode=S_IFREG|0640, st_size=114688, ...}) = 0 <0.000097>
close(34)                               = 0 <0.000081>
pread64(13, "\205\35\340\301\0\0\0\n\0\0\0\0\0\0\0\0\0\0\0\0_sX\231\0\6\0\0\0\0\0\0"..., 16384, 163840) = 16384 <0.000096>
pread64(13, "\35r_\237\0\0\1\10\0\0\0\0\0\0\0\0\0\0\0\0\33\362\35\344\0\2\0\0\0\0\0\0"..., 16384, 4325376) = 16384 <0.000077>
openat(AT_FDCWD, "./zapiermain/drip_sentdrip.ibd", O_RDWR) = 34 <0.000142>
fcntl(34, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000184>
getcwd("/mnt/mysql", 4096)              = 11 <0.000107>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000092>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000042>
lseek(34, 0, SEEK_END)                  = 114688 <0.000075>
lseek(34, 0, SEEK_SET)                  = 0 <0.000094>
fallocate(34, 0, 114688, 16384)         = 0 <0.000148>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 114688) = 16384 <0.000135>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000080>
lseek(34, 0, SEEK_END)                  = 131072 <0.000138>
lseek(34, 0, SEEK_SET)                  = 0 <0.000210>
fsync(34)                               = 0 <0.006250>
pread64(13, "$\221\201i\0\0\0\v\0\0\0\0\0\0\0\0\0\0\0\0_\237\215t\0\6\0\0\0\0\0\0"..., 16384, 180224) = 16384 <0.000125>
pread64(13, "\365A\266\373\0\0\1\t\0\0\0\0\0\0\0\0\0\0\0\0\35M\241\260\0\2\0\0\0\0\0\0"..., 16384, 4341760) = 16384 <0.000068>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000296>
lseek(34, 0, SEEK_END)                  = 131072 <0.000169>
lseek(34, 0, SEEK_SET)                  = 0 <0.000154>
fallocate(34, 0, 131072, 16384)         = 0 <0.000250>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 131072) = 16384 <0.000144>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000278>
lseek(34, 0, SEEK_END)                  = 147456 <0.000153>
lseek(34, 0, SEEK_SET)                  = 0 <0.000142>
fsync(34)                               = 0 <0.004836>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000105>
lseek(34, 0, SEEK_END)                  = 147456 <0.000088>
lseek(34, 0, SEEK_SET)                  = 0 <0.000118>
fallocate(34, 0, 147456, 16384)         = 0 <0.000880>
pwrite64(34, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 147456) = 16384 <0.000172>
lseek(34, 0, SEEK_CUR)                  = 0 <0.000116>
lseek(34, 0, SEEK_END)                  = 163840 <0.000128>
lseek(34, 0, SEEK_SET)                  = 0 <0.000104>
fsync(34)                               = 0 <0.007453>
pread64(13, "\263\23{\257\0\0\0\f\0\0\0\0\0\0\0\0\0\0\0\0_\314\26\26\0\6\0\0\0\0\0\0"..., 16384, 196608) = 16384 <0.000113>
pread64(13, "\275\345\272\35\0\0\1\6\0\0\0\0\0\0\0\0\0\0\0\0\35M\241\326\0\2\0\0\0\0\0\0"..., 16384, 4292608) = 16384 <0.000139>
pread64(13, "\317\314Z2\0\0\0\r\0\0\0\0\0\0\0\0\0\0\0\0_\370g\4\0\6\0\0\0\0\0\0"..., 16384, 212992) = 16384 <0.000108>
pread64(13, "|\305\230\321\0\0\1\25\0\0\0\0\0\0\0\0\0\0\0\0006\316*\35\0\2\0\0\0\0\0\0"..., 16384, 4538368) = 16384 <0.000100>
pread64(27, "\350i\215/\0\0\0R\377\377\377\377\377\377\377\377\0\0\0\0\1\r\272\326E\277\0\0\0\0\0\0"..., 16384, 1343488) = 16384 <0.000102>
pread64(27, "\222\316\5\340\0\0\0T\377\377\377\377\377\377\377\377\0\0\0\0R?\227\5E\277\0\0\0\0\0\0"..., 16384, 1376256) = 16384 <0.000095>
pread64(27, "\306\34\367\3\0\0\1\240\0\0\1\203\377\377\377\377\0\0\0\0R?\2245E\277\0\0\0\0\0\0"..., 16384, 6815744) = 16384 <0.000098>
pread64(27, "\350\37\367\25\0\0\0+\377\377\377\377\377\377\377\377\0\0\0\0R:]\317E\277\0\0\0\0\0\0"..., 16384, 704512) = 16384 <0.000412>
write(36, "j\35yc\"\1\0\0\0M\0\0\0\351\0\0\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0"..., 185) = 185 <0.000150>
fdatasync(36)                           = 0 <0.004391>
getcwd("/mnt/mysql", 4096)              = 11 <0.000141>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000244>
stat("./zapiermain/#sql-ib1081-1074994838.cfg", 0x7f54b8086ee0) = -1 ENOENT (No such file or directory) <0.000190>
getcwd("/mnt/mysql", 4096)              = 11 <0.000213>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000219>
stat("./zapiermain/#sql-ib1081-1074994838.cfp", 0x7f54b8086ee0) = -1 ENOENT (No such file or directory) <0.000143>
getcwd("/mnt/mysql", 4096)              = 11 <0.000145>
recvfrom(38, "\3\0\1DROP TABLE zapiermain.drip_se"..., 38, MSG_DONTWAIT, NULL, NULL) = 38 <0.000252>
pread64(27, "\4\246S\243\0\0\0\32\377\377\377\377\377\377\377\377\0\0\0\0\1\23M\35E\277\0\0\0\0\0\0"..., 16384, 425984) = 16384 <0.000076>
pread64(27, "2O4=\0\0\3\254\0\0\1\272\377\377\377\377\0\0\0\0R?\20\241E\277\0\0\0\0\0\0"..., 16384, 15400960) = 16384 <0.000050>
pread64(27, "\274BH\177\0\0\0c\377\377\377\377\377\377\377\377\0\0\0\0\0\367\215oE\277\0\0\0\0\0\0"..., 16384, 1622016) = 16384 <0.000059>
pread64(27, "\353\266\275^\0\0\0C\377\377\377\377\377\377\377\377\0\0\0\0\1\24\361\363E\277\0\0\0\0\0\0"..., 16384, 1097728) = 16384 <0.000054>
pread64(27, "\315`@\310\0\0\0\21\377\377\377\377\377\377\377\377\0\0\0\0\0$\3358E\277\0\0\0\0\0\0"..., 16384, 278528) = 16384 <0.000053>
pread64(13, "\304\333\300X\0\0\0\17\0\0\0\0\0\0\0\0\0\0\0\0`Q\237\r\0\6\0\0\0\0\0\0"..., 16384, 245760) = 16384 <0.000118>
pread64(13, "\352\210\322\7\0\0\0\235\0\0\0\0\0\0\0\0\0\0\0\0R?\355\324\0\2\0\0\0\0\0\0"..., 16384, 2572288) = 16384 <0.000122>
pread64(13, "\177\276\226t\0\0\0\16\0\0\0\0\0\0\0\0\0\0\0\0`$\311\262\0\6\0\0\0\0\0\0"..., 16384, 229376) = 16384 <0.000074>
pread64(27, "E\250A\3\0\0\1\247\0\0\0x\0\0\3\264\0\0\0\0R?\224\331E\277\0\0\0\0\0\0"..., 16384, 6930432) = 16384 <0.000057>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDONLY) = 39 <0.000308>
getcwd("/mnt/mysql", 4096)              = 11 <0.001755>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000103>
lseek(39, 0, SEEK_CUR)                  = 0 <0.000128>
lseek(39, 0, SEEK_END)                  = 18874368 <0.000318>
lseek(39, 0, SEEK_SET)                  = 0 <0.000062>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 1024, 0) = 1024 <0.056541>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000115>
close(39)                               = 0 <0.000097>
openat(AT_FDCWD, "./zapiermain/drip_drip.ibd", O_RDWR) = 39 <0.000136>
fcntl(39, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0, l_len=0}) = 0 <0.000103>
getcwd("/mnt/mysql", 4096)              = 11 <0.000086>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000102>
pread64(39, "\30\201p\325\0\0\0\0\0\18\227\0\0\0\1\0\0\0\0R:\f:\0\10\0\0\0\0\0\0"..., 16384, 0) = 16384 <0.000178>
pread64(39, "3\323\252<\0\0\0\3\377\377\377\377\377\377\377\377\0\0\0\0Q\257\226\222E\275\0\0\0\0\0\0"..., 16384, 49152) = 16384 <0.000129>
pread64(27, "\335\214\202a\0\0\0%\377\377\377\377\377\377\377\377\0\0\0\0R?#\207E\277\0\0\0\0\0\0"..., 16384, 606208) = 16384 <0.000135>
pread64(27, "&\35\36s\0\0\0(\377\377\377\377\377\377\377\377\0\0\0\0R?\"\224E\277\0\0\0\0\0\0"..., 16384, 655360) = 16384 <0.000093>
pread64(27, "\302*\30\224\0\0\0,\377\377\377\377\377\377\377\377\0\0\0\0R; $E\277\0\0\0\0\0\0"..., 16384, 720896) = 16384 <0.000129>
pread64(27, "\263'9\332\0\0\1\263\0\0\1\211\377\377\377\377\0\0\0\0R?\35WE\277\0\0\0\0\0\0"..., 16384, 7127040) = 16384 <0.000103>
pread64(27, "\313\224\222\211\0\0\3\263\0\0\3\204\0\0\0\272\0\0\0\0R?\16RE\277\0\0\0\0\0\0"..., 16384, 15515648) = 16384 <0.000349>
pread64(27, "T\220\201\371\0\0\0\35\377\377\377\377\377\377\377\377\0\0\0\0R;#sE\277\0\0\0\0\0\0"..., 16384, 475136) = 16384 <0.000283>
pread64(27, "\373\331\250\32\0\0\3\223\0\0\0\271\0\0\3\204\0\0\0\0R?\7]E\277\0\0\0\0\0\0"..., 16384, 14991360) = 16384 <0.000433>
pread64(27, "\226z\360 \0\0\0V\377\377\377\377\377\377\377\377\0\0\0\0R?\3\365E\277\0\0\0\0\0\0"..., 16384, 1409024) = 16384 <0.000130>
pread64(27, "\26\244\235E\0\0\0Z\377\377\377\377\377\377\377\377\0\0\0\0R?\4YE\277\0\0\0\0\0\0"..., 16384, 1474560) = 16384 <0.000256>
pread64(27, "\211\237\244\375\0\0\3\257\377\377\377\377\0\0\3\261\0\0\0\0\34\206\306*E\277\0\0\0\0\0\0"..., 16384, 15450112) = 16384 <0.000114>
pread64(27, "\31\265\211\327\0\0\0\247\377\377\377\377\0\0\0\250\0\0\0\0\0^:\322E\277\0\0\0\0\0\0"..., 16384, 2736128) = 16384 <0.000110>
pread64(27, "~\230\217\366\0\0\0\31\377\377\377\377\377\377\377\377\0\0\0\0R;\212NE\277\0\0\0\0\0\0"..., 16384, 409600) = 16384 <0.000111>
pread64(27, "\339\321\371\0\0\0p\0\0\0o\0\0\0q\0\0\0\0\0+\0065E\277\0\0\0\0\0\0"..., 16384, 1835008) = 16384 <0.000158>
pread64(27, "\206\367\253\256\0\0\0002\377\377\377\377\377\377\377\377\0\0\0\0\0%_DE\277\0\0\0\0\0\0"..., 16384, 819200) = 16384 <0.000127>
pread64(27, "\30\24\35}\0\0\0.\0\0\0\0\0\0\0\0\0\0\0\0\34\206\306*\0\3\0\0\0\0\0\0"..., 16384, 753664) = 16384 <0.000103>
pread64(27, "\253\260\304\324\0\0\0t\0\0\0q\0\0\0v\0\0\0\0\0,\272jE\277\0\0\0\0\0\0"..., 16384, 1900544) = 16384 <0.000148>
pread64(27, "\206\260\300\25\0\0\1\203\0\0\1\202\0\0\1\240\0\0\0\0\0\333\271oE\277\0\0\0\0\0\0"..., 16384, 6340608) = 16384 <0.000155>
pread64(27, "\246\365M\251\0\0\0Q\377\377\377\377\377\377\377\377\0\0\0\0\0%\332\311E\277\0\0\0\0\0\0"..., 16384, 1327104) = 16384 <0.000122>
write(36, "w\35yc\"\1\0\0\0M\0\0\0\242\1\0\0\0\0\1\0\0\0\0\0\0\0\0\0\0\0\0"..., 230) = 230 <0.000093>
fdatasync(36)                           = 0 <0.003051>
getcwd("/mnt/mysql", 4096)              = 11 <0.000089>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000073>
stat("./zapiermain/drip_sentdrip.cfg", 0x7f54b8086020) = -1 ENOENT (No such file or directory) <0.000087>
getcwd("/mnt/mysql", 4096)              = 11 <0.000055>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000098>
stat("./zapiermain/drip_sentdrip.cfp", 0x7f54b8086020) = -1 ENOENT (No such file or directory) <0.000072>
close(34)                               = 0 <0.000090>
getcwd("/mnt/mysql", 4096)              = 11 <0.000068>
lstat("/mnt/mysql/zapiermain", {st_mode=S_IFDIR|0750, st_size=4096, ...}) = 0 <0.000082>
unlink("./zapiermain/drip_sentdrip.ibd") = 0 <0.000469>

The only data being loaded into memory (i.e., mmap() with an fd) is in file trace.7952

$ awk '/mmap/ && !/MAP_ANONYMOUS/ {print FILENAME, $0}' trace* | sort -k3,3 -rh | head
trace.7952 mmap(NULL, 3096528, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f45fc511000 <0.000147>
trace.7952 mmap(NULL, 1918592, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f45fbffb000 <0.000037>
trace.7952 mmap(NULL, 1886208, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f45fc32e000 <0.000061>
trace.7952 mmap(0x7f45fc597000, 1732608, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x86000) = 0x7f45fc597000 <0.000072>
trace.7952 mmap(0x7f45fc01d000, 1417216, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x22000) = 0x7f45fc01d000 <0.000049>
trace.7952 mmap(NULL, 1323280, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f45fc1ea000 <0.000043>
trace.7952 mmap(NULL, 1046424, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f45fc8a2000 <0.000054>
trace.7952 mmap(0x7f45fc3c4000, 901120, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x96000) = 0x7f45fc3c4000 <0.000081>
trace.7952 mmap(0x7f45fc291000, 634880, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa7000) = 0x7f45fc291000 <0.000037>
trace.7952 mmap(0x7f45fc1f7000, 630784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd000) = 0x7f45fc1f7000 <0.000047>

It totals 18 MiB - far less than the size of the table

$ awk -F"," '/mmap/ && !/MAP_ANONYMOUS/ {s+= $2} END {print s/2^20}' trace*
18.1151

$ ls -lh /mnt/mysql/zapiermain/drip_sentdrip.ibd
-rw-r----- 1 mysql mysql 444M Nov 19 13:52 /mnt/mysql/zapiermain/drip_sentdrip.ibd

Conversely, all of the mmap(MAP_ANONYMOUS) calls total 4.9 GiB

$ awk -F"," '/mmap/ && /MAP_ANONYMOUS/ {s+= $2} END {print s/2^20}' trace*
4901.76