Rename state to app and furhter cleanups
[pstop.git] / BUGS
1 Bugs
2 ----
3
4 See also NEW_FEATURES for things which probably need adding soon.
5
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.
9
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
13 for more details.
14
15 3. Sometimes I see this:
16
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%
29
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.
32
33 4. Mutex page needs to configure P_S and restore confiuration on exit.
34
35 This is: set the appropriate settings such as
36
37 UPDATE setup_instruments
38 SET enabled = 'YES', timed = 'YES'
39 WHERE NAME LIKE 'wait/synch/mutex/innodb/%';
40
41 However, on exit, it should restore the previous settings back to
42 what they were before.  Currently if you've not set p_s appropriately you
43 won't get any useful information out of this page.