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

diff --git a/BUGS b/BUGS
index 3a1eed7..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
@@ -15,18 +15,34 @@ connection to speed things up?
 
 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%                                                                                                                    
+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%