Percona Ganglia MySQL Templates

Merge lp:~rodrigo-gadea-percona/percona-ganglia-mysql/graphs into lp:percona-ganglia-mysql/0.5-beta

  1. graphs
  2. Merge into trunk
Proposed by Rodrigo Gadea
Status: Merged
Approved by: Vadim Tkachenko
Approved revision: 12
Merge reported by: Vadim Tkachenko
Merged at revision: not available
Proposed branch: lp:~rodrigo-gadea-percona/percona-ganglia-mysql/graphs
Merge into: lp:percona-ganglia-mysql/0.5-beta
Diff against target: 1702 lines (+1430/-4)
48 files modified
INSTALL (+13/-4)
conf/default.json (+3/-0)
graph.d/innodb_adaptative_hash_indexes.json (+21/-0)
graph.d/innodb_buffer_pool.json (+34/-0)
graph.d/innodb_buffer_pool_activity.json (+29/-0)
graph.d/innodb_buffer_pool_report.json (+8/-0)
graph.d/innodb_checkpoint_age.json (+15/-0)
graph.d/innodb_current_locks_wait.json (+14/-0)
graph.d/innodb_insert_buffer.json (+29/-0)
graph.d/innodb_insert_buffer_usage.json (+27/-0)
graph.d/innodb_internal_hash_struct.json (+50/-0)
graph.d/innodb_io.json (+36/-0)
graph.d/innodb_io_pending.json (+62/-0)
graph.d/innodb_lock_structures.json (+14/-0)
graph.d/innodb_log.json (+14/-0)
graph.d/innodb_log_activity.json (+29/-0)
graph.d/innodb_memory_allocation.json (+22/-0)
graph.d/innodb_row_lock_time.json (+14/-0)
graph.d/innodb_row_lock_waits.json (+15/-0)
graph.d/innodb_row_operations.json (+37/-0)
graph.d/innodb_semaphores.json (+29/-0)
graph.d/innodb_semaphores_waits.json (+15/-0)
graph.d/innodb_semaphores_waits_times.json (+14/-0)
graph.d/innodb_tables_in_use.json (+21/-0)
graph.d/innodb_transaction_activity.json (+32/-0)
graph.d/innodb_transactions_active_locked.json (+21/-0)
graph.d/innodb_transactions_report.json (+36/-0)
graph.d/myisam_indexes.json (+39/-0)
graph.d/myisam_key_cache.json (+28/-0)
graph.d/mysql_binary_relay_logs.json (+34/-0)
graph.d/mysql_command_counters.json (+75/-0)
graph.d/mysql_connections.json (+21/-0)
graph.d/mysql_connections_types.json (+36/-0)
graph.d/mysql_files_tables.json (+29/-0)
graph.d/mysql_handlers.json (+71/-0)
graph.d/mysql_network_report.json (+10/-0)
graph.d/mysql_network_traffic.json (+22/-0)
graph.d/mysql_process_list.json (+104/-0)
graph.d/mysql_query_cache.json (+43/-0)
graph.d/mysql_query_cache_memory.json (+36/-0)
graph.d/mysql_replication.json (+36/-0)
graph.d/mysql_rows_sorted.json (+15/-0)
graph.d/mysql_select_types.json (+43/-0)
graph.d/mysql_sorts.json (+26/-0)
graph.d/mysql_table_cached.json (+14/-0)
graph.d/mysql_table_locks.json (+29/-0)
graph.d/mysql_temporary_objects.json (+29/-0)
graph.d/mysql_transaction_handler.json (+36/-0)
To merge this branch: bzr merge lp:~rodrigo-gadea-percona/percona-ganglia-mysql/graphs
Reviewer Review Type Date Requested Status
Vadim Tkachenko Approve
Review via email: mp+68766@code.launchpad.net

Description of the change

Added graph definitions, configuration file and documentation of them.

