1
=== modified file 'METRICS'
2
--- METRICS	2011-06-24 06:41:11 +0000
3
+++ METRICS	2011-07-25 22:42:07 +0000
4
@@ -2,497 +2,568 @@
5
2
METRICS
2
METRICS
6
3
=======
3
=======
7
4
4
25
5
    - 'Key_read_requests'
5
    - InnoDB Active/Locked Transactions (innodb_transactions_active_locked)
26
6
      The number of reads of a key block from the cache (operations per second). 
6
27
7
7
      - 'active_transactions'
28
8
    - 'Key reads'
8
        The number of active transactions in the server. Active transactions are those that are currently open (between BEGIN and COMMIT and also whilst a query is running).
29
9
      The number of physical reads of a key block from disk (operations per second).
9
30
10
10
      - 'locked_transactions'
31
11
    - 'Key_write_requests'
11
        The number of locked transactions in the server. Locked transactions are those in LOCK WAIT status (waiting for a row lock, a table lock or an auto-increment lock).
32
12
      The number of writes of a key block to the cache (operations per second). 
12
33
13
13
    - InnoDB Adaptive Hash Index (innodb_adaptative_hash_index)
34
14
    - 'Key_write'
14
35
15
      The number of physical writes of a key block to disk (operations per second).
15
      - 'hash_index_cells_total'
36
16
16
        The total number of Adaptative Hash Index cells of InnoDB.
37
17
    - 'history_list'
17
38
18
      The length of the history list shows how old the oldest unpurged transaction is (transactions).
18
      - 'hash_index_cells_used'
39
19
19
        The number of cells Adaptative Hash Index cells used by InnoDB.
40
20
    - 'innodb_transactions'
20
41
21
      The number of transactions done by the server (internal transaction counter).
21
    - InnoDB Buffer Pool (innodb_buffer_pool)
42
22
43
23
      - 'pool_size'
44
24
        The total size of buffer pool, in pages.
45
25
46
26
      - 'database_pages'
47
27
        The number of used pages in the buffer pool.
48
28
49
29
      - 'free_pages'
50
30
        The number of free pages in the buffer pool.
51
31
52
32
      - 'modified_pages' 
53
33
        The number of modified (dirty) pages in the buffer pool.
54
34
55
35
    - InnoDB Buffer Pool Activity (innodb_buffer_pool_activity)
56
36
      
57
37
      - 'pages_created'
58
38
        The number of created pages per second.
59
39
60
40
      - 'pages_read' 
61
41
        The number of logical reads of pages that the engine could not satisfy from the buffer pool, and had to read directly from the disk (pages per second). 
62
42
63
43
      - 'pages_written'
64
44
        The number of pages written per second.
65
45
66
46
    - InnoDB Checkpoint Age (innodb_checkpoint_age)
67
47
68
48
      - 'uncheckpointed_bytes'
69
49
        The number of uncheckpointed bytes: the amount of recovery that'll have to be performed if there's a crash.
70
22
 
50
 
547
23
    - 'read_views'
51
    - InnoDB Current Lock Waiting Time (innodb_current_lock_waits)
548
24
      The number of read views open shows how many transactions have a consistent snapshot of the database's contents, which is achieved by MVCC (transactions).
52
549
25
53
      - 'innodb_lock_wait_secs'
550
26
    - 'current_transactions'
54
551
27
      The total number of transactions currently in the server, no matter what status (ACTIVE, LOCK WAIT, not started, etc).
55
        The total number of seconds that InnoDB transactions have been waiting for locks.
552
28
56
553
29
    - 'locked_transactions'
57
    - InnoDB Insert Buffer (innodb_insert_buffer)
554
30
      The number of locked transactions in the server. Locked transactions are those in LOCK WAIT status (waiting for a row lock, a table lock or an auto-increment lock).
58
555
31
59
      - 'ibuf_inserts'
556
32
    - 'active_transactions'
60
        The number of INSERT operations per second in the InnoDB Insert Buffer.
557
33
      The number of active transactions in the server. Active transactions are those that are currently open (between BEGIN and COMMIT and also whilst a query is running).
61
558
34
62
      - 'ibuf_merged' 
559
35
    - 'pool_size'
63
        The number of MERGED RECORD operations per second in the InnoDB Insert Buffer.
560
36
      The total size of buffer pool, in pages.
64
561
37
65
      - 'ibuf_merges' 
562
38
    - free_pages 'free_pages'
66
        The number of MERGE operations per second in the InnoDB Insert Buffer.
563
39
      The number of free pages in the buffer pool.
67
564
40
68
    - InnoDB Insert Buffer Usage (innodb_insert_buffer_usage)
565
41
    - 'database_pages'
69
566
42
      The number of used pages in the buffer pool.
70
      - 'ibuf_free_cells'
567
43
71
        The number of free cells of the Insert Buffer.
568
44
    - 'modified_pages' 
72
569
45
      The number of modified (dirty) pages in the buffer pool.
73
      - 'ibuf_used_cells'
570
46
74
        The number of cells of the Insert Buffer being used.
571
47
    - 'pages_read' 
75
572
48
      The number of logical reads of pages that the engine could not satisfy from the buffer pool, and had to read directly from the disk (pages per second). 
76
      - 'ibuf_cell_count'
573
49
77
        The number of cells allocated for the Insert Buffer.
574
50
    - 'pages_created'
78
575
51
      The number of created pages per second.
79
    - InnoDB Internal Hash Memory Usage (innodb_internal_hash_struct)
576
52
80
577
53
    - 'pages_written'
81
      - 'adaptive_hash_memory'
578
54
      The number of pages written per second.
82
        The amount of memory in bytes used by InnoDB Adaptive Hash Index
579
55
83
580
56
    - 'file_fsyncs'
84
      - 'page_hash_memory'
581
57
      The number of fsync() calls per second (operations per second).
85
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
582
58
86
583
59
    - 'file_reads'
87
      - 'dictionary_cache_memory'
584
60
      The number of file reads per second (operations per second).
88
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
585
61
89
586
62
    - 'file_writes'
90
      - 'file_system_memory'
587
63
      The amount of InnoDB's file writes per second (operations per second).
91
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
588
64
92
589
65
    - 'log_writes'
93
      - 'lock_system_memory'
590
66
      The number of physical writes per second to the log file (operations per second).
94
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
591
67
95
592
68
    - 'pending_aio_log_ios'
96
      - 'recovery_system_memory'
593
69
     The number of total pending I/O operations to the log file (IO).
97
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
594
70
98
595
71
    - * 'pending_aio_sync_ios'
99
      - 'thread_hash_memory'
596
72
      The number of pending asynchronous fsync() operations in the data files (IO).
100
        The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
597
73
101
598
74
    - 'pending_buf_pool_flushes'
102
    - InnoDB I/O Activity (innodb_io)
599
75
      The number of pending buffer pool page-flush requests (IO).
103
600
76
104
      - 'file_fsyncs'
601
77
    - 'pending_chkp_writes'
105
        The number of fsync() calls per second (operations per second).
602
78
      The number of pending checkpoints writes (IO).
