Skip to main content
Blackboard Help

Configuring Global Schema Settings

The global schema is the structure of the Blackboard Learn database. It is a database that is separate from the document store databases, and controls connections and information to each of the document stores. The Global Schema Settings page allows administrators to edit the settings for database connection times and the size of the connection pool.

For a description of connection pools, see Configuring JDBC Settings. The global schema requires its own pool of connections, and consumes significantly less connections than each document store.

How to Configure the Global Schema Settings

  1. On the Administrator Panel, under Content Management, click Technical Settings.
  2. Click Global Schema Settings. The following table describes the available fields.
    Field Description
    Dead connection timeout Provide the number of seconds before a dead connection will time out and be removed from the pool. A dead connection is one that is not sending any activity between the database and the Content Collection.
    Live connection expiration Occasionally, a connection will remain open but unusable. This is sometimes referred to a "hung Java connection," and although the connection is not useable, it is not a dead connection. Automatically expiring all live open connections ensures that hung connections eventually close. Provide the number of minutes a database connection will remain open before the system automatically closes it. New connections are created dynamically when needed, up to the maximum connections setting.
    Maximum size of connection pool Provide the maximum number of connections that can exist in the connection pool. If this number is too high, performance may decrease because the database server consumes more resources. If it is too low, requests may take longer to process because they might wait in a queue until a connection becomes available.
    Minimum size of connection pool Provide the minimum size of the connection pool. Because the number of connections to the global schema is typically small, the default of 2 is adequate for most schools.