AppGini Community Forums

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!

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.

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 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