List:Commits« Previous MessageNext Message »
From:vasil.dimov Date:October 5 2010 10:07am
Subject:bzr commit into mysql-next-mr-persistent-stats branch (vasil.dimov:3300)
View as plain text  
#At file:///usr/local/devel/bzrroot/server/mysql-next-mr-persistent-stats/ based on revid:vasil.dimov@stripped

 3300 Vasil Dimov	2010-10-05
      Explain why we use 'read-uncommitted', there is a reason for it.

    modified:
      storage/innobase/dict/dict0stats.c
=== modified file 'storage/innobase/dict/dict0stats.c'
--- a/storage/innobase/dict/dict0stats.c	revid:vasil.dimov@stripped
+++ b/storage/innobase/dict/dict0stats.c	revid:vasil.dimov@stripped
@@ -2014,6 +2014,9 @@ dict_stats_fetch_from_ps(
 	mutex_exit(&kernel_mutex);
 
 	trx->op_info = "";
+	/* Use 'read-uncommitted' so that the SELECTs we execute
+	do not get blocked in case some user has locked the rows we
+	are SELECTing */
 	trx->isolation_level = TRX_ISO_READ_UNCOMMITTED;
 	trx_start(trx, ULINT_UNDEFINED);
 


Attachment: [text/bzr-bundle] bzr/vasil.dimov@oracle.com-20101005100639-m1fiqtfaw8ll6exk.bundle
Thread
bzr commit into mysql-next-mr-persistent-stats branch (vasil.dimov:3300) vasil.dimov5 Oct