What is xwikircs table and can I clean it?

Help / Discuss
1

Hello

Everything is in the title

Our database became very huge over year, 75GB, causing us some issues for backup and recovery.

See below the details of the database.

What is the purpose of xwikircs, is there any process to clean it safely or will it broke the whole wiki ? Also is it normal it became so huge over the year ?

+---------------+-------------------------------+---------------+
| database_name | table_name                    | table_size_mb |
+---------------+-------------------------------+---------------+
| xwiki         | xwikircs                      |      74342.00 |
| xwiki         | activitystream_events         |       1738.05 |
| xwiki         | activitystream_events_status  |        570.95 |
| xwiki         | xwikiobjects                  |        201.89 |
| xwiki         | xwikiproperties               |        187.75 |
| xwiki         | xwikidoc                      |        145.22 |
| xwiki         | xwikistrings                  |        122.45 |
| xwiki         | xwikilargestrings             |         65.22 |
| xwiki         | xwikiintegers                 |         44.05 |
| xwiki         | xwikispace                    |         11.92 |
| xwiki         | xwikirecyclebin               |          8.48 |
| xwiki         | xwikilinks                    |          1.56 |
| xwiki         | xwikiattachment               |          0.80 |
| xwiki         | xwikilongs                    |          0.77 |
| xwiki         | notification_filter_prefs     |          0.44 |
| xwiki         | xwikipreferences              |          0.39 |
| xwiki         | xwikidates                    |          0.25 |
| xwiki         | xwikiattrecyclebin            |          0.20 |
| xwiki         | xwikistatsvisit               |          0.14 |
| xwiki         | xwikistatsdoc                 |          0.11 |
| xwiki         | mailsender_events             |          0.09 |
| xwiki         | xwikidoubles                  |          0.06 |
| xwiki         | xwikilistitems                |          0.06 |
| xwiki         | xwikifloats                   |          0.06 |
| xwiki         | xwikicomments                 |          0.06 |
| xwiki         | xwikistatsreferer             |          0.06 |
| xwiki         | xwikilock                     |          0.06 |
| xwiki         | xwikilists                    |          0.05 |
| xwiki         | activitystream_events_targets |          0.03 |
| xwiki         | feeds_feedentrytags           |          0.03 |
| xwiki         | feeds_aggregatorurlgroups     |          0.03 |
| xwiki         | xwikidbversion                |          0.02 |
| xwiki         | DATABASECHANGELOGLOCK         |          0.02 |
| xwiki         | feeds_keyword                 |          0.02 |
| xwiki         | xwikiattachment_archive       |          0.02 |
| xwiki         | feeds_aggregatorgroup         |          0.02 |
| xwiki         | feeds_aggregatorurl           |          0.02 |
| xwiki         | DATABASECHANGELOG             |          0.02 |
| xwiki         | feeds_feedentry               |          0.02 |
| xwiki         | xwikiattachment_content       |          0.02 |
| xwiki         | xwikiid                       |          0.02 |
+---------------+-------------------------------+---------------+

Regards,

Axel
EBRAINS / Human Brain Project

2

See https://www.xwiki.org/xwiki/bin/view/Documentation/DevGuide/DatabaseSchema/DsXWikiIrcs/

You should never change the database directly or you’re at a high risk of breaking the wiki. Always go through APIs/extensions.

I don’t know of any official way to clean/reduce but I’ve noticed this extension to clean the history of some pages: https://extensions.xwiki.org/xwiki/bin/view/Extension/Remove%20Document%20History

You can also manually remove revisions from the history UI, see https://www.xwiki.org/xwiki/bin/view/Documentation/UserGuide/Features/VersionControl

You could check if there are some pages taking all the disk space in the xwikircs table and clean the history of these pages if you don’t need them (or only a portion of it).

You could also turn off page history but this is really not recommended.

Related: