{"id":4584,"date":"2024-02-21T12:11:03","date_gmt":"2024-02-21T03:11:03","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=4584"},"modified":"2024-02-14T15:19:40","modified_gmt":"2024-02-14T06:19:40","slug":"post-4584","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/4584","title":{"rendered":"MySQL\u3067\u7279\u5b9a\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u3057\u9ad8\u901f\u5316\u3092\u56f3\u308b\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"https:\/\/taitan916.info\/blog\/archives\/3076#i-2\" target=\"_blank\" rel=\"noopener\">\u4ee5\u524d\u306b\u4ed6\u793e\u304c\u8a2d\u8a08\u3055\u308c\u305f\u30ed\u30b0\u7cfb\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u62dd\u898b\u3057\u305f\u969b\u306b\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a<\/a>\u304c\u884c\u308f\u308c\u3066\u3044\u305f\u3002\u305d\u306e\u6642\u306f\u305d\u306e\u307e\u307e\u30b9\u30eb\u30fc\u3057\u305f\u3093\u3060\u3051\u3069\u3001\u305b\u3063\u304b\u304f\u306a\u3089\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u3092\u884c\u3048\u308b\u3088\u3046\u77e5\u8b58\u306f\u6301\u3063\u3066\u304a\u304d\u305f\u3044\u3002<a href=\"https:\/\/taitan916.info\/blog\/archives\/3277\" target=\"_blank\" rel=\"noopener\">\u4ee5\u524d\u306b\u53d6\u5f97\u3057\u305f\u5e02\u533a\u753a\u6751\u30c7\u30fc\u30bf<\/a>\u304c\u7d0415\u4e07\u884c\u3068\u305d\u3053\u305d\u3053\u306a\u30c7\u30fc\u30bf\u6570\u306a\u306e\u3067\u3053\u308c\u3067\u8a66\u3057\u3066\u307f\u305f\u3044\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u306e\u30e1\u30e2\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/h2>\n<p><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/ja\/partitioning-overview.html\" target=\"_blank\" rel=\"noopener\">https:\/\/dev.mysql.com\/doc\/refman\/8.0\/ja\/partitioning-overview.html<\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>\u30c6\u30fc\u30d6\u30eb\u69cb\u9020<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">mysql&gt; SHOW COLUMNS FROM `ad_address`;\r\n+----------------+--------------+------+-----+---------+-------+\r\n| Field          | Type         | Null | Key | Default | Extra |\r\n+----------------+--------------+------+-----+---------+-------+\r\n| id             | int          | NO   | PRI | 0       |       |\r\n| ken_id         | int          | YES  |     | NULL    |       |\r\n| city_id        | int          | YES  |     | NULL    |       |\r\n| town_id        | int          | YES  |     | NULL    |       |\r\n| zip            | varchar(8)   | YES  |     | NULL    |       |\r\n| office_flg     | tinyint(1)   | YES  |     | NULL    |       |\r\n| delete_flg     | tinyint(1)   | YES  |     | NULL    |       |\r\n| ken_name       | varchar(8)   | YES  |     | NULL    |       |\r\n| ken_furi       | varchar(8)   | YES  |     | NULL    |       |\r\n| city_name      | varchar(24)  | YES  |     | NULL    |       |\r\n| city_furi      | varchar(24)  | YES  |     | NULL    |       |\r\n| town_name      | varchar(32)  | YES  |     | NULL    |       |\r\n| town_furi      | varchar(32)  | YES  |     | NULL    |       |\r\n| town_memo      | varchar(16)  | YES  |     | NULL    |       |\r\n| kyoto_street   | varchar(32)  | YES  |     | NULL    |       |\r\n| block_name     | varchar(64)  | YES  |     | NULL    |       |\r\n| block_furi     | varchar(64)  | YES  |     | NULL    |       |\r\n| memo           | varchar(255) | YES  |     | NULL    |       |\r\n| office_name    | varchar(255) | YES  |     | NULL    |       |\r\n| office_furi    | varchar(255) | YES  |     | NULL    |       |\r\n| office_address | varchar(255) | YES  |     | NULL    |       |\r\n| new_id         | int          | YES  |     | NULL    |       |\r\n+----------------+--------------+------+-----+---------+-------+<\/pre>\n<p>\u30c6\u30fc\u30d6\u30eb\u5185\u5bb9\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/taitan916.info\/blog\/archives\/3277\" target=\"_blank\" rel=\"noopener\">\u904e\u53bb\u8a18\u4e8b\u53c2\u7167<\/a>\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a<\/h2>\n<h3>\u4e8b\u524d\u6e96\u5099<\/h3>\n<p>\u30c6\u30fc\u30d6\u30eb\u3068\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304f\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">CREATE TABLE `ad_address_pt` LIKE `ad_address`;\r\nINSERT INTO `ad_address_pt` SELECT * FROM `ad_address`;<\/pre>\n<p>\u307e\u305fadminer\u3088\u308a\u4ee5\u4e0b\u5909\u66f4\u3092\u884c\u3063\u305f\u3002\u7406\u7531\u306b\u3064\u3044\u3066\u306f\u5f8c\u8ff0\u3059\u308b\u3002<\/p>\n<ul>\n<li>\u30b9\u30c8\u30ec\u30fc\u30b8\u30a8\u30f3\u30b8\u30f3\u3092MyISAM\u304b\u3089InnoDB\u306b\u5909\u66f4<\/li>\n<li>\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092id\u304b\u3089id,ken_id\u306e\u8907\u5408\u306b\u5909\u66f4<\/li>\n<\/ul>\n<h3>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8ffd\u52a0<\/h3>\n<p>ad_address_pt\u30c6\u30fc\u30d6\u30eb\u306b\u4ee5\u4e0b\u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u3092\u8ffd\u52a0\u3057\u305f\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">ALTER TABLE `ad_address_pt` PARTITION BY RANGE (`ken_id`) (\r\n    PARTITION ken_id_1 VALUES LESS THAN (1) ENGINE = InnoDB,\r\n    PARTITION ken_id_2 VALUES LESS THAN (2) ENGINE = InnoDB,\r\n    PARTITION ken_id_3 VALUES LESS THAN (3) ENGINE = InnoDB,\r\n    PARTITION ken_id_4 VALUES LESS THAN (4) ENGINE = InnoDB,\r\n    PARTITION ken_id_5 VALUES LESS THAN (5) ENGINE = InnoDB,\r\n    PARTITION ken_id_6 VALUES LESS THAN (6) ENGINE = InnoDB,\r\n    PARTITION ken_id_7 VALUES LESS THAN (7) ENGINE = InnoDB,\r\n    PARTITION ken_id_8 VALUES LESS THAN (8) ENGINE = InnoDB,\r\n    PARTITION ken_id_9 VALUES LESS THAN (9) ENGINE = InnoDB,\r\n    PARTITION ken_id_10 VALUES LESS THAN (10) ENGINE = InnoDB,\r\n    PARTITION ken_id_11 VALUES LESS THAN (11) ENGINE = InnoDB,\r\n    PARTITION ken_id_12 VALUES LESS THAN (12) ENGINE = InnoDB,\r\n    PARTITION ken_id_13 VALUES LESS THAN (13) ENGINE = InnoDB,\r\n    PARTITION ken_id_14 VALUES LESS THAN (14) ENGINE = InnoDB,\r\n    PARTITION ken_id_15 VALUES LESS THAN (15) ENGINE = InnoDB,\r\n    PARTITION ken_id_16 VALUES LESS THAN (16) ENGINE = InnoDB,\r\n    PARTITION ken_id_17 VALUES LESS THAN (17) ENGINE = InnoDB,\r\n    PARTITION ken_id_18 VALUES LESS THAN (18) ENGINE = InnoDB,\r\n    PARTITION ken_id_19 VALUES LESS THAN (19) ENGINE = InnoDB,\r\n    PARTITION ken_id_20 VALUES LESS THAN (20) ENGINE = InnoDB,\r\n    PARTITION ken_id_21 VALUES LESS THAN (21) ENGINE = InnoDB,\r\n    PARTITION ken_id_22 VALUES LESS THAN (22) ENGINE = InnoDB,\r\n    PARTITION ken_id_23 VALUES LESS THAN (23) ENGINE = InnoDB,\r\n    PARTITION ken_id_24 VALUES LESS THAN (24) ENGINE = InnoDB,\r\n    PARTITION ken_id_25 VALUES LESS THAN (25) ENGINE = InnoDB,\r\n    PARTITION ken_id_26 VALUES LESS THAN (26) ENGINE = InnoDB,\r\n    PARTITION ken_id_27 VALUES LESS THAN (27) ENGINE = InnoDB,\r\n    PARTITION ken_id_28 VALUES LESS THAN (28) ENGINE = InnoDB,\r\n    PARTITION ken_id_29 VALUES LESS THAN (29) ENGINE = InnoDB,\r\n    PARTITION ken_id_30 VALUES LESS THAN (30) ENGINE = InnoDB,\r\n    PARTITION ken_id_31 VALUES LESS THAN (31) ENGINE = InnoDB,\r\n    PARTITION ken_id_32 VALUES LESS THAN (32) ENGINE = InnoDB,\r\n    PARTITION ken_id_33 VALUES LESS THAN (33) ENGINE = InnoDB,\r\n    PARTITION ken_id_34 VALUES LESS THAN (34) ENGINE = InnoDB,\r\n    PARTITION ken_id_35 VALUES LESS THAN (35) ENGINE = InnoDB,\r\n    PARTITION ken_id_36 VALUES LESS THAN (36) ENGINE = InnoDB,\r\n    PARTITION ken_id_37 VALUES LESS THAN (37) ENGINE = InnoDB,\r\n    PARTITION ken_id_38 VALUES LESS THAN (38) ENGINE = InnoDB,\r\n    PARTITION ken_id_39 VALUES LESS THAN (39) ENGINE = InnoDB,\r\n    PARTITION ken_id_40 VALUES LESS THAN (40) ENGINE = InnoDB,\r\n    PARTITION ken_id_41 VALUES LESS THAN (41) ENGINE = InnoDB,\r\n    PARTITION ken_id_42 VALUES LESS THAN (42) ENGINE = InnoDB,\r\n    PARTITION ken_id_43 VALUES LESS THAN (43) ENGINE = InnoDB,\r\n    PARTITION ken_id_44 VALUES LESS THAN (44) ENGINE = InnoDB,\r\n    PARTITION ken_id_45 VALUES LESS THAN (45) ENGINE = InnoDB,\r\n    PARTITION ken_id_46 VALUES LESS THAN (46) ENGINE = InnoDB,\r\n    PARTITION ken_id_47 VALUES LESS THAN (47) ENGINE = InnoDB,\r\n    PARTITION pmax VALUES LESS THAN MAXVALUE\r\n);<\/pre>\n<h3>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u78ba\u8a8d<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">SHOW CREATE TABLE `ad_address_pt`;\r\n| ad_address_pt | CREATE TABLE `ad_address_pt` (\r\n  `id` int NOT NULL DEFAULT '0',\r\n  `ken_id` int NOT NULL,\r\n  `city_id` int DEFAULT NULL,\r\n  `town_id` int DEFAULT NULL,\r\n  `zip` varchar(8) DEFAULT NULL,\r\n  `office_flg` tinyint(1) DEFAULT NULL,\r\n  `delete_flg` tinyint(1) DEFAULT NULL,\r\n  `ken_name` varchar(8) DEFAULT NULL,\r\n  `ken_furi` varchar(8) DEFAULT NULL,\r\n  `city_name` varchar(24) DEFAULT NULL,\r\n  `city_furi` varchar(24) DEFAULT NULL,\r\n  `town_name` varchar(32) DEFAULT NULL,\r\n  `town_furi` varchar(32) DEFAULT NULL,\r\n  `town_memo` varchar(16) DEFAULT NULL,\r\n  `kyoto_street` varchar(32) DEFAULT NULL,\r\n  `block_name` varchar(64) DEFAULT NULL,\r\n  `block_furi` varchar(64) DEFAULT NULL,\r\n  `memo` varchar(255) DEFAULT NULL,\r\n  `office_name` varchar(255) DEFAULT NULL,\r\n  `office_furi` varchar(255) DEFAULT NULL,\r\n  `office_address` varchar(255) DEFAULT NULL,\r\n  `new_id` int DEFAULT NULL,\r\n  PRIMARY KEY (`id`,`ken_id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3\r\n\/*!50100 PARTITION BY RANGE (`ken_id`)\r\n(PARTITION ken_id_1 VALUES LESS THAN (1) ENGINE = InnoDB,\r\n PARTITION ken_id_2 VALUES LESS THAN (2) ENGINE = InnoDB,\r\n PARTITION ken_id_3 VALUES LESS THAN (3) ENGINE = InnoDB,\r\n PARTITION ken_id_4 VALUES LESS THAN (4) ENGINE = InnoDB,\r\n PARTITION ken_id_5 VALUES LESS THAN (5) ENGINE = InnoDB,\r\n PARTITION ken_id_6 VALUES LESS THAN (6) ENGINE = InnoDB,\r\n PARTITION ken_id_7 VALUES LESS THAN (7) ENGINE = InnoDB,\r\n PARTITION ken_id_8 VALUES LESS THAN (8) ENGINE = InnoDB,\r\n PARTITION ken_id_9 VALUES LESS THAN (9) ENGINE = InnoDB,\r\n PARTITION ken_id_10 VALUES LESS THAN (10) ENGINE = InnoDB,\r\n PARTITION ken_id_11 VALUES LESS THAN (11) ENGINE = InnoDB,\r\n PARTITION ken_id_12 VALUES LESS THAN (12) ENGINE = InnoDB,\r\n PARTITION ken_id_13 VALUES LESS THAN (13) ENGINE = InnoDB,\r\n PARTITION ken_id_14 VALUES LESS THAN (14) ENGINE = InnoDB,\r\n PARTITION ken_id_15 VALUES LESS THAN (15) ENGINE = InnoDB,\r\n PARTITION ken_id_16 VALUES LESS THAN (16) ENGINE = InnoDB,\r\n PARTITION ken_id_17 VALUES LESS THAN (17) ENGINE = InnoDB,\r\n PARTITION ken_id_18 VALUES LESS THAN (18) ENGINE = InnoDB,\r\n PARTITION ken_id_19 VALUES LESS THAN (19) ENGINE = InnoDB,\r\n PARTITION ken_id_20 VALUES LESS THAN (20) ENGINE = InnoDB,\r\n PARTITION ken_id_21 VALUES LESS THAN (21) ENGINE = InnoDB,\r\n PARTITION ken_id_22 VALUES LESS THAN (22) ENGINE = InnoDB,\r\n PARTITION ken_id_23 VALUES LESS THAN (23) ENGINE = InnoDB,\r\n PARTITION ken_id_24 VALUES LESS THAN (24) ENGINE = InnoDB,\r\n PARTITION ken_id_25 VALUES LESS THAN (25) ENGINE = InnoDB,\r\n PARTITION ken_id_26 VALUES LESS THAN (26) ENGINE = InnoDB,\r\n PARTITION ken_id_27 VALUES LESS THAN (27) ENGINE = InnoDB,\r\n PARTITION ken_id_28 VALUES LESS THAN (28) ENGINE = InnoDB,\r\n PARTITION ken_id_29 VALUES LESS THAN (29) ENGINE = InnoDB,\r\n PARTITION ken_id_30 VALUES LESS THAN (30) ENGINE = InnoDB,\r\n PARTITION ken_id_31 VALUES LESS THAN (31) ENGINE = InnoDB,\r\n PARTITION ken_id_32 VALUES LESS THAN (32) ENGINE = InnoDB,\r\n PARTITION ken_id_33 VALUES LESS THAN (33) ENGINE = InnoDB,\r\n PARTITION ken_id_34 VALUES LESS THAN (34) ENGINE = InnoDB,\r\n PARTITION ken_id_35 VALUES LESS THAN (35) ENGINE = InnoDB,\r\n PARTITION ken_id_36 VALUES LESS THAN (36) ENGINE = InnoDB,\r\n PARTITION ken_id_37 VALUES LESS THAN (37) ENGINE = InnoDB,\r\n PARTITION ken_id_38 VALUES LESS THAN (38) ENGINE = InnoDB,\r\n PARTITION ken_id_39 VALUES LESS THAN (39) ENGINE = InnoDB,\r\n PARTITION ken_id_40 VALUES LESS THAN (40) ENGINE = InnoDB,\r\n PARTITION ken_id_41 VALUES LESS THAN (41) ENGINE = InnoDB,\r\n PARTITION ken_id_42 VALUES LESS THAN (42) ENGINE = InnoDB,\r\n PARTITION ken_id_43 VALUES LESS THAN (43) ENGINE = InnoDB,\r\n PARTITION ken_id_44 VALUES LESS THAN (44) ENGINE = InnoDB,\r\n PARTITION ken_id_45 VALUES LESS THAN (45) ENGINE = InnoDB,\r\n PARTITION ken_id_46 VALUES LESS THAN (46) ENGINE = InnoDB,\r\n PARTITION ken_id_47 VALUES LESS THAN (47) ENGINE = InnoDB,\r\n PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) *\/ |<\/pre>\n<h3>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u524a\u9664<\/h3>\n<p>\u4ee5\u4e0b\u3067\u524a\u9664\u3067\u304d\u308b\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">ALTER TABLE `ad_address_pt` DROP PARTITION ken_id_1;<\/pre>\n<p>\u5c1a\u3001<strong>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u304c\u524a\u9664\u3055\u308c\u308b\u3068\u5171\u306b\u7bc4\u56f2\u5185\u306e\u30c7\u30fc\u30bf\u3082\u524a\u9664\u3055\u308c\u308b\u70b9<\/strong>\u306b\u6ce8\u610f\u3002\u4f8b\u3048\u3070\u3060\u3051\u3069\u4eca\u56de\u4f7f\u3063\u305f\u30c6\u30fc\u30d6\u30eb\u306b\u306fken_id=1\u304c\u5317\u6d77\u9053\u306e\u5e02\u533a\u753a\u6751\u30c7\u30fc\u30bf\u304c\u5165\u3063\u3066\u304a\u308a\u3001\u4e0a\u8a18SQL\u6587\u3092\u5b9f\u884c\u3059\u308b\u3068\u5317\u6d77\u9053\u306e\u30c7\u30fc\u30bf\u3082\u524a\u9664\u3055\u308c\u308b\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u901f\u5ea6\u78ba\u8a8d<\/h2>\n<h3>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u3057\u3066\u3044\u306a\u3044\u30c6\u30fc\u30d6\u30eb<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">mysql&gt; SELECT count(*) FROM `ad_address` WHERE `ken_id` = 1;\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|    10302 |\r\n+----------+\r\n1 row in set (1.12 sec)<\/pre>\n<h3>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">mysql&gt; SELECT count(*) FROM `ad_address_pt` WHERE `ken_id` = 1;\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|    10302 |\r\n+----------+\r\n1 row in set (0.00 sec)<\/pre>\n<p>\u5927\u5e45\u306a\u5dee\u304c\u51fa\u305f\u3002\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\u3084SQL\u6587\u306b\u3088\u3063\u3066\u306f\u304b\u306a\u308a\u4f7f\u3048\u305d\u3046\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30a8\u30e9\u30fc\u95a2\u9023<\/h2>\n<h3>The mix of handlers in the partitions is not allowed in this version of MySQL<\/h3>\n<p>MyISAM\u306e\u30c6\u30fc\u30d6\u30eb\u306bInnoDB\u3067\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u3057\u3066\u3044\u305f\u306e\u304c\u30c0\u30e1\u3063\u307d\u3044\u3002\u4eca\u56de\u306f\u30c6\u30fc\u30d6\u30eb\u81ea\u4f53\u3092InnoDB\u306b\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u305f\u3002<\/p>\n<h3>A PRIMARY KEY must include all columns in the table's partitioning function (prefixed columns are not considered).<\/h3>\n<p>\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u3059\u308b\u969b\u306f\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u542b\u3081\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u306e\u3053\u3068\u3002ken_id&amp;id\u3092\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u306b\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u305f\u3002\u5c1a\u3001ken_id\u3060\u3051\u3060\u3068\u4eca\u56de\u306f\u30b1\u30fc\u30b9\u3067\u306f\u91cd\u8907\u30ab\u30e9\u30e0\u304c\u591a\u6570\u767a\u751f\u3059\u308b\u306e\u3067ken_id&amp;id\u306e\u8907\u6570\u6307\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u91cd\u8907\u3092\u907f\u3051\u305f\u3002<\/p>\n<h3>ERROR: Table has no partition for value from<\/h3>\n<p>\u30ec\u30f3\u30b8\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u3092\u8a2d\u5b9a\u3059\u308b\u969b\u306f\u7d42\u7aef\u307e\u3067\u5b9a\u7fa9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3068\u306e\u3053\u3068\u3002\u4ee5\u4e0b\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">PARTITION pmax VALUES LESS THAN MAXVALUE<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u4f7f\u3044\u3069\u3053\u308d<\/h2>\n<p>\u898f\u6a21\u304c\u5927\u304d\u3081\u3067\u96c6\u8a08\u3092\u884c\u3046\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u306e\u5834\u5408\u306b\u6709\u52b9\u3060\u3068\u601d\u308f\u308c\u308b\u3002\u4f8b\u3048\u3070\u58f2\u308a\u4e0a\u3052\u30ed\u30b0\u7cfb\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u304b\u3060\u3068\u5f8c\u304b\u3089\u5e74 \/ \u6708 \/ \u65e5\u5358\u4f4d\u3067\u96c6\u8a08\u3059\u308b\u3053\u3068\u306b\u306a\u308b\u3068\u601d\u3046\u304c\u3001\u305d\u306e\u969b\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3088\u308a\u3082\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30f3\u306e\u65b9\u304c\u52b9\u679c\u306f\u5927\u304d\u3044\u3063\u307d\u3044(<a href=\"https:\/\/enterprisezine.jp\/article\/detail\/3422?p=3\" target=\"_blank\" rel=\"noopener\">\u53c2\u8003\u8a18\u4e8b<\/a>)\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u6240\u611f<\/h2>\n<p>\u4f7f\u3044\u65b9\u306b\u3082\u3088\u308b\u3093\u3060\u308d\u3046\u3051\u3069\u4eca\u56de\u306e\u30b1\u30fc\u30b9\u3060\u3068\u5927\u5e45\u306b\u901f\u5ea6\u30a2\u30c3\u30d7\u3057\u305f\u3002\u5c1a\u3001\u4eca\u56de\u306e\u30b1\u30fc\u30b9\u306e\u5834\u5408\u306f\u90fd\u9053\u5e9c\u770cID\u306b\u5bfe\u3057\u3066\u8a2d\u5b9a\u3057\u305f\u305f\u3081\u6700\u521d\u304b\u308947\u30d1\u30bf\u30fc\u30f3\u306e\u307f\u306b\u306a\u308b\u304c\u3001\u4f8b\u3048\u3070\u30ed\u30b0\u7cfb\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u767b\u9332\u65e5\u6642\u306b\u5bfe\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3088\u3046\u306a\u5834\u5408\u306f\u672a\u6765\u65e5\u4ed8(2038\u5e74\u8fc4\u7b49)\u3092\u8a2d\u5b9a\u3059\u308b\u306e\u304c\u826f\u3044\u3089\u3057\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u524d\u306b\u4ed6\u793e\u304c\u8a2d\u8a08\u3055\u308c\u305f\u30ed\u30b0\u7cfb\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u62dd\u898b\u3057\u305f\u969b\u306b\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u8a2d\u5b9a\u304c\u884c\u308f ... <\/p>\n","protected":false},"author":1,"featured_media":1072,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5,66],"tags":[32],"class_list":["post-4584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-database","tag-speedup"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=4584"}],"version-history":[{"count":5,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4584\/revisions"}],"predecessor-version":[{"id":4593,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/4584\/revisions\/4593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1072"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=4584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=4584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=4584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}