MONyog Installation and Configuration

After the installation of Monyog on the windows system. We can run it either on localhost with its port or we can run it publicly on live IP. Locally it run on port 5555, but we can change the port from its setting. 

Configuration of MONyog (MYSQL SERVER)

  • Create a user on the database server and set it password and other necessary parameters
    user@db# useradd monitoring
    user@db# passwd monitoring
  • Create a user on the database and set its privileges. In my case I created user usrMonitoring and set its privileges through phpmyadmin web tool

  • Create mysqld group and add following user: monitoring, mysqld

  • Append the following under vi /etc/my.cnf

    #config for slow query
    long_query_time =50
  • Create the file slow-query.log under /var/log and change its ownership to mysql with read permissions
  • Open the browser and hit localhost or IP with 5555 port 
  • Initially the username and password is admin/admin
  • Under select server section press the add server button
MySQL Setting Phase

  • Establish the SSH connection with user created on the database server for log monitoring

  • Notifications and Email Setting ( As per requirements )

  • Advanced Setting: Change the setting of collection of interval 

  •          On the Advanced Setting Tab Select the MySQL error log
  •          Fetch and Test the Path

  •          On the Advanced Setting Tab Select the MySQL query log
  •          Fetch and test the Path

  • Select the sniffer setting and set the long running query time and also enable the deadlock monitoring and save the all setting
  • Click on the Monitors tab and select the Mysql Logs
  •  Go to Min. execution time for a query to be considered slow /customize/view advanced
  • Notify? “Yes”

  • You can also explore its amazing features on the other tabs like Real time monitoring and Query Analyser. If the query took more time than the allocated then it will email on the address.