Merge lp:~rodrigo-gadea-percona/percona-ganglia-mysql/docs into lp:~vadim-tk/percona-ganglia-mysql/init-repo
- docs
- Merge into init-repo
Proposed by
Rodrigo Gadea
Status: | Merged |
---|---|
Merged at revision: | 10 |
Proposed branch: | lp:~rodrigo-gadea-percona/percona-ganglia-mysql/docs |
Merge into: | lp:~vadim-tk/percona-ganglia-mysql/init-repo |
Diff against target: |
724 lines (+638/-59) 3 files modified
INSTALL (+73/-31) METRICS (+498/-0) README (+67/-28) |
To merge this branch: | bzr merge lp:~rodrigo-gadea-percona/percona-ganglia-mysql/docs |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Vadim Tkachenko | Pending | ||
Review via email:
|
Commit message
Description of the change
Documentation update
To post a comment you must log in.
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'INSTALL' |
2 | --- INSTALL 2011-06-23 20:57:30 +0000 |
3 | +++ INSTALL 2011-06-24 06:42:35 +0000 |
4 | @@ -1,31 +1,73 @@ |
5 | -Installation instructions |
6 | - |
7 | -This document assumes you have ganglia installed and |
8 | -configured and it is not covered. |
9 | - |
10 | -Pre-requirements are: |
11 | -php working in command line mode |
12 | -gmetric binary accessible ( i.e in $PATH environment variable) |
13 | - |
14 | -To start gathering statistics the script may be located |
15 | -in crontab for periodic execution. |
16 | - |
17 | -Sample crontab line: |
18 | - |
19 | -*/1 * * * * root php PATH_TO_SCRIPT/ss_get_mysql_stats.php --host 127.0.0.1 > /var/log/mysql-ganglia-2.log |
20 | - |
21 | ---host is mandatory parameter and this is hostname used to connect to mysqld process |
22 | - |
23 | -Additional parameters |
24 | - --user MySQL username; defaults to $mysql_user if not given |
25 | - --pass MySQL password; defaults to $mysql_pass if not given |
26 | - --port MySQL port; defaults to $mysql_port if not given |
27 | - |
28 | -And last parameter is |
29 | - --gmetric_param Parameter to pass directly to gmetric |
30 | - |
31 | -ss_get_mysql_stats.php calls gmetric for each metric, and sometime you may need to pass additional parameter to gmetric. For example -d 60 , which says to metric to expire in 60 seconds. |
32 | - |
33 | -Usage example: |
34 | -ss_get_mysql_stats.php --host 127.0.0.1 --gmetric_param "-d 60" |
35 | - |
36 | +========================= |
37 | +INSTALLATION INSTRUCTIONS |
38 | +========================= |
39 | + |
40 | +NOTE: This document assumes you have Ganglia |
41 | + installed and configured (see README). |
42 | + |
43 | + |
44 | +INSTALLATION |
45 | +============ |
46 | + |
47 | +Once downloaded, configuration instructions are available online at |
48 | + |
49 | + http://code.google.com/p/mysql-cacti-templates/wiki/InstallingTemplates#Configuring |
50 | + |
51 | +If the templates do not match your polling interval, desired graph size, or any |
52 | +number of other qualities, you can easily generate your own. Customization |
53 | +instructions can be found at |
54 | + |
55 | + http://code.google.com/p/mysql-cacti-templates/wiki/CustomizingTemplates |
56 | + |
57 | + |
58 | +USAGE |
59 | +===== |
60 | + |
61 | +PREREQUISITES |
62 | +------------- |
63 | + |
64 | + - php works in command line mode |
65 | + - gmetric binary is accessible ( i.e through your $PATH environment variable) |
66 | + |
67 | + |
68 | +SYNOPSIS |
69 | +-------- |
70 | + |
71 | + ss_get_mysql_stats.php --host HOST |
72 | + [[--user USER] [--pass PASSWORD] [--port PORT]] |
73 | + [--gmetric_param] |
74 | + |
75 | + |
76 | +OPTIONS |
77 | +------- |
78 | + |
79 | + --host |
80 | + The hostname or IP used to connect to the mysqld proccess. |
81 | + This option is MANDATORY. |
82 | + |
83 | + --user USER |
84 | + MySQL username; defaults to $mysql_user if not given. |
85 | + |
86 | + --pass PASSWORD |
87 | + MySQL password; defaults to $mysql_pass if not given. |
88 | + |
89 | + --port PORT |
90 | + MySQL port; defaults to $mysql_port if not given. |
91 | + |
92 | + --gmetric_param "STRING" |
93 | + Additional parameters for gmetric (passed directly). |
94 | + |
95 | + |
96 | +EXAMPLES |
97 | +======== |
98 | + |
99 | +To start gathering statistics, the script may be located in the crontab for |
100 | +periodic execution. A sample crontab line would be: |
101 | + |
102 | + */1 * * * * root php PATH_TO_SCRIPT/ss_get_mysql_stats.php --host 127.0.0.1 > /var/log/mysql-ganglia-2.log |
103 | + |
104 | +As ss_get_mysql_stats.php calls gmetric for each metric, sometimes you may need |
105 | +to pass additional parameters to gmetric. For example -d 60 , for expiring the |
106 | +metric in 60 seconds: |
107 | + |
108 | + ss_get_mysql_stats.php --host 127.0.0.1 --gmetric_param "-d 60" |
109 | |
110 | === added file 'METRICS' |
111 | --- METRICS 1970-01-01 00:00:00 +0000 |
112 | +++ METRICS 2011-06-24 06:42:35 +0000 |
113 | @@ -0,0 +1,498 @@ |
114 | +======= |
115 | +METRICS |
116 | +======= |
117 | + |
118 | + - 'Key_read_requests' |
119 | + The number of reads of a key block from the cache (operations per second). |
120 | + |
121 | + - 'Key reads' |
122 | + The number of physical reads of a key block from disk (operations per second). |
123 | + |
124 | + - 'Key_write_requests' |
125 | + The number of writes of a key block to the cache (operations per second). |
126 | + |
127 | + - 'Key_write' |
128 | + The number of physical writes of a key block to disk (operations per second). |
129 | + |
130 | + - 'history_list' |
131 | + The length of the history list shows how old the oldest unpurged transaction is (transactions). |
132 | + |
133 | + - 'innodb_transactions' |
134 | + The number of transactions done by the server (internal transaction counter). |
135 | + |
136 | + - 'read_views' |
137 | + 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). |
138 | + |
139 | + - 'current_transactions' |
140 | + The total number of transactions currently in the server, no matter what status (ACTIVE, LOCK WAIT, not started, etc). |
141 | + |
142 | + - 'locked_transactions' |
143 | + 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). |
144 | + |
145 | + - 'active_transactions' |
146 | + 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). |
147 | + |
148 | + - 'pool_size' |
149 | + The total size of buffer pool, in pages. |
150 | + |
151 | + - free_pages 'free_pages' |
152 | + The number of free pages in the buffer pool. |
153 | + |
154 | + - 'database_pages' |
155 | + The number of used pages in the buffer pool. |
156 | + |
157 | + - 'modified_pages' |
158 | + The number of modified (dirty) pages in the buffer pool. |
159 | + |
160 | + - 'pages_read' |
161 | + 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). |
162 | + |
163 | + - 'pages_created' |
164 | + The number of created pages per second. |
165 | + |
166 | + - 'pages_written' |
167 | + The number of pages written per second. |
168 | + |
169 | + - 'file_fsyncs' |
170 | + The number of fsync() calls per second (operations per second). |
171 | + |
172 | + - 'file_reads' |
173 | + The number of file reads per second (operations per second). |
174 | + |
175 | + - 'file_writes' |
176 | + The amount of InnoDB's file writes per second (operations per second). |
177 | + |
178 | + - 'log_writes' |
179 | + The number of physical writes per second to the log file (operations per second). |
180 | + |
181 | + - 'pending_aio_log_ios' |
182 | + The number of total pending I/O operations to the log file (IO). |
183 | + |
184 | + - * 'pending_aio_sync_ios' |
185 | + The number of pending asynchronous fsync() operations in the data files (IO). |
186 | + |
187 | + - 'pending_buf_pool_flushes' |
188 | + The number of pending buffer pool page-flush requests (IO). |
189 | + |
190 | + - 'pending_chkp_writes' |
191 | + The number of pending checkpoints writes (IO). |
192 | + |
193 | + - 'pending_ibuf_aio_reads' |
194 | + The number of pending asynchronous Insert Buffer reads (IO). |
195 | + |
196 | + - 'pending_log_flushes' |
197 | + The number of pending flushes to the log file (IO). |
198 | + |
199 | + - 'pending_log_writes' |
200 | + The number of pending log file writes (IO). |
201 | + |
202 | + - 'pending_normal_aio_reads' |
203 | + The number of pending asynchronous normal reads (IO). |
204 | + |
205 | + - 'pending_normal_aio_writes' |
206 | + The number of pending asynchronous normal writes (IO). |
207 | + |
208 | + - 'ibuf_inserts' |
209 | + The number of INSERT operations per second in the InnoDB Insert Buffer. |
210 | + |
211 | + - 'ibuf_merged' |
212 | + The number of MERGED RECORD operations per second in the InnoDB Insert Buffer. |
213 | + |
214 | + - 'ibuf_merges' |
215 | + The number of MERGE operations per second in the InnoDB Insert Buffer. |
216 | + |
217 | + - 'spin_waits' |
218 | + The number of spin waits per second done by threads. |
219 | + |
220 | + - 'spin_rounds' |
221 | + The number of spin rounds per seconds done by threads. |
222 | + |
223 | + - 'os_waits' |
224 | + The number of OS waits per second done by threads. |
225 | + |
226 | + - 'rows_inserted' |
227 | + The number of rows per second inserted into InnoDB tables. |
228 | + |
229 | + - 'rows_updated' |
230 | + The number of rows updated per second in InnoDB tables. |
231 | + |
232 | + - 'rows_deleted' |
233 | + The number of rows deleted per second from InnoDB tables. |
234 | + |
235 | + - 'rows_read' |
236 | + The number of rows reads per second from InnoDB tables. |
237 | + |
238 | + - 'Table_locks_waited' |
239 | + 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). |
240 | + |
241 | + - 'Table_locks_immediate' |
242 | + The number of times per second that a request for a table lock could be granted immediately (locks per second). |
243 | + |
244 | + - 'Slow_queries' |
245 | + The number of queries per second that have taken more than 'long_query_time' seconds. |
246 | + |
247 | + - 'Open_files' |
248 | + 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. |
249 | + |
250 | + - 'Open_tables' |
251 | + The number of tables that are open per second. |
252 | + |
253 | + - 'Opened_tables' |
254 | + 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. |
255 | + |
256 | + - 'innodb_open_files' |
257 | + 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. |
258 | + |
259 | + - 'open_files_limit' |
260 | + The number of open files that the server can have. |
261 | + |
262 | + - 'table_cache' |
263 | + The number of tables been cached. |
264 | + |
265 | + - 'Aborted_clients' |
266 | + The number of connections per second that were aborted because the client died without closing the connection properly. |
267 | + |
268 | + - 'Aborted_connects' |
269 | + The number of failed attempts per second to connect to the MySQL server. |
270 | + |
271 | + - 'Max_used_connections' |
272 | + The maximum number of connections that have been in use simultaneously since the server started. |
273 | + |
274 | + - 'Slow_launch_threads' |
275 | + The number of threads that have taken more than 'slow_launch_time' seconds to create. |
276 | + |
277 | + - 'Threads_cached' |
278 | + The number of threads in the thread cache. |
279 | + |
280 | + - 'Threads_connected' |
281 | + The number of currently open connections per second. |
282 | + |
283 | + - 'Threads_created' |
284 | + The number of threads per second created to handle connections. |
285 | + |
286 | + - 'Threads_running' |
287 | + The number of threads that are not sleeping. |
288 | + |
289 | + - 'max_connections' |
290 | + The number of connections permitted in the server. |
291 | + |
292 | + - 'thread_cache_size' |
293 | + How many threads the server should cache for reuse. |
294 | + |
295 | + - 'Connections' |
296 | + The number of connection attempts per second (successful or not) to the server (connections per second). |
297 | + |
298 | + - 'slave_running' |
299 | + 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). |
300 | + |
301 | + - 'slave_stopped' |
302 | + 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. |
303 | + |
304 | + - 'Slave_retried_transactions' |
305 | + The total number of times since startup that the replication slave SQL thread has retried transactions (transactions). |
306 | + |
307 | + - 'slave_lag' |
308 | + The number of seconds (estimation) of the lag between the master and the slave in a replication environment. |
309 | + |
310 | + - 'Slave_open_temp_tables' |
311 | + The number of temporary tables that the slave SQL thread currently has open. |
312 | + |
313 | + - 'Qcache_free_blocks' |
314 | + The number of free memory blocks in the query cache. |
315 | + |
316 | + - 'Qcache_free_memory' |
317 | + The amount of free memory in bytes for the query cache. |
318 | + |
319 | + - 'Qcache_hits' |
320 | + The number of query cache hits per second. |
321 | + |
322 | + - 'Qcache_inserts' |
323 | + The number of queries per second added to the query cache. |
324 | + |
325 | + - 'Qcache_lowmem_prunes' |
326 | + The number of queries per second that were deleted from the query cache because of low memory. |
327 | + |
328 | + - 'Qcache_not_cached' |
329 | + The number of non-cached queries per second (not cacheable, or not cached due to the 'query_cache_type' setting). |
330 | + |
331 | + - 'Qcache_queries_in_cache' |
332 | + The number of queries per second registered in the query cache. |
333 | + |
334 | + - 'Qcache_total_blocks' |
335 | + The total number of blocks in the query cache. |
336 | + |
337 | + - 'query_cache_size' |
338 | + The amount of memory allocated for caching query results. |
339 | + |
340 | + - 'Questions' |
341 | + 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). |
342 | + |
343 | + - 'Com_update' |
344 | + The number of UPDATE statements per second executed (queries per second). |
345 | + |
346 | + - 'Com_insert' |
347 | + The number of INSERT statements per second executed (queries per second). |
348 | + |
349 | + - 'Com_select' |
350 | + The number of SELECT statements per second executed (queries per second). |
351 | + |
352 | + - 'Com_delete' |
353 | + The number of DELETE statements per second executed (queries per second). |
354 | + |
355 | + - 'Com_replace' |
356 | + The number of REPLACE statements per second executed (queries per second). |
357 | + |
358 | + - 'Com_load' |
359 | + The number of LOAD statements per second executed (queries per second). |
360 | + |
361 | + - 'Com_update_multi' |
362 | + The number of UPDATE statements on multiple columns (???) per second executed (queries per second). |
363 | + |
364 | + - 'Com_insert_select' |
365 | + The number of INSERT ... SELECT statements per second executed (queries per second). |
366 | + |
367 | + - 'Com_delete_multi' |
368 | + The number of DELETE statements on multiple rows (??) per second executed (queries per second). |
369 | + |
370 | + - 'Com_replace_select' |
371 | + The number of REPLACE ... SELECT statements per second executed (queries per second). |
372 | + |
373 | + - 'Select_full_join' |
374 | + The number of joins per second that perform table scans because they do not use indexes (queries per second). |
375 | + |
376 | + - 'Select_full_range_join' |
377 | + The number of joins per second that used a range search on a reference table (queries per second). |
378 | + |
379 | + - 'Select_range' |
380 | + The number of joins per second that used ranges on the first table (queries per second). |
381 | + |
382 | + - 'Select_range_check' |
383 | + The number of joins without keys per second that checked for key usage after each row (queries per second). |
384 | + |
385 | + - 'Select_scan' |
386 | + The number of joins statements that did a full scan of the first table (queries per second). |
387 | + |
388 | + - 'Sort_merge_passes' |
389 | + The number of merge passes per second that the sort algorithm has had to do (queries per second). |
390 | + |
391 | + - 'Sort_range' |
392 | + The number of sorts per second that were done using ranges (queries per second). |
393 | + |
394 | + - 'Sort_rows' |
395 | + The number of sorted rows per second (rows per second). |
396 | + |
397 | + - 'Sort_scan' |
398 | + The number of sorts per second that were done by scanning the table (queries per second). |
399 | + |
400 | + - 'Created_tmp_tables' |
401 | + The number of internal temporary tables per second created by the server while executing statements. |
402 | + |
403 | + - 'Created_tmp_disk_tables' |
404 | + The number of internal on-disk temporary tables created per second by the server while executing statements. |
405 | + |
406 | + - 'Created_tmp_files' |
407 | + The number of temporary files per second that the server has created. |
408 | + |
409 | + - 'Bytes_sent' |
410 | + The number of bytes per second sent to all clients. |
411 | + |
412 | + - 'Bytes_received' |
413 | + The number of bytes per second received from all clients. |
414 | + |
415 | + - 'innodb_log_buffer_size' |
416 | + The size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables. |
417 | + |
418 | + - 'unflushed_log' |
419 | + The amount in kilobytes of InnoDB logs that hasn't been flushed. |
420 | + |
421 | + - 'log_bytes_flushed' |
422 | + The amount in bytes of InnoDB logs that has been flushed per second. |
423 | + |
424 | + - 'log_bytes_written' |
425 | + The amount in bytes of InnoDB logs that hasn't been flushed per second. |
426 | + |
427 | + - 'relay_log_space' |
428 | + The total combined size in bytes of all existing relay log files. |
429 | + |
430 | + - 'binlog_cache_size' |
431 | + The size in bytes of the cache to hold changes to the binary log during a transaction. |
432 | + |
433 | + - 'Binlog_cache_disk_use' |
434 | + 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. |
435 | + |
436 | + - 'Binlog_cache_use' |
437 | + The amount in bytes of the binary log cache used by transactions. |
438 | + |
439 | + - 'binary_log_space' |
440 | + The total size in bytes of all existing binary log files. |
441 | + |
442 | + - 'innodb_locked_tables' |
443 | + The number of InnoDB tables that are locked. |
444 | + |
445 | + - 'innodb_lock_structs' |
446 | + The number of internal lock structures InnoDB has (locks). |
447 | + |
448 | + - 'State_closing_tables' |
449 | + The number of threads being in 'closing_tables' state: the thread is flushing the changed table data to disk and closing the used tables. |
450 | + |
451 | + - 'State_copying_to_tmp_table' |
452 | + The number of threads being in 'copying to tmp table' state: the thread is creating a temporary table in memory or on disk. |
453 | + |
454 | + - 'State_end' |
455 | + 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. |
456 | + |
457 | + - 'State_freeing_items' |
458 | + 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. |
459 | + |
460 | + - 'State_init' |
461 | + 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. |
462 | + |
463 | + - 'State_locked' |
464 | + The number of threads being in 'locked' state: the query is locked by another query. |
465 | + |
466 | + - 'State_login' |
467 | + The number of threads being in 'login' state: the initial state for a connection thread until the client has been authenticated successfully. |
468 | + |
469 | + - 'State_preparing' |
470 | + The number of threads being in 'preparing' state: this state occurs during query optimization. |
471 | + |
472 | + - 'State_reading_from_net' |
473 | + The number of threads being in 'reading form net' state: the server is reading a packet from the network. |
474 | + |
475 | + - 'State_sending_data' |
476 | + 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. |
477 | + |
478 | + - 'State_sorting_result' |
479 | + 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. |
480 | + |
481 | + - 'State_statistics' |
482 | + The number of threads being in 'statistics' state: the server is calculating statistics to develop a query execution plan. |
483 | + |
484 | + - 'State_updating' |
485 | + The number of threads being in 'updating' state: the thread is searching for rows to update and is updating them. |
486 | + |
487 | + - 'State_writing_to_net' |
488 | + The number of threads being in 'writing to net' state: the server is writing a packet to the network. |
489 | + |
490 | + - 'State_none' |
491 | + The number of threads being in 'none' state: (NULL??) this state is used for the SHOW PROCESSLIST state. |
492 | + |
493 | + - 'State_other' |
494 | + The number of threads being in other state than the previously specified. |
495 | + |
496 | + - 'Handler_commit' |
497 | + The number of internal COMMIT calls per second. |
498 | + |
499 | + - 'Handler_delete' |
500 | + The number of times that rows have been deleted from tables (calls per second). |
501 | + |
502 | + - 'Handler_discover' |
503 | + The number of times per second that tables have been discovered asking the NDBCLUSTER storage engine. |
504 | + |
505 | + - 'Handler_prepare' |
506 | + The number of prepare phases of two-phase commit operations (calls per second). |
507 | + |
508 | + - 'Handler_read_first' |
509 | + The number of times per second the first entry in an index was read (calls per second). |
510 | + |
511 | + - 'Handler_read_key' |
512 | + The number of requests per second to read a row based on a key (calls per second). |
513 | + |
514 | + - 'Handler_read_next' |
515 | + The number of requests per second to read the next row in key order (calls per second). |
516 | + |
517 | + - 'Handler_read_prev' |
518 | + The number of requests per second to read the previous row in key order (calls per second). |
519 | + |
520 | + - 'Handler_read_rnd' |
521 | + The number of requests per second to read a row based on a fixed position (calls per second). |
522 | + |
523 | + - 'Handler_read_rnd_next' |
524 | + The number of requests per second to read the next row in the data file (calls per second). |
525 | + |
526 | + - 'Handler_rollback' |
527 | + The number of requests per second for a storage engine to perform a rollback operation (calls per second). |
528 | + |
529 | + - 'Handler_savepoint' |
530 | + The number of requests per second for a storage engine to place a savepoint (calls per second). |
531 | + |
532 | + - 'Handler_savepoint_rollback' |
533 | + The number of requests per second for a storage engine to roll back to a savepoint (calls per second). |
534 | + |
535 | + - 'Handler_update' |
536 | + The number of requests per second to update a row in a table (calls per second). |
537 | + |
538 | + - 'Handler_write' |
539 | + The number of requests per second to insert a row in a table (calls per second). |
540 | + |
541 | + - 'innodb_tables_in_use' |
542 | + The number of InnoDB tables in use. |
543 | + |
544 | + - 'innodb_lock_wait_secs' |
545 | + The total number of seconds that InnoDB transactions have been waiting for locks. |
546 | + |
547 | + - 'hash_index_cells_total' |
548 | + The total number of Adaptative Hash Index cells of InnoDB. |
549 | + |
550 | + - 'hash_index_cells_used' |
551 | + The number of cells Adaptative Hash Index cells used by InnoDB. |
552 | + |
553 | + - 'total_mem_alloc' |
554 | + The total amount of memory allocated by InnoDB in bytes. |
555 | + |
556 | + - 'additional_pool_alloc' |
557 | + The amount of memory allocated in the additional pool by InnoDB. |
558 | + |
559 | + - 'uncheckpointed_bytes' |
560 | + The number of uncheckpointed bytes: the amount of recovery that'll have to be performed if there's a crash. |
561 | + |
562 | + - 'ibuf_used_cells' |
563 | + The number of cells of the Insert Buffer being used. |
564 | + |
565 | + - 'ibuf_free_cells' |
566 | + The number of free cells of the Insert Buffer. |
567 | + |
568 | + - 'ibuf_cell_count' |
569 | + The number of cells allocated for the Insert Buffer. |
570 | + |
571 | + - 'adaptive_hash_memory' |
572 | + The amount of memory in bytes used by InnoDB Adaptive Hash Index |
573 | + |
574 | + - 'page_hash_memory' |
575 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
576 | + |
577 | + - 'dictionary_cache_memory' |
578 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
579 | + |
580 | + - 'file_system_memory' |
581 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
582 | + |
583 | + - 'lock_system_memory' |
584 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
585 | + |
586 | + - 'recovery_system_memory' |
587 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
588 | + |
589 | + - 'thread_hash_memory' |
590 | + The amount of memory in bytes used in page hash by Percona-enhanced versions of InnoDB. |
591 | + |
592 | + - 'innodb_sem_waits' |
593 | + The total number of InnoDB semaphore waits per second. |
594 | + |
595 | + - 'innodb_sem_wait_time_ms' |
596 | + The total number of milliseconds waited for semaphores. |
597 | + |
598 | + - 'Key_buf_bytes_unflushed' |
599 | + The amount of memory in bytes used for the key cache that have changed but have not yet been flushed to disk. |
600 | + |
601 | + - 'Key_buf_bytes_used' |
602 | + The amount of memory in bytes used for buffering index blocks (MyISAM tables). |
603 | + |
604 | + - 'key_buffer_size' |
605 | + The amount of memory in bytes designated for buffering index blocks for MyISAM tables. |
606 | + |
607 | + - 'Innodb_row_lock_time' |
608 | + The total time spent in acquiring row locks, in milliseconds. |
609 | + |
610 | + - 'Innodb_row_lock_waits' |
611 | + The number of times per second a row lock had to be waited for (waits per second). |
612 | |
613 | === modified file 'README' |
614 | --- README 2011-06-23 20:57:30 +0000 |
615 | +++ README 2011-06-24 06:42:35 +0000 |
616 | @@ -1,40 +1,79 @@ |
617 | +============ |
618 | INTRODUCTION |
619 | ============ |
620 | |
621 | -This is a set of templates for monitoring MySQL servers with |
622 | -Ganglia. The project is hosted |
623 | -at https://launchpad.net/percona-ganglia-mysql. |
624 | - |
625 | -Commercial support and enhancements are available through Percona, where the |
626 | -developer works. Their website is http://www.percona.com |
627 | - |
628 | +This is a set of templates for monitoring MySQL-based servers with Ganglia. |
629 | +The project is hosted at |
630 | + |
631 | + https://launchpad.net/percona-ganglia-mysql |
632 | + |
633 | +Commercial support and sponsored enhancements are available through Percona, |
634 | +where the main developer works. You can find more information at |
635 | + |
636 | + http://www.percona.com |
637 | + |
638 | + |
639 | +============ |
640 | INSTALLATION |
641 | ============ |
642 | |
643 | -Installation instructions are online at |
644 | -http://code.google.com/p/mysql-cacti-templates/wiki/InstallingTemplates. |
645 | - |
646 | -If the templates do not match your polling interval, desired graph size, or any |
647 | -number of other qualities, you can easily generate your own. Instructions are |
648 | -in the documentation linked above. |
649 | - |
650 | +Installation instructions are available in the INSTALL file at the base |
651 | +directory of the distribution. |
652 | + |
653 | +It is assumed that Ganglia is installed and configured on the system |
654 | +and won't be covered here. Instructions for these procedures can be found at |
655 | + |
656 | + http://sourceforge.net/apps/trac/ganglia/wiki/ganglia_configuration |
657 | + |
658 | + |
659 | +=================================== |
660 | +DOCUMENTATION AND COMMUNITY SUPPORT |
661 | +=================================== |
662 | + |
663 | +Documentation is available at the Better Cacti's Templates' wiki: |
664 | + |
665 | + http://code.google.com/p/mysql-cacti-templates/wiki/TableOfContents |
666 | + |
667 | +Descriptions of the metrics can be found in the METRICS file at the base |
668 | +directory of the distribution. |
669 | + |
670 | +Community support is available at its mailing list: |
671 | + |
672 | + http://groups.google.com/group/better-cacti-templates. |
673 | + |
674 | + |
675 | +================ |
676 | BUGS OR PROBLEMS |
677 | ================ |
678 | |
679 | -If you find any bugs or problems not listed in the FAQ, please enter an issue |
680 | -report at http://code.google.com/p/mysql-cacti-templates/. Please make sure you |
681 | -read the official Cacti documentation and forums first. Many of the issues and |
682 | -questions that come up are unrelated to these templates, and the answers are |
683 | -readily available in the Cacti manual or forums. |
684 | - |
685 | -Documentation is at the wiki hosted on |
686 | -http://code.google.com/p/mysql-cacti-templates/, and there is a mailing list at |
687 | -http://groups.google.com/group/better-cacti-templates. |
688 | - |
689 | +If you find any bugs or problems, please make sure of reading: |
690 | + |
691 | + - Better Cacti Templates' FAQ: |
692 | + |
693 | + http://code.google.com/p/mysql-cacti-templates/wiki/FAQ |
694 | + |
695 | + - Cacti's official documentation: |
696 | + |
697 | + http://www.cacti.net/documentation.php |
698 | + |
699 | + - Cacti's forums: |
700 | + |
701 | + http://forums.cacti.net/ |
702 | + |
703 | +Many of the issues and questions that come up are unrelated to these templates, |
704 | +and the answers are readily available in the Cacti manual or forums. |
705 | + |
706 | +If it is not listed there, please enter an issue or report it at |
707 | + |
708 | + http://code.google.com/p/mysql-cacti-templates/issues |
709 | + |
710 | + |
711 | +============ |
712 | CONTRIBUTING |
713 | ============ |
714 | |
715 | -This is an open-source project, and everyone is welcome to participate. Just |
716 | -join the mailing list and introduce yourself. Commit access to SVN, editing |
717 | -permission on the wiki, and anything else you need will be happily and speedily |
718 | -granted if you ask. |
719 | +This is an open-source project, released under the GPLv2 license, and everyone is |
720 | +welcome to participate. Just join the mailing list and introduce yourself. |
721 | + |
722 | +Commit access to SVN, editing permission on the wiki, and anything else you need |
723 | +will be happily and speedily granted if you ask. |
724 | \ No newline at end of file |