Configuration Guide for Cisco Unified MeetingPlace Release 8.6
Maintaining the Database
Downloads: This chapterpdf (PDF - 68.0KB) The complete bookPDF (PDF - 7.28MB) | Feedback

Maintaining the Database

Table Of Contents

Maintaining the Database


Maintaining the Database


The dbsize utility lists the sizes of several important database tables. To run the utility, sign in to the Application Server CLI as the root user.

[root@ApplicationServer ~]# dbsize 
Number of users
            3019
Number of groups
               3
Number of conferences
          586334
Number of conference participants
         1965944
Number of conference time records
         1490661
Number of conference notifications
               0
Number of conference category records
          886577
Number of conference attachments
               0
Number of meeting number reservations
          886653
 
   

The size of certain database tables can impact the performance of the system. The following table lists the recommended maximum number of records for specific tables, which you should periodically check using the dbsize utility. When necessary, reduce the number of records by using the applicable process.

dbsize Output
Recommended Maximum
How to Reduce the Number

Number of users

400,000 users

Verify active users, and delete any obsolete user profiles.

Deleting a User Profile

Deleting User Profiles by Import

Number of conferences

600,000 conferences

Reduce the value of the Days until meeting statistics deleted field on the Meeting Configuration Page.

The reduction will take place over time as new meetings are scheduled with the new retention period and older meetings are purged from the system.


Related Topics

Using the Command-Line Interface (CLI) on the Application Server