{"id":6782,"date":"2024-03-14T04:40:51","date_gmt":"2024-03-14T04:40:51","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/"},"modified":"2025-08-02T08:06:26","modified_gmt":"2025-08-02T08:06:26","slug":"what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/","title":{"rendered":"MyBatis Second-Level Cache: Pros & Cons"},"content":{"rendered":"

The second-level cache in MyBatis refers to caching at the Mapper level to cache query results, reducing the number of database accesses, and improving system performance. Its advantages and disadvantages are as follows:<\/p>\n

Advantages:<\/p>\n

    \n
  1. Reduce the number of database accesses to improve system performance: Secondary caching can store query results, allowing for data to be retrieved directly from the cache when the same query request is made, reducing the number of database accesses and enhancing system performance.<\/li>\n
  2. Improving data consistency: By default, MyBatis’s second-level cache is transactional, ensuring data consistency within the same transaction.<\/li>\n
  3. Simple Configuration: MyBatis’s second-level cache can be easily enabled or disabled through simple configuration.<\/li>\n<\/ol>\n

    Cons:<\/p>\n

      \n
    1. Data not updated in time: The secondary cache is shared under the same SqlSessionFactory, so when one session makes changes to the data, other sessions may not be aware of the changes, leading to delayed data updates.<\/li>\n
    2. High memory usage: Secondary cache is stored in memory, if the cache data is large, it will occupy a significant amount of memory.<\/li>\n
    3. The MyBatis second-level cache requires manual refreshing. When data changes, you need to manually clear or refresh the cache.<\/li>\n<\/ol>\n

      Overall, MyBatis’s second-level cache can improve system performance, but it also has some drawbacks, so developers need to decide whether to use it based on specific scenarios.<\/p>\n","protected":false},"excerpt":{"rendered":"

      The second-level cache in MyBatis refers to caching at the Mapper level to cache query results, reducing the number of database accesses, and improving system performance. Its advantages and disadvantages are as follows: Advantages: Reduce the number of database accesses to improve system performance: Secondary caching can store query results, allowing for data to be […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1682,515,1459,8414,8375],"class_list":["post-6782","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-caching","tag-database-performance","tag-mybatis","tag-orm-optimization","tag-second-level-cache"],"yoast_head":"\nMyBatis Second-Level Cache: Pros & Cons - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.\" \/>\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.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis Second-Level Cache: Pros & Cons\" \/>\n<meta property=\"og:description\" content=\"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T04:40:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T08:06:26+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"MyBatis Second-Level Cache: Pros & Cons\",\"datePublished\":\"2024-03-14T04:40:51+00:00\",\"dateModified\":\"2025-08-02T08:06:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\"},\"wordCount\":223,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"caching\",\"Database Performance\",\"MyBatis\",\"ORM Optimization\",\"second-level cache\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\",\"name\":\"MyBatis Second-Level Cache: Pros & Cons - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T04:40:51+00:00\",\"dateModified\":\"2025-08-02T08:06:26+00:00\",\"description\":\"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis Second-Level Cache: Pros & Cons\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MyBatis Second-Level Cache: Pros & Cons - Blog - Silicon Cloud","description":"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.","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.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/","og_locale":"en_US","og_type":"article","og_title":"MyBatis Second-Level Cache: Pros & Cons","og_description":"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T04:40:51+00:00","article_modified_time":"2025-08-02T08:06:26+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"MyBatis Second-Level Cache: Pros & Cons","datePublished":"2024-03-14T04:40:51+00:00","dateModified":"2025-08-02T08:06:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/"},"wordCount":223,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["caching","Database Performance","MyBatis","ORM Optimization","second-level cache"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/","name":"MyBatis Second-Level Cache: Pros & Cons - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T04:40:51+00:00","dateModified":"2025-08-02T08:06:26+00:00","description":"Discover MyBatis second-level cache benefits and drawbacks. Optimize database performance with caching insights.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-the-advantages-and-disadvantages-of-mybatiss-second-level-cache\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MyBatis Second-Level Cache: Pros & Cons"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=6782"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6782\/revisions"}],"predecessor-version":[{"id":151552,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6782\/revisions\/151552"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=6782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=6782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=6782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}