[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


Adam Field
SHERPA services analyst developer

From: <eprints-tech-bounces at ecs.soton.ac.uk> on behalf of Matthew Brady <Matthew.Brady at usq.edu.au>
Reply-To: "eprints-tech at ecs.soton.ac.uk" <eprints-tech at ecs.soton.ac.uk>
Date: Monday, 23 January 2017 06:25
To: "eprints-tech at ecs.soton.ac.uk" <eprints-tech at 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.

[cid:image002.png at 01D2756A.F6B313C0]

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




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.  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20170123/24fec9a0/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1264 bytes
Desc: image001.png
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20170123/24fec9a0/attachment-0002.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3478 bytes
Desc: image002.png
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20170123/24fec9a0/attachment-0003.png