MySQL Forums
Forum List  »  Performance

Solution
Posted by: Kaspar Con
Date: March 18, 2009 03:58AM

We finally found a solution for the slowdown. As mostly always it came from a direction you wouldn't suspect it to come.

As an upgrade to mysql 5.1.31 did not change anything we began to run queries via cron every minute. This showed us, that performance broke down every day at 3 a.m. - the time we backed the system up. We could also see that after an Insert (and therefore recreation of the index) the queries ran fast again.

We saw that we made all backups at the same time (filecopy, mysqldump and tivoli) which of course is rubbish. Moreover we copied the mysql database files via tivoli.

We finally spred the backup actions for 3 hours and don't make a hardcopy of the files anymore. Afterwards the queries where steadily fast. Perhaps the indexfiles where destroied by the hardcopy.

Thank you Aftab and Rick for your helpful suggestions

Options: ReplyQuote


Subject
Views
Written By
Posted
Solution
2200
March 18, 2009 03:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.