MySQL Forums
Forum List  »  Quality Assurance

large number of insert with autocommit set to off
Posted by: Hans-Peter Sloot
Date: April 03, 2012 06:25AM


This is about Server version: 5.1.52 on OEL6.

As an Oracle dba I am looking at mysql to expand my skills.
I want to move the sample schemas for Oracle to mysql.
To do this I have created a partitioned table in my sql for table SALES of the SH schema. After this I execute a script that does about 900K inserts with autocommet set to off.
After I commit I expect the rows to be visible to other sessions.
But that is not the case. Only when I restart mysqld I see the new rows in other sessions.

Am I doing something wrong or can mysql not handle such an amount of rows?
Any advice would be appreciated.

regards Hans-Peter

Options: ReplyQuote

Written By
large number of insert with autocommit set to off
April 03, 2012 06:25AM

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.