Configuration Guide for Cisco Unified MeetingPlace Release 8.5
Maintaining the Database
Downloads: This chapterpdf (PDF - 69.0KB) | Feedback

Maintaining the Cisco Unified MeetingPlace Database

Table Of Contents

Maintaining the Cisco Unified MeetingPlace Database


Maintaining the Cisco Unified MeetingPlace Database


Release 8.5
Revised: September 19, 2011 3:26 pm

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

250,000 users

Verify active users, and delete any obsolete user profiles.

Deleting a User Profile in the Configuring User Profiles and User Groups for Cisco Unified MeetingPlace module

Deleting User Profiles by Import in the Importing Data into Cisco Unified MeetingPlace module

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 Cisco Unified MeetingPlace Application Server module