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
Subject
Views
Written By
Posted
4475
February 18, 2009 04:54AM
2292
February 18, 2009 09:04AM
2384
February 18, 2009 11:57AM
2375
February 19, 2009 01:00AM
2331
February 19, 2009 01:52AM
2345
February 19, 2009 03:32AM
1774
February 19, 2009 05:08AM
2218
February 19, 2009 12:24PM
2307
February 19, 2009 10:53PM
2422
February 20, 2009 08:34AM
Solution
2200
March 18, 2009 03:58AM
2318
February 21, 2009 06:15AM
2269
February 24, 2009 10:02AM
2474
February 26, 2009 02:30AM
2102
February 26, 2009 09:56AM
2293
February 26, 2009 08:14PM
2313
February 27, 2009 01:38AM
2195
February 27, 2009 07:56PM
2190
February 28, 2009 06:20AM
2526
February 28, 2009 03:43PM
2319
February 27, 2009 04:21AM
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.