Re: why delete will block by select?
Posted by:
h h
Date: December 16, 2014 09:37PM
mysql> show create table phoenix_adspace_execution_byhour_ofregion\G
*************************** 1. row ***************************
Table: phoenix_adspace_execution_byhour_ofregion
Create Table: CREATE TABLE "phoenix_adspace_execution_byhour_ofregion" (
"id" bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'xx',
"clickCount" bigint(20) DEFAULT NULL COMMENT 'xx',
"execCount" bigint(20) DEFAULT NULL COMMENT 'xx',
"requestCount" bigint(20) DEFAULT NULL COMMENT 'xx',
"highTransPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"lowTransPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxx',
"transMoney" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"highFloorPrice" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"lowFloorPrice" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"floorMoney" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"highBidPrice" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"lowBidPrice" decimal(12,4) DEFAULT NULL COMMENT 'xxxx',
"bidMoney" decimal(12,4) DEFAULT NULL COMMENT 'xx',
"regionCode" varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
"adspace_time_id" bigint(20) DEFAULT NULL COMMENT 'xx',
"bidCount" bigint(20) DEFAULT NULL COMMENT 'xx',
PRIMARY KEY ("id"),
KEY "fk_phoenix_byhour_ofregion__adspace_time_id" ("adspace_time_id"),
CONSTRAINT "fk_phoenix_byhour_ofregion__adspace_time_id" FOREIGN KEY ("adspace _time_id") REFERENCES "phoenix_adspace_execution_byhour_oftime" ("id")
) ENGINE=InnoDB AUTO_INCREMENT=3643754 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COM MENT='xx'
1 row in set (0.00 sec)