MySQL Forums
Forum List  »  Partitioning

Re: Partition table not support foreign key feature ?
Posted by: Mayur P Vegad
Date: July 02, 2010 05:05AM

hi

CREATE TABLE "rp_doc" (
"doc_id" int(11) NOT NULL DEFAULT '0',
"parent_document_id" int(11) DEFAULT NULL,
"child_document_count" int(11) NOT NULL,
"file_extension" varchar(255) DEFAULT NULL,
"file_icon" varchar(255) DEFAULT NULL,
"ezr_document_type" varchar(255) NOT NULL,
"fo_id" int(11) NOT NULL,
"ba_id" smallint(6) NOT NULL,
"native_physical_path" text NOT NULL,
"native_page_count" int(11) DEFAULT NULL,
"native_file_size" bigint(20) DEFAULT NULL,
"native_is_download_only" tinyint(1) DEFAULT NULL,
"native_is_compressed" tinyint(1) DEFAULT NULL,
"text_physical_path" text NOT NULL,
"text_file_size" bigint(20) DEFAULT NULL,
"text_is_download_only" tinyint(1) DEFAULT NULL,
"text_is_compressed" tinyint(1) DEFAULT NULL,
"hidden_property" smallint(6) NOT NULL,
"has_translated" tinyint(1) NOT NULL,
"has_exact_duplicate" tinyint(1) NOT NULL,
"has_near_duplicate" tinyint(1) NOT NULL,
"is_reviewed" tinyint(1) NOT NULL,
"is_annotated" tinyint(1) NOT NULL,
"is_produced" tinyint(1) NOT NULL,
"load_date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"pa_id" varchar(100) DEFAULT NULL,
"ex_id" varchar(100) DEFAULT NULL,
PRIMARY KEY ("doc_id"),
KEY "FK_rp_doc_rep_basedirectory" ("bas_id"),
KEY "FK_rp_doc_folder" ("fo_id"),
KEY "FK_rp_doc_rp_doc" ("pa_id"),
KEY "idx_extdoc_id" ("paid"),
KEY "idx_ext_id" ("exid"),
KEY "idx_rep_doc_textphyspath" ("te_pa"(200)),
KEY "Idx_rep_doc_folder_id" ("fo_id"),
KEY "document_id" ("doc_id","pa_id"),
KEY "idx_nativefilsz" ("nae"),
KEY "Idx_textfile_size" ("te"),
CONSTRAINT "FK_rp_doc_rep_basedirectory" FOREIGN KEY ("ba_id") REFERENCES "rep_bd" ("rep_bd_id"),
CONSTRAINT "FK_rp_doc_rp_doc" FOREIGN KEY ("pa_id") REFERENCES "rp_doc" ("do_id"),
CONSTRAINT "FK_rp_doc_folder" FOREIGN KEY ("fo_id") REFERENCES "re" ("f_id")
)



i want to create partition on pk column , range wise partition but there is no fk support, and after how many record set we need to implement partition ; like in this table i have 15 lakhs record ; and will grow around 50 to 70 lacks record. so when i need to implement partition in table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition table not support foreign key feature ?
2182
July 02, 2010 05:05AM


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.