Search code examples
javamysqlpercona

Network application


I'm developing a network application, which will handle a lot of transactions, so I'm using INNODB as storage engine & Transactions, so do I need to use a LockTable also?

As I know they don't work together. Please give me the best solution to do it.


Solution

  • Not sure why you are asking about table locking with respect to InnoDB, as it supports row-level locking. I would just focus on making sure your transactions are written correctly and let MySQL take care of the rest.