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

Proposed by Rodrigo Gadea
Status: Merged
Approved by: Vadim Tkachenko
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
Reviewer Review Type Date Requested Status
Vadim Tkachenko Approve
Review via email: mp+69163@code.launchpad.net

Description of the change

Improvements on documentation (METRICS, INSTALL), graphs and added conf/.

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

ok to merge

Revision history for this message
Vadim Tkachenko (vadim-tk) :
review: Approve
15. By Rodrigo Gadea

Fixed title in graph and removed file manager's temp files

Preview Diff

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

Subscribers

People subscribed via source and target branches