Re: Very slow INSERT queries through C/C++ MySQL API
Posted by:
Rick James
Date: August 07, 2011 11:37PM
Plan A:
innodb_flush_log_at_trx_commit = 2
Plan B:
BEGIN;
do all the INSERTs
COMMIT;
Plan C:
create a file with all the data, then use LOAD DATA.
This belongs in the InnoDB forum or the Performance forum, it has nothing to do with C++.
Subject
Views
Written By
Posted
3522
June 08, 2011 10:51AM
Re: Very slow INSERT queries through C/C++ MySQL API
1804
August 07, 2011 11:37PM
1394
August 08, 2011 12:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.