Re: Insert speed on table with 7M rows but small row size.

2006-04-10 Thread Shawn Green
--- Alexey Polyakov <[EMAIL PROTECTED]> wrote: > On 4/8/06, Kevin Burton <[EMAIL PROTECTED]> wrote: > > > Is there anyway I can tune MySQL to improve this operation? > > There's a fundamental problem with B-trees - inserts in a big B-tree > can be very slow, cause it may require tree rebalanci

Re: Insert speed on table with 7M rows but small row size.

2006-04-08 Thread Alexey Polyakov
On 4/8/06, Kevin Burton <[EMAIL PROTECTED]> wrote: > Is there anyway I can tune MySQL to improve this operation? There's a fundamental problem with B-trees - inserts in a big B-tree can be very slow, cause it may require tree rebalancing. One workaround for this problem is partitioning. MySQL 5.1