1. Home
  2. Docs
  3. Kiwire ( v3 ) – Administrator
  4. Help & Tools
  5. Database

Database

The database modules let you manage database aspect of Kiwire™ platform.


Database Diagnostic

The Database Diagnostic module provides you a tools to check Kiwire™ database tables. Use this tools to repair and optimize your database when you encounter database error.




The field and its function description is listed below.


FieldFunction
TableName of all tables inside Kiwire database
StatusShows the status of tables if it is working properly.

Database Disk Usage

The Database Disk Usage module will tell you how much disk usage is being used. This helps you understand the database growth of your system. 



database_disk_usage


The field and its function description is listed below.


FieldFunction
Reported StatisticInsight details regarding your database.
Data SizeData size of that specific module.
Index SizeIndex size of that specific module.
Total SizeTotal size of that specific module.

Database Performance

The Database Performance module provides information and key statistic of the database performance.

database_performance


DATABASE MAINTENANCE 

The Database MRO (Maintenance, Repair & Operation) module let you perform the following functions:

  • Backup & download Kiwire™ database to your local computer
  • Purge account inactive more than 6 months
  • Purge device history inactive more than 3 months
  • Purge survey response create more than 3 months
  • Purge network monitoring system (nms) log created more than 1 month
  • Purge general report data created more than 3 months
  • Purge device report data created more than 3 months
  • Purge dwell type report data created more than 3 months
  • Purge error report data created more than 3 months
  • Purge profile report data created more than 3 months
  • Purge campaign report data created more than 3 months
  • Purge controller report data created more than 3 months
  • Purge campaign unique data for click and impression created more than 3 months
  • Purge messages created more than 3 months

Click on the respective button to use function.

database_maintenance