Re: New records not visible to client - 3rd posting!

[Mark Matthews]

Martin Woolley wrote:
> Also.... if I insert a new record using the MySQL
> command line SQL processor it also is not visible
> to App B so I think we can elliminate App A from
> this.


Martin,

If you're running on Windows, most likely InnoDB is your default table type. This means you're running with REPEATABLE_READ as your isolation level. If this is the case, the behavior you speak of is what's expected. The application that's "looking" for new data needs to commit or rollback the connection to get a new "snapshot" of the data. Otherwise it will be looking at its "stable snapshot", which means it will only see data as it was before the transaction started.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html