From: Eric Bergen
Date: June 29 2004 11:34pm
Subject: Re: Memory to Memory INSERTS
List-Archive: http://lists.mysql.com/mysql/168124
Message-Id: <11b1bd9904062916343548114a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

http://dev.mysql.com/doc/mysql/en/Insert_speed.html

-Eric

On Tue, 29 Jun 2004 09:43:04 -0400, sgreen@stripped <sgreen@stripped> wrote:
> 
> 
> I am proposing this as a hypothetical situation and I would like the full
> feedback of the group:
> 
> Could Alejandro re-use the sections of the MySQL source code that handle
> replication and bin-logging to make his data capture application appear as
> a "Master" server and have his MySQL database act as its slave?
> 
> Would that be faster than periodic batch files with LOAD DATA INFILE?
> 
> Respectfully,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
>                       Alejandro Heyworth
>                       <heyworth@digitaldis        To:       mysql@stripped
>                       ciples.com>                 cc:
>                                                   Fax to:
>                       06/25/2004 03:48 PM         Subject:  Memory to Memory INSERTS
> 
> 
> 
> 
> Hi!
> 
> I'm looking for a better way to insert large numbers of rows from a client
> application that is sampling physical data in real-time.  In our case, we
> are using a C "double hipvalues[1000000]" cyclical array to buffer our
> sampled values.
> 
> We're currently creating large query strings similar to:
> 
> INSERT DELAYED INTO hipjoint VALUES
> (hipvalues[0]),(hipvalues[1]),(hipvalues[2]),(hipvalues[3]),etc...
> 
> We would like to continue to insert our values directly from our client app
> 
> without first having to dump the data to a temp file and LOAD DATA
> INFILEing it periodically.
> 
> Any ideas?
> 
> Config values of interest:
> key_buffer_size = 4G
> bulk_insert_buffer_size = 1024M
> 
> We are using MySQL 4.1.2.
> 
> Thanks.
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=sgreen@stripped
> 
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
>