There appears to be an undocumented change from 3.23.49 to 3.23.51, possibly for the worse.
Consider two sessions executing the following sequence of commands on an innodb table (assume maximum ACID properties): session 1> begin; session 1> update table set field = field + 1 where primary_key = 1; session 2> select * from table where primary_key = 1; In version 3.23.49, session 2 returns a row relatively quickly. In version 3.23.51, session 2 blocks. The 3.23.49 behavior is reasonable -- the 2nd session is not required to block because the database is allowed to choose an ordering of transactions when transactions are concurrent and it is reasonable to choose the order where session 2 completes before session 1. So, it appears that version 3.23.51 has different behavior and I don't see this documented in the list of changes. And it could be argued that the 3.23.49 behavior was better. [fyi... one other undocumented change would be the change to the client libraries so that when an application tries to parse a group out of a configuration file, there won't be a core dump. I think this was a bug fix to libmysql.c, adding a '*' to the statement 'for (end= *option ; *(end= strcend(end,'_')) ; )'.] chuck --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php