Cisco Unified MeetingPlace Release 8.0 -- Maintaining the Cisco Unified MeetingPlace Database

From DocWiki

Main page: Cisco Unified MeetingPlace, Release 8.0

Up one level: Maintenance

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