MySQL Forums
Forum List  »  Performance

move records between tables faster #2...
Posted by: Zsolt Kendi
Date: November 26, 2010 08:18AM

This is countinue of topic "move records between tables faster...".

First of all sorry for RJ, I lost the topic above...

"What are your goals?"
Because still 3 serail "fifo" fast as possible to prevent loss.


"Is this MyISAM or InnoDB?"
MyISAM
"Consider PARTITION?"
No
"What percentage of the table is being moved?"
less than 1%
"How big is the table?"
~3Mrow, 1k/row, 3GB in ramdisk.

Options: ReplyQuote


Subject
Views
Written By
Posted
move records between tables faster #2...
4703
November 26, 2010 08:18AM


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.