How to reduce the size of Synchrony tables

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

目的

In Confluence 6.0 to 6.15, Synchrony tables are append-only. As the tables increase in size they may be come too large for some databases.

Note: In Confluence 7.0 and later, two scheduled jobs are available to evict Synchrony data on a regular basis. See How to remove Synchrony data for more information. 


ソリューション

The Synchrony tables can be truncated to resolve the issue.

Please note that turning Collaborative editing OFF and ON again may remove any unsaved drafts. You may refer to this page - How Do Drafts Work on Confluence for detailed information regarding drafts. Please follow the steps below to identify and publish unpublished drafts.

Identify unpublished drafts: How to recover or identify a lost shared draft after disabling collaborative editing in Confluence

データベースの変更を行う場合は必ず事前にバックアップを取得してください。

  1. Have the users publish or discard the changes
  2. Turn off collaborative editing
  3. Truncate the tables


    (warning) Don't do this while collaborative editing is on

    TRUNCATE TABLE "EVENTS";
    TRUNCATE TABLE "SECRETS";
    TRUNCATE TABLE "SNAPSHOTS";
  4. Turn on collaborative editing.

最終更新日 2019 年 6 月 17 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.