4 See also NEW_FEATURES for things which probably need adding soon.
6 1. Show the binlogs completely and match them properly
7 by looking at the pattern defined in the server. Currently I'm using
8 hard-coded stuff which matches personal usage.
10 2. Only tested on MySQL 5.6 and MariaDB 10.0. It should be possible
11 to make this work on MySQL 5.7 but that has not been tested yet.
13 3. Latency issues over slow connections. Perhaps should use compressed
14 connection to speed things up?
16 4. Sometimes I see this:
18 pstop 0.0.12 - 8:46:41 xxxxxxxxxxxxx / 5.6.21-log, up 1d 22h 59m 16s [ABS]
19 Latency by Table Name (table_io_waits_summary_by_table) 239 rows
20 Table Name Latency %| Fetch Insert Update Delete
21 xxx.xxxxxxxx 5124.10 h +++.+%|100.0%
22 xxxxxx.xxxxxxxxxxxx 5124.10 h +++.+%|100.0%
23 xxxxxx.xxxxxxx 5124.10 h +++.+%|100.0%
24 xxxxxxxx.xxxxxxxxxx 5124.09 h +++.+%|100.0%
25 xxxxxxxx.xxxxxxxx 5124.09 h +++.+%|100.0%
26 xxxxxx.xxxx 00:07:49 49.2%| 98.6% 0.3% 1.1%
27 xxxxxxxxx.xxxxxxxxxxx 00:06:23 40.2%| 97.4% 2.4% 0.1%
28 xxxxxxxxx.xxxxxxxxxx 26.25 s 2.8%|114.2% 0.1% +++.+% 0.0%
29 xxxxxx.xxxxxxxx 15.71 s 1.6%| 99.6% 0.4%
31 with a very long latency. Related to doing backups. Need to check the cause
32 of the 5124.10h ++ issue. Probably a subtraction problem of some sort.
34 5. Fix the filename encoding for example in sys:
36 sys.x@0024host_summary_by_sta 882.29 us 0.2%| 3.5% 96.5%| 100 | 30 33.3% 66.7%
37 sys.x@0024host_summary_by_fil 861.65 us 0.2%| 3.6% 96.4%| 100 | 30 33.3% 66.7%
38 sys.x@0024user_summary_by_sta 719.61 us 0.1%| 3.2% 96.8%| 60 | 18 33.3% 66.7%
39 sys.x@0024innodb_buffer_stats 563.74 us 0.1%| 3.8% 96.2%| 60 | 18 33.3% 66.7%
40 sys.x@0024schema_index_statis 558.13 us 0.1%| 1.8% 98.2%| 20 | 6 33.3% 66.7%
44 sys.x$host_summary_by_statist 882.29 us 0.2%| 3.5% 96.5%| 100 | 30 33.3% 66.7%
45 sys.x$host_summary_by_file_io 861.65 us 0.2%| 3.6% 96.4%| 100 | 30 33.3% 66.7%
46 sys.x$user_summary_by_stages 719.61 us 0.1%| 3.2% 96.8%| 60 | 18 33.3% 66.7%
47 sys.x$innodb_buffer_stats 563.74 us 0.1%| 3.8% 96.2%| 60 | 18 33.3% 66.7%
48 sys.x$schema_index_statistics 558.13 us 0.1%| 1.8% 98.2%| 20 | 6 33.3% 66.7%