mysql tables in use 500, locked 500
Hi All,
Run show innodb engine innodb ,i get information like below,
#######
MySQL thread id 7536470, query id 920936578 192.168.16.31 meizu_fm
---TRANSACTION 86C1D54B, ACTIVE (PREPARED) 0 sec, process no 10008, OS thread id 139646591694592 preparing
mysql tables in use 500, locked 500
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 7537288, query id 920945293 192.168.16.27 meizu_fm query end
UPDATE T_CALL_LAST_SYNC SET FSTATUS = 'P',FLAST_ANCHOR_SERVER = 1373354687446,FLAST_ANCHOR_CLIENT = '1373354830008' ,FEND_SYNC_TIME = 1373354687446 WHERE FUSERID=4895693 and FDEVICE='868033018722399'
---TRANSACTION 86C1D547, ACTIVE (PREPARED) 0 sec, process no 10008, OS thread id 139711110760192 preparing
#table schema,T_CALL_LAST_SYNC table is a partitioned table with 500 partitions.
PRIMARY KEY (`FUSERID`,`FDEVICE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 ROW_FORMAT=DYNAMIC
/*!50100 PARTITION BY KEY (FUSERID)
PARTITIONS 500 */
My question is:
1)The update query should use Parmary Key and just one partition will be used,why all partitions clocked?
2)what is "mysql tables in use 500, locked 500" mean?