I use MySQL 5.0.15
I have about 5 billion rows in table X, i create another table Y with
the same stucture with X
CREATE TABLE Y LIKE X;
Both X and Y is the InnoDB table, since i believe that both work on the
"row locking" models
I try to initiate 2 session
First session try to INSERT all of data from X to Y like this
INSERT INTO Y SELECT * FROM X;
After a while (i need a long time to finish this Query), i start my
second session and try
to insert a data into Y
What happened later make me confuse, because
INSERT INTO Y VALUES (something) is just hang on, seems waiting another
operation to be finished
Why concurrent insert is not working?
FYI, i use standar configuration from MySQL
Any explanation?
Thx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
