MySQL Forums
Forum List  »  InnoDB

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
2288
h h
December 15, 2014 07:53PM
1142
December 16, 2014 04:32PM
Re: why delete will block by select?
1168
h h
December 16, 2014 09:37PM
1005
December 17, 2014 06:38PM
1023
h h
December 17, 2014 09:29PM


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.