12 Čen
2023
12 Čen
'23
12:04
Hello Dr. Paulos,
Thank you for feedback.
On #2 ,if you can highlight which tables(table names) do you normally drop.
Regards,
Patrick
On 6/9/2023 10:58 AM, Dr Paulos Nyirenda wrote:
On 8 Jun 2023 at 10:25, patrick wrote:
Dear Fred users,
Hope you are all doing good.
I want to ask if there is any guide on how to do data cleaning in
Fred Database without impacting fred services.
Please share your experience .
Patrick,
For us at Malawi .mw ccTLD
1. running "fred-admin --object_regular_procedure" regularly such as
on a cron job helps to clean out issues with domain expiry, cleanv out
database objects like contacts, nssets, etc that have not been used
for a long time, etc
2. removing old logs in the database helps clean the DB out of
overgrowing our machine memory and disk space - when these run out we
see registrars getting EPP timeout. So far, the only way we know on
how to do this is by direct SQL ... is there a better way ?
3. advising our registrars to use the EPP poll command helps them
manage their domains BUT we are finding it difficult to get registrars
to use or automate this to avoid complaints from registrants ... is
there a better way ?
I hope this helps.
Regards,
Paulos
=====================================
Dr Paulos B Nyirenda
NIC.MW & .mw ccTLD: http://www.nic.mw
SDNP: http://www.sdnp.org.mw
Tel: +265-(0)-882 089 166
Cell: +265-(0)-888-824787
WhatsApp: +265-(0)-887386433
Thank you,
Patrick
_______________________________________________
fred-users mailing list -- fred-users(a)lists.nic.cz
To unsubscribe send an email to fred-users-leave(a)lists.nic.cz