EPrints Technical Mailing List Archive

Message: #06192


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] database table untouched for years.


Huh!  That’s quite interesting.  It’s ordervalues for the access dataset (which is kindof like the apache log and tracks whenever anyone looks at an abstract page or downloads a fulltext item).  It’s unlikely that the data is of any practical use, as I don’t believe there are front-end interfaces for the access table.  It’s used for download statistics, but is processed first…

 

If you *really* want to recover the 5GB of space, it’s probably safer to delete all the rows, just in case the existence of the table is relied upon.

 

 

isc

Adam Field
SHERPA services analyst developer

 

 

From: <eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Matthew Brady <Matthew.Brady@usq.edu.au>
Reply-To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
Date: Monday, 23 January 2017 06:25
To: "eprints-tech@ecs.soton.ac.uk" <eprints-tech@ecs.soton.ac.uk>
Subject: [EP-tech] database table untouched for years.

 

Hi All,

 

Our DBA has noticed a table that hasn’t had anything occur to it in quite a while… and I can’t see any reason it would actually be required (nor how it was created in the past, as the access dataset doesn’t require ‘order values’.  Only thing I can come up with is it was used in earlier versions, 2.3.13?? maybe 3.1.0?? and it didn’t get cleaned up when moving to 3.3.10.

 

 

Has anyone got any ideas? And/Or is it safe to remove it permanently?

 

 

Cheers

 

Matt.

_____________________________________________________________
This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.
 
The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.
 
The University of Southern Queensland is a registered provider of education with the Australian Government.
(CRICOS Institution Code QLD 00244B / NSW 02225M, TEQSA PRV12081 )

Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.

Jisc Services Limited is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under company number 2881024, VAT number GB 197 0632 86. The registered office is: One Castle Park, Tower Hill, Bristol BS2 0JA. T 0203 697 5800.