Record a MYSQL deadlock troubleshooting

The project reported a deadlock exception org.apache.ibatis.exceptions.PersistenceException: ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: com.baturu.wms.business.outbound.dao.OutboundNoticeHeaderDao.updateById (batch index #1) failed. Cause: java.sql.BatchUpdateException: Deadlock found when trying t ...

Posted on Fri, 12 Nov 2021 06:48:31 -0500 by pakenney38

MySQL database - storage engine (MyISAM and InnoDB)

preface Database storage engine is the underlying software organization of database. Database management system (DBMS) uses data engine to create, query, update and delete data. Different storage engines provide different storage mechanisms, indexing skills, locking levels and other functions. Using different storage engines, you can als ...

Posted on Mon, 25 Oct 2021 04:00:34 -0400 by Foser