106
603
79
107
      - 'file_reads'
604
80
    - 'pending_ibuf_aio_reads'
108
        The number of file reads per second (operations per second).
605
81
      The number of pending asynchronous Insert Buffer reads (IO).
109
606
82
110
      - 'file_writes'
607
83
    - 'pending_log_flushes'
111
        The amount of InnoDB's file writes per second (operations per second).
608
84
      The number of pending flushes to the log file (IO).
112
609
85
113
      - 'log_writes'
610
86
    - 'pending_log_writes'
114
        The number of physical writes per second to the log file (operations per second).
611
87
      The number of pending log file writes (IO).
115
612
88
116
    - InnoDB I/O Pending (innodb_io_pending) 
613
89
    - 'pending_normal_aio_reads'
117
614
90
      The number of pending asynchronous normal reads (IO).
118
      - 'pending_aio_log_ios'
615
91
119
       The number of total pending I/O operations to the log file (IO).
616
92
    - 'pending_normal_aio_writes'
120
617
93
      The number of pending asynchronous normal writes (IO).
121
      - 'pending_aio_sync_ios'
618
94
122
        The number of pending asynchronous fsync() operations in the data files (IO).
619
95
    - 'ibuf_inserts'
123
620
96
      The number of INSERT operations per second in the InnoDB Insert Buffer.
124
      - 'pending_buf_pool_flushes'
621
97
125
        The number of pending buffer pool page-flush requests (IO).
622
98
    - 'ibuf_merged' 
126
623
99
      The number of MERGED RECORD operations per second in the InnoDB Insert Buffer.
127
      - 'pending_chkp_writes'
624
100
128
        The number of pending checkpoints writes (IO).
625
101
    - 'ibuf_merges' 
129
626
102
      The number of MERGE operations per second in the InnoDB Insert Buffer.
130
      - 'pending_ibuf_aio_reads'
627
103
131
        The number of pending asynchronous Insert Buffer reads (IO).
628
104
    - 'spin_waits'
132
629
105
      The number of spin waits per second done by threads.
133
      - 'pending_log_flushes'
630
106
134
        The number of pending flushes to the log file (IO).
631
107
    - 'spin_rounds'
135
632
108
      The number of spin rounds per seconds done by threads.
136
      - 'pending_log_writes'
633
109
137
        The number of pending log file writes (IO).
634
110
    - 'os_waits'
138
635
111
      The number of OS waits per second done by threads.
139
      - 'pending_normal_aio_reads'
636
112
140
        The number of pending asynchronous normal reads (IO).
637
113
    - 'rows_inserted' 
141
638
114
      The number of rows per second inserted into InnoDB tables.
142
      - 'pending_normal_aio_writes'
639
115
143
        The number of pending asynchronous normal writes (IO).
640
116
    - 'rows_updated' 
144
641
117
      The number of rows updated per second in InnoDB tables. 
145
    - InnoDB Lock Structures (innodb_lock_structures)
642
118
146
643
119
    - 'rows_deleted'
147
      - 'innodb_lock_structs'
644
120
      The number of rows deleted per second from InnoDB tables.
148
        The number of internal lock structures InnoDB has (locks).
645
121
149
646
122
    - 'rows_read'
150
    - InnoDB Log Size (innodb_log)
647
123
      The number of rows reads per second from InnoDB tables. 
151
648
124
152
      - 'innodb_log_buffer_size'
649
125
    - 'Table_locks_waited'
153
        The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables.
650
126
      The number of times per second that a request for a table lock could not be granted immediately and a wait was needed (locks per second).
154
651
127
155
      - 'unflushed_log'
652
128
    - 'Table_locks_immediate'
156
        The amount in kilobytes of InnoDB logs that hasn't been flushed. 
653
129
      The number of times per second that a request for a table lock could be granted immediately (locks per second).
157
654
130
158
    - InnoDB Log Activity (innodb_log_activity)
655
131
    - 'Slow_queries'
159
656
132
      The number of queries per second that have taken more than 'long_query_time' seconds.
160
      - 'log_bytes_flushed'
657
133
161
        The amount in bytes of InnoDB logs that has been flushed per second.
658
134
    - 'Open_files'
162
659
135
      The number of files that are open per second. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. Also, the count does not include files that storage engines open using their own internal functions rather than asking the server level to do so. 
163
      - 'log_bytes_written'
660
136
      
164
        The amount in bytes of InnoDB logs that hasn't been flushed per second.
661
137
    - 'Open_tables'
165
662
138
      The number of tables that are open per second. 
166
    - InnoDB Memory Allocation (innodb_memory_allocation)
663
139
167
664
140
    - 'Opened_tables'
168
      - 'total_mem_alloc'
665
141
      The number of tables per second that have been opened with my_open() (a 'mysys' library function). Parts of the server that open files without using this function do not increment the count. 
169
        The total amount of memory allocated by InnoDB in bytes.
666
142
170
667
143
    - 'innodb_open_files'
171
      - 'additional_pool_alloc'
668
144
       The number of files per second that are open by InnoDB using its own internal functions rather than asking the server level to do so. 
172
        The amount of memory allocated in the additional pool by InnoDB.
669
145
173
670
146
    - 'open_files_limit'
174
    - InnoDB Row Operations (innodb_row_operations)
671
147
      The number of open files that the server can have.
175
672
148
176
      - 'rows_inserted' 
673
149
    - 'table_cache'
177
        The number of rows per second inserted into InnoDB tables.
674
150
      The number of tables been cached.
178
675
151
179
      - 'rows_updated' 
676
152
    - 'Aborted_clients'
180
        The number of rows updated per second in InnoDB tables. 
677
153
      The number of connections per second that were aborted because the client died without closing the connection properly. 
181
678
154
182
      - 'rows_deleted'
679
155
    - 'Aborted_connects'
183
        The number of rows deleted per second from InnoDB tables.
680
156
      The number of failed attempts per second to connect to the MySQL server.
184
681
157
185
      - 'rows_read'
682
158
    - 'Max_used_connections'
186
        The number of rows reads per second from InnoDB tables. 
683
159
      The maximum number of connections that have been in use simultaneously since the server started. 
187
684
160
188
    - InnoDB Row Lock Acquiring Time (innodb_row_lock_time)
685
161
    - 'Slow_launch_threads'
189
686
162
      The number of threads that have taken more than 'slow_launch_time' seconds to create. 
190
      - 'Innodb_row_lock_time'
687
163
191
        The total time spent in acquiring row locks, in milliseconds.
688
164
    - 'Threads_cached'
192
689
165
      The number of threads in the thread cache. 
193
    - InnoDB Row Lock Waits (innodb_row_lock_waits)
690
166
194
691
167
    - 'Threads_connected'
195
      - 'Innodb_row_lock_waits'
692
168
      The number of currently open connections per second. 
196
        The number of times per second a row lock had to be waited for (waits per second). 
693
169
197
694
170
    - 'Threads_created'
198
    - InnoDB Semaphores (innodb_semaphores)
695
171
      The number of threads per second created to handle connections.
199
696
172
200
      - 'spin_waits'
697
173
    - 'Threads_running'
