具体情况
引擎 innodb长查询日志# Query_time: 2.582698 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 1
16871 SET timestamp=1509850570;
16872 update `u_user` set `bonus_stone` = 19 , `bonus_point` = 371 where `id` = 7609;# Query_time: 2.016371 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 1
16876 SET timestamp=1509850585;
16877 update `u_user` set `bonus_stone` = 20 , `bonus_point` = 391 where `id` = 7609;业务,用户在答题的时候会频发更新用户表的经验和石头数量。
用户表一定时期会有很多update的操作业务处理的逻辑是
先用id查询出某一条数据,再根据主键更新
引擎 innodb长查询日志# Query_time: 2.582698 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 1
16871 SET timestamp=1509850570;
16872 update `u_user` set `bonus_stone` = 19 , `bonus_point` = 371 where `id` = 7609;# Query_time: 2.016371 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 1
16876 SET timestamp=1509850585;
16877 update `u_user` set `bonus_stone` = 20 , `bonus_point` = 391 where `id` = 7609;业务,用户在答题的时候会频发更新用户表的经验和石头数量。
用户表一定时期会有很多update的操作业务处理的逻辑是
先用id查询出某一条数据,再根据主键更新
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货