{"id":519,"date":"2019-07-24T14:59:06","date_gmt":"2019-07-24T05:59:06","guid":{"rendered":"https:\/\/medicalfields.jp\/blog\/?p=519"},"modified":"2019-07-24T14:59:41","modified_gmt":"2019-07-24T05:59:41","slug":"error-5-hy000-at-line-xxx-out-of-memory","status":"publish","type":"post","link":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/","title":{"rendered":"ERROR 5 (HY000) at line xxx: Out of memory"},"content":{"rendered":"\n<p>MariaDB10.3\u3092\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u8d8a\u3057\u306bCommand Prompt\u3088\u308a<\/p>\n<p>c:\\xampp\\mysql\\bin\\mysql.exe -h10.0.0.1 -uroot -pPW db_name &lt; D:^\\WEB^\\test.sql<\/p>\n<p>\u3063\u3066Windows\u3088\u308aSQL\u30d5\u30a1\u30a4\u30eb\u3092\u6d41\u3057\u305f\u3089Out of memory\u3068\u304b\u3059\u3089\u51fa\u305a\u306b\u3001\u9014\u4e2d\u307e\u3067\u3057\u304bInsert\u3055\u308c\u306a\u3044\u3002\u3081\u3061\u3083\u30c7\u30abSQL\u3057\u305f\u3089\u3082\u3061\u308d\u3093Out of Memory\u3002<\/p>\n<p>\u3060\u3044\u305f\u3044\uff11\uff10\uff10MB\u306eSQL\u30d5\u30a1\u30a4\u30eb\u3067SQLDump\u3088\u308a\u53d6\u5f97\u3057\u305f\u3084\u3064\u3067\u3067\u305f<\/p>\n<p>\u3068\u308a\u3042\u3048\u305aCentOS7\u306b\u3044\u308c\u3066\u308bMariaDB\u306emy.cnf\u3092<\/p>\n<p><br>[mysqld]<\/p>\n<p>innodb_log_file_size = 400M\uff08\u305f\u3076\u3093\u3053\u308c\u306f\u3042\u3093\u307e\u308a\u95a2\u4fc2\u306a\u3044\uff09<\/p>\n<p>wait_timeout = 28800\uff08\u3053\u308c\u3082\u95a2\u4fc2\u306a\u3055\u305d\u3046\uff1f\uff09<\/p>\n<p>max_allowed_packet=512M\uff08\u3053\u308c\u306f\u95a2\u4fc2\u3057\u3066\u305d\u3046\uff09<\/p>\n<p>\u3063\u3066\u611f\u3058\u3067\u7de8\u96c6\u3057\u305f\u3089\u51fa\u306b\u304f\u304f\u306a\u3063\u305f\u6c17\u304c\u3059\u308b\u3088\u3046\u306a\u3001\u3067\u3082\u307e\u3060\u51fa\u305f\u3068\u304d\u304c\u3042\u3063\u3066\u306a\u3093\u304b\u4e0d\u5b89\u5b9a<\/p>\n<p>SQLdump\u3067 &#8211;quick &#8211;skip-extended-insert \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u304b\u3063\u3066\u51e6\u7406\u3092\u5c11\u3057\u5206\u5272\u3055\u305b\u305f\u3051\u3069\u3001\u30a8\u30e9\u30fc\u3067\u3066\u3001\u5c11\u3057\u304c\u3063\u304b\u308a\u3002<\/p>\n<p>\u8272\u3005\u8abf\u3079\u3066\u308b\u3068SQL\u304c\u30a4\u30f3\u30b5\u30fc\u30c8\u4e2d\u306f\u30c6\u30fc\u30d6\u30eb\u304c\u30ed\u30c3\u30af\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u611f\u3058\u3060\u3063\u305f\u3002<\/p>\n<p>innodb_lock_wait_timeout =180\u306b\u3057\u305f\u3089\u3068\u308a\u3042\u3048\u305a\u6cbb\u3063\u305f\uff1f\uff1f<\/p>\n<p>innodb_lock_wait_timeout \u304c\u539f\u56e0\uff1f\uff1f<\/p>\n<p>SQL\u5165\u308c\u3066\u3044\u308b\u9593\u306fDB\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u73fe\u8c61\u304c\u8d77\u304d\u305f\u304c\u3001\u3053\u308c\u3082\u30c6\u30fc\u30d6\u30eb\u30ed\u30c3\u30af\u304c\u539f\u56e0\u306a\u3093\u3060\u308d\u3046\u304b\u3002\u306a\u3093\u304b\u9055\u3046\u3088\u3046\u306a\u3002<\/p>\n<p>innodb_lock_wait_timeout =180\u306b\u3057\u3066\u304b\u3089\u306f\u307e\u3060\u4e00\u5ea6\u3082\u5931\u6557\u3057\u3066\u306a\u3044\u3002<\/p>\n<p>\u3068\u3044\u3046\u304b\u3001\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u306a\u3057\u3067\u30b3\u30b1\u308b\u306e\u306f\u672c\u5f53\u306b\u52d8\u5f01\u3057\u3066\u307b\u3057\u3044<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB10.3\u3092\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u8d8a\u3057\u306bCommand Prompt\u3088\u308a c:\\xampp\\mysql\\bin\\mysql.exe -h10.0.0.1 -uroot -pPW db_name &lt; D:^\\WE &hellip; <a href=\"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">ERROR 5 (HY000) at line xxx: Out of memory<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[9],"tags":[],"class_list":["post-519","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"yuya\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0 | MedicalFields Engineering blog\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-07-24T05:59:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-07-24T05:59:41+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#article\",\"name\":\"ERROR 5 (HY000) at line xxx: Out of memory | \\u30e1\\u30c7\\u30a3\\u30ab\\u30eb\\u30d5\\u30a3\\u30fc\\u30eb\\u30ba\\u793e\\u54e1\\u30d6\\u30ed\\u30b0\",\"headline\":\"ERROR 5 (HY000) at line xxx: Out of memory\",\"author\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/author\\\/yuya\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/medicalfieldslogo-1.png\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#articleImage\",\"width\":248,\"height\":248},\"datePublished\":\"2019-07-24T14:59:06+09:00\",\"dateModified\":\"2019-07-24T14:59:41+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#webpage\"},\"articleSection\":\"SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"\\u30db\\u30fc\\u30e0\",\"item\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/category\\\/sql\\\/#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/category\\\/sql\\\/#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/category\\\/sql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#listItem\",\"name\":\"ERROR 5 (HY000) at line xxx: Out of memory\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#listItem\",\"name\":\"\\u30db\\u30fc\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#listItem\",\"position\":3,\"name\":\"ERROR 5 (HY000) at line xxx: Out of memory\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/category\\\/sql\\\/#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#organization\",\"name\":\"\\u30e1\\u30c7\\u30a3\\u30ab\\u30eb\\u30d5\\u30a3\\u30fc\\u30eb\\u30ba\\u793e\\u54e1\\u30d6\\u30ed\\u30b0\",\"description\":\"MedicalFields Engineering blog\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/medicalfieldslogo-1.png\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#organizationLogo\",\"width\":248,\"height\":248},\"image\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/author\\\/yuya\\\/#author\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/author\\\/yuya\\\/\",\"name\":\"yuya\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/79ad543620650a7333971d8687efa0a9e99e3b656e7dadd3de6cbde56e1bb17e?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"yuya\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#webpage\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/\",\"name\":\"ERROR 5 (HY000) at line xxx: Out of memory | \\u30e1\\u30c7\\u30a3\\u30ab\\u30eb\\u30d5\\u30a3\\u30fc\\u30eb\\u30ba\\u793e\\u54e1\\u30d6\\u30ed\\u30b0\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/sql\\\/error-5-hy000-at-line-xxx-out-of-memory\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/author\\\/yuya\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/author\\\/yuya\\\/#author\"},\"datePublished\":\"2019-07-24T14:59:06+09:00\",\"dateModified\":\"2019-07-24T14:59:41+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/\",\"name\":\"\\u30e1\\u30c7\\u30a3\\u30ab\\u30eb\\u30d5\\u30a3\\u30fc\\u30eb\\u30ba\\u793e\\u54e1\\u30d6\\u30ed\\u30b0\",\"description\":\"MedicalFields Engineering blog\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/medicalfields.jp\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","description":"","canonical_url":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#article","name":"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","headline":"ERROR 5 (HY000) at line xxx: Out of memory","author":{"@id":"https:\/\/medicalfields.jp\/blog\/author\/yuya\/#author"},"publisher":{"@id":"https:\/\/medicalfields.jp\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png","@id":"https:\/\/medicalfields.jp\/blog\/#articleImage","width":248,"height":248},"datePublished":"2019-07-24T14:59:06+09:00","dateModified":"2019-07-24T14:59:41+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#webpage"},"isPartOf":{"@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#webpage"},"articleSection":"SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/#listItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/medicalfields.jp\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/category\/sql\/#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/category\/sql\/#listItem","position":2,"name":"SQL","item":"https:\/\/medicalfields.jp\/blog\/category\/sql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#listItem","name":"ERROR 5 (HY000) at line xxx: Out of memory"},"previousItem":{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/#listItem","name":"\u30db\u30fc\u30e0"}},{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#listItem","position":3,"name":"ERROR 5 (HY000) at line xxx: Out of memory","previousItem":{"@type":"ListItem","@id":"https:\/\/medicalfields.jp\/blog\/category\/sql\/#listItem","name":"SQL"}}]},{"@type":"Organization","@id":"https:\/\/medicalfields.jp\/blog\/#organization","name":"\u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","description":"MedicalFields Engineering blog","url":"https:\/\/medicalfields.jp\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#organizationLogo","width":248,"height":248},"image":{"@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/medicalfields.jp\/blog\/author\/yuya\/#author","url":"https:\/\/medicalfields.jp\/blog\/author\/yuya\/","name":"yuya","image":{"@type":"ImageObject","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/79ad543620650a7333971d8687efa0a9e99e3b656e7dadd3de6cbde56e1bb17e?s=96&d=mm&r=g","width":96,"height":96,"caption":"yuya"}},{"@type":"WebPage","@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#webpage","url":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/","name":"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","inLanguage":"ja","isPartOf":{"@id":"https:\/\/medicalfields.jp\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/#breadcrumblist"},"author":{"@id":"https:\/\/medicalfields.jp\/blog\/author\/yuya\/#author"},"creator":{"@id":"https:\/\/medicalfields.jp\/blog\/author\/yuya\/#author"},"datePublished":"2019-07-24T14:59:06+09:00","dateModified":"2019-07-24T14:59:41+09:00"},{"@type":"WebSite","@id":"https:\/\/medicalfields.jp\/blog\/#website","url":"https:\/\/medicalfields.jp\/blog\/","name":"\u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","description":"MedicalFields Engineering blog","inLanguage":"ja","publisher":{"@id":"https:\/\/medicalfields.jp\/blog\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"\u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0 | MedicalFields Engineering blog","og:type":"article","og:title":"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","og:url":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/","og:image":"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png","og:image:secure_url":"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png","article:published_time":"2019-07-24T05:59:06+00:00","article:modified_time":"2019-07-24T05:59:41+00:00","twitter:card":"summary","twitter:title":"ERROR 5 (HY000) at line xxx: Out of memory | \u30e1\u30c7\u30a3\u30ab\u30eb\u30d5\u30a3\u30fc\u30eb\u30ba\u793e\u54e1\u30d6\u30ed\u30b0","twitter:image":"https:\/\/medicalfields.jp\/blog\/wp-content\/uploads\/2018\/12\/medicalfieldslogo-1.png"},"aioseo_meta_data":{"post_id":"519","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-05-21 15:15:35","updated":"2026-10-21 15:28:11","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/medicalfields.jp\/blog\/\" title=\"\u30db\u30fc\u30e0\">\u30db\u30fc\u30e0<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/medicalfields.jp\/blog\/category\/sql\/\" title=\"SQL\">SQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tERROR 5 (HY000) at line xxx: Out of memory\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u30db\u30fc\u30e0","link":"https:\/\/medicalfields.jp\/blog\/"},{"label":"SQL","link":"https:\/\/medicalfields.jp\/blog\/category\/sql\/"},{"label":"ERROR 5 (HY000) at line xxx: Out of memory","link":"https:\/\/medicalfields.jp\/blog\/sql\/error-5-hy000-at-line-xxx-out-of-memory\/"}],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6kJO0-8n","jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/comments?post=519"}],"version-history":[{"count":2,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/519\/revisions"}],"predecessor-version":[{"id":521,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/posts\/519\/revisions\/521"}],"wp:attachment":[{"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/categories?post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/medicalfields.jp\/blog\/wp-json\/wp\/v2\/tags?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}