Using the Embedded InnoDB plugin I’m working on, you can use the INNODB_STATUS table function in the data_dictionary, you can do pretty neat things.<\/p>\n
For example, we can see that each autocommit transaction causes an fsync and if you insert multiple rows ina \u00c2\u00a0single statement, you still only get 1 fsync:<\/p>\n
drizzle> SELECT * FROM DATA_DICTIONARY.INNODB_STATUS\r\n -> WHERE name=\"fsync_req_done\";\r\n+----------------+-------+\r\n| NAME | VALUE |\r\n+----------------+-------+\r\n| fsync_req_done | 25 |\r\n+----------------+-------+\r\n1 row in set (0 sec)\r\n\r\ndrizzle> insert into t1 values (1);\r\nQuery OK, 1 row affected (0.05 sec)\r\n\r\ndrizzle> SELECT * FROM DATA_DICTIONARY.INNODB_STATUS WHERE name=\"fsync_req_done\";\r\n+----------------+-------+\r\n| NAME | VALUE |\r\n+----------------+-------+\r\n| fsync_req_done | 26 |\r\n+----------------+-------+\r\n1 row in set (0 sec)\r\n\r\ndrizzle> insert into t1 values (1),(2),(3),(4);Query OK, 4 rows affected (0 sec)\r\nRecords: 4 Duplicates: 0 Warnings: 0\r\n\r\ndrizzle> SELECT * FROM DATA_DICTIONARY.INNODB_STATUS WHERE name=\"fsync_req_done\";\r\n+----------------+-------+\r\n| NAME | VALUE |\r\n+----------------+-------+\r\n| fsync_req_done | 27 |\r\n+----------------+-------+\r\n1 row in set (0 sec)<\/pre>\n","protected":false},"excerpt":{"rendered":"Using the Embedded InnoDB plugin I’m working on, you can use the INNODB_STATUS table function in the data_dictionary, you can do pretty neat things. For example, we can see that each autocommit transaction causes an fsync and if you insert … Continue reading