Qihua Wu
2010-May-04 09:23 UTC
[dtrace-discuss] dtrace: one fsync will cause how many physical IO?
We are using innodb mysql, each insert (autocommit) will take about 50 ms. For each physical write, it usually takes about 10 ms, so there must be a few physical IO caused by the sql. Based on mysql doc, each sql will cause a fsync to sync the redo to disk. And one fsync will at least write the meta data and the data to disk, that''s at least 2 physical writes, is there anyway in dtrace to monitor exactly how many writes happen for a fsync? mysql> insert into t1 values(1); Query OK, 1 row affected (0.05 sec). -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/dtrace-discuss/attachments/20100504/a3b280ef/attachment.html>