Re: why delete will block by select?
Posted by:
h h
Date: December 17, 2014 09:29PM
mysql> show create table phoenix_adspace_execution_byhour_oftime\G
*************************** 1. row ***************************
Table: phoenix_adspace_execution_byhour_oftime
Create Table: CREATE TABLE "phoenix_adspace_execution_byhour_oftime" (
"id" bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'xxx',
"adspaceId" bigint(20) DEFAULT NULL COMMENT 'xxx',
"createdTime" datetime DEFAULT NULL COMMENT 'xxx',
"clickCount" bigint(20) DEFAULT NULL COMMENT 'xxx',
"execCount" bigint(20) DEFAULT NULL COMMENT 'xxx',
"requestCount" bigint(20) DEFAULT NULL COMMENT 'xxx',
"highTransPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"lowTransPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxxx',
"transMoney" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"highFloorPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"lowFloorPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"floorMoney" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"highBidPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"lowBidPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"bidMoney" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"bidCount" bigint(20) DEFAULT NULL COMMENT 'xxx',
"clientId" varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'xxx',
PRIMARY KEY ("id")
) ENGINE=InnoDB AUTO_INCREMENT=255735 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMM ENT='xxx'
1 row in set (0.00 sec)
createdTime condition is not good