Re: How to move partition files
I have a merge to another table but my principal problem is innodb. My applications are writing on the table all the time and the spended time is very important to me. Because that I need to use InnoDB to reduce locks on the table.
In the process I need to convert the table InnoDB to a MyISAM to include in the MERGE table. Another problem is pruning, with MERGE you haven't pruning at all.
My criteria is the same as yours, recent data is the mos frequently accessed data but when I need to search a old data, the query spends too much time.
I think about this but I want to have InnoDB tables. Finally if I will have two tables, one with recent data and another with old data, I will think in use MyISAM tables.
Subject
Views
Written By
Posted
12615
March 05, 2008 03:06PM
7326
March 25, 2008 04:50AM
4025
September 30, 2008 10:18AM
4094
October 01, 2008 07:39PM
3901
October 03, 2008 04:26AM
3569
October 05, 2008 08:39PM
3618
October 08, 2008 10:43AM
3569
October 08, 2008 10:45PM
Re: How to move partition files
4370
October 09, 2008 02:15AM
3452
October 21, 2008 09: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.