201
        The number of spin waits per second done by threads.
698
174
      The number of threads that are not sleeping. 
202
699
175
203
      - 'spin_rounds'
700
176
    - 'max_connections'
204
        The number of spin rounds per seconds done by threads.
701
177
      The number of connections permitted in the server.
205
702
178
206
      - 'os_waits'
703
179
    - 'thread_cache_size'
207
        The number of OS waits per second done by threads.
704
180
      How many threads the server should cache for reuse.
208
705
181
209
    - InnoDB Semaphore Waits (innodb_semaphore_waits)
706
182
    - 'Connections'
210
707
183
      The number of connection attempts per second (successful or not) to the server (connections per second). 
211
      - 'innodb_sem_waits'
708
184
212
        The total number of InnoDB semaphore waits per second.
709
185
    - 'slave_running'
213
710
186
      This is 1 (ON) if this server is a replication slave that is connected to a replication master, and both the I/O and SQL threads are running; otherwise, it is 0 (OFF).
214
    - InnoDB Semaphore Waiting Time (innodb_semaphore_wait_time)
711
187
215
712
188
    - 'slave_stopped'
216
      - 'innodb_sem_wait_time_ms'
713
189
      This is 1 if this server is NOT a replication slave and neither both of the I/O and SQL threads are running; otherwise, it is 0.
217
        The total number of milliseconds waited for semaphores.
714
190
218
715
191
    - 'Slave_retried_transactions'
219
    - InnoDB Tables In Use (innodb_tables_in_use)
716
192
      The total number of times since startup that the replication slave SQL thread has retried transactions (transactions). 
220
717
193
221
      - 'innodb_tables_in_use'
718
194
    - 'slave_lag' 
222
        The number of InnoDB tables in use.
719
195
      The number of seconds (estimation) of the lag between the master and the slave in a replication environment.
223
720
196
224
      - 'innodb_locked_tables'
721
197
    - 'Slave_open_temp_tables'
225
        The number of InnoDB tables that are locked.
722
198
      The number of temporary tables that the slave SQL thread currently has open.
226
723
199
227
    - InnoDB Transactions (innodb_transactions_report)
724
200
    - 'Qcache_free_blocks'
228
725
201
      The number of free memory blocks in the query cache. 
229
      - 'innodb_transactions'
726
202
230
            The number of transactions done by the server (internal transaction counter).
727
203
    - 'Qcache_free_memory'
231
728
204
      The amount of free memory in bytes for the query cache.
232
    - InnoDB Transaction Activity (innodb_transaction_activity)
729
205
233
730
206
    - 'Qcache_hits'
234
      - 'history_list'
731
207
      The number of query cache hits per second. 
235
        The length of the history list shows how old the oldest unpurged transaction is (transactions).
732
208
236
733
209
    - 'Qcache_inserts'
237
      - 'read_views'
734
210
      The number of queries per second added to the query cache.
238
        The number of read views open shows how many transactions have a consistent snapshot of the database's contents, which is achieved by MVCC (transactions).
735
211
239
            
736
212
    - 'Qcache_lowmem_prunes'
240
      - 'current_transactions'
737
213
      The number of queries per second that were deleted from the query cache because of low memory.
241
        The total number of transactions currently in the server, no matter what status (ACTIVE, LOCK WAIT, not started, etc).
738
214
242
739
215
    - 'Qcache_not_cached'
243
    - MySQL Threads (mysql_threads)
740
216
      The number of non-cached queries per second (not cacheable, or not cached due to the 'query_cache_type' setting). 
244
741
217
245
      - 'Threads_created'
742
218
    - 'Qcache_queries_in_cache'
246
        The number of threads per second created to handle connections.
743
219
      The number of queries per second registered in the query cache.
247
744
220
248
      - 'Threads_cached'
745
221
    - 'Qcache_total_blocks'
249
        The number of threads in the thread cache. 
746
222
      The total number of blocks in the query cache. 
250
747
223
251
      - 'Threads_running'
748
224
    - 'query_cache_size'
252
        The number of threads that are not sleeping. 
749
225
      The amount of memory allocated for caching query results.
253
750
226
254
      - 'thread_cache_size'
751
227
    - 'Questions'
255
        How many threads the server should be cached for reuse.
752
228
      The number of statements per second executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands (queries per second).
256
753
229
257
      - 'Slow_launch_threads'
754
230
    - 'Com_update'
258
        The number of threads that have taken more than 'slow_launch_time' seconds to create. 
755
231
      The number of UPDATE statements per second executed (queries per second).
259
756
232
260
    - MyISAM indexes (myisam_indexes)
757
233
    - 'Com_insert'
261
758
234
      The number of INSERT statements per second executed (queries per second).
262
      - 'Key_read_requests'
759
235
263
        The number of reads of a key block from the cache (operations per second). 
760
236
    - 'Com_select'
264
761
237
      The number of SELECT statements per second executed (queries per second).
265
      - 'Key reads'
762
238
266
        The number of physical reads of a key block from disk (operations per second).
763
239
    - 'Com_delete'
267
764
240
      The number of DELETE statements per second executed (queries per second).
268
      - 'Key_write_requests'
765
241
269
        The number of writes of a key block to the cache (operations per second). 
766
242
    - 'Com_replace'
270
767
243
      The number of REPLACE statements per second executed (queries per second).
271
      - 'Key_write'
768
244
272
        The number of physical writes of a key block to disk (operations per second).
769
245
    - 'Com_load'
273
770
246
      The number of LOAD statements per second executed (queries per second).
274
    - MyISAM Key Cache (myisam_key_cache)
771
247
275
772
248
    - 'Com_update_multi'
276
      - 'Key_buf_bytes_unflushed'
773
249
      The number of UPDATE statements on multiple columns (???) per second executed (queries per second).
277
        The amount of memory in bytes used for the key cache that have changed but have not yet been flushed to disk.
774
250
278
775
251
    - 'Com_insert_select'
279
      - 'Key_buf_bytes_used'
776
252
      The number of INSERT ... SELECT statements per second executed (queries per second).
280
        The amount of memory in bytes used for buffering index blocks (MyISAM tables).
777
253
281
778
254
    - 'Com_delete_multi'
282
      - 'key_buffer_size'
779
255
      The number of DELETE statements on multiple rows (??) per second executed (queries per second).
283
        The amount of memory in bytes designated for buffering index blocks for MyISAM tables.
780
256
284
781
257
    - 'Com_replace_select'
285
    - MySQL Binary and Relay Logs (mysql_binary_relay_logs)
782
258
      The number of REPLACE ... SELECT statements per second executed (queries per second).
286
783
259
287
      - 'binary_log_space'
784
260
    - 'Select_full_join'
288
        The total size in bytes of all existing binary log files.
785
261
      The number of joins per second that perform table scans because they do not use indexes (queries per second).
289
786
262
290
      - 'relay_log_space'
787
263
    - 'Select_full_range_join'
291
        The total combined size in bytes of all existing relay log files.
788
264
      The number of joins per second that used a range search on a reference table (queries per second).
292
789
265
      
293
      - 'Binlog_cache_disk_use'
