{"id":7117,"date":"2023-11-01T09:41:21","date_gmt":"2023-11-01T09:41:21","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=7117"},"modified":"2023-11-01T09:41:24","modified_gmt":"2023-11-01T09:41:24","slug":"mysql-mariadb-performance-tuning-mysqltuner","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/","title":{"rendered":"MySQL &#038; MariaDB Performance Tuning using Mysqltuner"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en.jpg\" alt=\"optimize mysql with Mysqltuner perl script command line interface on Ubuntu\/Debian CentOS\/RedHat showing sample output report\" class=\"wp-image-7134\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<p>MySQL and MariaDB are one of the most popular open source relational database management systems. It powers many of the world&#8217;s most visited web services and applications. As usage grows, performance tuning becomes essential to optimize MySQL and avoid issues like slow queries.<\/p>\n\n\n\n<p>Mysqltuner is an open source Perl script that helps analyze and tune MySQL performance. It provides configuration and performance recommendations to optimize MySQL. In this comprehensive guide, we will cover:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"overview-of-mysqltuner\">Overview of mysqltuner<\/h2>\n\n\n\n<p>mysqltuner is a Perl script written and maintained by Major Hayden. It connects to MySQL, runs diagnostics, and provides configuration and tuning advice for improved performance.<\/p>\n\n\n\n<p>Key features of mysqltuner include:<\/p>\n\n\n\n<ul>\n<li>Quickly diagnose MySQL performance issues<\/li>\n\n\n\n<li>Suggest configuration changes for increased performance<\/li>\n\n\n\n<li>Recommend hardware upgrades for large installations<\/li>\n\n\n\n<li>Monitor memory, temporary tables, table cache hit rate, open files, and other metrics<\/li>\n\n\n\n<li>Estimate growth trends using historical statistics<\/li>\n\n\n\n<li>Generate a report with all metrics and advice<\/li>\n<\/ul>\n\n\n\n<p>mysqltuner is easy to use and provides clear, actionable recommendations. It is a valuable tool for MySQL performance monitoring and tuning.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"installing-mysqltuner\">Installing mysqltuner<\/h2>\n\n\n\n<p>mysqltuner is a standalone Perl script. To install it:<\/p>\n\n\n\n<ul>\n<li>Install Perl if it is not already installed:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo apt install perl<\/code><\/pre>\n\n\n\n<ul>\n<li>Download the latest mysqltuner script:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ wget https:\/\/raw.githubusercontent.com\/major\/MySQLTuner-perl\/master\/mysqltuner.pl<\/code><\/pre>\n\n\n\n<ul>\n<li>Make the script executable:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ chmod +x mysqltuner.pl<\/code><\/pre>\n\n\n\n<ul>\n<li>Optionally rename and move the script:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo mv mysqltuner.pl \/usr\/local\/bin\/mysqltuner<\/code><\/pre>\n\n\n\n<p>Now mysqltuner is installed and ready to use!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"using-mysqltuner-for-performance-tuning\">Using mysqltuner for performance tuning<\/h2>\n\n\n\n<p>Using mysqltuner is simple. Just run the script with your MySQL credentials:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqltuner --host localhost --user root --pass password<\/code><\/pre>\n\n\n\n<p>This will connect to the MySQL server on localhost as the root user, run diagnostics, and print a report.<\/p>\n\n\n\n<p>To save the report to a file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysqltuner --host localhost --user root --pass password &gt; mysqlreport.txt<\/code><\/pre>\n\n\n\n<p>Key options include:<\/p>\n\n\n\n<ul>\n<li><code>--host<\/code>\u2063 \u2013 MySQL hostname<\/li>\n\n\n\n<li><code>--user<\/code>\u2063 \u2013 MySQL username<\/li>\n\n\n\n<li><code>--pass<\/code>\u2063 \u2013 MySQL password<\/li>\n\n\n\n<li><code>--silent<\/code>\u2063 \u2013 Hide progress dots during processing<\/li>\n\n\n\n<li><code>--nobad<\/code>\u2063 \u2013 Remove bad advice from final report<\/li>\n\n\n\n<li><code>--nogood<\/code>\u2063 \u2013 Remove good advice from final report<\/li>\n\n\n\n<li><code>--forcemem<\/code>\u2063 \u2013 Amount of RAM installed in megabytes<\/li>\n<\/ul>\n\n\n\n<p>Review the report for performance advice and apply the recommendations. Rerun mysqltuner periodically to monitor changes over time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"interpreting-mysqltuner-recommendations\">Interpreting mysqltuner Recommendations<\/h2>\n\n\n\n<p>The mysqltuner report contains many metrics and suggestions. Here are some key areas to focus on:<\/p>\n\n\n\n<p><strong>Performance Metrics<\/strong><\/p>\n\n\n\n<ul>\n<li>Uptime \u2013 How long MySQL has been running uninterrupted. Long uptimes indicate stability.<\/li>\n\n\n\n<li>Total buffers \u2013 Total memory allocated to cache indexes and tables. Higher is better.<\/li>\n\n\n\n<li>Open files \u2013 Number of open files. Many open files could indicate index issues.<\/li>\n\n\n\n<li>Table cache hit rate \u2013 Look for a high cache hit rate, ideally over 99%. Lower rates indicate tuning needed.<\/li>\n<\/ul>\n\n\n\n<p><strong>Configuration Suggestions<\/strong><\/p>\n\n\n\n<ul>\n<li>Maximum memory usage \u2013 Increase if available memory allows to improve performance.<\/li>\n\n\n\n<li>Key buffer size \u2013 Raise if possible to improve index usage.<\/li>\n\n\n\n<li>Table cache \u2013 Increase to avoid file open limits.<\/li>\n\n\n\n<li>Thread cache size \u2013 Raise to avoid thread creation overhead.<\/li>\n<\/ul>\n\n\n\n<p><strong>Hardware Suggestions<\/strong><\/p>\n\n\n\n<ul>\n<li>RAM \u2013 Add more RAM if needed to support additional memory buffers.<\/li>\n\n\n\n<li>CPUs \u2013 Reduce CPU load or add cores if CPU utilization is high.<\/li>\n\n\n\n<li>Storage \u2013 Fast storage helps improve I\/O performance.<\/li>\n<\/ul>\n\n\n\n<p><strong>Query Performance<\/strong><\/p>\n\n\n\n<ul>\n<li>Slow queries \u2013 Tune expensive queries and add indexes where needed.<\/li>\n\n\n\n<li>Temporary tables \u2013 High temporary tables could indicate suboptimal indexes.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"implementing-mysqltuner-recommendations\">Implementing mysqltuner Recommendations<\/h2>\n\n\n\n<p>Here are some steps to act on mysqltuner recommendations and tune MySQL performance:<\/p>\n\n\n\n<ol>\n<li><strong>Adjust Memory Allocation<\/strong>&nbsp;&#8211; If more RAM is available, increase key buffer, query cache size, innodb buffer pool size, and table cache. This allows MySQL to keep more indexes and data in memory.<\/li>\n\n\n\n<li><strong>Optimize Slow Queries<\/strong>&nbsp;&#8211; Review slow queries, add indexes, and tune expensive joins or subqueries. This greatly improves overall throughput.<\/li>\n\n\n\n<li><strong>Improve Indexes<\/strong>&nbsp;&#8211; Inspect index usage with tools like EXPLAIN. Add needed indexes and remove unused ones. Pay attention to key buffer size.<\/li>\n\n\n\n<li><strong>Concurrency Tuning<\/strong>&nbsp;&#8211; Tune thread cache size, max connections, worker threads, and other concurrency settings. Find optimal values.<\/li>\n\n\n\n<li><strong>Storage Optimization<\/strong>&nbsp;&#8211; Ensure storage subsystem has adequate IOPS and throughput for workload. SSD storage provides huge gains.<\/li>\n\n\n\n<li><strong>Server Sizing<\/strong>&nbsp;&#8211; Rightsize server resources like CPU cores, RAM, storage as database grows. Monitor growth trends.<\/li>\n\n\n\n<li><strong>Configuration Best Practices<\/strong>&nbsp;&#8211; Review settings against recommended values like table cache, join buffer size, query cache size, etc.<\/li>\n\n\n\n<li><strong>Periodic Review<\/strong>&nbsp;&#8211; Rerun mysqltuner every few weeks. Implement additional recommendations as needed.<\/li>\n<\/ol>\n\n\n\n<p>With diligent tuning guided by mysqltuner, you can optimize MySQL to handle heavy workloads and deliver maximum performance. The key is regularly reviewing metrics and incrementally applying recommendations over time.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysqltuner-script-explained\">MySQLTuner Script Explained<\/h2>\n\n\n\n<p>The mysqltuner.pl script is well structured and extensively commented. Let&#8217;s walk through the main sections to understand what it does under the hood:<\/p>\n\n\n\n<p><strong>Initial Connection<\/strong><\/p>\n\n\n\n<ul>\n<li>Imports modules for database connections, text formatting, statistics<\/li>\n\n\n\n<li>Processes command line arguments<\/li>\n\n\n\n<li>Makes database connection using given credentials<\/li>\n<\/ul>\n\n\n\n<p><strong>Data Collection<\/strong><\/p>\n\n\n\n<ul>\n<li>Initializes variables for calculations<\/li>\n\n\n\n<li>Executes SHOW statements to collect configuration<\/li>\n\n\n\n<li>Executes queries on INFORMATION_SCHEMA for metrics<\/li>\n\n\n\n<li>Calculates ratios, hits, misses, totals on metrics<\/li>\n<\/ul>\n\n\n\n<p><strong>Analysis and Reporting<\/strong><\/p>\n\n\n\n<ul>\n<li>Checks metrics against recommended thresholds<\/li>\n\n\n\n<li>Compares current and previous mysqltuner report if exists<\/li>\n\n\n\n<li>Prints configuration variables and table metrics<\/li>\n\n\n\n<li>Makes hardware, configuration, indexing suggestions<\/li>\n\n\n\n<li>Formats report output and highlights issues<\/li>\n<\/ul>\n\n\n\n<p><strong>Connection Cleanup<\/strong><\/p>\n\n\n\n<ul>\n<li>Closes database connection<\/li>\n\n\n\n<li>Exits gracefully<\/li>\n<\/ul>\n\n\n\n<p>This shows the basic flow &#8211; connect, gather data, analyze, print report, disconnect. The heavy lifting is done by the data collection and analysis sections. MySQLTuner relies on SHOW commands and INFORMATION_SCHEMA queries to get configuration values and performance metrics.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ways-to-use-mysqltuner\">Ways to Use MySQLTuner<\/h2>\n\n\n\n<p>In addition to ad-hoc tuning, here are other good ways to leverage mysqltuner:<\/p>\n\n\n\n<p><strong>Application Testing<\/strong>&nbsp;&#8211; Run mysqltuner on development, staging, and production to compare configurations. Fine tune each environment.<\/p>\n\n\n\n<p><strong>New Database Server<\/strong>&nbsp;&#8211; Create a baseline report after provisioning a new database server. Use for initial sizing and tuning.<\/p>\n\n\n\n<p><strong>Performance Trends<\/strong>&nbsp;&#8211; Execute mysqltuner over time and save reports. Check for trends as database grows.<\/p>\n\n\n\n<p><strong>After Upgrade<\/strong>&nbsp;&#8211; How is performance after a MySQL or OS upgrade? Run mysqltuner to verify.<\/p>\n\n\n\n<p><strong>Cloud Migration<\/strong>&nbsp;&#8211; Migrating from bare metal to cloud? A mysqltuner report helps rightsize the instance.<\/p>\n\n\n\n<p><strong>Capacity Planning<\/strong>&nbsp;&#8211; Planning a storage, memory, or compute expansion? Mysqltuner indicates where resources are needed.<\/p>\n\n\n\n<p><strong>Diagnostics<\/strong>&nbsp;&#8211; If MySQL is slow, run mysqltuner to help uncover the bottlenecks.<\/p>\n\n\n\n<p>These examples demonstrate the wide applicability of mysqltuner for various performance monitoring and tuning scenarios.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"alternative-tuning-tools\">Alternative Tuning Tools<\/h2>\n\n\n\n<p>While mysqltuner is easy to use and full featured, there are other MySQL tuning tools to consider:<\/p>\n\n\n\n<ul>\n<li>Percona Toolkit &#8211; Advanced open source toolkit with pt-mysql-summary and pt-query-digest.<\/li>\n\n\n\n<li>MySQL Enterprise Monitor &#8211; GUI based dashboard for metrics and advisors.<\/li>\n\n\n\n<li>MySQL Query Analyzer &#8211; Track query performance over time.<\/li>\n\n\n\n<li>EXPLAIN ANALYZE &#8211; Optimizer statistics to choose better query plans.<\/li>\n\n\n\n<li>Performance Schema &#8211; Fine grained MySQL performance data.<\/li>\n<\/ul>\n\n\n\n<p>Mysqltuner makes an excellent starting point due to its ease of use and clear results. Complement it with other tools that provide drilling down capabilities for advanced tuning.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>mysqltuner is an invaluable tool for monitoring and tuning MySQL &amp; MariaDB performance. It quickly diagnoses problems and offers clear, actionable suggestions for improvement.<\/p>\n\n\n\n<p>Following mysqltuner&#8217;s advice can help resolve or avoid many common MySQL performance pitfalls. It&#8217;s an essential tool for any database administrator or application developer using MySQL in production.<\/p>\n\n\n\n<p>Consistent use of mysqltuner and other complementary tools will maximize database efficiency, reduce infrastructure costs, and provide the best experience for applications and their users.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL and MariaDB are one of the most popular open source relational database management systems. It powers many of the world&#8217;s most visited web services and applications. As usage grows, performance tuning becomes essential to optimize MySQL and avoid issues like slow queries. Mysqltuner is an open source Perl script that helps analyze and tune ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[57,69],"tags":[],"yoast_head":"\n<title>MySQL &amp; MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.\" \/>\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.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL &amp; MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-01T09:41:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-01T09:41:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"MySQL &#038; MariaDB Performance Tuning using Mysqltuner\",\"datePublished\":\"2023-11-01T09:41:21+00:00\",\"dateModified\":\"2023-11-01T09:41:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\"},\"wordCount\":1181,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Databases\",\"Linux system administration\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\",\"name\":\"MySQL & MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2023-11-01T09:41:21+00:00\",\"dateModified\":\"2023-11-01T09:41:24+00:00\",\"description\":\"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL &#038; MariaDB Performance Tuning using Mysqltuner\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"MySQL & MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations","description":"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.","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.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/","og_locale":"en_US","og_type":"article","og_title":"MySQL & MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations","og_description":"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.","og_url":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2023-11-01T09:41:21+00:00","article_modified_time":"2023-11-01T09:41:24+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/10\/mysqltuner_en.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"MySQL &#038; MariaDB Performance Tuning using Mysqltuner","datePublished":"2023-11-01T09:41:21+00:00","dateModified":"2023-11-01T09:41:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/"},"wordCount":1181,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Databases","Linux system administration"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/","url":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/","name":"MySQL & MariaDB Performance Tuning using Mysqltuner - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2023-11-01T09:41:21+00:00","dateModified":"2023-11-01T09:41:24+00:00","description":"Comprehensive guide to MySQL\/MariaDB performance tuning using mysqltuner. Learn how to install, use and interpret mysqltuner recommendations for optimizing MySQL configuration, memory, indexing, queries, and hardware.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/mysql-mariadb-performance-tuning-mysqltuner\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"MySQL &#038; MariaDB Performance Tuning using Mysqltuner"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7117"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=7117"}],"version-history":[{"count":9,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7117\/revisions"}],"predecessor-version":[{"id":7147,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/7117\/revisions\/7147"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=7117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=7117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=7117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}