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

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.

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