title: Laravel DB::beginTransaction causing other transaction locked
body: <p>In classic php I have 2 process files</p>
  
  <p>1) <code>process1.php</code>  => To lock row for .table InnodB.</p>
  
  <p>2) <code>process2.php</code> => To read another row from the same table</p>
  
  <p>I have played with <code>START TRANSACTION AND COMMIT</code> in PHP/MySQL and it is working properly as what I want.
  What I want is the <code>process2.php</code> can select another record eventhough the <code>process1.php</code> is still running and locking some row.</p>
  
  <p>Unfortunately it does not work in Laravel where my other process was locked until the first process completed eventhough the second process is selecting another table.</p>
  
  <p>Please help me to figure out this issue.</p>
  
  <pre><code>DB::beginTransaction();
  $rs = DB::table('test_iap')-&gt;where('content', 'waiting')-&gt;lockForUpdate()-&gt;get();
  
  $sql = "update test_iap set content='Updated' where id=1";
  DB::connection('mysql_pencil_main')-&gt;update(DB::raw($sql));
  sleep(10);# To allow testing at different file process
  
  DB::commit();
  </code></pre>