6

MySQL Conference Liveblogging: Monitoring Tools (Wednesday 5:15PM)


Posted by Artem Russakovskii on April 16th, 2008 in Databases

Updated: April 18th, 2008

  • Tom Hanlon of MySQL presents
  • monitoring tool basics
    • SHOW FULL PROCESSLIST
    • SHOW GLOBAL STATUS
    • SHOW GLOBAL VARIABLES
  • basic tools
    • mysqladmin is provided with the server
      • mysqladmin -i 10 extended status: will repeat the same command every 10 seconds. Pipe through grep "and smoke it" (bad pun, hah hah)
      • -r: show only changed values
    • MySQL Administrator
  • cacti
    • rrdtool based network graphing tool
    • uses snmp
    • PHP apache and MySQL based solution
    • MySQL plugins, download and install
    • "poller" gathers data and populates the graphs
    • someone offers munin as an alternative
      • not snmp based, its own agent is used
    • pros
      • cacti is fairly easy to configure
    • cons
      • could be CPU intensive with lots of machines (Perl polling seems to be the
  • Read the rest of this article »