790
266
    - 'Select_range'
294
        The amount in bytes of the binary log cache in disk used by transactions: when the value of 'binlog_cache_size' is exceeded, a temporary file is used to store changes from the transaction.
791
267
      The number of joins per second that used ranges on the first table (queries per second).
295
792
268
296
      - 'Binlog_cache_use'
793
269
    - 'Select_range_check'
297
        The amount in bytes of the binary log cache used by transactions. 
794
270
      The number of joins without keys per second that checked for key usage after each row (queries per second).
298
795
271
299
    - MySQL Command Counters (mysql_command_counters)
796
272
    - 'Select_scan'
300
797
273
      The number of joins statements that did a full scan of the first table (queries per second). 
301
      - 'Questions'
798
274
302
        The number of statements per second executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands (queries per second).
799
275
    - 'Sort_merge_passes'
303
800
276
      The number of merge passes per second that the sort algorithm has had to do (queries per second).
304
      - 'Com_update'
801
277
305
        The number of UPDATE statements per second executed (queries per second).
802
278
    - 'Sort_range'
306
803
279
      The number of sorts per second that were done using ranges (queries per second). 
307
      - 'Com_insert'
804
280
308
        The number of INSERT statements per second executed (queries per second).
805
281
    - 'Sort_rows'
309
806
282
      The number of sorted rows per second (rows per second).
310
      - 'Com_select'
807
283
311
        The number of SELECT statements per second executed (queries per second).
808
284
    - 'Sort_scan'
312
809
285
      The number of sorts per second that were done by scanning the table (queries per second). 
313
      - 'Com_delete'
810
286
314
        The number of DELETE statements per second executed (queries per second).
811
287
    - 'Created_tmp_tables'
315
812
288
      The number of internal temporary tables per second created by the server while executing statements.
316
      - 'Com_replace'
813
289
317
        The number of REPLACE statements per second executed (queries per second).
814
290
    - 'Created_tmp_disk_tables'
318
815
291
      The number of internal on-disk temporary tables created per second by the server while executing statements. 
319
      - 'Com_load'
816
292
320
        The number of LOAD statements per second executed (queries per second).
817
293
    - 'Created_tmp_files'
321
818
294
      The number of temporary files per second that the server has created. 
322
      - 'Com_update_multi'
819
295
323
        The number of UPDATE statements on multiple columns (???) per second executed (queries per second).
820
296
    - 'Bytes_sent'
324
821
297
      The number of bytes per second sent to all clients. 
325
      - 'Com_insert_select'
822
298
326
        The number of INSERT ... SELECT statements per second executed (queries per second).
823
299
    - 'Bytes_received'
327
824
300
      The number of bytes per second received from all clients. 
328
      - 'Com_delete_multi'
825
301
329
        The number of DELETE statements on multiple rows (??) per second executed (queries per second).
826
302
    - 'innodb_log_buffer_size'
330
      
827
303
      The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables.
331
      - 'Com_replace_select'
828
304
332
        The number of REPLACE ... SELECT statements per second executed (queries per second).
829
305
    - 'unflushed_log'
333
830
306
      The amount in kilobytes of InnoDB logs that hasn't been flushed. 
334
    - MySQL Connections (mysql_connections)
831
307
335
832
308
    - 'log_bytes_flushed'
336
      - 'max_connections'
833
309
      The amount in bytes of InnoDB logs that has been flushed per second.
337
        The number of connections permitted in the server.
834
310
338
835
311
    - 'log_bytes_written'
339
      - 'Max_used_connections'
836
312
      The amount in bytes of InnoDB logs that hasn't been flushed per second.
340
        The maximum number of connections that have been in use simultaneously since the server started. 
837
313
341
838
314
    - 'relay_log_space'
342
    - MySQL Connections Types (mysql_connections_types)
839
315
      The total combined size in bytes of all existing relay log files.
343
840
316
344
      - 'Connections'
841
317
    - 'binlog_cache_size'
345
        The number of connection attempts per second (successful or not) to the server (connections per second). 
842
318
      The size in bytes of the cache to hold changes to the binary log during a transaction.
346
843
319
347
      - 'Aborted_clients'
844
320
    - 'Binlog_cache_disk_use'
348
        The number of connections per second that were aborted because the client died without closing the connection properly. 
845
321
      The amount in bytes of the binary log cache in disk used by transactions: when the value of 'binlog_cache_size' is exceeded, a temporary file is used to store changes from the transaction.
349
846
322
350
      - 'Aborted_connects'
847
323
    - 'Binlog_cache_use'
351
        The number of failed attempts per second to connect to the MySQL server.
848
324
      The amount in bytes of the binary log cache used by transactions. 
352
849
325
353
      - 'Threads_connected'
850
326
    - 'binary_log_space'
354
        The number of currently open connections per second. 
851
327
      The total size in bytes of all existing binary log files.
355
852
328
356
    - MySQL Files and Tables (mysql_files_tables)
853
329
    - 'innodb_locked_tables'
357
854
330
      The number of InnoDB tables that are locked.
358
      - 'table_cache'
855
331
359
        The number of tables been cached.
856
332
    - 'innodb_lock_structs'
360
857
333
      The number of internal lock structures InnoDB has (locks).
361
      - 'Open_files'
858
334
362
        The number of files that are open per second. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. Also, the count does not include files that storage engines open using their own internal functions rather than asking the server level to do so. 
859
335
    - 'State_closing_tables'
363
860
336
      The number of threads being in 'closing_tables' state: the thread is flushing the changed table data to disk and closing the used tables.
364
      - 'Open_tables'
861
337
365
        The number of tables that are open per second. 
862
338
    - 'State_copying_to_tmp_table'
366
863
339
      The number of threads being in 'copying to tmp table' state: the thread is creating a temporary table in memory or on disk.
367
      - 'Opened_tables'
864
340
368
        The number of tables per second that have been opened with my_open() (a 'mysys' library function). Parts of the server that open files without using this function do not increment the count. 
865
341
    - 'State_end'
369
866
342
      The number of threads being in 'end' state: this occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. 
370
    - MySQL Handlers (mysql_handlers)
867
343
371
868
344
    - 'State_freeing_items'
372
      - 'Handler_write'
869
345
      The number of threads being in 'freeing items' state: the thread has executed a command. Some freeing of items done during this state involves the query cache.
373
        The number of requests per second to insert a row in a table (calls per second). 
870
346
374
871
347
    - 'State_init'
375
      - 'Handler_update'
872
348
      The number of threads per second being in 'init' state: this occurs before the initialization of ALTER TABLE, DELETE, INSERT, SELECT, or UPDATE statements. Actions taken by the server in this state include flushing the binary log, the InnoDB log, and some query cache cleanup operations. 
376
        The number of requests per second to update a row in a table (calls per second). 
873
349
377
874
350
    - 'State_locked'
378
      - 'Handler_delete'
875
351
      The number of threads being in 'locked' state: the query is locked by another query.
379
        The number of times that rows have been deleted from tables (calls per second). 
876
352
380
877
353
    - 'State_login'
381
      - 'Handler_read_first'
