← Back to branch summary

~ubuntu-branches/ubuntu/utopic/mysql-workbench/utopic

« back to all changes in this revision

Viewing changes to res/scripts/sys/sys_reports.js

  • Committer: Package Import Robot
  • Author(s): Dmitry Smirnov
  • Date: 2014-05-31 12:03:58 UTC
  • mfrom: (1.2.4)
  • Revision ID: package-import@ubuntu.com-20140531120358-cjik5ofkmj0fxsn8
Tags: 6.1.6+dfsg-1
* New upstream release [May 2014].
* Dropped "prtcl.patch".
* "debian/clean": better clean-up.

Show diffs side-by-side

added added

removed removed

Lines of Context:
res/scripts/sys/sys_reports.js
41
41
                ["Min Time (ms)", "min_latency", "LongInteger:ms", 80],
42
42
                ["Avg Time (ms)", "avg_latency", "LongInteger:ms", 80],
43
43
                ["Max Time (ms)", "max_latency", "LongInteger:ms", 80],
44
 
                ["Reads (#)", "count_read", "String", 80],
45
 
                ["Total Read (bytes)", "total_read", "Float", 80],
46
 
                ["Avg Read (bytes)", "avg_read", "String", 80],
 
44
                ["Reads (#)", "count_read", "LongInteger", 80],
 
45
                ["Total Read (bytes)", "total_read", "LongInteger", 80],
 
46
                ["Avg Read (bytes)", "avg_read", "Float", 80],
47
47
                ["Writes (#)", "count_write", "LongInteger", 80],
48
 
                ["Total Written (bytes)", "total_written", "String", 80],
49
 
                ["Avg Written (bytes)", "avg_written", "String", 80],
50
 
                ["Total Requested (bytes)", "total_requested", "String", 80]]
 
48
                ["Total Written (bytes)", "total_written", "LongInteger", 80],
 
49
                ["Avg Written (bytes)", "avg_written", "Float", 80],
 
50
                ["Total Requested (bytes)", "total_requested", "LongInteger", 80]]
51
51
  },
52
52
 
53
53
  {"category" : "io",
62
62
                ["Read Time (ms)", "read_latency", "LongInteger:ms", 80],
63
63
                ["Write Time (ms)", "write_latency", "LongInteger:ms", 80],
64
64
                ["Misc Time (ms)", "misc_latency", "LongInteger:ms", 80],
65
 
                ["Reads (bytes)", "count_read", "String", 80],
66
 
                ["Avg Read (bytes)", "total_read", "String", 80],
 
65
                ["Reads (bytes)", "count_read", "LongInteger", 80],
 
66
                ["Avg Read (bytes)", "total_read", "Float", 80],
67
67
                ["Writes (bytes)", "count_write", "LongInteger", 80],
68
 
                ["Total Written (bytes)", "total_written", "String", 80],
69
 
                ["Avg Written (bytes)", "avg_written", "String", 80]]
 
68
                ["Total Written (bytes)", "total_written", "LongInteger", 80],
 
69
                ["Avg Written (bytes)", "avg_written", "Float", 80]]
70
70
  },
71
71
 
72
72
  { "category" : "io",
96
96
                 ["Max Time (ms)", "max_latency", "LongInteger:ms", 80],
97
97
                 ["Avg Time (ms)", "avg_latency", "LongInteger:ms", 80],
98
98
                 ["Rows Sent (#)", "rows_sent", "LongInteger", 80],
99
 
                 ["Avg. Rows Sent (#)", "rows_sent_avg", "LongInteger", 80],
 
99
                 ["Avg. Rows Sent (#)", "rows_sent_avg", "Float", 80],
100
100
                 ["Rows Scanned (#)", "rows_examined", "LongInteger", 80],
101
 
                 ["Avg. Rows Scanned (#)", "rows_examined_avg", "LongInteger", 80],
 
101
                 ["Avg. Rows Scanned (#)", "rows_examined_avg", "Float", 80],
102
102
                 ["Temp. Tables (#)", "tmp_tables", "LongInteger", 80],
103
103
                 ["Temp. Disk Tables (#)", "tmp_disk_tables", "LongInteger", 80],
104
104
                 ["Rows Sorted (#)", "rows_sorted", "LongInteger", 80],
148
148
    "columns" : [["Query", "query", "String", 500],
149
149
                 ["Executed (#)", "exec_count", "LongInteger", 80],
150
150
                 ["Sort Merge Passes (#)", "sort_merge_passes", "LongInteger", 80],
151
 
                 ["Avg Sort Merges (#)", "avg_sort_merges", "LongInteger", 80],
 
151
                 ["Avg Sort Merges (#)", "avg_sort_merges", "Float", 80],
152
152
                 ["Sorts Using Scans (#)", "sorts_using_scans", "LongInteger", 80],
153
153
                 ["Sorts Using Range (#)", "sort_using_range", "LongInteger", 80],
154
154
                 ["Rows Sorted (#)", "rows_sorted", "LongInteger", 80],
155
 
                 ["Avg Rows Sorted (#)", "avg_rows_sorted", "LongInteger", 80],
 
155
                 ["Avg Rows Sorted (#)", "avg_rows_sorted", "Float", 80],
156
156
                 ["Digest", "digest", "String", 100]
157
157
                 ]
158
158
  },
165
165
                 ["Executed (#)", "exec_count", "LongInteger", 80],
166
166
                 ["No Index Used", "no_index_used_count", "LongInteger", 80],
167
167
                 ["No Good Index Used", "no_good_index_used_count", "LongInteger", 80],
