Hi All
This would seem an appropriate point at which to ask a question mentioned at the HEPSYSMAN. Is there interest
in holding a tutorial in conjunction with the next HEPSYSMAN on administering (mySQL) databases. I think
there was support voiced at the meeting and it leads to a broader question: what other areas of your work would
benefit from some training/tutorials? Please let me know any suggestions that you have so that we can consider
organising something in 2012.
Many thanks,
Jeremy
On 16 Nov 2011, at 12:39, Chris Brew wrote:
> Hi,
>
>
> Obviously after I gave a talk of stabilising and tuning CreamCEs last
> week, our CEs were bound to develop issues.
>
> Two of the CEs started to fail SAM test with this (obviously databasey
> error):
>
> Transfer to CREAM failed due to exception: CREAM Register returned error
> "MethodName=[jobRegister] Timestamp=[Sat 12 Nov 2011 19:43:45]
> ErrorCode=[0] Description=[system error] FaultCause=[Rollback executed
> due to: Lock wait timeout exceeded; try restarting transaction]"
>
>
> I ran tunemysql.pl against the DB on those hosts and it suggested
> increasing the innodb_buffer_pool_size to 2048M or more.
>
> I upped it to 2048M, the errors have gone away and you can see the effect
> from the attached ganglia plot.
>
> Yours,
> Chris.
>
> <default.png>
|