MySQL Forums
Forum List  »  Newbie

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




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.