Croup permissions size explodes

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
David Soul
Veteran Member
Posts: 31
Joined: 2018-01-04 18:32
Location: Vancouver, Canada
Contact:

Croup permissions size explodes

Post by David Soul » 2022-05-06 02:23

Approximately a year ago my web site was loading glacially slow - the web host took a look and determined that the table membership_grouppermissions should have an index added. This made load blindingly fast.

I am now running out of space on the server and find the size of that file has bitterly exploded too be 43,737,402 kb !!!
Should that file just continue to grown without limits - the index is now larger than the data file itself?

looking with phpMyAdmin the membership_grouppermissions table shows:
Showing rows 0 - 24 (700068296 total, Query took 0.0003 seconds.)
with
Space usage
Data 20.3 GiB
Index 21.4 GiB

with the following:
Row statistics
Format dynamic
Collation utf8_general_ci
Rows 700,069,466
Row length 31 B
Row size 64 B
Next autoindex 700,072,270
Creation May 03, 2022 at 01:25 AM
Last update May 06, 2022 at 02:12 AM
Last check May 03, 2022 at 06:16 AM

The entire actual data records in the tables in Appgini site are appoximately 24,000.

Is it possible that running "optimise table" would resolve the issue.
If the table is dropped would it be recreated automatically?
Flush?

Obviously I know nothing of these processes and cannot access the problem let alone solutions and tech support at the hosting site do not seem up to the task.

Any pointers that might get me looking at the right place for a solution would be a great start - thanks for any assistance you may offer here!
David HC Soul

Core::AppGini 5.93
Plugins: Search Page Maker + Summary Reports + Mass update plugin
Bizzworxx: AppGini Helper JavaScript Library + AppGini Helper Detail View Plug-in + AppGini Helper pack
Utilities: Global Search utility

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Croup permissions size explodes

Post by pbottcher » 2022-05-06 07:27

Hi,

I think you are facing the issue

viewtopic.php?t=2967

So in orde clear this issue, you can truncate the table, but you will need to recreate all permission settings. So depending on how many groups you have it could be quite some work.

As alternative you can write a sql query to remove all duplicate entries from that table.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

David Soul
Veteran Member
Posts: 31
Joined: 2018-01-04 18:32
Location: Vancouver, Canada
Contact:

Re: Croup permissions size explodes

Post by David Soul » 2022-05-06 21:09

I think you are facing the issue

viewtopic.php?t=2967
Thanks for this! I'll go check it out then will probably have to get someone to assist me in writing an SQL query if my host support will not undertake.

Kind Regards,
David
David HC Soul

Core::AppGini 5.93
Plugins: Search Page Maker + Summary Reports + Mass update plugin
Bizzworxx: AppGini Helper JavaScript Library + AppGini Helper Detail View Plug-in + AppGini Helper pack
Utilities: Global Search utility

David Soul
Veteran Member
Posts: 31
Joined: 2018-01-04 18:32
Location: Vancouver, Canada
Contact:

Re: Croup permissions size explodes

Post by David Soul » 2022-05-07 06:21

David Soul wrote:
2022-05-06 21:09
I think you are facing the issue

viewtopic.php?t=2967
Thanks for this! I'll go check it out ....
Kind Regards,
David
It worked!
Thank you so much for pointing in the right direction.

Kind regards,
David
David HC Soul

Core::AppGini 5.93
Plugins: Search Page Maker + Summary Reports + Mass update plugin
Bizzworxx: AppGini Helper JavaScript Library + AppGini Helper Detail View Plug-in + AppGini Helper pack
Utilities: Global Search utility

Post Reply