large number of insert with autocommit set to off
Hi,
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
Subject
Views
Written By
Posted
large number of insert with autocommit set to off
2027
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.