DB::beginTransaction();
DB::table('mj_user')->where('id', $user->id)->decrement('charge', $amount);
DB::table('mj_user')->where('id', $user->id)->decrement('balance', $amount);
//.....
DB::commit();
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX \ G;
果然有两个在死锁
SELECT `trx_mysql_thread_id` FROM INFORMATION_SCHEMA.INNODB_TRX;
kill pid
show OPEN TABLES where In_use > 0;
show processlist
kill id
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
kill 线程ID
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;