from my home system. Oh and if you didn't know already I use wordpress.
This system is _very_ lightly loaded.
-pstop 0.0.10 - 21:40:51 xxxxxxxxxxxxx / 5.6.16-log, up 13m 7s [ABS]
+pstop 0.0.10 - 21:40:51 xxxxxxxxxxxxx / 5.6.xx-log, up 13m 7s [ABS]
Latency by Table Name (table_io_waits_summary_by_table) 10 rows
Table Name Latency %| Fetch Insert Update Delete
wordpress.wp_comments 1.34 s 75.0%| 99.6% 0.4%
-----------------------------------------------------------------------------
-pstop 0.0.10 - 21:42:01 xxxxxxxxxxxxx / 5.6.16-log, up 14m 17s [ABS]
+pstop 0.0.10 - 21:42:01 xxxxxxxxxxxxx / 5.6.xx-log, up 14m 17s [ABS]
Operations by Table Name (table_io_waits_summary_by_table) 10 rows
Table Name Ops %| Fetch Insert Update Delete
wordpress.wp_comments 85.91 k 57.3%|100.0% 0.0%
-----------------------------------------------------------------------------
-pstop 0.0.10 - 21:43:10 xxxxxxxxxxxxx / 5.6.16-log, up 15m 26s [ABS]
+pstop 0.0.10 - 21:43:10 xxxxxxxxxxxxx / 5.6.xx-log, up 15m 26s [ABS]
File I/O by filename (file_summary_by_instance)
Table Name Latency %| Read Write Misc|Rd bytes Wr bytes| Ops R Ops W Ops M Ops
<redo_log> 7.22 s 47.3%| 0.1% 99.9%| 68.00 k 82.50 k| 240 2.5% 47.5% 50.0%
-----------------------------------------------------------------------------
-pstop 0.0.10 - 21:44:27 xxxxxxxxxxxxx / 5.6.16-log, up 16m 43s [ABS]
+pstop 0.0.10 - 21:44:27 xxxxxxxxxxxxx / 5.6.xx-log, up 16m 43s [ABS]
Locks by Table Name (table_lock_waits_summary_by_table)
Table Name Latency %| Read Write|S.Lock High NoIns Normal Extrnl|AlloWr CncIns Low Normal Extrnl
wordpress.wp_options 4.15 ms 50.4%| 97.2% 2.8%| 34.1% 63.1%| 0.8% 1.9%
wordpress.wp_links 42.85 us 0.5%|100.0% | 24.3% 75.7%|
| | |
TOTALS 8.24 ms 100.0%| 95.6% 4.4%| 30.8% 64.8%| 1.1% 2.9%
+
+-----------------------------------------------------------------------------
+
+pstop 0.1.4 - 0:37:29 xxxxxxxxxxxxxxx / 5.6.xx-log, up 170d 13h 19m 1s [REL] 26 seconds
+Activity by Username (processlist) 11 rows
+User |Run Time %| Sleep %|Conn Actv|Hosts DBs|Sel Ins Upd Del Oth|
+aaaaaaaaa | |00:04:01 72.4%|1146 1| 573 1| 1 |
+bbbbbbbbbbbb | |00:01:04 19.2%| 2 | 1 | |
+ccccccccc | |00:00:26 7.8%| 5 1| 3 1| |
+ddddddd | |00:00:02 0.6%| 9 | 4 1| |
+eeeeeeeee | | | 62 7| 62 | |
+fffffffff | | | 24 | 17 1| |
+gggggggg | | | 2 | 2 1| |
+hhhhh | | | 1 1| 1 1| 1 |
+iiiiiiiiiiiiii| | | 1 1| 1 | |
+jjjjjjjjjjjj | | | 1 1| 1 | |
+kkkkkkkkkkkkkk| | | 1 1| 1 | |
+...
+ | | | | | |
+Totals | |00:05:33 100.0%|1254 13| | 2 |