Record not Visible to other sessions even after commit
Posted by: Kamal
Date: October 16, 2006 03:34AM

Hi,
I am Oracle and MS SQL DBA. I am new to MYSQL 5.0. I have setup an instance and created a database in MYSQL. While i was testing, i created a table and inserted a row, committed. This record is not visible to other session which is already connected. But i can see if i open a new connection. I suppose this seems to be some refereshment issue. Buffer pool is 750MB. There is no activity started yet. Is there anything related to parameter setting in my.cnf?

Thanks in advance.

Thanks
Kam.

Options: ReplyQuote


Subject
Written By
Posted
Record not Visible to other sessions even after commit
October 16, 2006 03:34AM


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.