> -----Original Message-----
> From: GRIDPP2: Deployment and support of SRM and local storage management
> [mailto:[log in to unmask]] On Behalf Of Alessandra Forti
>
> well not if you change hardware. I dropped them because last time took
> hours to dump them and 17-18 hours to reload them. I think Cambridge had a
> 2 days ordeal because of this. By dropping the requests tables and all
> related indices it takes then less than 5 minutes to upload and my ibdata1
> is now down to 1.7GB from 26GB it was.
>
I am very keen to do this too; last time I tried our upgrade it
did take ages to reload the database so I shall look forward to
the blog post.
Ewan
|