To post a comment you must log in.
Revision history for this message
Vadim Tkachenko (vadim-tk) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'INSTALL'
2--- INSTALL 2011-06-24 19:35:37 +0000
3+++ INSTALL 2011-07-22 02:23:23 +0000
4@@ -5,7 +5,19 @@
5 NOTE: This document assumes you have Ganglia
6 installed and configured (see README).
7
8-
9+- Copy the graph definitions in the graph.d/ subdirectory to Ganglia's graph.d/
10+(usually /var/www/gweb/graph.d).
11+
12+- If you have other graphs defined in Ganglia besides the default ones, copy the
13+default.json file included in the conf/ subdirectory to Ganglia's one
14+(usually /var/lib/ganglia/conf). Otherwise, add the content of the array in the
15+distributed file to yours.
16+
17+This file contains the graphs to be shown in the web interface - all by default.
18+You may edit it to fit your needs.
19+
20+You may have to delete the ganglia_metrics.cache file in the conf/ directory
21+in order to rebuild the cache if the graphs are not shown.
22
23 USAGE
24 =====
25@@ -16,7 +28,6 @@
26 - php works in command line mode
27 - gmetric binary is accessible ( i.e through your $PATH environment variable)
28
29-
30 SYNOPSIS
31 --------
32
33@@ -24,7 +35,6 @@
34 [[--user USER] [--pass PASSWORD] [--port PORT]]
35 [--gmetric_param]
36
37-
38 OPTIONS
39 -------
40
41@@ -44,7 +54,6 @@
42 --gmetric_param "STRING"
43 Additional parameters for gmetric (passed directly).
44
45-
46 EXAMPLES
47 ========
48
49
50=== added directory 'conf'
51=== added file 'conf/default.json'
52--- conf/default.json 1970-01-01 00:00:00 +0000
53+++ conf/default.json 2011-07-22 02:23:23 +0000
54@@ -0,0 +1,3 @@
55+{
56+ "included_reports": ["load_report","mem_report","cpu_report","network_report","innodb_adaptative_hash_indexes","mysql_binary_relay_logs","innodb_buffer_pool_activity","innodb_buffer_pool","innodb_current_locks_wait","innodb_insert_buffer","innodb_insert_buffer_usage","innodb_internal_hash_struct","innodb_io","innodb_io_pending","innodb_lock_structures","innodb_log","innodb_memory_allocation","innodb_row_lock_time","innodb_row_lock_waits","innodb_row_operations","innodb_semaphores","innodb_semaphores_waits","innodb_semaphores_waits_times","innodb_tables_in_use","innodb_transactions_active_locked","innodb_transactions_report","myisam_indexes","myisam_key_cache","mysql_command_counters","mysql_connections","mysql_connections_types","mysql_files_tables","mysql_handlers","mysql_network_traffic","mysql_process_list","mysql_query_cache","mysql_query_cache_memory","mysql_replication","mysql_select_types","mysql_sorts","mysql_rows_sorted","mysql_table_locks","mysql_temporary_objects","mysql_transaction_handler"]
57+}
58
59=== added directory 'graph.d'
60=== added file 'graph.d/innodb_adaptative_hash_indexes.json'
61--- graph.d/innodb_adaptative_hash_indexes.json 1970-01-01 00:00:00 +0000
62+++ graph.d/innodb_adaptative_hash_indexes.json 2011-07-22 02:23:23 +0000
63@@ -0,0 +1,21 @@
64+{
65+ "report_name": "innodb_adaptative_hash_index",
66+ "report_type": "standard",
67+ "title": "- InnoDB Adaptive Hash Index @",
68+ "vertical_label": "Cells",
69+ "series": [
70+ {
71+ "metric": "hash_index_cells_total",
72+ "label": "Total Cells",
73+ "color": "0C4E5D",
74+ "type": "line",
75+ "line_width": "2"
76+ },
77+ {
78+ "metric": "hash_index_cells_used",
79+ "label": "Used Cells",
80+ "color": "D9C7A3",
81+ "type": "stack"
82+ }
83+ ]
84+}
85
86=== added file 'graph.d/innodb_buffer_pool.json'
87--- graph.d/innodb_buffer_pool.json 1970-01-01 00:00:00 +0000
88+++ graph.d/innodb_buffer_pool.json 2011-07-22 02:23:23 +0000
89@@ -0,0 +1,34 @@
90+{
91+ "report_name": "innodb_buffer_pool",
92+ "report_type": "standard",
93+ "title": "- InnoDB Buffer Pool @",
94+ "vertical_label": "Pages",
95+ "series": [
96+ {
97+ "metric": "pool_size",
98+ "label": "Total Pool Size",
99+ "color": "3D1500",
100+ "type": "line",
101+ "line_width": "2"
102+ },
103+ {
104+ "metric": "database_pages",
105+ "label": "Used Pages",
106+ "color": "EDAA41",
107+ "type": "stack"
108+ },
109+ {
110+ "metric": "free_pages",
111+ "label": "Free Pages",
112+ "color": "AA3B27",
113+ "type": "stack"
114+ },
115+ {
116+ "metric": "modified_pages",
117+ "label": "Modified",
118+ "color": "1A9850",
119+ "type": "line",
120+ "line_width": "2"
121+ }
122+ ]
123+}
124
125=== added file 'graph.d/innodb_buffer_pool_activity.json'
126--- graph.d/innodb_buffer_pool_activity.json 1970-01-01 00:00:00 +0000
127+++ graph.d/innodb_buffer_pool_activity.json 2011-07-22 02:23:23 +0000
128@@ -0,0 +1,29 @@
129+{
130+ "report_name": "innodb_buffer_pool_activity",
131+ "report_type": "standard",
132+ "title": "- InnoDB Buffer Pool Activity @",
133+ "vertical_label": "Pages/sec",
134+ "series": [
135+ {
136+ "metric": "pages_created",
137+ "label": "Pages Created",
138+ "color": "D6883A",
139+ "type": "line",
140+ "line_width": "2"
141+ },
142+ {
143+ "metric": "pages_read",
144+ "label": "Pages Read",
145+ "color": "E6D883",
146+ "type": "line",
147+ "line_width": "2"
148+ },
149+ {
150+ "metric": "pages_written",
151+ "label": "Pages Written",
152+ "color": "55AD84",
153+ "type": "line",
154+ "line_width": "2"
155+ }
156+ ]
157+}
158
159=== added file 'graph.d/innodb_buffer_pool_report.json'
160--- graph.d/innodb_buffer_pool_report.json 1970-01-01 00:00:00 +0000
161+++ graph.d/innodb_buffer_pool_report.json 2011-07-22 02:23:23 +0000
162@@ -0,0 +1,8 @@
163+{
164+ "report_name": "innodb_buffer_pool_ng",
165+ "report_type": "template",
166+ "title": "- InnoDB Buffer Pool 2 @",
167+ "vertical_label": "Pages",
168+
169+ "graphite": "target=alias(HOST_CLUSTER.database_pages.sum,'Used')&target=alias(HOST_CLUSTER.free_pages.sum%2C'Free')&target=alias(HOST_CLUSTER.modified_pages.sum,'Modified')&target=alias(HOST_CLUSTER.pool_size.sum,'Total')&areaMode=stacked&max=100&colorList=3d1500,edaa41,aa3b27,13343B"
170+}
171
172=== added file 'graph.d/innodb_checkpoint_age.json'
173--- graph.d/innodb_checkpoint_age.json 1970-01-01 00:00:00 +0000
174+++ graph.d/innodb_checkpoint_age.json 2011-07-22 02:23:23 +0000
175@@ -0,0 +1,15 @@
176+{
177+ "report_name": "innodb_checkpoint_age",
178+ "report_type": "standard",
179+ "title": "InnoDB Checkpoint Age",
180+ "vertical_label": "Bytes",
181+ "series": [
182+ {
183+ "metric": "uncheckpointed_bytes",
184+ "label": "Uncheckpointed Bytes",
185+ "color": "F781BF",
186+ "type": "stack",
187+ "line_width": "2"
188+ }
189+ ]
190+}
191
192=== added file 'graph.d/innodb_current_locks_wait.json'
193--- graph.d/innodb_current_locks_wait.json 1970-01-01 00:00:00 +0000
194+++ graph.d/innodb_current_locks_wait.json 2011-07-22 02:23:23 +0000
195@@ -0,0 +1,14 @@
196+{
197+ "report_name": "innodb_current_lock_waits",
198+ "report_type": "standard",
199+ "title": "- InnoDB Current Lock Waiting Time @",
200+ "vertical_label": "Seconds",
201+ "series": [
202+ {
203+ "metric": "innodb_lock_wait_secs",
204+ "label": "Lock Waiting",
205+ "color": "201A33",
206+ "type": "stack"
207+ }
208+ ]
209+}
210
211=== added file 'graph.d/innodb_insert_buffer.json'
212--- graph.d/innodb_insert_buffer.json 1970-01-01 00:00:00 +0000
213+++ graph.d/innodb_insert_buffer.json 2011-07-22 02:23:23 +0000
214@@ -0,0 +1,29 @@
215+{
216+ "report_name": "innodb_insert_buffer",
217+ "report_type": "standard",
218+ "title": "- InnoDB Insert Buffer @",
219+ "vertical_label": "Ops/sec",
220+ "series": [
221+ {
222+ "metric": "ibuf_inserts",
223+ "label": "INSERT operations",
224+ "color": "157419",
225+ "type": "line",
226+ "line_width": "2"
227+ },
228+ {
229+ "metric": "ibuf_merged",
230+ "label": "MERGED RECORD operations",
231+ "color": "0000FF",
232+ "type": "line",
233+ "line_width": "2"
234+ },
235+ {
236+ "metric": "ibuf_merges",
237+ "label": "MERGE operations",
238+ "color": "862F2F",
239+ "type": "line",
240+ "line_width": "2"
241+ }
242+ ]
243+}
244
245=== added file 'graph.d/innodb_insert_buffer_usage.json'
246--- graph.d/innodb_insert_buffer_usage.json 1970-01-01 00:00:00 +0000
247+++ graph.d/innodb_insert_buffer_usage.json 2011-07-22 02:23:23 +0000
248@@ -0,0 +1,27 @@
249+{
250+ "report_name": "innodb_insert_buffer_usage",
251+ "report_type": "standard",
252+ "title": "- InnoDB Insert Buffer Usage @",
253+ "vertical_label": "Cells",
254+ "series": [
255+ {
256+ "metric": "ibuf_free_cells",
257+ "label": "Free Cells",
258+ "color": "7FBF7B",
259+ "type": "stack"
260+ },
261+ {
262+ "metric": "ibuf_used_cells",
263+ "label": "Used Cells",
264+ "color": "15AAf9",
265+ "type": "stack"
266+ },
267+ {
268+ "metric": "ibuf_cell_count",
269+ "label": "Allocated Cells",
270+ "color": "157419",
271+ "type": "line",
272+ "line_width": "2"
273+ }
274+ ]
275+}
276
277=== added file 'graph.d/innodb_internal_hash_struct.json'
278--- graph.d/innodb_internal_hash_struct.json 1970-01-01 00:00:00 +0000
279+++ graph.d/innodb_internal_hash_struct.json 2011-07-22 02:23:23 +0000
280@@ -0,0 +1,50 @@
281+{
282+ "report_name": "innodb_internal_hash_struct",
283+ "report_type": "standard",
284+ "vertical_label": "Bytes",
285+ "title": "- InnoDB Internal Hash Memory Usage @",
286+ "series": [
287+ {
288+ "metric": "adaptive_hash_memory",
289+ "label": "Adaptive Hash Memory",
290+ "color": "1B9E77",
291+ "type": "stack"
292+ },
293+ {
294+ "metric": "page_hash_memory",
295+ "label": "Page Hash Memory",
296+ "color": "D95F02",
297+ "type": "stack"
298+ },
299+ {
300+ "metric": "dictionary_cache_memory",
301+ "label": "Dictionary Cache Memory",
302+ "color": "7570B3",
303+ "type": "stack"
304+ },
305+ {
306+ "metric": "file_system_memory",
307+ "label": "File System Memory",
308+ "color": "E7298A",
309+ "type": "stack"
310+ },
311+ {
312+ "metric": "lock_system_memory",
313+ "label": "Lock System Memory",
314+ "color": "66A61E",
315+ "type": "stack"
316+ },
317+ {
318+ "metric": "recovery_system_memory",
319+ "label": "Recovery System Memory",
320+ "color": "E6AB02",
321+ "type": "stack"
322+ },
323+ {
324+ "metric": "thread_hash_memory",
325+ "label": "Thread Hash Memory",
326+ "color": "A6761D",
327+ "type": "stack"
328+ }
329+ ]
330+}
331
332=== added file 'graph.d/innodb_io.json'
333--- graph.d/innodb_io.json 1970-01-01 00:00:00 +0000
334+++ graph.d/innodb_io.json 2011-07-22 02:23:23 +0000
335@@ -0,0 +1,36 @@
336+{
337+ "report_name": "innodb_buffer_pool",
338+ "report_type": "standard",
339+ "title": "- InnoDB I/O Activity @",
340+ "vertical_label": "Ops/sec",
341+ "series": [
342+ {
343+ "metric": "file_fsyncs",
344+ "color": "1F78B4",
345+ "label": "fsync Calls",
346+ "type": "line",
347+ "line_width": "2"
348+ },
349+ {
350+ "metric": "file_reads",
351+ "label": "File Reads",
352+ "color": "FF7F00",
353+ "type": "line",
354+ "line_width": "2"
355+ },
356+ {
357+ "metric": "file_writes",
358+ "label": "File Writes",
359+ "color": "33A02C",
360+ "type": "line",
361+ "line_width": "2"
362+ },
363+ {
364+ "metric": "log_writes",
365+ "label": "Log Writes",
366+ "color": "984EA3",
367+ "type": "line",
368+ "line_width": "2"
369+ }
370+ ]
371+}
372
373=== added file 'graph.d/innodb_io_pending.json'
374--- graph.d/innodb_io_pending.json 1970-01-01 00:00:00 +0000
375+++ graph.d/innodb_io_pending.json 2011-07-22 02:23:23 +0000
376@@ -0,0 +1,62 @@
377+{
378+ "report_name": "innodb_io_pending",
379+ "report_type": "standard",
380+ "title": "- InnoDB I/O Pending @",
381+ "vertical_label": "Operations",
382+ "series": [
383+ {
384+ "metric": "pending_aio_log_ios",
385+ "label": "Async. I/O ops. to the Log Files",
386+ "color": "FF0000",
387+ "type": "stack"
388+ },
389+ {
390+ "metric": "pending_aio_sync_ios",
391+ "label": "Async. fsync calls",
392+ "color": "FF7D00",
393+ "type": "stack"
394+ },
395+ {
396+ "metric": "pending_buf_pool_flushes",
397+ "label": " Buffer Pool Flush Requests",
398+ "color": "FFF200",
399+ "type": "stack"
400+ },
401+ {
402+ "metric": "pending_chkp_writes",
403+ "label": "Checkpoint Writes",
404+ "color": "00A348",
405+ "type": "stack"
406+ },
407+ {
408+ "metric": "pending_ibuf_aio_reads",
409+ "metric": "Async. Insert Buffer Reads",
410+ "color": "6DC8FE",
411+ "type": "stack"
412+ },
413+ {
414+ "metric": "pending_log_flushes",
415+ "label": "Log Flushes",
416+ "color": "4444FF",
417+ "type": "stack"
418+ },
419+ {
420+ "metric": "pending_log_writes",
421+ "label": "Log Writes",
422+ "color": "55009D",
423+ "type": "stack"
424+ },
425+ {
426+ "metric": "pending_normal_aio_reads",
427+ "label": "Normsl Async. Reads",
428+ "color": "B90054",
429+ "type": "stack"
430+ },
431+ {
432+ "metric": "pending_normal_aio_writes",
433+ "label": "Normal Async. Writes",
434+ "color": "A65628",
435+ "type": "stack"
436+ }
437+ ]
438+}
439
440=== added file 'graph.d/innodb_lock_structures.json'
441--- graph.d/innodb_lock_structures.json 1970-01-01 00:00:00 +0000
442+++ graph.d/innodb_lock_structures.json 2011-07-22 02:23:23 +0000
443@@ -0,0 +1,14 @@
444+{
445+ "report_name": "innodb_lock_structures",
446+ "report_type": "standard",
447+ "title": "- InnoDB Lock Structures @",
448+ "vertical_label": "Structures",
449+ "series": [
450+ {
451+ "metric": "innodb_lock_structs",
452+ "label": "Internal Lock Structures",
453+ "color": "0C4E5D",
454+ "type": "stack"
455+ }
456+ ]
457+}
458
459=== added file 'graph.d/innodb_log.json'
460--- graph.d/innodb_log.json 1970-01-01 00:00:00 +0000
461+++ graph.d/innodb_log.json 2011-07-22 02:23:23 +0000
462@@ -0,0 +1,14 @@
463+{
464+ "report_name": "innodb_log",
465+ "report_type": "standard",
466+ "title": "- InnoDB Log Size @",
467+ "vertical_label": "Bytes",
468+ "series": [
469+ {
470+ "metric": "innodb_log_buffer_size",
471+ "label": "Log Buffer Size",
472+ "color": "FF7F00",
473+ "type": "stack"
474+ }
475+ ]
476+}
477
478=== added file 'graph.d/innodb_log_activity.json'
479--- graph.d/innodb_log_activity.json 1970-01-01 00:00:00 +0000
480+++ graph.d/innodb_log_activity.json 2011-07-22 02:23:23 +0000
481@@ -0,0 +1,29 @@
482+{
483+ "report_name": "innodb_log_activity",
484+ "report_type": "standard",
485+ "title": "- InnoDB Log Activity @",
486+ "vertical_label": "Bytes/sec",
487+ "series": [
488+ {
489+ "metric": "log_bytes_written",
490+ "label": "Written Log Bytes",
491+ "color": "5B8257",
492+ "type": "line",
493+ "line_width": "2"
494+ },
495+ {
496+ "metric": "log_bytes_flushed",
497+ "label": "Flushed Log Bytes",
498+ "color": "AB4253",
499+ "type": "line",
500+ "line_width": "2"
501+ },
502+ {
503+ "metric": "unflushed_log",
504+ "label": "Unflushed Log Bytes",
505+ "color": "AFECED",
506+ "type": "stack",
507+ "line_width": "2"
508+ }
509+ ]
510+}
511
512=== added file 'graph.d/innodb_memory_allocation.json'
513--- graph.d/innodb_memory_allocation.json 1970-01-01 00:00:00 +0000
514+++ graph.d/innodb_memory_allocation.json 2011-07-22 02:23:23 +0000
515@@ -0,0 +1,22 @@
516+{
517+ "report_name": "innodb_memory_allocation",
518+ "report_type": "standard",
519+ "title": "- InnoDB Memory Allocation @",
520+ "vertical_label": "Bytes",
521+ "series": [
522+ {
523+ "metric": "total_mem_alloc",
524+ "label": "Total Allocated Memory",
525+ "color": "53777A",
526+ "type": "stack"
527+ },
528+ {
529+ "metric": "additional_pool_alloc",
530+ "label": "Allocated Memory in the Additional Pool",
531+ "color": "C02942",
532+ "type": "line",
533+ "line_width": "2"
534+ }
535+
536+ ]
537+}
538
539=== added file 'graph.d/innodb_row_lock_time.json'
540--- graph.d/innodb_row_lock_time.json 1970-01-01 00:00:00 +0000
541+++ graph.d/innodb_row_lock_time.json 2011-07-22 02:23:23 +0000
542@@ -0,0 +1,14 @@
543+{
544+ "report_name": "innodb_row_lock_time",
545+ "report_type": "standard",
546+ "title": "- InnoDB Row Lock Acquiring Time @",
547+ "vertical_label": "Milliseconds",
548+ "series": [
549+ {
550+ "metric": "Innodb_row_lock_time",
551+ "label": "Row Lock Acquiring",
552+ "color": "B11D03",
553+ "type": "stack"
554+ }
555+ ]
556+}
557
558=== added file 'graph.d/innodb_row_lock_waits.json'
559--- graph.d/innodb_row_lock_waits.json 1970-01-01 00:00:00 +0000
560+++ graph.d/innodb_row_lock_waits.json 2011-07-22 02:23:23 +0000
561@@ -0,0 +1,15 @@
562+{
563+ "report_name": "innodb_row_lock_waits",
564+ "report_type": "standard",
565+ "title": "- InnoDB Row Lock Waits @",
566+ "vertical_label": "Waits/sec",
567+ "series": [
568+ {
569+ "metric": "Innodb_row_lock_waits",
570+ "label": "Row Lock Waits",
571+ "color": "E84A5F",
572+ "type": "line",
573+ "line_width": "2"
574+ }
575+ ]
576+}
577
578=== added file 'graph.d/innodb_row_operations.json'
579--- graph.d/innodb_row_operations.json 1970-01-01 00:00:00 +0000
580+++ graph.d/innodb_row_operations.json 2011-07-22 02:23:23 +0000
581@@ -0,0 +1,37 @@
582+{
583+ "report_name": "innodb_row_operations",
584+ "report_type": "standard",
585+ "title": " - InnoDB Row Operations @",
586+ "vertical_label": "Ops/sec",
587+ "series": [
588+ {
589+ "metric": "rows_read",
590+ "label": "Reads",
591+ "color": "377EB8",
592+ "type": "line",
593+ "line_width": "2"
594+ },
595+ {
596+ "metric": "rows_deleted",
597+ "label": "Deletes",
598+ "color": "4DAF4A",
599+ "type": "line",
600+ "line_width": "2"
601+ },
602+ {
603+ "metric": "rows_updated",
604+ "label": "Updates",
605+ "color": "984EA3",
606+ "type": "line",
607+ "line_width": "2"
608+ },
609+
610+ {
611+ "metric": "rows_inserted",
612+ "label": "Inserts",
613+ "color": "FF7F00",
614+ "type": "line",
615+ "line_width": "2"
616+ }
617+ ]
618+}
619
620=== added file 'graph.d/innodb_semaphores.json'
621--- graph.d/innodb_semaphores.json 1970-01-01 00:00:00 +0000
622+++ graph.d/innodb_semaphores.json 2011-07-22 02:23:23 +0000
623@@ -0,0 +1,29 @@
624+{
625+ "report_name": "innodb_semaphores",
626+ "report_type": "standard",
627+ "title": "- InnoDB Semaphores @",
628+ "vertical_label": "Ops/sec",
629+ "series": [
630+ {
631+ "metric": "spin_rounds",
632+ "label": "Spin Rounds",
633+ "color": "1F78B4",
634+ "type": "line" ,
635+ "line_width": "2"
636+ },
637+ {
638+ "metric": "spin_waits",
639+ "label": "Spin Waits",
640+ "color": "33A02C",
641+ "type": "line",
642+ "line_width": "2"
643+ },
644+ {
645+ "metric": "os_waits",
646+ "label": "OS Waits",
647+ "color": "FF7F00",
648+ "type": "line",
649+ "line_width": "2"
650+ }
651+ ]
652+}
653
654=== added file 'graph.d/innodb_semaphores_waits.json'
655--- graph.d/innodb_semaphores_waits.json 1970-01-01 00:00:00 +0000
656+++ graph.d/innodb_semaphores_waits.json 2011-07-22 02:23:23 +0000
657@@ -0,0 +1,15 @@
658+{
659+ "report_name": "innodb_semaphore_waits",
660+ "report_type": "standard",
661+ "title": "- InnoDB Semaphore Waits @",
662+ "vertical_label": "Waits/sec",
663+ "series": [
664+ {
665+ "metric": "innodb_sem_waits",
666+ "label": "Waits for Semaphores",
667+ "color": "7020AF",
668+ "type": "line",
669+ "line_width": "2"
670+ }
671+ ]
672+}
673
674=== added file 'graph.d/innodb_semaphores_waits_times.json'
675--- graph.d/innodb_semaphores_waits_times.json 1970-01-01 00:00:00 +0000
676+++ graph.d/innodb_semaphores_waits_times.json 2011-07-22 02:23:23 +0000
677@@ -0,0 +1,14 @@
678+{
679+ "report_name": "innodb_semaphore_wait_time",
680+ "report_type": "standard",
681+ "title": "- InnoDB Semaphore Waiting Time @",
682+ "vertical_label": "Milliseconds",
683+ "series": [
684+ {
685+ "metric": "innodb_sem_wait_time_ms",
686+ "label": "Waiting Time for Semaphores",
687+ "color": "708226",
688+ "type": "stack"
689+ }
690+ ]
691+}
692
693=== added file 'graph.d/innodb_tables_in_use.json'
694--- graph.d/innodb_tables_in_use.json 1970-01-01 00:00:00 +0000
695+++ graph.d/innodb_tables_in_use.json 2011-07-22 02:23:23 +0000
696@@ -0,0 +1,21 @@
697+{
698+ "report_name": "innodb_tables_in_use",
699+ "report_type": "standard",
700+ "title": "- InnoDB Tables In Use @",
701+ "vertical_label": "Tables",
702+ "series": [
703+ {
704+ "metric": "innodb_tables_in_use",
705+ "label": "Tables in Use",
706+ "color": "D99362",
707+ "type": "stack"
708+ },
709+ {
710+ "metric": "innodb_locked_tables",
711+ "label": "Locked Tables",
712+ "color": "E41A1C",
713+ "type": "line",
714+ "line_width": "2"
715+ }
716+ ]
717+}
718
719=== added file 'graph.d/innodb_transaction_activity.json'
720--- graph.d/innodb_transaction_activity.json 1970-01-01 00:00:00 +0000
721+++ graph.d/innodb_transaction_activity.json 2011-07-22 02:23:23 +0000
722@@ -0,0 +1,32 @@
723+{
724+ "report_name": "innodb_transaction_activity",
725+ "report_type": "standard",
726+ "title": "- InnoDB Transaction Activity @",
727+ "vertical_label": "Transactions",
728+ "series": [
729+ {
730+ "metric": "innodb_transactions",
731+ "label": "Total Transactions (Internal Transaction Counter)",
732+ "color": "8F005C",
733+ "type": "stack"
734+ },
735+ {
736+ "metric": "current_transactions",
737+ "label": "Current Transactions",
738+ "color": "4444FF",
739+ "type": "stack"
740+ },
741+ {
742+ "metric": "history_list",
743+ "label": "History List",
744+ "color": "FF7D00",
745+ "type": "stack"
746+ },
747+ {
748+ "metric": "read_views",
749+ "label": "Read Views",
750+ "color": "74C366",
751+ "type": "stack"
752+ }
753+ ]
754+}
755
756=== added file 'graph.d/innodb_transactions_active_locked.json'
757--- graph.d/innodb_transactions_active_locked.json 1970-01-01 00:00:00 +0000
758+++ graph.d/innodb_transactions_active_locked.json 2011-07-22 02:23:23 +0000
759@@ -0,0 +1,21 @@
760+{
761+ "report_name": "innodb_transactions_active_locked",
762+ "report_type": "standard",
763+ "title": "- InnoDB Active/Locked Transactions @",
764+ "vertical_label": "Transactions",
765+ "series": [
766+ {
767+ "metric": "active_transactions",
768+ "label": "Active Transactions",
769+ "color": "33A02C",
770+ "type": "stack"
771+ },
772+ {
773+ "metric": "locked_transactions",
774+ "label": "Locked Transactions",
775+ "color": "FF0000",
776+ "type": "line",
777+ "line_width": "2"
778+ }
779+ ]
780+}
781
782=== added file 'graph.d/innodb_transactions_report.json'
783--- graph.d/innodb_transactions_report.json 1970-01-01 00:00:00 +0000
784+++ graph.d/innodb_transactions_report.json 2011-07-22 02:23:23 +0000
785@@ -0,0 +1,36 @@
786+{
787+ "report_name": "innodb_transactions_report",
788+ "report_type": "standard",
789+ "title": "- InnoDB Transactions @",
790+ "vertical_label": "Transactions",
791+ "series": [
792+ {
793+ "metric": "innodb_transactions",
794+ "label": "Total Transactions - Internal Transaction Counter",
795+ "color": "8F005C",
796+ "type": "line",
797+ "line_width": "2"
798+ },
799+ {
800+ "metric": "current_transactions",
801+ "label": "Current Transactions",
802+ "color": "4444FF",
803+ "type": "line",
804+ "line_width": "2"
805+ },
806+ {
807+ "metric": "history_list",
808+ "label": "History List",
809+ "color": "FF7D00",
810+ "type": "line",
811+ "line_width": "2"
812+ },
813+ {
814+ "metric": "read_views",
815+ "label": "Read Views",
816+ "color": "74C366",
817+ "type": "line",
818+ "line_width": "2"
819+ }
820+ ]
821+}
822
823=== added file 'graph.d/myisam_indexes.json'
824--- graph.d/myisam_indexes.json 1970-01-01 00:00:00 +0000
825+++ graph.d/myisam_indexes.json 2011-07-22 02:23:23 +0000
826@@ -0,0 +1,39 @@
827+{
828+ "report_name": "myisam_indexes",
829+ "report_type": "standard",
830+ "title": "- MyISAM indexes @",
831+ "vertical_label": "Ops/sec",
832+ "series": [
833+ {
834+ "metric": "Key_read_requests",
835+ "label": "Key Read Requests",
836+ "color": "157419",
837+ "type": "line",
838+ "line_width": "2"
839+ },
840+
841+ {
842+ "metric": "Key_reads",
843+ "label": "Key Reads",
844+ "color": "AFECED",
845+ "type": "line",
846+ "line_width": "2"
847+ },
848+
849+ {
850+ "metric": "Key_write",
851+ "label": "Key Writes",
852+ "color": "F51D30",
853+ "type": "line",
854+ "line_width": "2"
855+ },
856+
857+ {
858+ "metric": "Key_write_requests",
859+ "label": "Key Writes Requests",
860+ "color": "984EA3",
861+ "type": "line",
862+ "line_width": "2"
863+ }
864+ ]
865+}
866
867=== added file 'graph.d/myisam_key_cache.json'
868--- graph.d/myisam_key_cache.json 1970-01-01 00:00:00 +0000
869+++ graph.d/myisam_key_cache.json 2011-07-22 02:23:23 +0000
870@@ -0,0 +1,28 @@
871+{
872+ "report_name": "myisam_key_cache",
873+ "report_type": "standard",
874+ "title": "- MyISAM Key Cache @",
875+ "vertical_label": "Bytes",
876+ "series": [
877+ {
878+ "metric": "Key_buf_bytes_used",
879+ "label": "Key Buffer Used Bytes",
880+ "color": "5AAE61",
881+ "type": "stack"
882+ },
883+ {
884+ "metric": "Key_buf_bytes_unflushed",
885+ "label": "Key Buffer Unflushed Bytes",
886+ "color": "FECEA8",
887+ "type": "line",
888+ "type": "1F78B4"
889+ },
890+ {
891+ "metric": "key_buffer_size",
892+ "label": "Total Key Buffer Size",
893+ "color": "1B7837",
894+ "type": "line",
895+ "line_width": "2"
896+ }
897+ ]
898+}
899
900=== added file 'graph.d/mysql_binary_relay_logs.json'
901--- graph.d/mysql_binary_relay_logs.json 1970-01-01 00:00:00 +0000
902+++ graph.d/mysql_binary_relay_logs.json 2011-07-22 02:23:23 +0000
903@@ -0,0 +1,34 @@
904+{
905+ "report_name": "mysql_binary_relay_logs",
906+ "report_type": "standard",
907+ "title": "- MySQL Binary and Relay Logs @",
908+ "vertical_label": "Bytes",
909+ "series": [
910+ {
911+ "metric": "binary_log_space",
912+ "label": "Binary Log Space",
913+ "color": "1B7837",
914+ "type": "line",
915+ "line_width": "2"
916+ },
917+ {
918+ "metric": "relay_log_space",
919+ "label": "Relay Log Space",
920+ "color": "762A83",
921+ "type": "line",
922+ "line_width": "2"
923+ },
924+ {
925+ "metric": "Binlog_cache_use",
926+ "label": "Binlog Cache Use",
927+ "color": "7FBF7B",
928+ "type": "stack"
929+ },
930+ {
931+ "metric": "Binlog_cache_disk_use",
932+ "label": "Binlog Cache Disk Use",
933+ "color": "B2DF8A",
934+ "type": "stack"
935+ }
936+ ]
937+}
938
939=== added file 'graph.d/mysql_command_counters.json'
940--- graph.d/mysql_command_counters.json 1970-01-01 00:00:00 +0000
941+++ graph.d/mysql_command_counters.json 2011-07-22 02:23:23 +0000
942@@ -0,0 +1,75 @@
943+{
944+ "report_name": "mysql_command_counters",
945+ "report_type": "standard",
946+ "title": "- MySQL Command Counters @",
947+ "vertical_label": "Ops/sec",
948+ "series": [
949+ {
950+ "metric": "Questions",
951+ "label": "Questions",
952+ "color": "984EA3",
953+ "type": "line",
954+ "line_width": "2"
955+ },
956+ {
957+ "metric": "Com_select",
958+ "label": "SELECTs",
959+ "color": "E31A1C",
960+ "type": "stack"
961+ },
962+ {
963+ "metric": "Com_delete",
964+ "label": "DELETEs",
965+ "color": "FF7D00",
966+ "type": "stack"
967+ },
968+ {
969+ "metric": "Com_insert",
970+ "label": "INSERTs",
971+ "color": "FFF200",
972+ "type": "stack"
973+ },
974+ {
975+ "metric": "Com_update",
976+ "label": "UPDATEs",
977+ "color": "00CF00",
978+ "type": "stack"
979+ },
980+ {
981+ "metric": "Com_replace",
982+ "label": "REPLACEs",
983+ "color": "2175D9",
984+ "type": "stack"
985+ },
986+ {
987+ "metric": "Com_load",
988+ "label": "LOADs",
989+ "color": "55009D",
990+ "type": "stack"
991+ },
992+ {
993+ "metric": "Com_delete_multi",
994+ "label": "DELETEs on multiple rows",
995+ "color": "942D0C",
996+ "type": "stack"
997+ },
998+ {
999+ "metric": "Com_insert_select",
1000+ "label": "INSERT ... SELECTs",
1001+ "color": "AAABA1",
1002+ "type": "stack"
1003+ },
1004+ {
1005+ "metric": "Com_update_multi",
1006+ "label": "UPDATEs on multiple rows",
1007+ "color": "D8ACE0",
1008+ "type": "stack"
1009+ },
1010+ {
1011+ "metric": "Com_replace_select",
1012+ "label": "REPLACE ... SELECTs",
1013+ "color": "00B99B",
1014+ "type": "stack"
1015+ }
1016+ ]
1017+}
1018
1019=== added file 'graph.d/mysql_connections.json'
1020--- graph.d/mysql_connections.json 1970-01-01 00:00:00 +0000
1021+++ graph.d/mysql_connections.json 2011-07-22 02:23:23 +0000
1022@@ -0,0 +1,21 @@
1023+{
1024+ "report_name": "mysql_connections",
1025+ "report_type": "standard",
1026+ "title": "- MySQL Connections @",
1027+ "vertical_label": "Connections",
1028+ "series": [
1029+ {
1030+ "metric": "Max_used_connections",
1031+ "label": "Max. Used Conn. Simultaneously since Server Started",
1032+ "color": "FFD660",
1033+ "type": "stack"
1034+ },
1035+ {
1036+ "metric": "max_connections",
1037+ "label": "Maximum Connections Permitted",
1038+ "color": "FDAE61",
1039+ "type": "line",
1040+ "line_width": "2"
1041+ }
1042+ ]
1043+}
1044
1045=== added file 'graph.d/mysql_connections_types.json'
1046--- graph.d/mysql_connections_types.json 1970-01-01 00:00:00 +0000
1047+++ graph.d/mysql_connections_types.json 2011-07-22 02:23:23 +0000
1048@@ -0,0 +1,36 @@
1049+{
1050+ "report_name": "mysql_connections_types",
1051+ "report_type": "standard",
1052+ "title": "- MySQL Connections Types @",
1053+ "vertical_label": "Connections/sec",
1054+ "series": [
1055+ {
1056+ "metric": "Connections",
1057+ "label": "Connections Attemps - Succ. or Not",
1058+ "color": "377EB8",
1059+ "type": "line",
1060+ "line_width": "2"
1061+ },
1062+ {
1063+ "metric": "Threads_connected",
1064+ "label": "Threads Connected",
1065+ "color": "4DAF4A",
1066+ "type": "line",
1067+ "line_width": "2"
1068+ },
1069+ {
1070+ "metric": "Aborted_clients",
1071+ "label": "Aborted Clients",
1072+ "color": "E41A1C",
1073+ "type": "line",
1074+ "line_width": "2"
1075+ },
1076+ {
1077+ "metric": "Aborted_connects",
1078+ "label": "Aborted Connections",
1079+ "color": "984EA3",
1080+ "type": "line",
1081+ "line_width": "2"
1082+ }
1083+ ]
1084+}
1085
1086=== added file 'graph.d/mysql_files_tables.json'
1087--- graph.d/mysql_files_tables.json 1970-01-01 00:00:00 +0000
1088+++ graph.d/mysql_files_tables.json 2011-07-22 02:23:23 +0000
1089@@ -0,0 +1,29 @@
1090+{
1091+ "report_name": "mysql_files_tables",
1092+ "report_type": "standard",
1093+ "title": "- MySQL Files and Tables @",
1094+ "vertical_label": "Objects/sec",
1095+ "series": [
1096+ {
1097+ "metric": "Open_tables",
1098+ "label": "Open Tables",
1099+ "color": "33A02C",
1100+ "type": "line",
1101+ "line_width": "2"
1102+ },
1103+ {
1104+ "metric": "Open_files",
1105+ "label": "Open Files",
1106+ "color": "1F78B4",
1107+ "type": "line",
1108+ "line_width": "2"
1109+ },
1110+ {
1111+ "metric": "Opened_tables",
1112+ "label": "Tables Opened with my_open",
1113+ "color": "FF7F00",
1114+ "type": "line",
1115+ "line_width": "2"
1116+ }
1117+ ]
1118+}
1119
1120=== added file 'graph.d/mysql_handlers.json'
1121--- graph.d/mysql_handlers.json 1970-01-01 00:00:00 +0000
1122+++ graph.d/mysql_handlers.json 2011-07-22 02:23:23 +0000
1123@@ -0,0 +1,71 @@
1124+{
1125+ "report_name": "mysql_handlers",
1126+ "report_type": "standard",
1127+ "title": "- MySQL Handlers @",
1128+ "vertical_label": "Calls/sec",
1129+ "series": [
1130+ {
1131+ "metric": "Handler_write",
1132+ "label": "Handler Write",
1133+ "color": "E41A1C",
1134+ "type": "line",
1135+ "line_width": "2"
1136+ },
1137+ {
1138+ "metric": "Handler_update",
1139+ "label": "Handler Update",
1140+ "color": "377EB8",
1141+ "type": "line",
1142+ "line_width": "2"
1143+ },
1144+ {
1145+ "metric": "Handler_delete",
1146+ "label": "Handler Delete",
1147+ "color": "4DAF4A",
1148+ "type": "line",
1149+ "line_width": "2"
1150+ },
1151+ {
1152+ "metric": "Handler_read_first",
1153+ "label": "Handler Read First",
1154+ "color": "984EA3",
1155+ "type": "line",
1156+ "line_width": "2"
1157+ },
1158+ {
1159+ "metric": "Handler_read_key",
1160+ "label": "Handler Read Key",
1161+ "color": "FF7F00",
1162+ "type": "line",
1163+ "line_width": "2"
1164+ },
1165+ {
1166+ "metric": "Handler_read_next",
1167+ "label": "Handler Read Next",
1168+ "color": "A65628",
1169+ "type": "line",
1170+ "line_width": "2"
1171+ },
1172+ {
1173+ "metric": "Handler_read_prev",
1174+ "label": "Handler Read Prev",
1175+ "color": "F781BF",
1176+ "type": "line",
1177+ "line_width": "2"
1178+ },
1179+ {
1180+ "metric": "Handler_read_rnd",
1181+ "label": "Handler Read Rnd",
1182+ "color": "999999",
1183+ "type": "line",
1184+ "line_width": "2"
1185+ },
1186+ {
1187+ "metric": "Handler_read_rnd_next",
1188+ "label": "Handler Read Rnd Next",
1189+ "color": "E6AB02",
1190+ "type": "line",
1191+ "line_width": "2"
1192+ }
1193+ ]
1194+}
1195
1196=== added file 'graph.d/mysql_network_report.json'
1197--- graph.d/mysql_network_report.json 1970-01-01 00:00:00 +0000
1198+++ graph.d/mysql_network_report.json 2011-07-22 02:23:23 +0000
1199@@ -0,0 +1,10 @@
1200+{
1201+ "report_name" : "mysql_network_report",
1202+ "report_type" : "standard",
1203+ "title" : "- MySQL Network @",
1204+ "vertical_label" : "Bytes/sec",
1205+ "series" : [
1206+ { "metric": "Bytes_received", "color": "33cc33", "label": "In", "line_width": "2", "type": "line" },
1207+ { "metric": "Bytes_sent", "color": "5555cc", "label": "Out", "line_width": "2", "type": "line" }
1208+ ]
1209+}
1210
1211=== added file 'graph.d/mysql_network_traffic.json'
1212--- graph.d/mysql_network_traffic.json 1970-01-01 00:00:00 +0000
1213+++ graph.d/mysql_network_traffic.json 2011-07-22 02:23:23 +0000
1214@@ -0,0 +1,22 @@
1215+{
1216+ "report_name": "mysql_network_traffic",
1217+ "report_type": "standard",
1218+ "title": "- MySQL Network Traffic @",
1219+ "vertical_label": "Bytes/sec",
1220+ "series": [
1221+ {
1222+ "metric": "Bytes_received",
1223+ "label": "In",
1224+ "color": "1F78B4",
1225+ "type": "line",
1226+ "line_width": "2"
1227+ },
1228+ {
1229+ "metric": "Bytes_sent",
1230+ "label": "Out",
1231+ "color": "33A02C",
1232+ "type": "line",
1233+ "line_width": "2"
1234+ }
1235+ ]
1236+}
1237
1238=== added file 'graph.d/mysql_process_list.json'
1239--- graph.d/mysql_process_list.json 1970-01-01 00:00:00 +0000
1240+++ graph.d/mysql_process_list.json 2011-07-22 02:23:23 +0000
1241@@ -0,0 +1,104 @@
1242+{
1243+ "report_name": "mysql_process_list",
1244+ "report_type": "standard",
1245+ "title": "MySQL Processlist",
1246+ "vertical_label": "Threads",
1247+ "series": [
1248+ {
1249+ "metric": "State_closing_tables",
1250+ "label": "State Closing Tables",
1251+ "color": "A6CEE3",
1252+ "type": "stack"
1253+ },
1254+ {
1255+ "metric": "State_copying_to_tmp_table",
1256+ "label": "State Copying to TMP table",
1257+ "color": "1F78B4",
1258+ "type": "stack"
1259+ },
1260+ {
1261+ "metric": "State_end",
1262+ "label": "State End",
1263+ "color": "B2DF8A",
1264+ "type": "stack"
1265+ },
1266+ {
1267+ "metric": "State_freeing_series",
1268+ "label": "State Freeing Series",
1269+ "color": "33A02C",
1270+ "type": "stack"
1271+ },
1272+ {
1273+ "metric": "State_init",
1274+ "label": "State Init",
1275+ "color": "FB9A99",
1276+ "type": "stack"
1277+ },
1278+ {
1279+ "metric": "State_locked",
1280+ "label": "State Locked",
1281+ "color": "E31A1C",
1282+ "type": "stack"
1283+ },
1284+ {
1285+ "metric": "State_login",
1286+ "label": "State Login",
1287+ "color": "FDBF6F",
1288+ "type": "stack"
1289+ },
1290+ {
1291+ "metric": "State_preparing",
1292+ "label": "State Preparing",
1293+ "color": "FF7F00",
1294+ "type": "stack"
1295+ },
1296+ {
1297+ "metric": "State_reading_from_net",
1298+ "label": "State Reading From Net",
1299+ "color": "CAB2D6",
1300+ "type": "stack"
1301+ },
1302+ {
1303+ "metric": "State_sending_data",
1304+ "label": "State Sending Data",
1305+ "color": "6A3D9A",
1306+ "type": "stack"
1307+ },
1308+ {
1309+ "metric": "State_sorting_result",
1310+ "label": "State Sorting Result",
1311+ "color": "B83A04",
1312+ "type": "stack"
1313+ },
1314+ {
1315+ "metric": "State_statistics",
1316+ "label": "State Statistics",
1317+ "color": "FB8072",
1318+ "type": "stack"
1319+ },
1320+ {
1321+ "metric": "State_updating",
1322+ "label": "State Updating",
1323+ "color": "B56414",
1324+ "type": "stack"
1325+ },
1326+ {
1327+ "metric": "State_writing_to_net",
1328+ "label": "State Writing to Net",
1329+ "color": "80B1D3",
1330+ "type": "stack"
1331+ },
1332+ {
1333+ "metric": "State_none",
1334+ "label": "State None",
1335+ "color": "999999",
1336+ "type": "stack"
1337+ },
1338+ {
1339+ "metric": "State_other",
1340+ "label": "State Other",
1341+ "color": "194240",
1342+ "type": "stack"
1343+ }
1344+ ]
1345+}
1346
1347=== added file 'graph.d/mysql_query_cache.json'
1348--- graph.d/mysql_query_cache.json 1970-01-01 00:00:00 +0000
1349+++ graph.d/mysql_query_cache.json 2011-07-22 02:23:23 +0000
1350@@ -0,0 +1,43 @@
1351+{
1352+ "report_name": "mysql_query_cache",
1353+ "report_type": "standard",
1354+ "title": "- MySQL Query Cache @",
1355+ "vertical_label": "Ops/sec",
1356+ "series": [
1357+ {
1358+ "metric": "Qcache_queries_in_cache",
1359+ "label": "Queries Registered in the Query Cache",
1360+ "color": "A6CEE3",
1361+ "type": "line",
1362+ "line_width": "2"
1363+ },
1364+ {
1365+ "metric": "Qcache_hits",
1366+ "label": "Query Cache Hits",
1367+ "color": "1F78B4",
1368+ "type": "line",
1369+ "line_width": "2"
1370+ },
1371+ {
1372+ "metric": "Qcache_inserts",
1373+ "label": "Query Cache Inserts",
1374+ "color": "B2DF8A",
1375+ "type": "line",
1376+ "line_width": "2"
1377+ },
1378+ {
1379+ "metric": "Qcache_not_cached",
1380+ "label": "Non-Cached Queries",
1381+ "color": "FF7F00",
1382+ "type": "line",
1383+ "line_width": "2"
1384+ },
1385+ {
1386+ "metric": "Qcache_lowmem_prunes",
1387+ "label": "Queries deleted from Cache - Lowmem Prunes",
1388+ "color": "FB9A99",
1389+ "type": "line",
1390+ "line_width": "2"
1391+ }
1392+ ]
1393+}
1394
1395=== added file 'graph.d/mysql_query_cache_memory.json'
1396--- graph.d/mysql_query_cache_memory.json 1970-01-01 00:00:00 +0000
1397+++ graph.d/mysql_query_cache_memory.json 2011-07-22 02:23:23 +0000
1398@@ -0,0 +1,36 @@
1399+{
1400+ "report_name": "mysql_query_cache_memory",
1401+ "report_type": "standard",
1402+ "title": "- MySQL Query Cache Memory @",
1403+ "vertical_label": "Blocks",
1404+ "series": [
1405+ {
1406+ "metric": "Qcache_free_blocks",
1407+ "label": "Free Blocks",
1408+ "color": "33A02C",
1409+ "type": "line",
1410+ "line_width": "2"
1411+ },
1412+ {
1413+ "metric": "Qcache_free_memory",
1414+ "label": "Free Memory",
1415+ "color": "B2DF8A",
1416+ "type": "line",
1417+ "line_width": "2"
1418+ },
1419+ {
1420+ "metric": "Qcache_total_blocks",
1421+ "label": "Total Blocks",
1422+ "color": "1F78B4",
1423+ "type": "line",
1424+ "line_width": "2"
1425+ },
1426+ {
1427+ "metric": "query_cache_size",
1428+ "label": "Allocated Memory for Query Cache",
1429+ "color": "A6CEE3",
1430+ "type": "line",
1431+ "line_width": "2"
1432+ }
1433+ ]
1434+}
1435
1436=== added file 'graph.d/mysql_replication.json'
1437--- graph.d/mysql_replication.json 1970-01-01 00:00:00 +0000
1438+++ graph.d/mysql_replication.json 2011-07-22 02:23:23 +0000
1439@@ -0,0 +1,36 @@
1440+{
1441+ "report_name": "mysql_replication",
1442+ "report_type": "standard",
1443+ "title": "- MySQL Replication @",
1444+ "vertical_label": "MISC",
1445+ "series": [
1446+ {
1447+ "metric": "slave_running",
1448+ "label": "Slave Running",
1449+ "color": "1F78B4",
1450+ "type": "line",
1451+ "line_width": "2"
1452+ },
1453+ {
1454+ "metric": "slave_stopped",
1455+ "label": "Slave Stopped",
1456+ "color": "FFFF99",
1457+ "type": "line",
1458+ "line_width": "2"
1459+ },
1460+ {
1461+ "metric": "slave_lag",
1462+ "label": "Slave lag - seconds",
1463+ "color": "FDBF6F",
1464+ "type": "line",
1465+ "line_width": "2"
1466+ },
1467+ {
1468+ "metric": "Slave_retried_transactions",
1469+ "label": "Retried transactions by Slave",
1470+ "color": "CAB2D6",
1471+ "type": "line",
1472+ "line_width": "2"
1473+ }
1474+ ]
1475+}
1476
1477=== added file 'graph.d/mysql_rows_sorted.json'
1478--- graph.d/mysql_rows_sorted.json 1970-01-01 00:00:00 +0000
1479+++ graph.d/mysql_rows_sorted.json 2011-07-22 02:23:23 +0000
1480@@ -0,0 +1,15 @@
1481+{
1482+ "report_name": "mysql_rows_sorted",
1483+ "report_type": "standard",
1484+ "title": "- MySQL Rows Sorted @",
1485+ "vertical_label": "Rows/sec",
1486+ "series": [
1487+ {
1488+ "metric": "Sort_rows",
1489+ "label": "Rows Sorted",
1490+ "color": "FFAB00",
1491+ "type": "line",
1492+ "line_width": "2"
1493+ }
1494+ ]
1495+}
1496
1497=== added file 'graph.d/mysql_select_types.json'
1498--- graph.d/mysql_select_types.json 1970-01-01 00:00:00 +0000
1499+++ graph.d/mysql_select_types.json 2011-07-22 02:23:23 +0000
1500@@ -0,0 +1,43 @@
1501+{
1502+ "report_name": "mysql_select_types",
1503+ "report_type": "standard",
1504+ "title": "- MySQL Select Types @",
1505+ "vertical_label": "Queries/sec",
1506+ "series": [
1507+ {
1508+ "metric": "Select_full_join",
1509+ "label": "Full Join",
1510+ "color": "E41A1C",
1511+ "type": "line",
1512+ "line_width": "2"
1513+ },
1514+ {
1515+ "metric": "Select_full_range_join",
1516+ "label": "Full Range Join",
1517+ "color": "377EB8",
1518+ "type": "line",
1519+ "line_width": "2"
1520+ },
1521+ {
1522+ "metric": "Select_range",
1523+ "label": "Range",
1524+ "color": "4DAF4A",
1525+ "type": "line",
1526+ "line_width": "2"
1527+ },
1528+ {
1529+ "metric": "Select_range_check",
1530+ "label": "Range Check",
1531+ "color": "984EA3",
1532+ "type": "line",
1533+ "line_width": "2"
1534+ },
1535+ {
1536+ "metric": "Select_scan",
1537+ "label": "Scan",
1538+ "color": "FF7F00",
1539+ "type": "line",
1540+ "line_width": "2"
1541+ }
1542+ ]
1543+}
1544
1545=== added file 'graph.d/mysql_sorts.json'
1546--- graph.d/mysql_sorts.json 1970-01-01 00:00:00 +0000
1547+++ graph.d/mysql_sorts.json 2011-07-22 02:23:23 +0000
1548@@ -0,0 +1,26 @@
1549+{
1550+ "report_name": "mysql_sorts",
1551+ "report_type": "standard",
1552+ "title": "- MySQL Sorts @",
1553+ "vertical_label": "Queries/sec",
1554+ "series": [
1555+ {
1556+ "metric": "Sort_range",
1557+ "label": "Range",
1558+ "color": "157419",
1559+ "type": "stack"
1560+ },
1561+ {
1562+ "metric": "Sort_merge_passes",
1563+ "label": "Merge Passes",
1564+ "color": "DA4725",
1565+ "type": "stack"
1566+ },
1567+ {
1568+ "metric": "Sort_scan",
1569+ "label": "Scan",
1570+ "color": "4444FF",
1571+ "type": "stack"
1572+ }
1573+ ]
1574+}
1575
1576=== added file 'graph.d/mysql_table_cached.json'
1577--- graph.d/mysql_table_cached.json 1970-01-01 00:00:00 +0000
1578+++ graph.d/mysql_table_cached.json 2011-07-22 02:23:23 +0000
1579@@ -0,0 +1,14 @@
1580+{
1581+ "report_name": "mysql_files_tables",
1582+ "report_type": "standard",
1583+ "title": "MySQL Cached Tables",
1584+ "vertical_label": "Tables",
1585+ "series": [
1586+ {
1587+ "metric": "table_cache",
1588+ "label": "Cached Tables",
1589+ "color": "D09887",
1590+ "type": "stack",
1591+ }
1592+ ]
1593+}
1594
1595=== added file 'graph.d/mysql_table_locks.json'
1596--- graph.d/mysql_table_locks.json 1970-01-01 00:00:00 +0000
1597+++ graph.d/mysql_table_locks.json 2011-07-22 02:23:23 +0000
1598@@ -0,0 +1,29 @@
1599+{
1600+ "report_name": "mysql_table_locks",
1601+ "report_type": "standard",
1602+ "title": "- MySQL Table Locks @",
1603+ "vertical_label": "Ops/sec",
1604+ "series": [
1605+ {
1606+ "metric": "Slow_queries",
1607+ "label": "Slow Queries",
1608+ "color": "E41A1C",
1609+ "type": "line",
1610+ "line_width": "2"
1611+ },
1612+ {
1613+ "metric": "Table_locks_immediate",
1614+ "label": "Table Locks - Immediate",
1615+ "color": "33A02C",
1616+ "type": "line" ,
1617+ "line_width": "2"
1618+ },
1619+ {
1620+ "metric": "Table_locks_waited",
1621+ "label": "Table Locks - Waited",
1622+ "color": "984EA3",
1623+ "type": "line" ,
1624+ "line_width": "2"
1625+ }
1626+ ]
1627+}
1628
1629=== added file 'graph.d/mysql_temporary_objects.json'
1630--- graph.d/mysql_temporary_objects.json 1970-01-01 00:00:00 +0000
1631+++ graph.d/mysql_temporary_objects.json 2011-07-22 02:23:23 +0000
1632@@ -0,0 +1,29 @@
1633+{
1634+ "report_name": "mysql_temporary_objects",
1635+ "report_type": "standard",
1636+ "title": "- MySQL Temporary Objects @",
1637+ "vertical_label": "Ops/sec",
1638+ "series": [
1639+ {
1640+ "metric": "Created_tmp_tables",
1641+ "label": "Temporary Tables Created",
1642+ "color": "FF7F00",
1643+ "type": "line",
1644+ "line_width": "2"
1645+ },
1646+ {
1647+ "metric": "Created_tmp_disk_tables",
1648+ "label": "Temporary Tables Created on Disk",
1649+ "color": "E41A1C",
1650+ "type": "line",
1651+ "line_width": "2"
1652+ },
1653+ {
1654+ "metric": "Created_tmp_files",
1655+ "label": "Temporary Files Created",
1656+ "color": "984EA3",
1657+ "type": "line",
1658+ "line_width": "2"
1659+ }
1660+ ]
1661+}
1662
1663=== added file 'graph.d/mysql_transaction_handler.json'
1664--- graph.d/mysql_transaction_handler.json 1970-01-01 00:00:00 +0000
1665+++ graph.d/mysql_transaction_handler.json 2011-07-22 02:23:23 +0000
1666@@ -0,0 +1,36 @@
1667+{
1668+ "report_name": "mysql_transaction_handler",
1669+ "report_type": "standard",
1670+ "title": "- MySQL Transaction Handler @",
1671+ "vertical_label": "Calls/sec",
1672+ "series": [
1673+ {
1674+ "metric": "Handler_commit",
1675+ "label": "Handler COMMIT",
1676+ "color": "DE0056",
1677+ "type": "line",
1678+ "line_width": "2"
1679+ },
1680+ {
1681+ "metric": "Handler_rollback",
1682+ "label": "Handler ROLLBACK",
1683+ "color": "784890",
1684+ "type": "line",
1685+ "line_width": "2"
1686+ },
1687+ {
1688+ "metric": "Handler_savepoint",
1689+ "label": "Handler SAVEPOINT",
1690+ "color": "FF7F00",
1691+ "type": "line",
1692+ "line_width": "2"
1693+ },
1694+ {
1695+ "metric": "Handler_savepoint_rollback",
1696+ "label": "Handler SAVEPOINT ROLLBACK",
1697+ "color": "4DAF4A",
1698+ "type": "line",
1699+ "line_width": "2"
1700+ }
1701+ ]
1702+}

Subscribers

People subscribed via source and target branches