878
354
      The number of threads being in 'login' state: the initial state for a connection thread until the client has been authenticated successfully. 
382
        The number of times per second the first entry in an index was read (calls per second).
879
355
383
880
356
    - 'State_preparing'
384
      - 'Handler_read_key' 
881
357
      The number of threads being in 'preparing' state: this state occurs during query optimization. 
385
        The number of requests per second to read a row based on a key (calls per second).
882
358
386
883
359
    - 'State_reading_from_net'
387
      - 'Handler_read_next'
884
360
      The number of threads being in 'reading form net' state: the server is reading a packet from the network. 
388
        The number of requests per second to read the next row in key order (calls per second).
885
361
389
886
362
    - 'State_sending_data'
390
      - 'Handler_read_prev'
887
363
      The number of threads being in 'sending data' state: the thread is reading and processing rows for a SELECT statement, and sending data to the client.
391
        The number of requests per second to read the previous row in key order (calls per second).
888
364
392
889
365
    - 'State_sorting_result'
393
      - 'Handler_read_rnd'
890
366
      The number of threads being in 'sorting result' state: for a SELECT statement, the thread is sorting index pages for more efficient access for nontemporary tables. 
394
        The number of requests per second to read a row based on a fixed position (calls per second).
891
367
395
892
368
    - 'State_statistics'
396
      - 'Handler_read_rnd_next'
893
369
      The number of threads being in 'statistics' state: the server is calculating statistics to develop a query execution plan.
397
        The number of requests per second to read the next row in the data file (calls per second).
894
370
398
895
371
    - 'State_updating'
399
    - MySQL Network (mysql_network_report)
896
372
      The number of threads being in 'updating' state: the thread is searching for rows to update and is updating them. 
400
897
373
401
      - 'Bytes_sent'
898
374
    - 'State_writing_to_net'
402
        The number of bytes per second sent to all clients. 
899
375
      The number of threads being in 'writing to net' state: the server is writing a packet to the network. 
403
900
376
404
      - 'Bytes_received'
901
377
    - 'State_none'
405
        The number of bytes per second received from all clients. 
902
378
      The number of threads being in 'none' state: (NULL??) this state is used for the SHOW PROCESSLIST state.
406
903
379
407
    - MySQL Processlist (mysql_process_list)
904
380
    - 'State_other'
408
905
381
      The number of threads being in other state than the previously specified.
409
      - 'State_closing_tables'
906
382
410
        The number of threads being in 'closing_tables' state: the thread is flushing the changed table data to disk and closing the used tables.
907
383
    - 'Handler_commit'
411
908
384
      The number of internal COMMIT calls per second. 
412
      - 'State_copying_to_tmp_table'
909
385
413
        The number of threads being in 'copying to tmp table' state: the thread is creating a temporary table in memory or on disk.
910
386
    - 'Handler_delete'
414
911
387
      The number of times that rows have been deleted from tables (calls per second). 
415
      - 'State_end'
912
388
416
        The number of threads being in 'end' state: this occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. 
913
389
    - 'Handler_discover'
417
914
390
      The number of times per second that tables have been discovered asking the NDBCLUSTER storage engine.
418
      - 'State_freeing_items'
915
391
419
        The number of threads being in 'freeing items' state: the thread has executed a command. Some freeing of items done during this state involves the query cache.
916
392
    - 'Handler_prepare'
420
917
393
      The number of prepare phases of two-phase commit operations (calls per second). 
421
      - 'State_init'
918
394
422
        The number of threads per second being in 'init' state: this occurs before the initialization of ALTER TABLE, DELETE, INSERT, SELECT, or UPDATE statements. Actions taken by the server in this state include flushing the binary log, the InnoDB log, and some query cache cleanup operations. 
919
395
    - 'Handler_read_first'
423
920
396
      The number of times per second the first entry in an index was read (calls per second).
424
      - 'State_locked'
921
397
425
        The number of threads being in 'locked' state: the query is locked by another query.
922
398
    - 'Handler_read_key' 
426
923
399
      The number of requests per second to read a row based on a key (calls per second).
427
      - 'State_login'
924
400
428
        The number of threads being in 'login' state: the initial state for a connection thread until the client has been authenticated successfully. 
925
401
    - 'Handler_read_next'
429
926
402
      The number of requests per second to read the next row in key order (calls per second).
430
      - 'State_preparing'
927
403
431
        The number of threads being in 'preparing' state: this state occurs during query optimization. 
928
404
    - 'Handler_read_prev'
432
929
405
      The number of requests per second to read the previous row in key order (calls per second).
433
      - 'State_reading_from_net'
930
406
434
        The number of threads being in 'reading form net' state: the server is reading a packet from the network. 
931
407
    - 'Handler_read_rnd'
435
932
408
      The number of requests per second to read a row based on a fixed position (calls per second).
436
      - 'State_sending_data'
933
409
437
        The number of threads being in 'sending data' state: the thread is reading and processing rows for a SELECT statement, and sending data to the client.
934
410
    - 'Handler_read_rnd_next'
438
935
411
      The number of requests per second to read the next row in the data file (calls per second).
439
      - 'State_sorting_result'
936
412
440
        The number of threads being in 'sorting result' state: for a SELECT statement, the thread is sorting index pages for more efficient access for nontemporary tables. 
937
413
    - 'Handler_rollback'
441
938
414
      The number of requests per second for a storage engine to perform a rollback operation (calls per second). 
442
      - 'State_statistics'
939
415
443
        The number of threads being in 'statistics' state: the server is calculating statistics to develop a query execution plan.
940
416
    - 'Handler_savepoint'
444
941
417
      The number of requests per second for a storage engine to place a savepoint (calls per second). 
445
      - 'State_updating'
942
418
446
        The number of threads being in 'updating' state: the thread is searching for rows to update and is updating them. 
943
419
    - 'Handler_savepoint_rollback'
447
944
420
      The number of requests per second for a storage engine to roll back to a savepoint (calls per second). 
448
      - 'State_writing_to_net'
945
421
449
        The number of threads being in 'writing to net' state: the server is writing a packet to the network. 
946
422
    - 'Handler_update'
450
947
423
      The number of requests per second to update a row in a table (calls per second). 
451
      - 'State_none'
948
424
452
        The number of threads being in 'none' state: (NULL??) this state is used for the SHOW PROCESSLIST state.
949
425
    - 'Handler_write'
453
950
426
      The number of requests per second to insert a row in a table (calls per second). 
454
      - 'State_other'
951
427
455
        The number of threads being in other state than the previously specified.
952
428
    - 'innodb_tables_in_use'
456
953
429
      The number of InnoDB tables in use.
457
    - MySQL Query Cache (mysql_query_cache)
954
430
458
955
431
    - 'innodb_lock_wait_secs'
459
      - 'Qcache_hits'
956
432
      The total number of seconds that InnoDB transactions have been waiting for locks.
460
        The number of query cache hits per second. 
957
433
461
958
434
    - 'hash_index_cells_total'
462
      - 'Qcache_inserts'
959
435
      The total number of Adaptative Hash Index cells of InnoDB.
