Tech Tip - Database Optimization

Document created by DavidM Employee on Jul 16, 2014Last modified by DavidM Employee on Aug 12, 2014
Version 4Show Document
  • View in full screen mode

The new version of DBTool, DBToolv3 adds optimization.

I've been using with noticeable improvements, and there is no need to stop NV to run it.
It will report each table as either 'Table is already up to date' or OK as in optimization OK. At the end it gives the total # of tables that it optimized.

It is available from here:
ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/

The same tool can be used for database backup, restore, and repair.

Syntax:
DBtoolv3 backup [database name] [path]
DBtoolv3 restore [database name] [path]
DBtoolv3 repair [database name]
DBtoolv3 optimize [database name]

Examples:
DBtoolv3 backup nms2 D:\backup\nms2\
DBtoolv3 restore reporter D:\backup\reporter\
DBtoolv3 repair super
DBtoolv3 optimize em

- Works on mysql 3308 databases.
- Doesn't work on 3306 or 3307 databases.

 

The greater the database size the more it will help especially when it gets over 60gb.

 

Note: if performance is a problem at the system it is best to run this after hours.

 

The new thread can be found at RE: Database Optimization.

This document was generated from the following discussion: Database Optimization

Attachments

    Outcomes