Re: DATA CLEANING IN FRED REGISTRY DATABASE

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