{"id":416,"date":"2012-05-31T21:44:09","date_gmt":"2012-05-31T21:44:09","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=416"},"modified":"2022-06-03T03:52:29","modified_gmt":"2022-06-03T08:52:29","slug":"mysql-performance-optimization","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/","title":{"rendered":"MySQL Performance Optimization"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><a href=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png\"><img decoding=\"async\" class=\"alignleft wp-image-417\" title=\"mysql-logo\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo-300x174.png\" alt=\"\" width=\"240\" height=\"139\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo-300x174.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png 400w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/><\/a>MySQL has two primary storage engines: MyISAM and InnoDB.<br \/>\nEach has its own performance characteristics and considerations but generally MyISAM is good for read-intensive data and InnoDB is good for transactional data.<\/p>\n<p>&nbsp;<\/p>\n<p><!--more-->Use the following simple guidelines to tune your MySQL Server&#8217;s performance:<\/p>\n<p>Run &#8216;OPTIMIZE TABLE&#8217; and &#8216;REPAIR TABLE&#8217; operations regularly to keep things running smoothly. You can use the MySQL &#8216;OPTIMIZE TABLE&#8217; command to effectively defragment a mysql table and increase the loading speed of your database. This command is very useful for tables which are frequently updated.<\/p>\n<pre class=\"brush: bash; gutter: false\">mysql&gt; OPTIMIZE TABLE demo;\r\n\r\n+-----------------------+----------+----------+----------+\r\n| Table\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Op\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Msg_type | Msg_text |\r\n+-----------------------+----------+----------+----------+\r\n| vps.demo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | optimize | status\u00a0\u00a0 | OK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n+-----------------------+----------+----------+----------+\r\n1 row in set (1.57 sec)<\/pre>\n<p>This has the effect of defragmenting the table and reducing the size of the table on disk. It also has a very positive effect on query performance, reducing the select query response time.<br \/>\nIf you have the DirectAdmin control panel installed on your server, you can optimize the MySQL databases using the following command:<\/p>\n<pre class=\"brush: bash; gutter: false\">mysqlcheck --defaults-extra-file=\/usr\/local\/directadmin\/conf\/my.cnf\r\n--auto-repair --optimize --all-databases<\/pre>\n<p>Make sure you have optimized all your queries first, and ensure that your tables are indexed properly for MySQL to use.<\/p>\n<p>Enable the slow query log. The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization.<br \/>\nEdit the\u00a0&#8216;\/etc\/my.cnf &#8216; MySQL configuration file (or &#8216;\/etc\/mysql\/my.cnf&#8217; on <a title=\"Debian VPS\" href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Debian<\/a> based distros) and add\/uncomment the following lines:<\/p>\n<pre class=\"brush: bash; gutter: false\">slow_query_log=1\r\nslow_query_log_file=\/var\/log\/mysql-slow_query.log\r\nlong_query_time=3<\/pre>\n<p>Note that in MySQL versions prior to 5.5 the syntax is slightly different, so add\/uncomment the following lines in &#8216;my.cnf&#8217; configuration file:<\/p>\n<pre class=\"brush: bash; gutter: false\">log_slow_queries=1\r\nlog_slow_queries=\/var\/log\/mysql-slow_query.log\r\nlong_query_time=3<\/pre>\n<p>Restart the MySQL server for the changes to take effect. This enables logging of slow queries. After enabling slow query log, MySQL will create, capture and log to the log file all the SQL statements that took more than 3 seconds to execute, which is by default set to 10 seconds. The overall MySQL and server performance will increase significantly by lowering the number of slow queries.<\/p>\n<p>After these optimization steps, the MySQL service will take much less time to query your database which will result in better performance of your website scripts.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL has two primary storage engines: MyISAM and InnoDB. Each has its own performance characteristics and considerations but generally MyISAM &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MySQL Performance Optimization\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#more-416\" aria-label=\"Read more about MySQL Performance Optimization\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":417,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1704,21],"tags":[82,48,81,84,39,1152,85,83],"class_list":["post-416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-optimization","category-tips-and-tricks","tag-database-engine","tag-debian","tag-innodb","tag-myisam","tag-mysql","tag-rosehosting","tag-sql","tag-tables","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MySQL Performance Optimization | RoseHosting<\/title>\n<meta name=\"description\" content=\"MySQL Performance Optimization | RoseHosting\" \/>\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.rosehosting.com\/blog\/mysql-performance-optimization\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Performance Optimization\" \/>\n<meta property=\"og:description\" content=\"MySQL Performance Optimization | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-31T21:44:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:52:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"232\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\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:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MySQL Performance Optimization\",\"datePublished\":\"2012-05-31T21:44:09+00:00\",\"dateModified\":\"2022-06-03T08:52:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/\"},\"wordCount\":363,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/mysql-logo.png\",\"keywords\":[\"Database engine\",\"debian\",\"InnoDB\",\"MyISAM\",\"mysql\",\"rosehosting\",\"SQL\",\"Tables\"],\"articleSection\":[\"Databases\",\"Optimization\",\"Tips and Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/\",\"name\":\"MySQL Performance Optimization | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/mysql-logo.png\",\"datePublished\":\"2012-05-31T21:44:09+00:00\",\"dateModified\":\"2022-06-03T08:52:29+00:00\",\"description\":\"MySQL Performance Optimization | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/mysql-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2012\\\/05\\\/mysql-logo.png\",\"width\":\"400\",\"height\":\"232\",\"caption\":\"mysql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/mysql-performance-optimization\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Performance Optimization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Performance Optimization | RoseHosting","description":"MySQL Performance Optimization | RoseHosting","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.rosehosting.com\/blog\/mysql-performance-optimization\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Performance Optimization","og_description":"MySQL Performance Optimization | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2012-05-31T21:44:09+00:00","article_modified_time":"2022-06-03T08:52:29+00:00","og_image":[{"width":400,"height":232,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png","type":"image\/png"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MySQL Performance Optimization","datePublished":"2012-05-31T21:44:09+00:00","dateModified":"2022-06-03T08:52:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/"},"wordCount":363,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png","keywords":["Database engine","debian","InnoDB","MyISAM","mysql","rosehosting","SQL","Tables"],"articleSection":["Databases","Optimization","Tips and Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/","url":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/","name":"MySQL Performance Optimization | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png","datePublished":"2012-05-31T21:44:09+00:00","dateModified":"2022-06-03T08:52:29+00:00","description":"MySQL Performance Optimization | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2012\/05\/mysql-logo.png","width":"400","height":"232","caption":"mysql"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/mysql-performance-optimization\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Performance Optimization"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/416\/revisions"}],"predecessor-version":[{"id":42318,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/416\/revisions\/42318"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/417"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}