Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

By default MONyog(SQL DM for MySQL) service runs under Local System Account. If you are having Slow query or General query log in a Mapped Network Drive, SQL DM for MySQL is not be able to reach it. If SQL DM for MySQL has to access the file present in a Mapped Network Drive, you have to convert the path into shared path (accessed with UNC notation: \system\share) and then follow these steps:

  1. Click the Start menu, then click Run and then type,

    Code Block
    themeConfluence
    services.msc
  2. After the

...

  1. Services

...

  1. window pops up with a list of all the services running in your system.

  2. Search for Monyog and then right click --> Properties.
  3. Click

...

  1. the Log On

...

  1. tab and then you can see that SQL DM for MySQL is using

...

  1. Local System Account

...

  1. .
  2. You need to use

...

  1. This account

...

  1. option and then give the credentials that you use to log on to the system with

...

  1. Administrative

...

  1. privilege.
  2. Save the settings, restart MONyog (SQL DM for MySQL) service.
  3. After following the above steps try to access the file which is shared across network.
Note
titleNote

The shared path should be accessed with UNC notation (\system\share). SQL DM for MySQL cannot identify if destination of the log file is on a Mapped Network Drive (this is a restriction with services on Windows and not with SQL DM for MySQL).

...