- 论坛徽章:
- 0
|
本帖最后由 kingwkb 于 2010-07-31 13:58 编辑
数据量很小可能是什么问题导致的?
# Query_time: 0.251454 Lock_time: 0.000037 Rows_sent: 0 Rows_examined: 0
SET timestamp=1280555233;
update online set lastupdate = 1280555232,UID = 0 where SID = 'xxxxxxx' and BID = xxxxx;
表结构
CREATE TABLE IF NOT EXISTS `online` (
`SID` varchar(32) NOT NULL COMMENT '',
`BID` mediumint(8 ) unsigned NOT NULL COMMENT '',
`UID` mediumint(8 ) unsigned NOT NULL COMMENT '',
`lastupdate` int(10) unsigned NOT NULL COMMENT '',
PRIMARY KEY (`SID`,`BID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|