Over a million developers have joined DZone.
Platinum Partner

Optimize MySQL and Schedule Maintenance with MySQL Tuner

· Performance Zone

The Performance Zone is brought to you in partnership with New Relic. Quickly learn how to use Docker and containers in general to create packaged images for easy management, testing, and deployment of software.

Once in a while it is worthwhile to take care of your database and verify it can provide the needed resources for your system.
After all, most of the data may be stored in it...


Some Tasks I would Recommend You to Do
Please notice that this work may not be done manually, but can be automated. If you do so, you may be contribute it back to the community at your favorite open source project:

  1. Run MySQLTuner and look for issues.
  2. Take care of fragmented tables:
    1. You can find them using SHOW TABLE STATUS WHERE Data_free > 0\G and take care of them using OPTIMIZE TABLE table_name; 
    2. Or you can use mysqlfragfinder script for that.
  3. Verify RAM, disk and CPU utilization
  4. Check the slow log query

The Performance Zone is brought to you in partnership with New Relic. Read more about providing a framework that gets you started on the right path to move your IT services to cloud computing, and give you an understanding as to why certain applications should not move to the cloud.

Topics:

Published at DZone with permission of Moshe Kaplan , DZone MVB .

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}