Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # munin-run --debug mysql_commands
- # Processing plugin configuration from /etc/munin/plugin-conf.d/ansible.conf
- # Processing plugin configuration from /etc/munin/plugin-conf.d/munin-node
- # Setting /rgid/ruid/ to /119/0/
- # Setting /egid/euid/ to /119 119/0/
- # Setting up environment
- # Environment mysqluser = debian-sys-maint
- # Environment mysqlconnection = DBI:mysql:mysql;mysql_read_default_file=/etc/mysql/debian.cnf
- # Environment mysqlopts = --defaults-file=/etc/mysql/debian.cnf
- # About to run '/etc/munin/plugins/mysql_commands'
- Com_delete.value 4546376
- Com_insert.value 2804559
- Com_insert_select.value 341479
- Com_load.value 0
- Com_replace.value 0
- Com_replace_select.value 0
- Com_select.value 236967004
- Com_update.value 7069348
- Com_update_multi.value 0
- # sudo -u munin munin-cron --host server.com --debug
- ...
- 2018/01/09 08:35:01 [DEBUG] for my mysql_commands (irqstats mysql_innodb_tnx diskstats apache_accesses smart_sda df ntp_offset vmstat fw_packets mysql_select_types netstat users mysql_qcache mysql_table_locks swap mysql_slow mysql_myisam_indexes if_err_eth0 apt hddtemp_smartctl ntp_kernel_err ntp_kernel_pll_freq mysql_innodb_rows mysql_innodb_bpool forks ntp_kernel_pll_off cpu load postfix_mailvolume postfix_mailqueue mysql_qcache_mem open_inodes processes http_loadtime open_files uptime mysql_commands mysql_innodb_semaphores apt_all mysql_innodb_io smart_sdb memory mysql_connections mysql_files_tables mysql_network_traffic df_inode mysql_sorts if_eth0 entropy proc_pri mysql_innodb_bpool_act apache_processes threads mysql_innodb_log mysql_innodb_insert_buf mysql_tmp_tables mysql_innodb_io_pend interrupts apache_volume)
- 2018/01/09 08:35:01 [DEBUG] Fetching service configuration for 'mysql_commands'
- 2018/01/09 08:35:01 [DEBUG] Writing to socket: "config mysql_commands
- ".
- 2018/01/09 08:35:02 [DEBUG] Reading from socket: "graph_vlabel Commands per ${graph_period}ngraph_total Questionsngraph_args --base 1000ngraph_title Command Countersngraph_category mysql2nCom_delete.type DERIVEnCom_delete.label DeletenCom_delete.draw STACKnCom_delete.min 0nCom_insert.draw STACKnCom_insert.min 0nCom_insert.type DERIVEnCom_insert.label InsertnCom_insert_select.type DERIVEnCom_insert_select.label Insert selectnCom_insert_select.draw STACKnCom_insert_select.min 0nCom_load.label Load DatanCom_load.type DERIVEnCom_load.min 0nCom_load.draw STACKnCom_replace.type DERIVEnCom_replace.label ReplacenCom_replace.draw STACKnCom_replace.min 0nCom_replace_select.draw STACKnCom_replace_select.min 0nCom_replace_select.type DERIVEnCom_replace_select.label Replace selectnCom_select.type DERIVEnCom_select.label SelectnCom_select.draw STACKnCom_select.min 0nCom_update.type DERIVEnCom_update.label UpdatenCom_update.draw STACKnCom_update.min 0nCom_update_multi.label Update multinCom_update_multi.type DERIVEnCom_update_multi.min 0nCom_update_multi.draw STACK".
- 2018/01/09 08:35:02 [DEBUG] config: 0.151266 sec for 'mysql_commands' on server.com/1.2.3.4/4949
- 2018/01/09 08:35:02 [DEBUG] Now parsing config output from plugin mysql_commands on server.com
- 2018/01/09 08:35:02 [DEBUG] update_rate 0 for mysql_commands on server.com/1.2.3.4:4949
- 2018/01/09 08:35:02 [DEBUG] No service data for mysql_commands, fetching it
- 2018/01/09 08:35:02 [DEBUG] Writing to socket: "fetch mysql_commands
- ".
- 2018/01/09 08:35:02 [DEBUG] data: 0.175058 sec for 'mysql_commands' on server.com/1.2.3.4/4949
- 2018/01/09 08:35:02 [DEBUG] Now parsing fetch output from plugin mysql_commands on server.com/1.2.3.4:4949
- 2018/01/09 08:35:02 [FETCH from mysql_commands] # Bad exit
- ...
- [mysql*]
- user root
- env.mysqlopts --defaults-file=/etc/mysql/debian.cnf
- env.mysqluser debian-sys-maint
- env.mysqlconnection DBI:mysql:mysql;mysql_read_default_file=/etc/mysql/debian.cnf
Add Comment
Please, Sign In to add comment