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)
Posted by: Gurjeet Kaur - August 29, 2016. This article has been viewed 4264 times.
Online URL: https://www.phpkb.com/kb/article/optimising-kb-database-126.html

Powered by PHPKB (Knowledge Base Software)