Skip navigation links

MySQL Forums :: Newbie :: large number of insert with autocommit set to off


Advanced Search

Re: large number of insert with autocommit set to ff
Posted by: Rick James ()
Date: April 04, 2012 09:59PM

900K or 900M -- no problem.
> After I commit I expect the rows to be visible to other sessions.
They should have been visible.
Something else must be the issue. Please provide the specific SQL.

Did the table really get populated? Run
SHOW TABLE STATUS LIKE 'tablename';

Are the PARTITIONs populated?
SELECT * FROM information_schema WHERE TABLE_SCHEMA = 'tablename';

Inserting 900K rows in a single transaction stresses the engine more than committing it piecemeal. (But as a DBA, you probably realize that.) I have very little experience with the performance diff, but I think it is about 2x.

Also provide this so we can understand more:
SHOW CREATE TABLE tablename;

Options: ReplyQuote


Subject Written By Posted
large number of insert with autocommit set to off Hans-Peter Sloot 04/03/2012 05:57AM
Re: large number of insert with autocommit set to ff Rick James 04/04/2012 09:59PM
Re: large number of insert with autocommit set to off Hans-Peter Sloot 04/05/2012 04:50AM
Re: large number of insert with autocommit set to off Hans-Peter Sloot 04/05/2012 05:19AM
Re: large number of insert with autocommit set to off Rick James 04/06/2012 09:10PM
Re: large number of insert with autocommit set to off Hans-Peter Sloot 04/10/2012 12:38AM


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.