Guest User

Untitled

a guest
Jan 9th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.67 KB | None | 0 0
  1. # munin-run --debug mysql_commands
  2. # Processing plugin configuration from /etc/munin/plugin-conf.d/ansible.conf
  3. # Processing plugin configuration from /etc/munin/plugin-conf.d/munin-node
  4. # Setting /rgid/ruid/ to /119/0/
  5. # Setting /egid/euid/ to /119 119/0/
  6. # Setting up environment
  7. # Environment mysqluser = debian-sys-maint
  8. # Environment mysqlconnection = DBI:mysql:mysql;mysql_read_default_file=/etc/mysql/debian.cnf
  9. # Environment mysqlopts = --defaults-file=/etc/mysql/debian.cnf
  10. # About to run '/etc/munin/plugins/mysql_commands'
  11. Com_delete.value 4546376
  12. Com_insert.value 2804559
  13. Com_insert_select.value 341479
  14. Com_load.value 0
  15. Com_replace.value 0
  16. Com_replace_select.value 0
  17. Com_select.value 236967004
  18. Com_update.value 7069348
  19. Com_update_multi.value 0
  20.  
  21. # sudo -u munin munin-cron --host server.com --debug
  22. ...
  23. 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)
  24. 2018/01/09 08:35:01 [DEBUG] Fetching service configuration for 'mysql_commands'
  25. 2018/01/09 08:35:01 [DEBUG] Writing to socket: "config mysql_commands
  26. ".
  27. 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".
  28. 2018/01/09 08:35:02 [DEBUG] config: 0.151266 sec for 'mysql_commands' on server.com/1.2.3.4/4949
  29. 2018/01/09 08:35:02 [DEBUG] Now parsing config output from plugin mysql_commands on server.com
  30. 2018/01/09 08:35:02 [DEBUG] update_rate 0 for mysql_commands on server.com/1.2.3.4:4949
  31. 2018/01/09 08:35:02 [DEBUG] No service data for mysql_commands, fetching it
  32. 2018/01/09 08:35:02 [DEBUG] Writing to socket: "fetch mysql_commands
  33. ".
  34. 2018/01/09 08:35:02 [DEBUG] data: 0.175058 sec for 'mysql_commands' on server.com/1.2.3.4/4949
  35. 2018/01/09 08:35:02 [DEBUG] Now parsing fetch output from plugin mysql_commands on server.com/1.2.3.4:4949
  36. 2018/01/09 08:35:02 [FETCH from mysql_commands] # Bad exit
  37. ...
  38.  
  39. [mysql*]
  40. user root
  41. env.mysqlopts --defaults-file=/etc/mysql/debian.cnf
  42. env.mysqluser debian-sys-maint
  43. env.mysqlconnection DBI:mysql:mysql;mysql_read_default_file=/etc/mysql/debian.cnf
Add Comment
Please, Sign In to add comment