{"id":1344,"date":"2018-08-07T02:23:24","date_gmt":"2018-08-07T02:23:24","guid":{"rendered":"http:\/\/dbtut.com\/?p=1344"},"modified":"2018-11-09T13:37:49","modified_gmt":"2018-11-09T13:37:49","slug":"mysql-how-to-drop-a-large-table-gracefully","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/","title":{"rendered":"MySQL-How to drop a large table gracefully?"},"content":{"rendered":"<h2><\/h2>\n<h2>Description:<\/h2>\n<p>Drop tables is such a common\u00a0content of a DBA&#8217;s daily work. Drop a small table( such as less than 100 Mega Bytes ), we can just do DROP\u00a0operations during low load. But in most\u00a0situations, the tables are more than 100MB, even reach to 100GB(called large table). Then if you drop this kind of tables( including during the low load ), the\u00a0whole\u00a0 system may be freezing till the DROP finished, or even been unavailable because of the disk I\/O\u00a0overloaded.<\/p>\n<p>Currently, we use\u00a0separate tablespaces for different tables (innodb_file_per_table=ON). And MySQL server was often built on the LINUX. That means the data of a table is actually stored in a\u00a0separate data file. So if we can remove the data file\u00a0progressively and don&#8217;t let the MySQL server knows, then the DROP LARGE TABLE operation will be done gracefully.<\/p>\n<p>Then how can we remove a data file and don&#8217;t let MySQL knows?<\/p>\n<p>(1) LINUX allows us to build a hard link to the file, that makes us could remove the data file after DROP TABLE on the MySQL server, and this is invisible to database.<\/p>\n<p>(2) We can then remove the data file step by step by using the TRUNCATE command of LINUX( <a href=\"http:\/\/man7.org\/linux\/man-pages\/man1\/truncate.1.html\">http:\/\/man7.org\/linux\/man-pages\/man1\/truncate.1.html<\/a> ).<\/p>\n<p>&nbsp;<\/p>\n<h2>How to drop large tables gracefully:<\/h2>\n<h3>1. Build a hard link to the data file<\/h3>\n<p>Build a hard link named <em>testbigfile.ibd.rm<\/em>, the table name is testbigfile, then we can find the data file on the database<\/p>\n<pre class=\"lang:default decode:true\">datadir( mysql&gt; show variables like 'datadir'; )<\/pre>\n<pre class=\"lang:default decode:true \">ln testbigfile.ibd testbigfile.ibd.rm<\/pre>\n<p>&nbsp;<\/p>\n<p>We can use<i>\u00a0<code>ls -l<\/code>\u00a0<\/i>statement to showing the details:<\/p>\n<p>It shows that the link has been used by two files,\u00a0<i>testbigfile.idb\u00a0<\/i>and\u00a0<i>testbigfile.idb.rm<\/i>.<\/p>\n<p>So when we remove a file, it&#8217;s not actually removing the file, just the link, that makes the DROP TABLE statement can be finished in a very short time. And if we remove the remaining file, it&#8217;s the real data removing.<\/p>\n<p>&nbsp;<\/p>\n<h3>2. DROP TABLE<\/h3>\n<p>After building a hard link to the data file, we can DROP the table on MySQL server:<\/p>\n<pre class=\"lang:default decode:true\">&gt; drop table testbigfile;<\/pre>\n<p>Then only one file named<i>\u00a0testbigfile.idb.rm<\/i>\u00a0left.<\/p>\n<p>&nbsp;<\/p>\n<h3>3. Remove the actual file<\/h3>\n<p><i>truncate<\/i>\u00a0command allows to remove file step by step, for example:<\/p>\n<pre class=\"lang:default decode:true \">truncate\u00a0 -s\u00a0 -1GB\u00a0\u00a0testbigfile.ibd.rm<\/pre>\n<p>&nbsp;<\/p>\n<p>This means truncate\u00a0<i>\u00a0testbigfile.ibd.rm<\/i>\u00a0 for 1GB per time. Then we can run this\u00a0command multiple times during low load until the file is empty, and use <em>rm<\/em> command to remove the file at last.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1344\" class=\"pvc_stats all  \" data-element-id=\"1344\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description: Drop tables is such a common\u00a0content of a DBA&#8217;s daily work. Drop a small table( such as less than 100 Mega Bytes ), we can just do DROP\u00a0operations during low load. But in most\u00a0situations, the tables are more than 100MB, even reach to 100GB(called large table). Then if you drop this kind of tables( &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1344\" class=\"pvc_stats all  \" data-element-id=\"1344\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":50,"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":[7],"tags":[1341],"class_list":["post-1344","post","type-post","status-publish","format-standard","","category-mysql","tag-drop-table"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":4351,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL-How to drop a large table gracefully? - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL-How to drop a large table gracefully? - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-07T02:23:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T13:37:49+00:00\" \/>\n<meta name=\"author\" content=\"Shuo Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shuo Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\"},\"author\":{\"name\":\"Shuo Wang\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\"},\"headline\":\"MySQL-How to drop a large table gracefully?\",\"datePublished\":\"2018-08-07T02:23:24+00:00\",\"dateModified\":\"2018-11-09T13:37:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\"},\"wordCount\":413,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"drop table\"],\"articleSection\":[\"MySQL-MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\",\"name\":\"MySQL-How to drop a large table gracefully? - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-07T02:23:24+00:00\",\"dateModified\":\"2018-11-09T13:37:49+00:00\",\"description\":\"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL-How to drop a large table gracefully?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289\",\"name\":\"Shuo Wang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g\",\"caption\":\"Shuo Wang\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/shuowang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL-How to drop a large table gracefully? - Database Tutorials","description":"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.","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:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/","og_locale":"en_US","og_type":"article","og_title":"MySQL-How to drop a large table gracefully? - Database Tutorials","og_description":"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-07T02:23:24+00:00","article_modified_time":"2018-11-09T13:37:49+00:00","author":"Shuo Wang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shuo Wang","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/"},"author":{"name":"Shuo Wang","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289"},"headline":"MySQL-How to drop a large table gracefully?","datePublished":"2018-08-07T02:23:24+00:00","dateModified":"2018-11-09T13:37:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/"},"wordCount":413,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["drop table"],"articleSection":["MySQL-MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/","name":"MySQL-How to drop a large table gracefully? - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-07T02:23:24+00:00","dateModified":"2018-11-09T13:37:49+00:00","description":"This article introduces how to drop a large table gracefully, which means the DROP process can be quickly finished and invisible to MySQL server, in the meanwhile, avoiding the disk I\/O overloaded.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/07\/mysql-how-to-drop-a-large-table-gracefully\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"MySQL-How to drop a large table gracefully?"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/83d7028b846c78bfd03244ec6cd04289","name":"Shuo Wang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da30aa3d0157ae5f1f853927f56b868cfb1d801888eb954768c471e5d41cdd87?s=96&d=mm&r=g","caption":"Shuo Wang"},"url":"https:\/\/dbtut.com\/index.php\/author\/shuowang\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1344"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1344\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}