MySQL数据库InnoDB引擎优化问题

Question

 CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `balance` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;

update user set balance = balance - 1     where id = ?

上边表结构，下边语句。当同一个id高并发访问的时候会锁住。我应该怎么优化？

Answer 1

https://www.cnblogs.com/kevingrace/p/6133818.html