168
 
                 ["No Index Used %", "no_index_used_pct", "String", 80],
 
168
                 ["No Index Used %", "no_index_used_pct", "Float", 80],
169
169
                 ["Digest", "digest", "String", 100]
170
170
                 ]
171
171
  },
177
177
    "columns" : [["Query", "query", "String", 300],
178
178
                 ["Executed (#)", "exec_count", "LongInteger", 80],
179
179
                 ["Errors (#)", "errors", "LongInteger", 80],
180
 
                 ["Error (%)", "error_pct", "String", 50],
 
180
                 ["Error (%)", "error_pct", "Float", 50],
181
181
                 ["Warnings (#)", "warnings", "LongInteger", 80],
182
182
                 ["Warnings (%)", "warning_pct", "Float", 50],
183
183
                 ["Digest", "digest", "String", 100]
228
228
                 ["Rows Deleted (#)", "rows_deleted", "LongInteger", 80],
229
229
                 ["Delete Time (ms)", "delete_latency", "LongInteger:ms", 80],
230
230
                 ["I/O Read Reqs (#)", "io_read_requests", "LongInteger", 80],
231
 
                 ["I/O Read (#)", "io_read", "String", 80],
 
231
                 ["I/O Read (#)", "io_read", "LongInteger", 80],
232
232
                 ["I/O Read Time (ms)", "io_read_latency", "LongInteger:ms", 80],
233
233
                 ["I/O Write Reqs (#)", "io_write_requests", "LongInteger", 80],
234
 
                 ["I/O Write (#)", "io_write", "String", 80],
 
234
                 ["I/O Write (#)", "io_write", "LongInteger", 80],
235
235
                 ["I/O Write Time (ms)", "io_write_latency", "LongInteger:ms", 80],
236
236
                 ["I/O Misc. Reqs (#)", "io_misc_requests", "LongInteger", 80],
237
237
                 ["I/O Misc. Time (ms)", "io_misc_latency", "LongInteger:ms", 80]
253
253
                 ["Rows Deleted (#)", "rows_deleted", "LongInteger", 80],
254
254
                 ["Delete Time (ms)", "delete_latency", "LongInteger:ms", 80],
255
255
                 ["I/O Read Reqs (#)", "io_read_requests", "LongInteger", 80],
256
 
                 ["I/O Read (#)", "io_read", "String", 80],
 
256
                 ["I/O Read (#)", "io_read", "LongInteger", 80],
257
257
                 ["I/O Read Time (ms)", "io_read_latency", "LongInteger:ms", 80],
258
258
                 ["I/O Write Reqs (#)", "io_write_requests", "LongInteger", 80],
259
 
                 ["I/O Write", "io_write", "String", 80],
 
259
                 ["I/O Write (#)", "io_write", "LongInteger", 80],
260
260
                 ["I/O Write Time (ms)", "io_write_latency", "LongInteger:ms", 80],
261
261
                 ["I/O Misc. Reqs (#)", "io_misc_requests", "LongInteger", 80],
262
262
                 ["I/O Misc. Time (ms)", "io_misc_latency", "LongInteger:ms", 80],
263
 
                 ["Buffer Allocated", "innodb_buffer_allocated", "String", 80],
264
 
                 ["Buffer Data", "innodb_buffer_data", "String", 80],
 
263
                 ["Buffer Allocated", "innodb_buffer_allocated", "LongInteger", 80],
 
264
                 ["Buffer Data", "innodb_buffer_data", "LongInteger", 80],
265
265
                 ["Buffer Pages", "innodb_buffer_pages", "LongInteger", 80],
266
266
                 ["Buffer Pages Hashed", "innodb_buffer_pages_hashed", "LongInteger", 80],
267
267
                 ["Buffer Pages Old", "innodb_buffer_pages_old", "LongInteger", 80],
337
337
  "description" : "Summarizes the output of the INFORMATION_SCHEMA.INNODB_BUFFER_PAGE table, aggregating by schema",
338
338
  "caption" : "InnoDB Buffer Stats by Schema",
339
339
  "columns" : [["Schema", "object_schema", "String", 200],
340
 
              ["Allocated", "allocated", "String", 80],
341
 
              ["Data", "data", "String", 80],
 
340
              ["Allocated", "allocated", "LongInteger", 80],
 
341
              ["Data", "data", "LongInteger", 80],
342
342
              ["Pages", "pages", "LongInteger", 80],
343
343
              ["Pages Hashed", "pages_hashed", "LongInteger", 80],
344
344
              ["Pages Old", "pages_old", "LongInteger", 80],
345
 
              ["Rows Cached", "rows_cached", "String", 80]
 
345
              ["Rows Cached", "rows_cached", "LongInteger", 80]
346
346
              ]
347
347
  },
348
348
               
352
352
  "caption" : "InnoDB Buffer Stats by Table",
353
353
  "columns" : [["Schema", "object_schema", "String", 200],
354
354
              ["Table", "object_name", "String", 200],
355
 
              ["Allocated", "allocated", "String", 80],
356
 
              ["Data", "data", "String", 80],
 
355
              ["Allocated", "allocated", "LongInteger", 80],
 
356
              ["Data", "data", "LongInteger", 80],
357
357
              ["Pages", "pages", "LongInteger", 80],
358
358
              ["Pages Hashed", "pages_hashed", "LongInteger", 80],
359
359
              ["Pages Old", "pages_old", "LongInteger", 80],
360
 
              ["Rows Cached", "rows_cached", "String", 80]
 
360
              ["Rows Cached", "rows_cached", "LongInteger", 80]
361
361
              ]
362
362
  }
363
363
]