MySQL Forums :: Partitioning :: how to speed up for List partitioning table


Advanced Search

how to speed up for List partitioning table
Posted by: jongse park ()
Date: December 28, 2014 07:59PM

Hi,

I have some list partitiong tables.
I have two process load data infile ... and insert into ... select.

My Process like below;
1. I have a hundred partitioning tables. eache partitioning table is loaded data every 15 minutes. 4 times for 1 hour. (load data infile query runs). the data file of loaded is about 2GB. 2GB * 4 time = total 8GB an one hour.
each partitioning table has about 100 list partitions.
2. after load data job have finished. insert data other tables with insert into ....select data from those partitioning tables for 1 hour.
3. "insert into ....select" execute with concurently load data infile running to other partition on the same partitioning tables.
4. above process is rotating.

as a result, Load data infile process is getting delayed. so insert into ...select process is affected and is getting delayed.

How can I tune the this process.
Is there any material or ducuments for I can refer to?

Options: ReplyQuote


Subject Views Written By Posted
how to speed up for List partitioning table 1641 jongse park 12/28/2014 07:59PM
Re: how to speed up for List partitioning table 899 Rick James 12/30/2014 03:05PM


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.