Bonjour,
Je voudrais savoir comment monitorer MySQL depuis Munin.
J’ai accès aux statistiques de mon serveur (apache disk munin network postfix processes system) et je voudrais pouvoir ajouter MySQL, pour cela j’ai fais :
et ajouté mon mot de passe à la ligne 132 :
my %config = (
'dsn' => $ENV{'mysqlconnection'} || 'DBI:mysql:mysql',
'user' => $ENV{'mysqluser'} || 'root',
'password' => $ENV{'mysqlpassword'} || 'fsbg',
);
J’affiche ensuite les plugins disponibles :
qui me donne :
acpi files_ munin_stats postgres_connections_db snmp__sensors_fsc_fan
amavis foldingathome munin_update postgres_locks_ snmp__sensors_fsc_temp
apache_accesses foldingathome_rank mysql_ postgres_querylength_ snmp__sensors_mbm_fan
apache_processes foldingathome_wu mysql_bytes postgres_scans_ snmp__sensors_mbm_temp
apache_volume forks mysql_innodb postgres_size_ snmp__sensors_mbm_volt
apc_envunit_ freeradius_acct mysql_isam_space_ postgres_transactions_ snmp__swap
apc_nis freeradius_auth mysql_queries postgres_tuples_ snmp__uptime
apt freeradius_proxy_acct mysql_slowqueries postgres_users snmp__users
apt_all freeradius_proxy_auth mysql_threads postgres_xlog snmp__winload
asterisk_channels fw_conntrack named processes snmp__winmem
asterisk_channelstypes fw_forwarded_local netopia proc_pri snort_alerts
asterisk_codecs fw_packets netstat proxy_plugin snort_bytes_pkt
asterisk_meetme haproxy_ nfs4_client ps_ snort_drop_rate
asterisk_meetmeusers hddtemp nfs_client psu_ snort_pattern_match
asterisk_sipchannels hddtemp2 nfsd qmailqstat snort_pkts
asterisk_sippeers hddtempd nfsd4 qmailscan snort_traffic
asterisk_voicemail hddtemp_smartctl nginx_request qmailscan-simple spamstats
bind9 http_loadtime nginx_status quota_usage_ squeezebox_
bind9_rndc id nomadix_users_ samba squid_cache
bonding_err_ if_ ntp_ selinux_avcstat squid_icp
buddyinfo if_err_ ntp_kernel_err sendmail_mailqueue squid_objectsize
cmc_tc_sensor_ ifx_concurrent_sessions_ ntp_kernel_pll_freq sendmail_mailstats squid_requests
colour_tester interrupts ntp_kernel_pll_off sendmail_mailtraffic squid_traffic
courier_ iostat ntp_offset sensors_ surfboard
courier_mta_mailqueue iostat_ios ntp_states slapd_ swap
courier_mta_mailstats ip_ nut_misc slapd_bdb_cache_ sybase_space
courier_mta_mailvolume ipac-ng nutups_ slony_lag_ tcp
cps_ ipmi_ nut_volts smart_ threads
cpu ipmi_sensor_ nvidia_ snmp__cpuload tomcat_
cpuspeed ircu open_files snmp__df tomcat_access
cupsys_pages irqstats open_inodes snmp__fc_if_ tomcat_jvm
df jmx_ openvpn snmp__fc_if_err_ tomcat_threads
df_abs load perdition snmp__if_ tomcat_volume
df_inode loggrep ping_ snmp__if_err_ uptime
dhcpd3 lpar_cpu plugin.sh snmp__if_multi users
digitemp_ lpstat plugins.history snmp__load varnish_
diskstat_ mailman pm3users_ snmp__memory vlan_
diskstats mailscanner pop_stats snmp__netapp_diskusage_ vlan_inetuse_
ejabberd_ mbmon_ port_ snmp__netapp_inodeusage_ vlan_linkuse_
entropy memcached_ postfix_mailqueue snmp__netstat vmstat
env memory postfix_mailstats snmp__print_pages vserver_cpu_
exim_mailqueue mhttping postfix_mailvolume snmp__print_supplies vserver_loadavg
exim_mailqueue_alt multigraph_tester postgres_bgwriter snmp__processes vserver_resources
exim_mailstats multiping postgres_cache_ snmp__rdp_users warning_tester
extinfo_tester multips postgres_checkpoints snmp__sensors_fsc_bx_fan yum
fail2ban multips_memory postgres_connections_ snmp__sensors_fsc_bx_temp zimbra_
Je créé les liens symbolique pour les plugins que je souhaite activer :
Puis je redémarre munin :
Rien ne s’affiche dans Munin, où ce trouve le fichier log de munin ?
Si quelqu’un à des îdées …
Merci
