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).
_______________________________________________ dtrace-discuss mailing list dtrace-discuss@opensolaris.org