spaces.at.internet2.edu has been upgraded to Confluence 7.13.2. If you have any questions and/or concerns, please contact us at collaboration-support@internet2.edu
Child pages
  • Duke Disk Space Usage

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To get an idea of our size, here's are some counts of rows in a few tables:


grouper_attribute_assign - 84,599

grouper_memberships - 12,591,506

grouper_group_set - 6,593,297

...

grouper_stem_set - 2,255,213


grouper_pit_attribute_assign - 177,782

grouper_pit_memberships - 21,352,983

...

This is the disk space used by each of the Grouper tables excluding indexes.


TableDisk space (GB)
GROUPER_ATTRIBUTE_ASSIGN.021484375
GROUPER_ATTRIBUTE_ASSIGN_VALUE.0078125
GROUPER_ATTRIBUTE_DEF.000061035
GROUPER_ATTRIBUTE_DEF_NAME.00390625
GROUPER_ATTRIBUTE_DEF_NAME_SET.001953125
GROUPER_ATTRIBUTE_DEF_SCOPE.000061035
GROUPER_ATTR_ASSIGN_ACTION.000061035
GROUPER_ATTR_ASSIGN_ACTION_SET.000061035
GROUPER_AUDIT_ENTRY13.7304688
GROUPER_AUDIT_TYPE.000061035
GROUPER_CHANGE_LOG_CONSUMER.000061035
GROUPER_CHANGE_LOG_ENTRY1.44805908
GROUPER_CHANGE_LOG_ENTRY_TEMP.0859375
GROUPER_CHANGE_LOG_TYPE.000061035
GROUPER_COMPOSITES.001953125
GROUPER_DDL.000061035
GROUPER_FIELDS.000061035
GROUPER_GROUPS.3671875
GROUPER_GROUP_SET4.15332031
GROUPER_LOADER_LOG.036132813
GROUPER_MEMBERS.59375
GROUPER_MEMBERSHIPS4.4453125
GROUPER_PIT_ATTRIBUTE_ASSIGN.044921875
GROUPER_PIT_ATTRIBUTE_DEF.000061035
GROUPER_PIT_ATTR_ASSN_ACTN.000061035
GROUPER_PIT_ATTR_ASSN_ACTN_SET.000061035
GROUPER_PIT_ATTR_ASSN_VALUE.02734375
GROUPER_PIT_ATTR_DEF_NAME.002929688
GROUPER_PIT_ATTR_DEF_NAME_SET.002929688
GROUPER_PIT_FIELDS.000061035
GROUPER_PIT_GROUPS.247070313
GROUPER_PIT_GROUP_SET4.87597656
GROUPER_PIT_MEMBERS.33203125
GROUPER_PIT_MEMBERSHIPS5.88476563
GROUPER_PIT_ROLE_SET.000976563
GROUPER_PIT_STEMS.140625
GROUPER_QZ_CRON_TRIGGERS.000061035
GROUPER_QZ_FIRED_TRIGGERS.000061035
GROUPER_QZ_JOB_DETAILS.000061035
GROUPER_QZ_LOCKS.000061035
GROUPER_QZ_SCHEDULER_STATE.000061035
GROUPER_QZ_SIMPROP_TRIGGERS.000061035
GROUPER_QZ_TRIGGERS.000061035
GROUPER_ROLE_SET.000427246
GROUPER_STEMS.1875
GROUPER_STEM_SET.4140625
GROUPER_TABLE_INDEX.000061035
SUBJECT.000061035
SUBJECTATTRIBUTE.000061035




Index disk space usage

This is the total disk space used by indexes on each of the Grouper tables.

TableDisk space (GB)
GROUPER_ATTRIBUTE_ASSIGN0.0673828130
GROUPER_ATTRIBUTE_ASSIGN_VALUE0.0095214860
GROUPER_ATTRIBUTE_DEF0.0002441400
GROUPER_ATTRIBUTE_DEF_NAME0.0017700190
GROUPER_ATTRIBUTE_DEF_NAME_SET0.0053100590
GROUPER_ATTRIBUTE_DEF_SCOPE0.0001220700
GROUPER_ATTR_ASSIGN_ACTION0.0001220700
GROUPER_ATTR_ASSIGN_ACTION_SET0.0002441400
GROUPER_AUDIT_ENTRY18.9204101580
GROUPER_AUDIT_TYPE0.0001220700
GROUPER_CHANGE_LOG_CONSUMER0.0001220700
GROUPER_CHANGE_LOG_ENTRY3.2520141610
GROUPER_CHANGE_LOG_ENTRY_TEMP0.1224365250
GROUPER_CHANGE_LOG_TYPE0.0001220700
GROUPER_COMPOSITES0.0028686520
GROUPER_DDL0.0001220700
GROUPER_FIELDS0.0002441400
GROUPER_GROUPS0.6962890630
GROUPER_GROUP_SET11.5604858360
GROUPER_LOADER_LOG0.0254516600
GROUPER_MEMBERS0.8634033210
GROUPER_MEMBERSHIPS24.0016479350
GROUPER_PIT_ATTRIBUTE_ASSIGN0.1552734410
GROUPER_PIT_ATTRIBUTE_DEF0.0004882800
GROUPER_PIT_ATTR_ASSN_ACTN0.0003051750
GROUPER_PIT_ATTR_ASSN_ACTN_SET0.0004272450
GROUPER_PIT_ATTR_ASSN_VALUE0.0469970710
GROUPER_PIT_ATTR_DEF_NAME0.0038452140
GROUPER_PIT_ATTR_DEF_NAME_SET0.0046997070
GROUPER_PIT_FIELDS0.0003662100
GROUPER_PIT_GROUPS0.4638671890
GROUPER_PIT_GROUP_SET14.7217407250
GROUPER_PIT_MEMBERS0.5703735350
GROUPER_PIT_MEMBERSHIPS15.8040161330
GROUPER_PIT_ROLE_SET0.0021972660
GROUPER_PIT_STEMS0.2714843770
GROUPER_QZ_CRON_TRIGGERS0.0000610350
GROUPER_QZ_FIRED_TRIGGERS0.0004272450
GROUPER_QZ_JOB_DETAILS0.0001831050
GROUPER_QZ_LOCKS0.0000610350
GROUPER_QZ_SCHEDULER_STATE0.0000610350
GROUPER_QZ_SIMPROP_TRIGGERS0.0000610350
GROUPER_QZ_TRIGGERS0.0007934550
GROUPER_ROLE_SET0.0010986330
GROUPER_STEMS0.3280029290
GROUPER_STEM_SET0.8203125000
GROUPER_TABLE_INDEX0.0001220700
SUBJECT0.0000610350
SUBJECTATTRIBUTE0.0002441400