463
        The number of queries per second added to the query cache.
960
436
464
961
437
    - 'hash_index_cells_used'
465
      - 'Qcache_lowmem_prunes'
962
438
      The number of cells Adaptative Hash Index cells used by InnoDB.
466
        The number of queries per second that were deleted from the query cache because of low memory.
963
439
467
964
440
    - 'total_mem_alloc'
468
      - 'Qcache_not_cached'
965
441
      The total amount of memory allocated by InnoDB in bytes.
469
        The number of non-cached queries per second (not cacheable, or not cached due to the 'query_cache_type' setting). 
966
442
470
967
443
    - 'additional_pool_alloc'
471
      - 'Qcache_queries_in_cache'
968
444
      The amount of memory allocated in the additional pool by InnoDB.
472
        The number of queries per second registered in the query cache.
969
445
473
970
446
    - 'uncheckpointed_bytes'
474
    - MySQL Query Cache Memory (mysql_query_cache_memory)
971
447
      The number of uncheckpointed bytes: the amount of recovery that'll have to be performed if there's a crash.
475
972
448
476
      - 'Qcache_free_blocks'
973
449
    - 'ibuf_used_cells'
477
        The number of free memory blocks in the query cache. 
974
450
      The number of cells of the Insert Buffer being used.
478
975
451
479
      - 'Qcache_free_memory'
976
452
    - 'ibuf_free_cells'
480
        The amount of free memory in bytes for the query cache.
977
453
      The number of free cells of the Insert Buffer.
481
978
454
482
      - 'Qcache_total_blocks'
979
455
    - 'ibuf_cell_count'
483
        The total number of blocks in the query cache. 
980
456
      The number of cells allocated for the Insert Buffer.
484
981
457
485
      - 'query_cache_size'
982
458
    - 'adaptive_hash_memory'
486
        The amount of memory allocated for caching query results.
983
459
      The amount of memory in bytes used by InnoDB Adaptive Hash Index
487
984
460
488
    - MySQL Replication Status (mysql_replication)
985
461
    - 'page_hash_memory'
489
986
462
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
490
      - 'slave_running'
987
463
491
        This is 1 (ON) if this server is a replication slave that is connected to a replication master, and both the I/O and SQL threads are running; otherwise, it is 0 (OFF).
988
464
    - 'dictionary_cache_memory'
492
989
465
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
493
      - 'slave_stopped'
990
466
494
        This is 1 if this server is NOT a replication slave and neither both of the I/O and SQL threads are running; otherwise, it is 0.
991
467
    - 'file_system_memory'
495
992
468
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
496
      - 'Slave_retried_transactions'
993
469
497
        The total number of times since startup that the replication slave SQL thread has retried transactions (transactions). 
994
470
    - 'lock_system_memory'
498
995
471
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
499
      - 'slave_lag' 
996
472
500
        The number of seconds (estimation) of the lag between the master and the slave in a replication environment.
997
473
    - 'recovery_system_memory'
501
998
474
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
502
    - MySQL Select Types (mysql_select_types)
999
475
503
1000
476
    - 'thread_hash_memory'
504
      - 'Select_full_join'
1001
477
       The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB.
505
        The number of joins per second that perform table scans because they do not use indexes (queries per second).
1002
478
506
1003
479
    - 'innodb_sem_waits'
507
      - 'Select_full_range_join'
1004
480
       The total number of InnoDB semaphore waits per second.
508
        The number of joins per second that used a range search on a reference table (queries per second).
1005
481
509
1006
482
    - 'innodb_sem_wait_time_ms'
510
      - 'Select_range'
1007
483
       The total number of milliseconds waited for semaphores.
511
        The number of joins per second that used ranges on the first table (queries per second).
1008
484
512
1009
485
    - 'Key_buf_bytes_unflushed'
513
      - 'Select_range_check'
1010
486
      The amount of memory in bytes used for the key cache that have changed but have not yet been flushed to disk.
514
        The number of joins without keys per second that checked for key usage after each row (queries per second).
1011
487
515
1012
488
    - 'Key_buf_bytes_used'
516
      - 'Select_scan'
1013
489
      The amount of memory in bytes used for buffering index blocks (MyISAM tables).
517
        The number of joins statements that did a full scan of the first table (queries per second). 
1014
490
518
1015
491
    - 'key_buffer_size'
519
    - MySQL Sorts (mysql_sorts)
1016
492
      The amount of memory in bytes designated for buffering index blocks for MyISAM tables.
520
1017
493
521
      - 'Sort_merge_passes'
1018
494
    - 'Innodb_row_lock_time'
522
        The number of merge passes per second that the sort algorithm has had to do (queries per second).
1019
495
      The total time spent in acquiring row locks, in milliseconds.
523
1020
496
524
      - 'Sort_range'
1021
497
    - 'Innodb_row_lock_waits'
525
        The number of sorts per second that were done using ranges (queries per second). 
1022
498
      The number of times per second a row lock had to be waited for (waits per second). 
526
1023
527
      - 'Sort_scan'
1024
528
        The number of sorts per second that were done by scanning the table (queries per second). 
1025
529
1026
530
    - MySQL Rows Sorted (mysql_rows_sorted)
1027
531
1028
532
      - 'Sort_rows'
1029
533
        The number of sorted rows per second (rows per second).
1030
534
1031
535
    - MySQL Table Locks (mysql_table_locks)
1032
536
1033
537
      - 'Table_locks_waited'
1034
538
        The number of times per second that a request for a table lock could not be granted immediately and a wait was needed (locks per second).
1035
539
      
1036
540
      - 'Table_locks_immediate'
1037
541
        The number of times per second that a request for a table lock could be granted immediately (locks per second).
1038
542
1039
543
      - 'Slow_queries'
1040
544
        The number of queries per second that have taken more than 'long_query_time' seconds.
1041
545
1042
546
    - MySQL Temporary Objects (mysql_temporary_objects)
1043
547
1044
548
      - 'Created_tmp_tables'
1045
549
        The number of internal temporary tables per second created by the server while executing statements.
1046
550
1047
551
      - 'Created_tmp_disk_tables'
1048
552
        The number of internal on-disk temporary tables created per second by the server while executing statements. 
1049
553
1050
554
      - 'Created_tmp_files'
1051
555
        The number of temporary files per second that the server has created. 
1052
556
1053
557
    - MySQL Transaction Handler (mysql_transaction_handler)
1054
558
1055
559
      - 'Handler_commit'
1056
560
        The number of internal COMMIT calls per second. 
1057
561
1058
562
      - 'Handler_rollback'
1059
563
        The number of requests per second for a storage engine to perform a rollback operation (calls per second). 
1060
564
1061
565
      - 'Handler_savepoint'
1062
566
        The number of requests per second for a storage engine to place a savepoint (calls per second). 
1063
567
1064
568
      - 'Handler_savepoint_rollback'
1065
569
        The number of requests per second for a storage engine to roll back to a savepoint (calls per second). 
