{"id":462,"date":"2020-03-26T22:17:26","date_gmt":"2020-03-26T20:17:26","guid":{"rendered":"http:\/\/my-opinions.uw-t.com\/?p=462"},"modified":"2020-03-26T22:18:02","modified_gmt":"2020-03-26T20:18:02","slug":"index-column-size-too-large-the-maximum-column-size-is-767-bytes","status":"publish","type":"post","link":"https:\/\/uw-t.com\/en\/programing\/mysql\/index-column-size-too-large-the-maximum-column-size-is-767-bytes","title":{"rendered":"Index column size too large. The maximum column size is 767 bytes."},"content":{"rendered":"\n<p>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u043c\u043d\u043e\u0433\u043e \u0433\u0434\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0430, \u043d\u043e \u0440\u0435\u0448\u0430\u0435\u0442\u0441\u044f \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0440\u0443\u0442\u0430 \u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 <\/p>\n\n\n\n<p>mysql<\/p>\n\n\n\n<p>set global innodb_file_format = BARRACUDA;<\/p>\n\n\n\n<p>set global innodb_large_prefix = ON;<\/p>\n\n\n\n<p>SET GLOBAL innodb_default_row_format = DYNAMIC;<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u043c\u043d\u043e\u0433\u043e \u0433\u0434\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0430, \u043d\u043e \u0440\u0435\u0448\u0430\u0435\u0442\u0441\u044f \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0440\u0443\u0442\u0430 \u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 mysql set global innodb_file_format = BARRACUDA; set global innodb_large_prefix = ON; SET GLOBAL innodb_default_row_format = DYNAMIC;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-462","post","type-post","status-publish","format-standard","hentry","category-mysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/comments?post=462"}],"version-history":[{"count":3,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/462\/revisions"}],"predecessor-version":[{"id":465,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/462\/revisions\/465"}],"wp:attachment":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/media?parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/categories?post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/tags?post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}