Optimize MySql with MySQL Workbench

Everyone needs to keep the integrity of their database and tables optimized.

How?

  • Start MySQL Workbench and connect the software to your MySQL server.
  • Right click on your database and select Schema InspectorInspector
  • Select all of the tables.
  • Check each box and run each check individually Full Maintenance
  • Visit the following link to learn more about optimization –
    https://dev.mysql.com/doc/refman/5.7/en/optimization.html
Advertisements

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Business, Computer Software, Computers, Education, Free Software, freeware, higher ed, higher education, Information Technology, Linux, Microsoft, Microsoft Windows, mysql, Technology, Windows Server and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s