{"id":1235,"date":"2017-01-18T17:10:27","date_gmt":"2017-01-18T08:10:27","guid":{"rendered":"http:\/\/blog.anyons.net\/?p=1235"},"modified":"2022-07-12T14:48:05","modified_gmt":"2022-07-12T05:48:05","slug":"mysql-%ed%8a%9c%eb%8b%9d-%eb%82%98%ed%94%84%eb%8b%a4","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=1235","title":{"rendered":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)"},"content":{"rendered":"<h3>\uba3c\uc800<\/h3>\n<ol>\n<li>Subscription\uc744 \ubc1b\uc544\ub77c<\/li>\n<li>\uae30\uc220\uc9c0\uc6d0 \uc5c5\uccb4\uc5d0\uac8c \uc758\uc9c0\ud574\ub77c<\/li>\n<li>HW \uc758 \uc911\uc694\uc131<br \/>\nmysql community &lt; mysql enterprize \uc4f0\ub808\ub4dc\ud480\uc774 \uc788\uace0 \uc5c6\uace0 \ucc28\uc774 (12 core \uc774\uc0c1\uc5d0\uc11c \uc131\ub2a5 \ucc28\uc774) -&gt; maria DB\ub294 \uc4f0\ub808\ub4dc\ud480\uc774 \uc874\uc7ac<\/li>\n<li>\uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ub530\ub85c \uc788\ub2e4.<\/li>\n<li>my.cnf \ub97c \uc798 \uc368\ub77c<br \/>\ndefault\ub85c \uc788\ub294 \uac83\uc740 \ub0ae\uc740 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub3cc\ub9ac\uac8c\ub054 \ub418\uc5b4 \uc788\ub294 \uac83\uc774\ub2e4.<\/li>\n<li>\uc131\ub2a5 \ud55c\uacc4\uac00 \uc788\ub2e4.<\/li>\n<li>BMT \uc218\uce58\ub294 \ub9f9\uc2e0\ud558\uc9c0 \ub9c8\ub77c<\/li>\n<\/ol>\n<h3>\ud29c\ub2dd<\/h3>\n<p>\uc544\ub974\ub178 Adant MySQL Connect 2013 \ubc1c\ud45c<br \/>\n<a href=\"http:\/\/aadant.com\/blog\/wp-content\/uploads\/2013\/09\/50-Tips-for-Boosting-MySQL-Performance-CON2655.pdf\">http:\/\/aadant.com\/blog\/wp-content\/uploads\/2013\/09\/50-Tips-for-Boosting-MySQL-Performance-CON2655.pdf<\/a><\/p>\n<ol>\n<li>Make sour you have enough RAM<\/li>\n<li>Use fast and multi-core processors<\/li>\n<li>Use fast and reliable storage<\/li>\n<li>Choose the right OS\n<ul>\n<li>MySQL is excellent on Linux<\/li>\n<li>WIndows need 2012 R2<\/li>\n<\/ul>\n<\/li>\n<li>Adjust the OS limits\n<ul>\n<li>Max open files per process<\/li>\n<li>Max threads per user<\/li>\n<\/ul>\n<\/li>\n<li>Consider using alternative malloc\n<ul>\n<li>[mysqld_safe]<br \/>\nmalloc-lib=\/usr\/lib64\/libjemalloc.so.1<\/li>\n<li>[mysqld_safe]<br \/>\nmalloc-lib=tcmalloc<\/li>\n<\/ul>\n<\/li>\n<li>Set CPI affinity\n<ul>\n<li>taskset command on linux<br \/>\ntaskset -c 1-4 &#8216;pidof mysqld&#8217;<\/li>\n<li>On Windows<br \/>\nSTART \/AFFINITY 0x1111 bin\\mysqld -console<\/li>\n<\/ul>\n<\/li>\n<li><strong>Choose the right file system<\/strong>\n<ul>\n<li>xfs is excellent &gt; ext4 &gt; ext3<\/li>\n<\/ul>\n<\/li>\n<li>Mount options\n<ul>\n<li>ext4 (rw,noatime, nodiration, nobarrier, data=ordered)<\/li>\n<li>xfs (rw, noatime, nodiratime, nobarrier, logbufs=8, logbsize=32k)<\/li>\n<li>SSD specific\n<ul>\n<li>trim<\/li>\n<li>innodb_page_size = 4k<\/li>\n<li>innodb_flush_neighbors = 0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Choose the best I\/O scheduler (Use deadline or noop on Linux)\n<ul>\n<li>deadline is generally the best I\/O scheduler<br \/>\necho deadline &gt; \/sys\/block\/{DEVICE-NAME}\/queue\/scheduler<\/li>\n<li>the best value is HW and WL specific<br \/>\nnoop on high end controller<\/li>\n<\/ul>\n<\/li>\n<li>Use a battery backed disk cache<\/li>\n<li>Balance the load on several disks (SSD)<\/li>\n<li><strong>Turn Off the Query Cache<\/strong>\n<ul>\n<li>query_cache_type = 0<\/li>\n<li>query_cache_size = 0<\/li>\n<li>qcache_free_blocks &gt; 5-10k<\/li>\n<\/ul>\n<\/li>\n<li>Use the Thread Pool<\/li>\n<li>Configure table caching\n<ul>\n<li>table_open_cache\n<ul>\n<li>not too small, not too big, used to size PS<\/li>\n<li>opened_tables \/ sec<\/li>\n<\/ul>\n<\/li>\n<li>table_definition_cache\n<ul>\n<li>do not forget to increase<\/li>\n<li>opened_table_definitions \/ sec<\/li>\n<\/ul>\n<\/li>\n<li>table_cache_instances = 8 or 16<\/li>\n<li>innodb_open_files<\/li>\n<li>mdl_hash_instances = 256<\/li>\n<\/ul>\n<\/li>\n<li>Cache the threads\n<ul>\n<li>thread_cache_size<\/li>\n<\/ul>\n<\/li>\n<li>Reduce per thread memory usage\n<ul>\n<li>Memory allocation is expensive =\u00a0max_used_connections *(<br \/>\nread_buffer_size +<br \/>\nread_rnd_buffer_size +<br \/>\njoin_buffer_size +<br \/>\nsort_buffer_size +<br \/>\nbinlog_cache_size +<br \/>\nthread_stack +<br \/>\n2 * net_buffer_length&#8230;<br \/>\n)<\/li>\n<\/ul>\n<\/li>\n<li>Beware of sync_binlog = 1<\/li>\n<li>Move your tables to InnoDB<\/li>\n<li>Use a large buffer pool (80% buffer pool)\n<ul>\n<li>innodb_buffer_pool_size<\/li>\n<li><strong>Do not swap !<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Reduce the buffer pool contention\n<ul>\n<li>\ud14c\uc774\ube14\uc774 \ub9ce\uc73c\uba74 \ub9ce\uc744\uc218\ub85d \ubc84\ud37c\ud480\uc774 \ud070\uac8c \uc88b\ub2e4<\/li>\n<\/ul>\n<\/li>\n<li>Use large redo logs\n<ul>\n<li>\ubc84\uc804 5.6 \uc774\uc0c1\uc5d0\uc11c\ub294 2\uae30\uac00 \uc774\uc0c1 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4<\/li>\n<\/ul>\n<\/li>\n<li>Adjust the IO capacity\n<ul>\n<li>5200 RPM \uc5d0\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 \uae30\ub2a5\uc73c\ub85c \uadf8\ub2e4\uc9c0&#8230;<\/li>\n<li>\ub514\ud3f4\ud2b8 \uac12\uc774 \ub108\ubb34 \ub0ae\uae34 \ud558\uc9c0\ub9cc \uc131\ub2a5 \ud5a5\uc0c1\uc5d0 \uadf8\ub807\uac8c\uae4c\uc9c0\ud070 \ub3c4\uc6c0\uc774 \ub418\uc9c0\ub294 \uc54a\ub294\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<li>Configure the InnoDB flushing\n<ul>\n<li>\ucee4\ubc0b\ud560\ub54c \ub85c\uadf8\ub97c \ud50c\ub7ec\uc26c \uc5b4\ub5bb\uac8c \ud560\uac83\uc778\uac00?<\/li>\n<li>\uc548\uc815\uc131\uc744 \uc911\uc694\uc2dc\ud558\uba74 1<\/li>\n<li>\uc5d4\uac04\ud558\uba74 2\ub85c \ub194\ub3c4&#8230;<\/li>\n<li>innodb_flush_method = O_DIRECT \/\/ \ucee4\ub110 \ubcf5\uc0ac \ube44\uc6a9 \uc5c6\uc774 DMA\ub97c \uc0ac\uc6a9 \uac00\ub054 linux \ucee4\ub110 \ubc84\uc804\uc774 \uc774\uc0c1\ud574\uc11c \ud30c\uc77c \uc2dc\uc2a4\ud15c\uc5d0\uc11c Direct IO\uac00 \ucf1c\uc838\uc788\uc9c0 \uc54a\uc740 \uacbd\uc6b0 \uace8\ub54c\ub9b4\uc218\ub294 \uc788\ub2e4. \uc708\ub3c4\uc6b0\ub294 \uc635\uc158\uc774 \ub2e4\ub974\ub2e4<\/li>\n<\/ul>\n<\/li>\n<li>Enable innodb_file_per_table\n<ul>\n<li>5.6\ubd80\ud130 \ub514\ud3f4\ud2b8 \uc774\ubbc0\ub85c&#8230;<\/li>\n<\/ul>\n<\/li>\n<li>Configure the thread concurrency\n<ul>\n<li>\ub514\ud3f4\ud2b8\ub85c \ub194\ub3c4 \ub428<\/li>\n<\/ul>\n<\/li>\n<li>Reduce the transaction isolation<\/li>\n<li>Design the tables\n<ul>\n<li>latin1 -&gt; utf-8<\/li>\n<li>primary key -&gt; int<\/li>\n<\/ul>\n<\/li>\n<li>Add indexes\n<ul>\n<li>innodb \ub294 data\uc640 index\uac00 \uac19\uc740 \ud30c\uc77c \uc548\uc5d0 \ub4e4\uc5b4\uac00\uc11c \ubb34\uc870\uac74 \ub9ce\uc774 \uc7a1\ub294\uac8c \uaf2d \uc88b\uc544\uc9c0\uc9c0\ub294 \uc54a\ub294\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<li>Remove unused indexes\n<ul>\n<li>\uc548\uc4f0\ub294 \uc778\ub371\uc2a4\ub294 \uc0ad\uc81c\ud558\uc790<\/li>\n<\/ul>\n<\/li>\n<li>Reduce rows_examined\n<ul>\n<li>\ucffc\ub9ac \uc4f8\ub54c \uc790\ub8cc \ud655\uc778\ud558\ub294 \ub370\uc774\ud130 \uc218\ub97c \uc904\uc774\ub294 \uac83\uc740 \ub2f9\uc5f0<\/li>\n<\/ul>\n<\/li>\n<li>Reduce rows_sent\n<ul>\n<li>\ucffc\ub9ac \uc4f8\ub54c select \ud574\uc11c \uac00\uc838\uc624\ub294 \uc790\ub8cc \uac2f\uc218 \uc904\uc774\ub294 \uac83\ub3c4 \ub2f9\uc5f0<\/li>\n<\/ul>\n<\/li>\n<li>Reduce locking\n<ul>\n<li>lock\uc744 \uc904\uc774\ub294 \uac83\ub3c4 \ub2f9\uc5f0<\/li>\n<li>\ud2b9\ud788 mysql\uc740 auto commit \uc774 \ub514\ud3f4\ud2b8\uc778\ub370 \uc774\uac78 \uc4f0\uc9c0 \uc54a\ub3c4\ub85d&#8230;<\/li>\n<\/ul>\n<\/li>\n<li>Mine the slow query log\n<ul>\n<li>\uc2ac\ub85c\uc6b0 \ucffc\ub9ac \uc7a1\ub294 \uac83\ub3c4 \ub2f9\uc5f0<\/li>\n<\/ul>\n<\/li>\n<li>Use the performance_schema\n<ul>\n<li>\ud37c\ud3ec\uba3c\uc2a4 \ud234\uc744 \uc798 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4<\/li>\n<li>\ud37c\ud3ec\uba3c\uc2a4 \ud234\uc744 \uc0ac\uc6a9\ud558\ub294 \uc2dc\uc810\uc5d0 10% \uc758 \uc131\ub2a5 \ud558\ud5a5\uc774 \uc77c\uc5b4\ub09c\ub2e4.<\/li>\n<li>\ubc84\uc804 8\uc815\ub3c4\ubd80\ud130\ub294 \uadf8\ub807\uac8c \uc131\ub2a5\uc758 \ud558\ud5a5\uc774 \uc77c\uc5b4\ub098\uc9c0\ub294 \uc54a\ub294\ub2e4<\/li>\n<\/ul>\n<\/li>\n<li>Tune the replication thread\n<ul>\n<li>\uc54c\ub824\uc9c4 \ubc84\uadf8\uac00 \uc880 \uc788\uc5b4\uc11c&#8230;<\/li>\n<li>\ub9cc\uc57d \uc0ac\uc6a9\ud558\ub824\uba74 binlog_format=ROW \uc635\uc158\uc774 \ud544\uc694\ud558\ub2e4<\/li>\n<\/ul>\n<\/li>\n<li>Avoid temporary tables on disk\n<ul>\n<li>mysql\uc740 join\uc744 \ud558\uac70\ub098 \ud560\ub54c \uc6a9\ub7c9\uc774 \ud06c\uba74 temp table\uc744 \ub2e4 disk\uc5d0\ub2e4 \uc4f4\ub2e4.<\/li>\n<li>temp table\uc744 ram\uc5d0 \uc62c\ub824\uc57c \ud55c\ub2e4.<\/li>\n<li>temp file system\uc744 \uc0ac\uc6a9\ud558\ub354\ub77c\ub3c4 \ub108\ubb34 \ud06c\uac8c \uc7a1\uc73c\ub85c swap\uc744 \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0<\/li>\n<\/ul>\n<\/li>\n<li>Cache data in the App<\/li>\n<li>Avoid long running transactions<\/li>\n<li>Close idle connections\n<ul>\n<li>\uac00\ub2a5\ud558\uba74 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c timeout\uc744 \uc0ac\uc6a9\ud574\uc11c \uc5b4\ub290\uc815\ub3c4 \uc2dc\uac04\uc774 \uc9c0\ub098\uba74 \uc800\uc808\ub85c \ub04a\uc5b4\uc9c0\uac8c \ud574\ub77c<\/li>\n<\/ul>\n<\/li>\n<li>Close prepare statements\n<ul>\n<li>prepare \ud558\uace0 \uc81c\ubc1c\uc880 close \ud574\ub77c<\/li>\n<\/ul>\n<\/li>\n<li>Configure Connector \/ J\n<ul>\n<li>JDBC Connector \uc778\ub370 \uad73\uc774 JDBC\ub97c \uc0ac\uc6a9\ud560\uc77c\uc740 \uc5c6\uc73c\ub2c8\uae4c<\/li>\n<li>mysql connector \uc640 maria connector\ub4f1\uc744 \uac19\uc774 \uc4f0\uc9c0 \ub9d0\uace0 \uc81c\ubc1c \uc81c\ub300\ub85c \ub41c \ud504\ub85c\uadf8\ub7a8\uc744 \uc368\ub77c<\/li>\n<\/ul>\n<\/li>\n<li>Do not use the information_schema in your App<\/li>\n<li>View are not good for performance<\/li>\n<li>Sacle out, shard<\/li>\n<li>Monitor the database and OS<\/li>\n<li>Backup the database<\/li>\n<li>Optimize table and data files\n<ul>\n<li>\uc8fc\uae30\uc801\uc73c\ub85c \ud574\uc57c \ud558\ub294 \uac8c \ub9de\ub2e4<\/li>\n<li>\ub77c\uc774\ube0c\uc11c\ubc84\uc5d0\uc11c\ub294 \ud558\uc9c0 \ub9c8\ub77c<\/li>\n<\/ul>\n<\/li>\n<li>Upgrade regularly<\/li>\n<li>Perform regular health checks<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\uba3c\uc800 Subscription\uc744 \ubc1b\uc544\ub77c \uae30\uc220\uc9c0\uc6d0 \uc5c5\uccb4\uc5d0\uac8c \uc758\uc9c0\ud574\ub77c HW \uc758 \uc911\uc694\uc131 mysql community &lt; mysql enterprize \uc4f0\ub808\ub4dc\ud480\uc774 \uc788\uace0 \uc5c6\uace0 \ucc28\uc774 (12 core \uc774\uc0c1\uc5d0\uc11c \uc131\ub2a5 \ucc28\uc774) -&gt; maria DB\ub294 \uc4f0\ub808\ub4dc\ud480\uc774 \uc874\uc7ac \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ub530\ub85c \uc788\ub2e4. my.cnf \ub97c \uc798 \uc368\ub77c default\ub85c \uc788\ub294 \uac83\uc740 \ub0ae\uc740 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub3cc\ub9ac\uac8c\ub054 \ub418\uc5b4 \uc788\ub294 \uac83\uc774\ub2e4. \uc131\ub2a5 \ud55c\uacc4\uac00 \uc788\ub2e4. BMT \uc218\uce58\ub294 \ub9f9\uc2e0\ud558\uc9c0 \ub9c8\ub77c \ud29c\ub2dd <\/p>\n<p>\uc544\ub974\ub178 Adant [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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}},"categories":[94,165],"tags":[324,325],"class_list":["post-1235","post","type-post","status-publish","format-standard","hentry","category-configuration","category-system","tag-mysql","tag-325","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anyons.net\/?p=1235\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon\" \/>\n<meta property=\"og:description\" content=\"\uba3c\uc800 Subscription\uc744 \ubc1b\uc544\ub77c \uae30\uc220\uc9c0\uc6d0 \uc5c5\uccb4\uc5d0\uac8c \uc758\uc9c0\ud574\ub77c HW \uc758 \uc911\uc694\uc131 mysql community &lt; mysql enterprize \uc4f0\ub808\ub4dc\ud480\uc774 \uc788\uace0 \uc5c6\uace0 \ucc28\uc774 (12 core \uc774\uc0c1\uc5d0\uc11c \uc131\ub2a5 \ucc28\uc774) -&gt; maria DB\ub294 \uc4f0\ub808\ub4dc\ud480\uc774 \uc874\uc7ac \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ub530\ub85c \uc788\ub2e4. my.cnf \ub97c \uc798 \uc368\ub77c default\ub85c \uc788\ub294 \uac83\uc740 \ub0ae\uc740 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub3cc\ub9ac\uac8c\ub054 \ub418\uc5b4 \uc788\ub294 \uac83\uc774\ub2e4. \uc131\ub2a5 \ud55c\uacc4\uac00 \uc788\ub2e4. BMT \uc218\uce58\ub294 \ub9f9\uc2e0\ud558\uc9c0 \ub9c8\ub77c \ud29c\ub2dd \uc544\ub974\ub178 Adant [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=1235\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-18T08:10:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:48:05+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)\",\"datePublished\":\"2017-01-18T08:10:27+00:00\",\"dateModified\":\"2022-07-12T05:48:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235\"},\"wordCount\":493,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"mysql\",\"\ud29c\ub2dd\"],\"articleSection\":[\"Configuration\",\"System\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=1235#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=1235\",\"name\":\"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2017-01-18T08:10:27+00:00\",\"dateModified\":\"2022-07-12T05:48:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=1235\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1235#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anyons.net\/?p=1235","og_locale":"ko_KR","og_type":"article","og_title":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon","og_description":"\uba3c\uc800 Subscription\uc744 \ubc1b\uc544\ub77c \uae30\uc220\uc9c0\uc6d0 \uc5c5\uccb4\uc5d0\uac8c \uc758\uc9c0\ud574\ub77c HW \uc758 \uc911\uc694\uc131 mysql community &lt; mysql enterprize \uc4f0\ub808\ub4dc\ud480\uc774 \uc788\uace0 \uc5c6\uace0 \ucc28\uc774 (12 core \uc774\uc0c1\uc5d0\uc11c \uc131\ub2a5 \ucc28\uc774) -&gt; maria DB\ub294 \uc4f0\ub808\ub4dc\ud480\uc774 \uc874\uc7ac \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc774 \ub530\ub85c \uc788\ub2e4. my.cnf \ub97c \uc798 \uc368\ub77c default\ub85c \uc788\ub294 \uac83\uc740 \ub0ae\uc740 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub3cc\ub9ac\uac8c\ub054 \ub418\uc5b4 \uc788\ub294 \uac83\uc774\ub2e4. \uc131\ub2a5 \ud55c\uacc4\uac00 \uc788\ub2e4. BMT \uc218\uce58\ub294 \ub9f9\uc2e0\ud558\uc9c0 \ub9c8\ub77c \ud29c\ub2dd \uc544\ub974\ub178 Adant [...]","og_url":"https:\/\/anyons.net\/?p=1235","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2017-01-18T08:10:27+00:00","article_modified_time":"2022-07-12T05:48:05+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=1235#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=1235"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)","datePublished":"2017-01-18T08:10:27+00:00","dateModified":"2022-07-12T05:48:05+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=1235"},"wordCount":493,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["mysql","\ud29c\ub2dd"],"articleSection":["Configuration","System"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=1235#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=1235","url":"https:\/\/anyons.net\/?p=1235","name":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4) - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2017-01-18T08:10:27+00:00","dateModified":"2022-07-12T05:48:05+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=1235#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=1235"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=1235#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"MySQL \ud29c\ub2dd (from \ub098\ud504\ub2e4)"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":580,"url":"https:\/\/anyons.net\/?p=580","url_meta":{"origin":1235,"position":0},"title":"\uad6d\uc81c\ud654 \uac1c\ubc1c\uc2dc \uace0\ub824\ud560 \uc0ac\ud56d","author":"anydragon","date":"2013\ub144 06\uc6d4 05\uc77c","format":false,"excerpt":"\ucd9c\ucc98] http:\/\/allofsoftware.net\/entry\/\uad6d\uc81c\ud654-\uc2dc-\uace0\ub824\ud574\uc57c-\ud560-49\uac00\uc9c0 \ubc88\ud638 \ud56d\ubaa9 \uc124\uba85 1 \uc5b8\uc5b4 \uad6c\ubd84 \ud55c \uad6d\uac00\uc5d0\ub3c4 \uc5b8\uc5b4\uac00 \uc5ec\ub7ec\uac00\uc9c0\uc774\uae30\ub3c4 \ud558\uace0 \ud558\ub098\uc758 \uc5b8\uc5b4\uac00 \uc5ec\ub7ec \ub098\ub77c\uc5d0\uc11c \uc11c\ub85c \ub2e4\ub974\uac8c \uc4f0\uc774\uae30\ub3c4 \ud55c\ub2e4. 2 \uc9c0\uc5ed \uad6c\ubd84 \uc9c0\uc5ed\uacfc \uad6d\uac00\uac00 \uc644\uc804\ud788 \uc77c\uce58\ud558\uc9c0\ub294 \uc54a\ub294\ub2e4. \uc5b8\uc5b4\uc640 \uc9c0\uc5ed \uc815\ubcf4\uac00 \ud569\uccd0\uc838\uc11c Locale\uc774 \ub41c\ub2e4. \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub294 Locale \ub2e8\uc704\ub85c \uc9c0\uc5ed\ud654(L10N)\ub97c \ud55c\ub2e4. 3 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc758 \uc778\ucf54\ub529 \uc804\ub7b5 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uac00 \uc9c0\uc6d0\ud574\uc57c \ud560 \uc778\ucf54\ub529\uc740 \ub9e4\uc6b0 \ubcf5\uc7a1\ud558\ub2e4.\u2026","rel":"","context":"&quot;Concept&quot;\uc5d0\uc11c","block_context":{"text":"Concept","link":"https:\/\/anyons.net\/?cat=95"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2814,"url":"https:\/\/anyons.net\/?p=2814","url_meta":{"origin":1235,"position":1},"title":"azure ubuntu \uc124\uce58 ver 2022","author":"anydragon","date":"2022\ub144 09\uc6d4 06\uc77c","format":false,"excerpt":"TimeZone Setting ls -l \/etc\/localtime cd \/etc sudo rm -rf localtime sudo ln -s \/usr\/share\/zoneinfo\/Asia\/Seoul localtime # time changed UTC -> KST date package update sudo apt update sudo apt upgrade do-release-upgrade sudo apt autoclean sudo apt autoremove Util Install & Setting # install Utils sudo apt install build-essential sudo\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2802,"url":"https:\/\/anyons.net\/?p=2802","url_meta":{"origin":1235,"position":2},"title":"Azure OS Disk Size \ubd80\uc871\ud560\ub54c \uac00\uc7a5 \uc27d\uac8c SizeUp \ud558\ub294 \ubc29\ubc95","author":"anydragon","date":"2022\ub144 08\uc6d4 28\uc77c","format":false,"excerpt":"\ucc98\uc74c Auzre\uc5d0 VM\uc744 \ub9cc\ub4e4\uace0 \uc6b4\uc601\uc744 \ud558\ub2e4\ubcf4\uba74 \uc0dd\uac01\uce58\ub3c4 \uc54a\uac8c Disk Size \uac00 \ubd80\uc871\ud574 \uc9c8\ub54c\uac00 \uc788\ub2e4. \ud2b9\ud788 OS Disk \uac00 \ubd80\uc871\ud574 \uc9c0\uba74 \uc5ec\ub7ec\uac00\uc9c0 \ubc29\ubc95\uc744 \ucc3e\uc544\ubcf4\uace0\ub294 \"\uc808\ub9dd\" \ud55c\ub2e4 \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c Power Shell\ub85c \uc5b4\ucc0c \uc5b4\ucc0c \ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc9c0\ub9cc..........\uc5b4\ub835\ub2e4. \uadf8\ub807\ub2e4\uace0 \uc0c8\ub85c \uc124\uce58\ud558\uae30\uc5d0\ub294 \ud560\uc77c\uc774 \ub9ce\uc544\ub3c4 \ub108\ubb34 \ub9ce\ub2e4. \uadf8\ub7ec\ub2e4\uac00 OS Disk Size\ub97c \ubc14\uafc0\uc218 \uc788\ub294 \uac00\uc7a5 \uc26c\uc6b4 \ubc29\ubc95\uc744\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/08\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2022-08-28-%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB-10.50.49.png?resize=1050%2C600 3x"},"classes":[]},{"id":2576,"url":"https:\/\/anyons.net\/?p=2576","url_meta":{"origin":1235,"position":3},"title":"2021\ub144 6\uc6d4 \ub0b4\uac00 \uc124\uce58\ud55c vscode \ud655\uc7a5\ub4e4","author":"anydragon","date":"2022\ub144 06\uc6d4 14\uc77c","format":false,"excerpt":"\ucd5c\uadfc\uc5d0\ub294 asp.net core \uc5d0 \ud55c\uc815\ud574\uc11c \uac1c\ubc1c\uc744 \ud558\ub2e4\ubcf4\ub2c8 \ub300\ubd80\ubd84 Disable \ud558\uace0 \ud544\uc694\ud55c \uac83\ub9cc Enable \ud574\uc11c \uc0ac\uc6a9 \uc0ac\uc6a9\uc911 .NET Core Add Reference .NET Core Test Explorer .NET Install Tool for Extension Authors ASP.NET Core Switcher Auto Close Tag Auto Rename Tag Auto-Using for C# Bookmarks C# C# Namespace Autocompletion Code Spell Checker\u2026","rel":"","context":"&quot;Configuration&quot;\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2919,"url":"https:\/\/anyons.net\/?p=2919","url_meta":{"origin":1235,"position":4},"title":"\uc120\uacfc \uc545, \uc815\uacfc \uc624\ub97c \ubc14\ub77c\ubcf4\ub294 \uc778\uac04\uacfc AI","author":"anydragon","date":"2022\ub144 12\uc6d4 12\uc77c","format":false,"excerpt":"\uc77c\ubc18\uc801\uc73c\ub85c \uc120\ud55c\uc0ac\ub78c\uacfc \uc545\ud55c\uc0ac\ub78c\uc774 \uc788\ub2e4. \ub611\uac19\uc740 \uc0c1\ud669\uc744 \ubcf4\uace0 \uadf8 \uc0c1\ud669\uc5d0 \ub300\ud55c \ud574\uc11d\ub3c4 \uac01\uac01\uc758 \uc0ac\ub78c\ub9c8\ub2e4 \ub2e4\ub974\ub2e4. \uacfc\ud559\uc801\uc73c\ub85c \uc99d\uba85\ud560\uc218 \uc788\ub294 \uac83\uc774 \ub4dc\ub808\uc2a4\ub97c \ubcf4\uace0 25%\uc758 \uc0ac\ub78c\uc740 \ud30c\ub780\uc0c9, \uac80\uc740\uc0c9 \uc73c\ub85c 75%\uc758 \uc0ac\ub78c\uc740 \ud770\uc0c9, \uae08\uc0c9\uc73c\ub85c \ubcf4\uc778\ub2e4\ub294 \uc774\ubbf8\uc9c0\uac00 \uc788\ub2e4. \u00a0 \uc694\uc988\uc74c \ubcf4\ud1b5 \uc2e0\uacbd\ub9dd \uac19\uc740 AI\uc758 \ud2b9\uc9d5\uc740 \ud559\uc2b5\uc744 \uc2dc\ud0b4\uc73c\ub85c\uc368 \ucd5c\ub300\ud55c \uc0ac\ub78c\uc5d0 \uac00\uae4c\uc6b4 AI\ub97c \ub9cc\ub4e4\uace0 \uc2f6\uc5b4\ud55c\ub2e4. \ubb38\uc81c\ub294 \uc800\ub7f0 \uc758\uacac\uc774\u2026","rel":"","context":"&quot;\ubbf8\ubd84\ub958&quot;\uc5d0\uc11c","block_context":{"text":"\ubbf8\ubd84\ub958","link":"https:\/\/anyons.net\/?cat=1"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2022\/12\/tumblr_nkcjuq8Tdr1tnacy1o1_500.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1123,"url":"https:\/\/anyons.net\/?p=1123","url_meta":{"origin":1235,"position":5},"title":"\ud504\ub85c\uc81d\ud2b8 \uc9c4\ud589","author":"anydragon","date":"2015\ub144 04\uc6d4 09\uc77c","format":false,"excerpt":"\uacf5\ud1b5\uc791\uc5c5 \uc640\uc774\uc5b4 \ud504\ub808\uc784\uacfc \uc2a4\ud1a0\ub9ac\ubcf4\ub4dc\uc5d0\uc11c \ub108\ubb34 \uc815\uad50\ud558\uac8c \uad6c\ud604\ud558\uba74 \uac70\uae30\uc5d0 \ube60\uc9c8\uc218 \uc788\ub2e4. \ud2b9\ud788 \uc694\uc998 \ub098\uc624\ub294 \uc640\uc774\uc5b4\ud504\ub808\uc784\ud234\uc774\ub098 \uc2a4\ud1a0\ub9ac \ubcf4\ub4dc \ud234\ub4e4\uc774 \uac00\ub2a5\ud558\uba74 \uc815\uad50\ud55c \ucef4\ud3ec\ub10c\ud2b8\ub97c \uc81c\uacf5\ud558\uae30\ub294 \ud558\uc9c0\ub9cc \uadf8 \uc815\uad50\ud568\uc73c\ub85c \uc778\ud574 \uc624\ud788\ub824 \uc791\uc5c5\uc5d0 \ubc29\ud574\uac00 \ub9ce\uc774 \ub41c\ub2e4. \uc815\uad50\ud574\uc57c \ud558\ub294 \ubd80\ubd84\uacfc \uc815\uad50\ud558\uc9c0 \ub9d0\uc544\uc57c \ud558\ub294 \ubd80\ubd84\uc744 \uba85\ud655\ud558\uac8c \uad6c\ubd84\ud558\ub294 \uac83\uc740 \ubc18\ub4dc\uc2dc \ud544\uc694\ud558\ub2e4. \u00a0\uad6c\uc131\uc694\uc18c change log - \uac1c\uc815 \uc774\ub825 (version history,\u2026","rel":"","context":"&quot;Concept&quot;\uc5d0\uc11c","block_context":{"text":"Concept","link":"https:\/\/anyons.net\/?cat=95"},"img":{"alt_text":"page2","src":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2015\/04\/page2.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2015\/04\/page2.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2015\/04\/page2.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2015\/04\/page2.jpg?resize=700%2C400 2x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/1235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1235"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/1235\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}