[EP-tech] So many cache tables in database (eprints 3.4.3)

[ayu.2788 at gmail.com (Ayu Widi)]

CAUTION: This e-mail originated outside the University of Southampton.
Thank you martin for your help.

On Tue, 2 May 2023 at 13.22 Martin Br?ndle <martin.braendle at uzh.ch<mailto:martin.braendle at uzh.ch>> wrote:
Hi,

this is normal if you have a lot of traffic and searches on your repo.

You can cleanup them using  epadmin cleanup_cachemaps *repository_id* which drops any orphaned cache tables.

Kind regards,

Martin

--
Dr. Martin Br?ndle
Zentrale Informatik
Universit?t Z?rich<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FZ%25C3%25BCrich%2B%250D%250AStampfenbachstr.%2B73%2B%250D%250ACH-8006%2BZ%25C3%25BCrich%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ce0846243e6074ea5e75d08db4ad65802%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638186056674922446%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3zzNPxyo72oSPEZB12y9bQCiW4fTxna7mPtdeCNKbA0%3D&reserved=0>
Stampfenbachstr. 73<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FZ%25C3%25BCrich%2B%250D%250AStampfenbachstr.%2B73%2B%250D%250ACH-8006%2BZ%25C3%25BCrich%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ce0846243e6074ea5e75d08db4ad65802%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638186056674922446%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3zzNPxyo72oSPEZB12y9bQCiW4fTxna7mPtdeCNKbA0%3D&reserved=0>
CH-8006 Z?rich<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.google.com%2Fmaps%2Fsearch%2FZ%25C3%25BCrich%2B%250D%250AStampfenbachstr.%2B73%2B%250D%250ACH-8006%2BZ%25C3%25BCrich%3Fentry%3Dgmail%26source%3Dg&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ce0846243e6074ea5e75d08db4ad65802%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638186056674922446%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3zzNPxyo72oSPEZB12y9bQCiW4fTxna7mPtdeCNKbA0%3D&reserved=0>



From: eprints-tech-bounces at ecs.soton.ac.uk<mailto:eprints-tech-bounces at ecs.soton.ac.uk> <eprints-tech-bounces at ecs.soton.ac.uk<mailto:eprints-tech-bounces at ecs.soton.ac.uk>> on behalf of Ayu Widi via Eprints-tech <eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk>>
Date: Tuesday, 2 May 2023 at 08:13
To: eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk> <eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk>>
Subject: [EP-tech] So many cache tables in database (eprints 3.4.3)
CAUTION: This e-mail originated outside the University of Southampton.
Hi people,

I always see so many cache tables in my eprints database (I attached the screenshot). Please let me know what it is and how to deal with it? thank you
--
Regards,
Ayu Widi
BRIN Indonesia
Phone / SMS / Whatsapp : +62 818 0778 6675

--
Regards,

Retno Ayu Widiyaningrum, M.Kom
BRIN Indonesia

Phone / SMS / Whatsapp : +62 818 0778 6675

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230502/53549eee/attachment-0001.html