MySQL Forums
Forum List  »  Partitioning

mysql tables in use 500, locked 500
Posted by: bruce.zuo bruce
Date: July 16, 2013 03:14AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql tables in use 500, locked 500
2999
July 16, 2013 03:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.