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. Latency issues over slow connections. Perhaps I should use
11 compressed connection to speed things up, but that is not possible
12 at the moment. See https://github.com/go-sql-driver/mysql/issues/24
15 3. Sometimes I see this:
17 pstop 0.0.12 - 8:46:41 xxxxxxxxxxxxx / 5.6.21-log, up 1d 22h 59m 16s [ABS]
18 Latency by Table Name (table_io_waits_summary_by_table) 239 rows
19 Table Name Latency %| Fetch Insert Update Delete
20 xxx.xxxxxxxx 5124.10 h +++.+%|100.0%
21 xxxxxx.xxxxxxxxxxxx 5124.10 h +++.+%|100.0%
22 xxxxxx.xxxxxxx 5124.10 h +++.+%|100.0%
23 xxxxxxxx.xxxxxxxxxx 5124.09 h +++.+%|100.0%
24 xxxxxxxx.xxxxxxxx 5124.09 h +++.+%|100.0%
25 xxxxxx.xxxx 00:07:49 49.2%| 98.6% 0.3% 1.1%
26 xxxxxxxxx.xxxxxxxxxxx 00:06:23 40.2%| 97.4% 2.4% 0.1%
27 xxxxxxxxx.xxxxxxxxxx 26.25 s 2.8%|114.2% 0.1% +++.+% 0.0%
28 xxxxxx.xxxxxxxx 15.71 s 1.6%| 99.6% 0.4%
30 with a very long latency. Related to doing backups. Need to check the cause
31 of the 5124.10h ++ issue. Probably a subtraction problem of some sort.