Re: Partition table not support foreign key feature ?
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.