Maintenance

Using MySQL Administrator, enable the Slow Query Log. This log should be checked on a regular basis. To enable it:

1. Launch the MySQL Administrator tool.
2. A dialog box will appear, prompting you to enter the Server Host, Port, Username, and Password. Click OK when you have entered the required information.
   1. Server Host is usually localhost, or the IP address of the server that is running both MySQL Server and MassTransit Server.
   2. Port is the port number for accessing the server; the default port number is 3306.
   3. The Username and Password fields should be populated with the MassTransit MySQL user information that was specified at initial installation time.
3. Once the MySQL Administrator tool has launched, click on the Startup Variables option which appears in the left-hand window pane.
   1. Make sure that the Log files tab is selected and check the Slow Query log checkbox. Then, enter a name for the slow query log. Otherwise, a default name will be used.
   2. Click Apply Changes when done, to save and apply the changes.
4. You can now view the log within the GUI by selecting the Server Logs option which appears in the left-hand window pane. In the right-hand window pane, three tabs should appear: Error Log, Slow Query Log, and General Query Log.
5. Open the Slow Query Log tab. The slow query log will allow you to see if the MySQL queries are taking too long to process requests. Anything greater than 10 seconds should be investigated.
6. Turn off the slow query log once you are done.