X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=BUGS;h=48e62b4afc54a201032558f0b9c05735cfaac3f0;hb=84f9a5c41e806461c4193db0c7a0ef652b1b1357;hp=2556f67c0db992f9b2657fe50b5874003e3daed3;hpb=bba62c7e1fa806db54a4bb0e898b1cc5e952b2c8;p=pstop.git

diff --git a/BUGS b/BUGS
index 2556f67..48e62b4 100644
--- a/BUGS
+++ b/BUGS
@@ -1,7 +1,7 @@
 Bugs
 ----
 
-See also NEW_FEATURES for things which probably need adding soon. 
+See also NEW_FEATURES for things which probably need adding soon.
 
 1. Show the binlogs completely and match them properly
 by looking at the pattern defined in the server. Currently I'm using
@@ -13,7 +13,36 @@ to make this work on MySQL 5.7 but that has not been tested yet.
 3. Latency issues over slow connections. Perhaps should use compressed
 connection to speed things up?
 
-4. Inefficient collection of data. I'm calculating stuff for the
-things I'm not actually displaying, so I should split this so that
-the display part does the calculations when needed and only the raw
-values are collected.
+4. Sometimes I see this:
+
+pstop 0.0.12 -  8:46:41 xxxxxxxxxxxxx / 5.6.21-log, up 1d 22h 59m 16s   [ABS]
+Latency by Table Name (table_io_waits_summary_by_table) 239 rows
+Table Name                        Latency      %| Fetch Insert Update Delete
+xxx.xxxxxxxx                    5124.10 h +++.+%|100.0%
+xxxxxx.xxxxxxxxxxxx             5124.10 h +++.+%|100.0%
+xxxxxx.xxxxxxx                  5124.10 h +++.+%|100.0%
+xxxxxxxx.xxxxxxxxxx             5124.09 h +++.+%|100.0%
+xxxxxxxx.xxxxxxxx               5124.09 h +++.+%|100.0%
+xxxxxx.xxxx                      00:07:49  49.2%| 98.6%   0.3%          1.1%
+xxxxxxxxx.xxxxxxxxxxx            00:06:23  40.2%| 97.4%   2.4%          0.1%
+xxxxxxxxx.xxxxxxxxxx              26.25 s   2.8%|114.2%   0.1% +++.+%   0.0%
+xxxxxx.xxxxxxxx                   15.71 s   1.6%| 99.6%   0.4%
+
+with a very long latency. Related to doing backups. Need to check the cause
+of the 5124.10h ++ issue. Probably a subtraction problem of some sort.
+
+5. Fix the filename encoding for example in sys:
+
+sys.x@0024host_summary_by_sta   882.29 us   0.2%|  3.5%         96.5%|     100         |      30  33.3%         66.7%
+sys.x@0024host_summary_by_fil   861.65 us   0.2%|  3.6%         96.4%|     100         |      30  33.3%         66.7%
+sys.x@0024user_summary_by_sta   719.61 us   0.1%|  3.2%         96.8%|      60         |      18  33.3%         66.7%
+sys.x@0024innodb_buffer_stats   563.74 us   0.1%|  3.8%         96.2%|      60         |      18  33.3%         66.7%
+sys.x@0024schema_index_statis   558.13 us   0.1%|  1.8%         98.2%|      20         |       6  33.3%         66.7%
+
+Should be
+
+sys.x$host_summary_by_statist   882.29 us   0.2%|  3.5%         96.5%|     100         |      30  33.3%         66.7%
+sys.x$host_summary_by_file_io   861.65 us   0.2%|  3.6%         96.4%|     100         |      30  33.3%         66.7%
+sys.x$user_summary_by_stages    719.61 us   0.1%|  3.2%         96.8%|      60         |      18  33.3%         66.7%
+sys.x$innodb_buffer_stats       563.74 us   0.1%|  3.8%         96.2%|      60         |      18  33.3%         66.7%
+sys.x$schema_index_statistics   558.13 us   0.1%|  1.8%         98.2%|      20         |       6  33.3%         66.7%