{"id":2620,"date":"2020-09-14T13:37:54","date_gmt":"2020-09-14T11:37:54","guid":{"rendered":"https:\/\/geko2.factoryfy.com\/rds-performance-issues-by-iops-on-gp-ssd\/"},"modified":"2021-11-03T18:30:47","modified_gmt":"2021-11-03T17:30:47","slug":"rds-performance-issues-by-iops-on-gp-ssd","status":"publish","type":"post","link":"https:\/\/geko.cloud\/en\/rds-performance-issues-by-iops-on-gp-ssd\/","title":{"rendered":"RDS performance issues by IOPS on GP SSD"},"content":{"rendered":"<p>We want to share with you a problem that we have recently solved with a project.<\/p>\n<p>RDS is the managed database service offered by AWS that solves the main management, operation and maintenance problems involved in having a relational database platform. With RDS everything is very simple, you guarantee the service and the operative allowing to grow and to decrease according to necessity.<\/p>\n<p>In addition Amazon has its own engine based on Mysql, Aurora that even allows to have a serverless database platform! Which we will talk about in another post later.<\/p>\n<p>&nbsp;<\/p>\n<h3>The scenario we face<\/h3>\n<p>A client with its full AWS-based platform with all its relational databases using RDS manifests in one of its platforms performance problems, crashes, wandering and unpredictable behavior etc.<\/p>\n<p>It turns out that this problem does not occur from the beginning but at a certain point in time it started to degrade until it became a real problem. We appreciate that RDS was deployed using T3 bursting instance where credits seemed to decrease periodically.<\/p>\n<p>We decided to change the instance to type M5 to have a better performance and resource availability . The performance improves very significantly until we noticed the following:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/rds-disk-latency.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2603\" src=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/rds-disk-latency.png\" alt=\"\" width=\"740\" height=\"262\" \/><\/a><a href=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/queuerdsaws.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2604\" src=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/queuerdsaws.png\" alt=\"\" width=\"518\" height=\"272\" \/><\/a><\/p>\n<p>The metrics continue to warn that there is write\/read latency and IOPS are glued. How is this possible in a general purpose SSD?<\/p>\n<p>The metric that for us is important to follow in any RDS is the one referring to the Disk QueueDepth, this metric indicates the size of the queue that the system has waiting to be processed in disk IO operation, that is, the debt in disk operations that the system has. Read Write disk latencies are nothing more than mirages of this fact.<\/p>\n<p>&nbsp;<\/p>\n<h3>The solution<\/h3>\n<p>The explanation is simple, AWS RDS provides a total of<strong> 3 IOPS\/Gb<\/strong> depending on the size of the EBS disk that is created. The client RDS was created with <strong>20Gb total size = 60 IOPS<\/strong> , which <strong>AWS by default always provides a minimum of 100 IOPS<\/strong>.<\/p>\n<p>This explained why the <strong>CPU and RAM were not affected<\/strong> but the performance as such was.<\/p>\n<p>As we detected the bottleneck, we simply proceeded to expand via Terraform the size of the associated <strong>EBS volume to 100Gb with its corresponding 300IOPS (three times as before)<\/strong>.<\/p>\n<p>The result here you have it :<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/readwritelatencyafterebs.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2605\" src=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/readwritelatencyafterebs.png\" alt=\"\" width=\"756\" height=\"270\" \/><\/a><a href=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/rdsquesolvedissue.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2606\" src=\"https:\/\/geko2.factoryfy.com\/wp-content\/uploads\/rdsquesolvedissue.png\" alt=\"\" width=\"519\" height=\"274\" \/><\/a><\/p>\n<p>Nothing more to add, no more latencies, no more blockages and no more problems with this platform, we leave you the link to the official <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/CHAP_Storage.html\">AWS documentation on RDS and EBS<\/a><\/p>\n<p>Remember that for productive environments, the recommendation is always to provide at least 100Gb per disk (even if we don&#8217;t need it) to obtain those 300 IOPS minimum.<\/p>\n<p>Remember that<a href=\"https:\/\/geko.cloud\/en\/contact\/\"> at Geko we are still at your disposal to help you<\/a> with any performance problems you may have with your platform.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We want to share with you a problem that we have recently solved with a project. RDS is the managed database service offered by AWS that solves the main management, operation and maintenance problems involved in having a relational database platform. With RDS everything is very simple, you guarantee the service and the operative allowing [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[67],"tags":[72,85],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RDS performance issues by IOPS on GP SSD - Geko Cloud<\/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:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RDS performance issues by IOPS on GP SSD - Geko Cloud\" \/>\n<meta property=\"og:description\" content=\"We want to share with you a problem that we have recently solved with a project. RDS is the managed database service offered by AWS that solves the main management, operation and maintenance problems involved in having a relational database platform. With RDS everything is very simple, you guarantee the service and the operative allowing [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\" \/>\n<meta property=\"og:site_name\" content=\"Geko Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-14T11:37:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-03T17:30:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"299\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jose Luis S\u00e1nchez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@geko_cloud\" \/>\n<meta name=\"twitter:site\" content=\"@geko_cloud\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\"},\"author\":{\"name\":\"Jose Luis S\u00e1nchez\",\"@id\":\"https:\/\/geko.cloud\/es\/#\/schema\/person\/d06aff498ebfbc75b5010ebe92af41ed\"},\"headline\":\"RDS performance issues by IOPS on GP SSD\",\"datePublished\":\"2020-09-14T11:37:54+00:00\",\"dateModified\":\"2021-11-03T17:30:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\"},\"wordCount\":472,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/geko.cloud\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png\",\"keywords\":[\"AWS\",\"MySQL\"],\"articleSection\":[\"Labs\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\",\"url\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\",\"name\":\"RDS performance issues by IOPS on GP SSD - Geko Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/geko.cloud\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png\",\"datePublished\":\"2020-09-14T11:37:54+00:00\",\"dateModified\":\"2021-11-03T17:30:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage\",\"url\":\"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png\",\"contentUrl\":\"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png\",\"width\":750,\"height\":299,\"caption\":\"RDS performance purpose\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/geko.cloud\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RDS performance issues by IOPS on GP SSD\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/geko.cloud\/es\/#website\",\"url\":\"https:\/\/geko.cloud\/es\/\",\"name\":\"Geko Cloud\",\"description\":\"Servicios de consultor\u00eda cloud y devops\",\"publisher\":{\"@id\":\"https:\/\/geko.cloud\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/geko.cloud\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/geko.cloud\/es\/#organization\",\"name\":\"Geko Cloud\",\"url\":\"https:\/\/geko.cloud\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/geko.cloud\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/geko.cloud\/wp-content\/uploads\/2021\/10\/geko_logo-positivo.png\",\"contentUrl\":\"https:\/\/geko.cloud\/wp-content\/uploads\/2021\/10\/geko_logo-positivo.png\",\"width\":1650,\"height\":809,\"caption\":\"Geko Cloud\"},\"image\":{\"@id\":\"https:\/\/geko.cloud\/es\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/geko_cloud\",\"https:\/\/www.instagram.com\/gekocloud\/\",\"https:\/\/www.linkedin.com\/company\/gekocloud\",\"https:\/\/www.youtube.com\/channel\/UC5EFLCqUM7fEaXSa_0nWowQ\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/geko.cloud\/es\/#\/schema\/person\/d06aff498ebfbc75b5010ebe92af41ed\",\"name\":\"Jose Luis S\u00e1nchez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/geko.cloud\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ebfd055d4dba456220c682523fcc237c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ebfd055d4dba456220c682523fcc237c?s=96&d=mm&r=g\",\"caption\":\"Jose Luis S\u00e1nchez\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RDS performance issues by IOPS on GP SSD - Geko Cloud","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:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/","og_locale":"en_US","og_type":"article","og_title":"RDS performance issues by IOPS on GP SSD - Geko Cloud","og_description":"We want to share with you a problem that we have recently solved with a project. RDS is the managed database service offered by AWS that solves the main management, operation and maintenance problems involved in having a relational database platform. With RDS everything is very simple, you guarantee the service and the operative allowing [&hellip;]","og_url":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/","og_site_name":"Geko Cloud","article_published_time":"2020-09-14T11:37:54+00:00","article_modified_time":"2021-11-03T17:30:47+00:00","og_image":[{"width":750,"height":299,"url":"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png","type":"image\/png"}],"author":"Jose Luis S\u00e1nchez","twitter_card":"summary_large_image","twitter_creator":"@geko_cloud","twitter_site":"@geko_cloud","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#article","isPartOf":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/"},"author":{"name":"Jose Luis S\u00e1nchez","@id":"https:\/\/geko.cloud\/es\/#\/schema\/person\/d06aff498ebfbc75b5010ebe92af41ed"},"headline":"RDS performance issues by IOPS on GP SSD","datePublished":"2020-09-14T11:37:54+00:00","dateModified":"2021-11-03T17:30:47+00:00","mainEntityOfPage":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/"},"wordCount":472,"commentCount":0,"publisher":{"@id":"https:\/\/geko.cloud\/es\/#organization"},"image":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage"},"thumbnailUrl":"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png","keywords":["AWS","MySQL"],"articleSection":["Labs"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/","url":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/","name":"RDS performance issues by IOPS on GP SSD - Geko Cloud","isPartOf":{"@id":"https:\/\/geko.cloud\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage"},"image":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage"},"thumbnailUrl":"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png","datePublished":"2020-09-14T11:37:54+00:00","dateModified":"2021-11-03T17:30:47+00:00","breadcrumb":{"@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#primaryimage","url":"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png","contentUrl":"https:\/\/geko.cloud\/wp-content\/uploads\/rdsssdperfornaceissue.png","width":750,"height":299,"caption":"RDS performance purpose"},{"@type":"BreadcrumbList","@id":"https:\/\/geko.cloud\/es\/problemas-rendimiento-rds-iops-gp-ssd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/geko.cloud\/en\/"},{"@type":"ListItem","position":2,"name":"RDS performance issues by IOPS on GP SSD"}]},{"@type":"WebSite","@id":"https:\/\/geko.cloud\/es\/#website","url":"https:\/\/geko.cloud\/es\/","name":"Geko Cloud","description":"Servicios de consultor\u00eda cloud y devops","publisher":{"@id":"https:\/\/geko.cloud\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/geko.cloud\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/geko.cloud\/es\/#organization","name":"Geko Cloud","url":"https:\/\/geko.cloud\/es\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/geko.cloud\/es\/#\/schema\/logo\/image\/","url":"https:\/\/geko.cloud\/wp-content\/uploads\/2021\/10\/geko_logo-positivo.png","contentUrl":"https:\/\/geko.cloud\/wp-content\/uploads\/2021\/10\/geko_logo-positivo.png","width":1650,"height":809,"caption":"Geko Cloud"},"image":{"@id":"https:\/\/geko.cloud\/es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/geko_cloud","https:\/\/www.instagram.com\/gekocloud\/","https:\/\/www.linkedin.com\/company\/gekocloud","https:\/\/www.youtube.com\/channel\/UC5EFLCqUM7fEaXSa_0nWowQ"]},{"@type":"Person","@id":"https:\/\/geko.cloud\/es\/#\/schema\/person\/d06aff498ebfbc75b5010ebe92af41ed","name":"Jose Luis S\u00e1nchez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/geko.cloud\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ebfd055d4dba456220c682523fcc237c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ebfd055d4dba456220c682523fcc237c?s=96&d=mm&r=g","caption":"Jose Luis S\u00e1nchez"}}]}},"_links":{"self":[{"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/posts\/2620"}],"collection":[{"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/comments?post=2620"}],"version-history":[{"count":2,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/posts\/2620\/revisions"}],"predecessor-version":[{"id":5240,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/posts\/2620\/revisions\/5240"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/media\/2213"}],"wp:attachment":[{"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/media?parent=2620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/categories?post=2620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geko.cloud\/en\/wp-json\/wp\/v2\/tags?post=2620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}