by looking at the pattern defined in the server. Currently I'm using
hard-coded stuff which matches personal usage.
-2. Latency issues over slow connections. Perhaps should use compressed
-connection to speed things up?
+2. Latency issues over slow connections. Perhaps I should use
+compressed connection to speed things up, but that is not possible
+at the moment. See https://github.com/go-sql-driver/mysql/issues/24
+for more details.
3. Sometimes I see this:
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.
-4. Fix the filename encoding for example in sys:
+4. Mutex page needs to configure P_S and restore confiuration on exit.
-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%
+This is: set the appropriate settings such as
-Should be
+UPDATE setup_instruments
+SET enabled = 'YES', timed = 'YES'
+WHERE NAME LIKE 'wait/synch/mutex/innodb/%';
-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%
+However, on exit, it should restore the previous settings back to
+what they were before. Currently if you've not set p_s appropriately you
+won't get any useful information out of this page.