Posts Tagged ‘optimize’

Optimizing MassTransit Databases

Tuesday, September 15th, 2009

From time to time you may need to repair or optimize your MassTransit databases. You can do so easily by using the MySQL Administrator that came with your MySQL installer package.

Optimizing For Windows

  • Log in to the MySQL Administrator
  • Select Catalogs
  • Select the mtdatabase schema
  • Highlight the table(s) you wish to optimize

MySQL Admin - Catalogs

  • Click the Maintenance button at the bottom right
  • The Tables Maintenance box will pop up
  • Select Optimize Tables
  • Click Next
  • Click Optimize

Tables Maintenance

Once completed you will see a list of tables and what optimizations took place.

admin 3