Support Knowledge Base

Optimising KB Database

This section allows you to optimize the database tables of your knowledge base to defragment the table and reduce the size of the table on disk which leads to improved query performance and reduced response time for the select query. Table structure optimization reclaims unused space after deletions and basically clean up the table after structural modifications have been made.

Superusers can navigate to "Optimize Database" which is available in Tools section of left navigation bar.

Optimization should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions.

Click on Optimize Database Now button to optimize the tables of your database. During optimization, database tables are locked due to which front-end users will not be able to access them. So, you should optimize it during maintenance time or when there is less traffic present in your system.

The optimized result with the status is displayed after the completion of optimization as shown below:

  • #: This column displays the serial number of table record.
  • Table Name: This column shows the name of an optimized database table. The records are arranged in ascending order of table names.
  • Operation: This column displays the operation which was performed on the database table.
  • Status: This column shows the status of the optimization.
Custom Fields
  • Applicable To: Standard Edition, Standard (Multi-Language) Edition, Enterprise Edition (MySQL), Enterprise Multi-Language Edition (MySQL), Enterprise Edition (SQL Server), Enterprise Multi-Language Edition (SQL Server)
1 (1)
Article Rating (1 Votes)
Rate this article
Attached Files
There are no attachments for this article.
There are no comments for this article. Be the first to post a comment.
Security Code Security Code
Related Articles RSS Feed
Indexing Attachments
Viewed 1380 times since Thu, Sep 22, 2016
Sitemap Generator
Viewed 1569 times since Thu, Sep 1, 2016
Harvesting emails from knowledge base
Viewed 1286 times since Tue, Sep 6, 2016
Taking backup of knowledge base data
Viewed 1303 times since Tue, Aug 30, 2016