#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.dimov | 5 Oct |