X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=BUGS;h=7194db2208faa2fbfcb9ce5d54711312faa39da3;hb=b958730449ac1d927c267373a68b9ae54b72c454;hp=ddabec8ac94a9156e57183691ad3196f636a7345;hpb=51686f03152ce2a2456023fc77ac9fb865ce2b43;p=pstop.git diff --git a/BUGS b/BUGS index ddabec8..7194db2 100644 --- a/BUGS +++ b/BUGS @@ -7,13 +7,10 @@ See also NEW_FEATURES for things which probably need adding soon. by looking at the pattern defined in the server. Currently I'm using hard-coded stuff which matches personal usage. -2. Only tested on MySQL 5.6 and MariaDB 10.0. It should be possible -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 +2. Latency issues over slow connections. Perhaps should use compressed connection to speed things up? -4. Sometimes I see this: +3. 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 @@ -30,28 +27,3 @@ 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% - -6. Name munging of partition tables is not working properly: - -pstop 0.0.13 - 14:53:03 xxxxxxxxxxxxxxx / 5.7.5-log, up 49m 36s [ABS] -File I/O by filename (file_summary_by_instance) -Table Name Latency %| Read Write Misc|Rd bytes Wr bytes| Ops R Ops W Ops M Ops -dw.Arch_Transaction#P#pMAX 742.12 ms 17.5%| 91.5% 8.4% 0.1%| 82.98 M 12.27 M| 12.09 k 85.8% 12.7% 1.5% -dw.Arch_TransactionMessage#P# 74.13 ms 1.7%| 65.7% 31.9% 2.5%| 9.29 M 4.09 M| 1.82 k 63.7% 28.0% 8.3% -dw.Arch_BookingNote#P#pMAX 17.49 ms 0.4%| 67.5% 23.9% 8.6%| 2.23 M 720.00 k| 433 66.1% 20.8% 13.2%%