MySQL Forums
Forum List  »  Backup

Re: Backup and trimming data idea
Posted by: newbie Shai
Date: July 02, 2012 09:47AM

Dear Rick,
Can say in short look for all the where and make sure there are all indexed? Is there any other indication when to put the order by to be part of the indexes? Priority always goes highest for '=' in the case of like?

This part is a bit new to me.
"So, if you can't figure out which table will be picked first, have two indexes so that the optimizer is free to pick:
INDEX(b, id, c) or (id, b, c), and
INDEX(b, c)
(Again, order of the fields is important.) ". If we look into all the SELECT, UPDATE, DELETE etc may not all involved the same number of keys. So for that case how to handle it.


Regarding the delete only two tables I can see for sure will have more then a million rows. So should I just partition this two tables alone and leave the rest as it is and do manual chunk deletes?

Options: ReplyQuote


Subject
Views
Written By
Posted
3875
June 22, 2012 07:34PM
1808
June 23, 2012 05:23PM
1880
June 23, 2012 05:36PM
1896
June 24, 2012 01:51PM
1928
June 25, 2012 10:16AM
1763
June 26, 2012 08:14AM
1885
June 26, 2012 08:46AM
1777
June 27, 2012 08:36AM
1859
June 27, 2012 09:03AM
1712
June 28, 2012 11:19PM
1668
June 29, 2012 07:12AM
1665
June 30, 2012 11:50AM
Re: Backup and trimming data idea
1758
July 02, 2012 09:47AM
1701
July 03, 2012 01:32PM
1757
July 05, 2012 11:13AM
1917
July 06, 2012 09:57AM
1695
July 07, 2012 10:50AM
1742
July 08, 2012 09:33AM
1729
July 16, 2012 08:08PM
1693
July 21, 2012 10:57PM


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.