1066
499
570
1067
=== modified file 'conf/default.json'
1068
--- conf/default.json	2011-07-22 02:16:54 +0000
1069
+++ conf/default.json	2011-07-25 22:42:07 +0000
1070
@@ -1,3 +1,52 @@
1071
1
{
1
{
1073
2
	"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"]
2
    "included_reports": [
1074
3
        "load_report",
1075
4
        "mem_report",
1076
5
        "cpu_report",
1077
6
        "network_report",
1078
7
        "innodb_transactions_active_locked",
1079
8
        "innodb_adaptative_hash_indexes",
1080
9
        "innodb_buffer_pool",
1081
10
        "innodb_buffer_pool_activity",
1082
11
        "innodb_checkpoint_age",
1083
12
        "innodb_current_locks_wait",
1084
13
        "innodb_insert_buffer",
1085
14
        "innodb_insert_buffer_usage",
1086
15
        "innodb_internal_hash_struct",
1087
16
        "innodb_io",
1088
17
        "innodb_io_pending",
1089
18
        "innodb_lock_structures",
1090
19
        "innodb_log",
1091
20
        "innodb_log_activity",
1092
21
        "innodb_memory_allocation",
1093
22
        "innodb_row_lock_time",
1094
23
        "innodb_row_lock_waits",
1095
24
        "innodb_row_operations",
1096
25
        "innodb_semaphores",
1097
26
        "innodb_semaphores_waits",
1098
27
        "innodb_semaphores_waits_times",
1099
28
        "innodb_tables_in_use",
1100
29
        "innodb_transactions_report",
1101
30
        "innodb_transaction_activity",
1102
31
        "myisam_indexes",
1103
32
        "myisam_key_cache",
1104
33
        "mysql_binary_relay_logs",
1105
34
        "mysql_command_counters",
1106
35
        "mysql_connections",
1107
36
        "mysql_connections_types",
1108
37
        "mysql_files_tables",
1109
38
        "mysql_handlers",
1110
39
        "mysql_network_traffic",
1111
40
        "mysql_process_list",
1112
41
        "mysql_query_cache",
1113
42
        "mysql_query_cache_memory",
1114
43
        "mysql_replication",
1115
44
        "mysql_select_types",
1116
45
        "mysql_sorts",
1117
46
        "mysql_rows_sorted",
1118
47
        "mysql_table_locks",
1119
48
        "mysql_temporary_objects",
1120
49
        "mysql_transaction_handler",
1121
50
        "mysql_threads"
1122
51
    ]
1123
3
}
52
}
1124
4
53
1125
=== modified file 'graph.d/innodb_io.json'
1126
--- graph.d/innodb_io.json	2011-07-22 02:16:54 +0000
1127
+++ graph.d/innodb_io.json	2011-07-25 22:42:07 +0000
1128
@@ -1,5 +1,5 @@
1129
1
{
1
{
1131
2
    "report_name":    "innodb_buffer_pool",
2
    "report_name":    "innodb_io",
1132
3
    "report_type":    "standard",
3
    "report_type":    "standard",
1133
4
    "title":          "- InnoDB I/O Activity @",
4
    "title":          "- InnoDB I/O Activity @",
1134
5
    "vertical_label": "Ops/sec",
5
    "vertical_label": "Ops/sec",
1135
6
6
1136
=== modified file 'graph.d/innodb_log.json'
1137
--- graph.d/innodb_log.json	2011-07-22 02:16:54 +0000
1138
+++ graph.d/innodb_log.json	2011-07-25 22:42:07 +0000
1139
@@ -9,6 +9,13 @@
1140
9
            "label":  "Log Buffer Size",
9
            "label":  "Log Buffer Size",
1141
10
            "color":  "FF7F00",
10
            "color":  "FF7F00",
1142
11
            "type":   "stack"
11
            "type":   "stack"
1143
12
        },
1144
13
        {
1145
14
            "metric": "unflushed_log",
1146
15
            "label": "Unflushed Log Bytes",
1147
16
            "color": "E41A1C",
1148
17
            "type": "line",
1149
18
            "line_width": "2"
1150
12
        }
19
        }
1151
13
    ]
20
    ]
1152
14
}
21
}
1153
15
22
1154
=== modified file 'graph.d/innodb_log_activity.json'
1155
--- graph.d/innodb_log_activity.json	2011-07-22 02:16:54 +0000
1156
+++ graph.d/innodb_log_activity.json	2011-07-25 22:42:07 +0000
1157
@@ -17,13 +17,6 @@
1158
17
            "color": "AB4253",
17
            "color": "AB4253",
1159
18
            "type": "line",
18
            "type": "line",
1160
19
            "line_width": "2"
19
            "line_width": "2"
1161
20
        },
1162
21
        {
1163
22
            "metric": "unflushed_log",
1164
23
            "label": "Unflushed Log Bytes",
1165
24
            "color": "AFECED",
1166
25
            "type": "stack",
1167
26
            "line_width": "2"
1168
27
        }
20
        }
1169
28
    ]
21
    ]
1170
29
}
22
}
1171
30
23
1172
=== modified file 'graph.d/innodb_transaction_activity.json'
1173
--- graph.d/innodb_transaction_activity.json	2011-07-22 02:16:54 +0000
1174
+++ graph.d/innodb_transaction_activity.json	2011-07-25 22:42:07 +0000
1175
@@ -4,29 +4,26 @@
1176
4
    "title":          "- InnoDB Transaction Activity @",
4
    "title":          "- InnoDB Transaction Activity @",
1177
5
    "vertical_label": "Transactions",
5
    "vertical_label": "Transactions",
1178
6
    "series": [
6
    "series": [
1179
7
        {
1180
8
            "metric": "innodb_transactions",
1181
9
            "label": "Total Transactions (Internal Transaction Counter)",
1182
10
            "color": "8F005C",
1183
11
            "type": "stack"
1184
12
        },
1185
13
        {  
7
        {  
1186
14
            "metric": "current_transactions",
8
            "metric": "current_transactions",
1187
15
            "label": "Current Transactions",
9
            "label": "Current Transactions",
1188
16
            "color": "4444FF",
10
            "color": "4444FF",
1190
17
            "type": "stack"
11
            "type": "line",
1191
12
            "line_width": "2"
1192
18
        },
13
        },
1193
19
        {  
14
        {  
1194
20
            "metric": "history_list",
15
            "metric": "history_list",
1195
21
            "label": "History List",
16
            "label": "History List",
1196
22
            "color": "FF7D00",
17
            "color": "FF7D00",
1198
23
            "type": "stack"
18
            "type": "line",
1199
19
            "line_width": "2"
1200
24
        },
20
        },
1201
25
        {  
21
        {  
1202
26
            "metric": "read_views",
22
            "metric": "read_views",
1203
27
            "label": "Read Views",
23
            "label": "Read Views",
1204
28
            "color": "74C366",
24
            "color": "74C366",
1206
29
            "type": "stack"
25
            "type": "line",
1207
26
            "line_width": "2"
1208
30
        }
27
        }
1209
31
    ]
28
    ]
