• 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 …

Last year open source analyst Michael Coté of Redmonk coined the term Little Four to describe four up-and-coming open source management vendors and as a foil to the Big Four of systems management.

In the open source space, the 4 names that come up each time ? usually from people I?m talking with even before I say anything ? are: Zenoss, Hyperic, GroundWorks, and openQRM.

…