{"id":3528,"date":"2013-04-09T13:44:38","date_gmt":"2013-04-09T13:44:38","guid":{"rendered":"https:\/\/bodhost.com\/kb\/?p=3528"},"modified":"2026-02-26T14:04:33","modified_gmt":"2026-02-26T14:04:33","slug":"mysql-optimization","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/","title":{"rendered":"MySQL Optimization"},"content":{"rendered":"\r\n<h4><strong><span style=\"font-size: 20pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Optimization in MySQL involves three components:<\/span><\/strong><\/h4>\r\n\r\n\r\n\r\n<ul>\r\n<li>Optimizing the MySQL Server<\/li>\r\n<li>Optimizing the database<\/li>\r\n<li>Query Optimization<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Optimizing the configuration of MySQL<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>Server optimization includes a variety of approaches and methods, what I am trying to present here is an introduction to the basic approaches:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Server compilation<\/li>\r\n<li>Tuning server parameters<\/li>\r\n<li>Tuning other parameters<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>To perform a good quality optimization, proceed by a practical methodology to modify data one by one and test each time result of the system to have an idea about the report. Measure the system performance before and after performing the optimization to check whether the system has optimized or not.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Server Compilation<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>It is recommended to use the source code version of the MySQL server and compile taking into account various system parameters to know the character set to use the microprocessor on which it will turn and use an appropriate compiler (Ex for pgcc Pentium microprocessors).<\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Tuning Server Parameters<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>It is possible to optimize the operation of MySQL by changing the values of the server parameters.<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>To view the settings you must use the command: mysql&gt; SHOW VARIABLES;<\/li>\r\n<li>To see the effect of the parameters on the server you must run the command: mysql&gt; SHOW STATUS;<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>There are many monitoring tools to see the effects of the changes made to the settings on the receiver that are equivalent to the Mytop MySQL Monitoring Tool.<\/p>\r\n\r\n\r\n\r\n<p>Note: my.cnf file contains all the parameters which you want to optimize.<\/p>\r\n\r\n\r\n\r\n<p>As a first step, it is possible to start with the memory manager settings. The guiding principle is that if the server has more memory the faster it goes, however, we must ensure that the memory is available.<\/p>\r\n\r\n\r\n\r\n<p>Mysql contains a set of InnoDB buffer pool sizes and it is also possible to configure the space allocated in Cache from the variables of my.cnf. The two most important variables \u201ckey_buffer_size\u201d and \u201ctable_cache\u201d shared by all threads running on the server and significantly influence the performance.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Example of variables:<\/span><\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>key_buffer_size: memory used for backups of MyISAM indexes.<\/li>\r\n<li>table_cache:number of working tables simultaneously.<\/li>\r\n<li>read_buffer_size: memory used for saving data from full table scans.<\/li>\r\n<li>sort_buffer_size: memory used for storing data tables that sorted by order.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Tuning other parameters<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>The MySQL server is recommended for optimum performance on Solaris OS, however, it is possible to optimize it on other OS to be closer to its ideal performance.\r\n\r\n<\/li>\r\n<li>RAID-0 is recommended for optimizing operations to read and write. And the use of SCSI rather than IDE drivers.\r\n\r\n<\/li>\r\n<li>Using fast networks optimizes response time and the communication between client\/server and master\/slave server replication.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 20pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Optimizing the database<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>Generally for optimizing databases, we look to the best practices and design methodologies for databases that can implement database schemas and perform standard data. However, this requires:<\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Understand what is slow in databases<\/li>\r\n<li>Modeling the database<\/li>\r\n<li>Using Indexes<\/li>\r\n<li>Use OPTIMIZE TABLE<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">What slowed the database<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>A number of factors are usually the cause of the slow database. We include the following most common areas:\r\n\r\n<\/li>\r\n<li>Not enough indexes: The primary cause of slowness is the use of tables without indexes or no indexes on columns involved in the research. This does not mean that all tables must have indexes but must consider the needs of indexing.\r\n\r\n<\/li>\r\n<li>Excessive use of indexes: The increase in the number of indexes affects the performance level of updates, in fact, during the update of a table the add operations, modification, and deletion generally affect the indexes.\r\n\r\n<\/li>\r\n<li>Unnecessary privileges on tables and columns: Each MySQL access privilege checks the tables and columns of a table which considerably slows down the performance.\r\n\r\n<\/li>\r\n<li>Incorrect choices in the design of the database.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Modeling the database:<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Use the best practices for modeling and database design and the choice of the appropriate methodology used to implement database performance.\r\n\r\n<\/li>\r\n<li>Many considerations should be taken as:\r\n\r\n<\/li>\r\n<li>Appropriate choice of field types: always try to choose the most appropriate variables needed (e.g. For storing a number do not use more than 10 digits, even it is better to use a TINYINT deviation). Use the smaller fields for columns.\r\n\r\n<\/li>\r\n<li>Use fixed-length fields: the use of predetermined lengths to optimize access to columns because their positions are predefined. This involves reducing the use of VARCHAR, TEXT, and BLOB (for TEXT and BLOB, it is recommended to break the normalization of the database schema and data to back up these fields in third tables).<\/li>\r\n<li>Increase the use of NOT NULL when it is possible to optimize the storage space.<br \/>Choosing the right type for tables: MySQL allows you to have the same table schema types.<br \/>Make good indexing tables.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Using indexes<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>An index is a look-up table that allows us to quickly find rows in a table. The indexes used to determine the position of the record sought at a table. Indexes in MySQL stored form of b-trees (binary trees), which is a data structure easy to navigate.<\/p>\r\n\r\n\r\n\r\n<p>The index includes single or multiple columns, the index called during a search on indexed columns. The basic idea to remember is that if a search is common and it included one or more columns, one must create the indexes corresponding to optimize the response time via the command CREATE INDEX.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 16pt; line-height: 115%; font-family: 'Arial','sans-serif';\">Using OPTIMIZE TABLE<\/span><b style=\"mso-bidi-font-weight: normal;\"><\/b><\/p>\r\n\r\n\r\n\r\n<p>Equivalent to disk defragmentation, OPTIMIZE TABLE for fragmenting tables.<\/p>\r\n\r\n\r\n\r\n<p>Query Optimization:\u00a0 MySQL can analyze queries and know the time and the execution plan. Such information can include slow queries and optimize execution.<\/p>\r\n\r\n\r\n\r\n<p><span style=\"font-size: 20pt; font-family: 'Arial','sans-serif';\">Detecting slow queries<\/span><span style=\"font-size: 20pt; font-family: 'Arial','sans-serif';\">:<\/span><\/p>\r\n\r\n\r\n\r\n<ul>\r\n<li>Observe delays in executions and abnormal response time<\/li>\r\n<li>Or to make a benchmark: test applications to see what components are slower.<\/li>\r\n<li>Or check the Slow query log: it is possible to activate this option in MySQL setting variable &#8211; log-slow-queries<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>Once slow queries, run EXPLAIN to understand the performance.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Optimization in MySQL involves three components: Optimizing the MySQL Server Optimizing the database Query Optimization Optimizing the configuration of MySQL Server optimization includes a variety of approaches and methods, what&hellip;<\/p>\n<p><a href=\"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/\" class=\"more-link\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[664],"tags":[461,462],"class_list":["post-3528","post","type-post","status-publish","format-standard","hentry","category-web-hosting","tag-mysql-optimization","tag-mysql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL Performance Tuning: Optimize Your Database<\/title>\n<meta name=\"description\" content=\"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Performance Tuning: Optimize Your Database\" \/>\n<meta property=\"og:description\" content=\"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-09T13:44:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:04:33+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/c48414ad1536cea20e85282b0737a9f9\"},\"headline\":\"MySQL Optimization\",\"datePublished\":\"2013-04-09T13:44:38+00:00\",\"dateModified\":\"2026-02-26T14:04:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/\"},\"wordCount\":966,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"keywords\":[\"mysql optimization\",\"mysql server\"],\"articleSection\":[\"Web Hosting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/\",\"name\":\"MySQL Performance Tuning: Optimize Your Database\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2013-04-09T13:44:38+00:00\",\"dateModified\":\"2026-02-26T14:04:33+00:00\",\"description\":\"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/mysql-optimization\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Web Hosting\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/web-hosting\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Optimization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/c48414ad1536cea20e85282b0737a9f9\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Performance Tuning: Optimize Your Database","description":"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.","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:\/\/www.bodhost.com\/kb\/mysql-optimization\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Performance Tuning: Optimize Your Database","og_description":"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.","og_url":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2013-04-09T13:44:38+00:00","article_modified_time":"2026-02-26T14:04:33+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/"},"author":{"name":"admin","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/c48414ad1536cea20e85282b0737a9f9"},"headline":"MySQL Optimization","datePublished":"2013-04-09T13:44:38+00:00","dateModified":"2026-02-26T14:04:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/"},"wordCount":966,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"keywords":["mysql optimization","mysql server"],"articleSection":["Web Hosting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/","url":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/","name":"MySQL Performance Tuning: Optimize Your Database","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"datePublished":"2013-04-09T13:44:38+00:00","dateModified":"2026-02-26T14:04:33+00:00","description":"Optimize your MySQL database with performance tuning tips. Improve query, indexing, and configuration for faster, more efficient database operations.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/mysql-optimization\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/mysql-optimization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Web Hosting","item":"https:\/\/www.bodhost.com\/kb\/category\/web-hosting\/"},{"@type":"ListItem","position":2,"name":"MySQL Optimization"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/c48414ad1536cea20e85282b0737a9f9","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51e53199212db3f59606920448d45a6ead224f904558e3ab9251d071a609b202?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.bodhost.com\/kb\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/3528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=3528"}],"version-history":[{"count":14,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/3528\/revisions"}],"predecessor-version":[{"id":13958,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/3528\/revisions\/13958"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=3528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=3528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=3528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}