List:General Discussion« Previous MessageNext Message »
From:Thomas Lekai Date:March 4 2005 5:20am
Subject:Speed of Inserts into MyIsam tables from mysqlbinlog
View as plain text  
I was running a table in InnoDB, and the table had about 6 indexes, none
of which seemed to be affected when I ran mysqlbinlog against the tables
in order to apply bin-logs from production against a test system.  I was
manage to process upwards of 2300 queries per second by throwing about
1.8 GB of memory into the innodb_buffer_pool.

Now that I am dealing with MyIsam tables, I shifted my memory towards
the key_buffer, and am considering using bulk_insert_buffer_size.  I am
not sure what is a good value for the bulk_insert_buffer_size.  I have
also removed all indexes that are not needed from the table while it is
being loaded with data.

My question, is there anything else that I can do to increase the speed
of the inserts into this MyIsam table as the bin_logs are played back on
the system?  This is also used to help gauge performance, so this method
of inserting data is important to the process as a whole.

Regards,

Thomas.

Thread
Speed of Inserts into MyIsam tables from mysqlbinlogThomas Lekai4 Mar
  • Re: Speed of Inserts into MyIsam tables from mysqlbinlogEric Bergen4 Mar