1210
32
}
29
}
1211
33
30
1212
=== modified file 'graph.d/innodb_transactions_report.json'
1213
--- graph.d/innodb_transactions_report.json	2011-07-22 02:16:54 +0000
1214
+++ graph.d/innodb_transactions_report.json	2011-07-25 22:42:07 +0000
1215
@@ -10,27 +10,6 @@
1216
10
            "color": "8F005C",
10
            "color": "8F005C",
1217
11
            "type": "line",
11
            "type": "line",
1218
12
            "line_width": "2"
12
            "line_width": "2"
1219
13
        },
1220
14
        {  
1221
15
            "metric": "current_transactions",
1222
16
            "label": "Current Transactions",
1223
17
            "color": "4444FF",
1224
18
            "type": "line",
1225
19
            "line_width": "2"
1226
20
        },
1227
21
        {  
1228
22
            "metric": "history_list",
1229
23
            "label": "History List",
1230
24
            "color": "FF7D00",
1231
25
            "type": "line",
1232
26
            "line_width": "2"
1233
27
        },
1234
28
        {  
1235
29
            "metric": "read_views",
1236
30
            "label": "Read Views",
1237
31
            "color": "74C366",
1238
32
            "type": "line",
1239
33
            "line_width": "2"
1240
34
        }
13
        }
1241
35
    ]
14
    ]
1242
36
}
15
}
1243
37
16
1244
=== modified file 'graph.d/mysql_files_tables.json'
1245
--- graph.d/mysql_files_tables.json	2011-07-22 02:16:54 +0000
1246
+++ graph.d/mysql_files_tables.json	2011-07-25 22:42:07 +0000
1247
@@ -5,6 +5,13 @@
1248
5
    "vertical_label": "Objects/sec",
5
    "vertical_label": "Objects/sec",
1249
6
    "series": [
6
    "series": [
1250
7
        {
7
        {
1251
8
            "metric":     "table_cache",
1252
9
            "label":      "Table Cache",
1253
10
            "color":      "984EA3",
1254
11
            "type":       "line",
1255
12
            "line_width": "2"
1256
13
        },
1257
14
        {
1258
8
            "metric":     "Open_tables",
15
            "metric":     "Open_tables",
1259
9
            "label":      "Open Tables",
16
            "label":      "Open Tables",
1260
10
            "color":      "33A02C",
17
            "color":      "33A02C",
1261
11
18
1262
=== removed file 'graph.d/mysql_network_traffic.json'
1263
--- graph.d/mysql_network_traffic.json	2011-07-22 02:16:54 +0000
1264
+++ graph.d/mysql_network_traffic.json	1970-01-01 00:00:00 +0000
1265
@@ -1,22 +0,0 @@
1266
1
{
1267
2
    "report_name":    "mysql_network_traffic",
1268
3
    "report_type":    "standard",
1269
4
    "title":          "- MySQL Network Traffic @",
1270
5
    "vertical_label": "Bytes/sec",
1271
6
    "series": [
1272
7
        { 
1273
8
            "metric": "Bytes_received",
1274
9
            "label": "In",
1275
10
            "color": "1F78B4",
1276
11
            "type": "line",
1277
12
            "line_width": "2"
1278
13
        },
1279
14
        {
1280
15
            "metric": "Bytes_sent",
1281
16
            "label": "Out",
1282
17
            "color": "33A02C",
1283
18
            "type": "line",
1284
19
            "line_width": "2"
1285
20
        }
1286
21
    ]
1287
22
}
1288
23
0
1289
=== modified file 'graph.d/mysql_replication.json'
1290
--- graph.d/mysql_replication.json	2011-07-22 02:16:54 +0000
1291
+++ graph.d/mysql_replication.json	2011-07-25 22:42:07 +0000
1292
@@ -1,7 +1,7 @@
1293
1
{
1
{
1294
2
    "report_name":    "mysql_replication",
2
    "report_name":    "mysql_replication",
1295
3
    "report_type":    "standard",
3
    "report_type":    "standard",
1297
4
    "title":          "- MySQL Replication @",
4
    "title":          "- MySQL Replication Status @",
1298
5
    "vertical_label": "MISC",
5
    "vertical_label": "MISC",
1299
6
    "series": [
6
    "series": [
1300
7
        {
7
        {
1301
8
8
1302
=== added file 'graph.d/mysql_threads.json'
1303
--- graph.d/mysql_threads.json	1970-01-01 00:00:00 +0000
1304
+++ graph.d/mysql_threads.json	2011-07-25 22:42:07 +0000
1305
@@ -0,0 +1,43 @@
1306
1
{
1307
2
    "report_name":    "mysql_threads",
1308
3
    "report_type":    "standard",
1309
4
    "title":          "- MySQL Threads @",
1310
5
    "vertical_label": "Threads",
1311
6
    "series": [
1312
7
        {  
1313
8
            "metric": "Threads_created",
1314
9
            "label": "Threads Created",
1315
10
            "color": "377EB8",
1316
11
            "type": "line",
1317
12
            "line_width": "2"
1318
13
        },
1319
14
        {  
1320
15
            "metric": "Threads_cached",
1321
16
            "label": "Threads Cached",
1322
17
            "color": "4DAF4A",
1323
18
            "type": "line",
1324
19
            "line_width": "2"
1325
20
        },
1326
21
        {  
1327
22
            "metric": "Threads_running",
1328
23
            "label": "Threads Running",
1329
24
            "color": "984EA3",
1330
25
            "type": "line",
1331
26
            "line_width": "2"
1332
27
        },
1333
28
        {  
1334
29
            "metric": "thread_cache_size",
1335
30
            "label": "Thread Cache Size",
1336
31
            "color": "FF7F00",
1337
32
            "type": "line",
1338
33
            "line_width": "2"
1339
34
        },
1340
35
        {  
1341
36
            "metric": "Slow_launch_threads",
1342
37
            "label": "Slow Launch Threads",
1343
38
            "color": "FFFF33",
1344
39
            "type": "line",
1345
40
            "line_width": "2"
1346
41
        }
1347
42
    ]
1348
43
}
Status:	Merged
Approved by:	Vadim Tkachenko on 2011-07-25
Approved revision:	14
Merged at revision:	15
Proposed branch:	lp:~rodrigo-gadea-percona/percona-ganglia-mysql/graphs
Merge into:	lp:percona-ganglia-mysql
Diff against target:	1348 lines (+679/-555) 11 files modified METRICS (+564/-493) conf/default.json (+50/-1) graph.d/innodb_io.json (+1/-1) graph.d/innodb_log.json (+7/-0) graph.d/innodb_log_activity.json (+0/-7) graph.d/innodb_transaction_activity.json (+6/-9) graph.d/innodb_transactions_report.json (+0/-21) graph.d/mysql_files_tables.json (+7/-0) graph.d/mysql_network_traffic.json (+0/-22) graph.d/mysql_replication.json (+1/-1) graph.d/mysql_threads.json (+43/-0)
To merge this branch:	bzr merge lp:~rodrigo-gadea-percona/percona-ganglia-mysql/graphs
Related bugs:	Link a bug report
Reviewer	Review Type	Date Requested	Status
Vadim Tkachenko		2011-07-25	Approve on 2011-07-25
Review via email: mp+69163@code.launchpad.net