List:Internals« Previous MessageNext Message »
From:Sela Lerer Date:March 23 2009 10:47am
Subject:Re: remote binary bulk inserts from background thread in MySQL server
View as plain text  
You can LOAD DATA INFILE from a named pipe and dump the data into this pipe.

On Mon, Mar 23, 2009 at 11:22 AM, Andrej van der Zee
<andrejvanderzee@stripped> wrote:
>
> Hi,
>
>
> >
> > Sergei> Either by using the client API and prepared statements - then you
> won't
> > Sergei> need to convert your binary data to strings, and you can bulk-insert
> many
> > Sergei> rows at once.
> >
> > At this moment, the fastest way to do it is to write things to a file
> > on the client side and then issue a 'load data local infile' to read
> > the file.
>
> Wouldn't writing it to disk first slow down the whole thing? Writing
> directly to the network wouldn't have this overhead.
>
> Thanks,
> Andrej
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals?unsub=1
>
Thread
remote binary bulk inserts from background thread in MySQL serverAndrej van der Zee5 Mar
  • Re: remote binary bulk inserts from background thread in MySQLserverSergei Golubchik6 Mar
    • Re: remote binary bulk inserts from background thread in MySQLserverMichael Widenius8 Mar
      • Re: remote binary bulk inserts from background thread in MySQL serverAndrej van der Zee23 Mar
        • Re: remote binary bulk inserts from background thread in MySQL serverSela Lerer23 Mar