maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Sanja!

FYI:

https://jira.mariadb.org/browse/MDEV-515
and
https://jira.mariadb.org/browse/MDEV-5835

On Aug 03, Jan Lindström wrote:
> Hi,
> 
> If we talk about bulk load I would write directly .ibd file format pages,
> now as InnoDB has always some order between pages doing this in parallel
> has challenges, we can read and parse input, sort it, reformat to InnoDB
> pages, write these pages (maybe you could do this also parallel). To speed
> this up, I would remove secondary keys that are not needed from table and
> rebuild them after bulk load.
> 
> R: Jan
> 
> On Thu, Aug 3, 2017 at 12:09 PM, Oleksandr Byelkin <sanja@xxxxxxxxxxx> wrote:
> 
> > I am thinking about efficient inserting in a table using several threads
> > (LOAD), is it possible (and how difficult if it does) to make inserts with
> > help of several threads abut inside one InnoDB transaction (maybe one XA
> > transaction)?

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx