Page History
...
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:
Click the Start menu, then click Run and then type,
Code Block theme Confluence services.msc
After the
...
Services
...
window pops up with a list of all the services running in your system.
- Search for Monyog and then right click --> Properties.
- Click
...
- the Log On
...
- tab and then you can see that SQL DM for MySQL is using
...
- Local System Account
...
- .
- You need to use
...
- This account
...
- option and then give the credentials that you use to log on to the system with
...
- Administrative
...
- privilege.
- Save the settings, restart MONyog (SQL DM for MySQL) service.
- After following the above steps try to access the file which is shared across network.
Note | ||
---|---|---|
| ||
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). |
...