[EP-tech] Re: size of tables in mysql

Tim Brody tdb2 at ecs.soton.ac.uk
Tue Feb 5 16:09:50 GMT 2013


On Tue, 2013-02-05 at 13:47 +0100, Yuri wrote:
> -rw-rw---- 1 mysql mysql 2,7G  5 feb 13:45 
> /var/lib/mysql/mysite/access__ordervalues_en.MYD
> 
> is this a normal value for a 40000 thesis site with 10 millions of pdf 
> download at year?
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/

What version of EPrints is this in?

On a recent 3.3 access__ordervalues_en should no longer be populated,
and can be safely cleared. It's on our "TODO" to tidy up historical
access log data (i.e. throw away more robots & other junk data).

-- 
All the best,
Tim
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20130205/9f005c77/attachment.bin 


More information about the Eprints-tech mailing list