{"id":6857,"date":"2026-05-12T02:27:17","date_gmt":"2026-05-12T05:27:17","guid":{"rendered":"https:\/\/helpsysadmin.com.br\/blog\/?p=6857"},"modified":"2026-05-12T03:01:59","modified_gmt":"2026-05-12T06:01:59","slug":"optimizing-mariadb-performance","status":"publish","type":"post","link":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/","title":{"rendered":"Complete guide to optimizing MariaDB performance."},"content":{"rendered":"<div id=\"helps-1378407365\" class=\"helps-before-content-2 helps-entity-placement\"><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-3661896953164277\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- 2anuncios display quadrado -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-3661896953164277\"\r\n     data-ad-slot=\"5051229894\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\n<p>This is a comprehensive technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware\/OS, Configuration (my.cnf), and Queries (Queries\/Indexes).<\/p>\n\n\n\n<p>Below, I detail each layer, focusing on the most impactful configurations.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-operating-system-os-optimization\">1. Operating System (OS) Optimization<\/h3>\n\n\n\n<p>Before touching MariaDB, the environment must be prepared.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Swappiness: The database should never use SWAP, as disk performance is drastically lower than RAM.<\/li>\n\n\n\n<li>Add the following to \/etc\/sysctl.conf:<\/li>\n\n\n\n<li>vm.swappiness = 10. After editing the file, run sysctl -p to apply the changes without restarting the server.RAM.<\/li>\n\n\n\n<li><strong>Filesystem:<\/strong> Prefer XFS or ext4. XFS generally handles large volumes of data and concurrency better.<\/li>\n\n\n\n<li><strong>File Descriptors: <\/strong>Increase the limit on open files.<\/li>\n\n\n\n<li>In \/etc\/security\/limits.conf:<\/li>\n\n\n\n<li>mysql soft nofile 65535<\/li>\n\n\n\n<li>mysql hard nofile 65535<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-innodb-engine-optimization-my-cnf\">2. InnoDB Engine Optimization (my.cnf)<\/h3>\n\n\n\n<p>The configuration file usually resides in \/etc\/my.cnf or \/etc\/my.cnf.d\/server.cnf. InnoDB is the default engine and the most important one to tune.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-a-memory-the-most-critical-factor\">A. Memory (The Most Critical Factor)<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>innodb_buffer_pool_size:<\/strong> This is the most important variable. It defines how much RAM MariaDB will use to cache data and indexes.\n<ul class=\"wp-block-list\">\n<li><strong>Dedicated Server:<\/strong> Allocate between 60% and 80% of the total RAM.<\/li>\n\n\n\n<li><strong>Shared Server (Web + DB):<\/strong> Allocate between 30% and 50% of the RAM, leaving space for Apache\/Nginx and PHP.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>innodb_buffer_pool_instances:<\/strong> Divides the pool into regions to reduce thread contention.\n<ul class=\"wp-block-list\">\n<li>If the buffer pool is > 1GB, set this value equal to the number of CPU cores (up to a reasonable limit, e.g., 8 or 16).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-b-log-and-write-i-o\">B. Log and Write (I\/O)<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>innodb_log_file_size<\/code><\/strong>: Size of redo log files. Larger values \u200b\u200bimprove write performance but increase recovery time after a crash.\n<ul class=\"wp-block-list\">\n<li><strong>Recommended:<\/strong> 1GB to 4GB (depending on write traffic).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><code>innodb_flush_log_at_trx_commit<\/code><\/strong>: Controls the ACID guarantee.\n<ul class=\"wp-block-list\">\n<li>1 (Default): Most secure. Writes to disk after every transaction. Slowest.<\/li>\n\n\n\n<li>2 (Optimized): Writes to the OS cache after every transaction and to disk every second. Much faster, risk of 1 second of data loss in case of power failure (but not in case of a MySQL crash). <strong>Recommended for most web servers.<\/strong><\/li>\n\n\n\n<li>0: Maximum speed, highest risk.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><code>innodb_flush_method<\/code><\/strong>: How MariaDB interacts with the disk.\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/helpsysadmin.com.br\/blog\/como-instalar-crowdsec\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Como instalar Crowdsec\" target=\"_blank\" rel=\"noopener\">Linux<\/a>: Use O_DIRECT. This prevents the OS from caching what MariaDB has already cached, saving RAM (avoiding &#8220;double buffering&#8221;).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-buffers-and-connections\">3. Buffers and Connections<\/h3>\n\n\n\n<p><strong>Be careful here:<\/strong> many of these settings are per thread (connection). High values \u200b\u200bmultiplied by many connections can cause RAM to overflow (OOM Killer).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>max_connections<\/code>: Do not set arbitrarily high. Use the history of simultaneous connections (<code>Max_used_connections<\/code>) and add a 20% margin.<\/li>\n\n\n\n<li><code>thread_cache_size<\/code>: Keeps threads open for reuse.<\/li>\n\n\n\n<li>Basic formula: 8 + (<code>max_connections<\/code> \/ 100).<\/li>\n\n\n\n<li><code>tmp_table_size<\/code> and <code>max_heap_table_size<\/code>: Should have the same value. Determine the size of temporary tables and<\/li>\n\n\n\n<li>Recommended: 64M to 128M (Be careful not to overdo it).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-query-cache-warning\">4. Query Cache (Warning!)<\/h3>\n\n\n\n<p>In modern MariaDB and MySQL 8.0+, query caching is often discouraged or removed because it causes &#8220;locking&#8221; in high-concurrency environments.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Recommendation: <\/strong>Disable it (query_cache_type = 0 and query_cache_size = 0) and rely on InnoDB caching or application caching (Redis\/Memcached).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-query-optimization\">5. Query Optimization<\/h3>\n\n\n\n<p>No server configuration can save a poorly written query.<\/p>\n\n\n\n<p>Slow Query Log: Enable to identify the culprits:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>slow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql-slow.log\nlong_query_time = 1  # Loga queries que demoram mais de 1 segundo\nlog_queries_not_using_indexes = 1 # \u00datil para auditoria<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">slow_query_log<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">slow_query_log_file<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">\/var<\/span><span style=\"color: #D8DEE9FF\">\/<\/span><span style=\"color: #D8DEE9\">log<\/span><span style=\"color: #D8DEE9FF\">\/mysql-slow.log<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">long_query_time<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">  # <\/span><span style=\"color: #D8DEE9\">Loga<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">queries<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">que<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">demoram<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">mais<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">de<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">segundo<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">log_queries_not_using_indexes<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\"> # <\/span><span style=\"color: #D8DEE9\">\u00datil<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">para<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">auditoria<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>EXPLAIN<\/strong> command: Use before any heavy SELECT statement to see if indexes are being used.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Search for type: ALL (full table scan &#8211; bad).<\/li>\n\n\n\n<li>Search for type: ref or eq_ref (index usage &#8211; good).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-6-automated-diagnostic-tools\">6. Automated Diagnostic Tools<\/h3>\n\n\n\n<p>Don&#8217;t try to guess. Use scripts that analyze the current state of the server and suggest adjustments.<\/p>\n\n\n\n<p><strong>MySQLTuner:<\/strong> A Perl script that analyzes uptime and suggests variables.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>wget http:\/\/mysqltuner.pl\/ -O mysqltuner.pl\nperl mysqltuner.pl<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">wget<\/span><span style=\"color: #D8DEE9FF\"> http<\/span><span style=\"color: #ECEFF4\">:<\/span><span style=\"color: #616E88\">\/\/mysqltuner.pl\/ -O mysqltuner.pl<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">perl<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">mysqltuner<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #D8DEE9\">pl<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Note:<\/strong> Run the tuner only after the server has been running for at least 24 hours to obtain accurate statistical data.<\/p>\n\n\n\n<p><strong>Percona Toolkit:<\/strong> The pt-query-digest is excellent for analyzing the slow log and generating reports on which queries consume the most resources.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-summary-of-my-cnf-example-for-a-server-with-16gb-ram\">Summary of my.cnf (Example for a server with 16GB RAM)<\/h3>\n\n\n\n<p>Here is a basic example (&#8220;boilerplate&#8221;) for a dedicated server with 16GB of RAM. Adjust as needed.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&#91;mysqld&#93;\n# Basic\nbind-address            = 0.0.0.0\nmax_connections         = 300\n# InnoDB \ninnodb_buffer_pool_size = 10G       # ~60-70% da RAM\ninnodb_buffer_pool_instances = 8    # Similar to CPU Cores\ninnodb_log_file_size    = 2G\ninnodb_flush_log_at_trx_commit = 2  # Performance > ACID estrito\ninnodb_flush_method     = O_DIRECT\ninnodb_file_per_table   = 1\n# Buffers (Por thread - Warning)\nsort_buffer_size        = 2M\nread_buffer_size        = 2M\nread_rnd_buffer_size    = 8M\njoin_buffer_size        = 8M\n# Temp Tables\ntmp_table_size          = 128M\nmax_heap_table_size     = 128M\n# Logs\nslow_query_log          = 1\nslow_query_log_file = \/var\/log\/mysql-slow.log\nlong_query_time         = 2\nlog_queries_not_using_indexes = 1<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9FF\">&#91;<\/span><span style=\"color: #D8DEE9\">mysqld<\/span><span style=\"color: #D8DEE9FF\">&#93;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\"># <\/span><span style=\"color: #D8DEE9\">Basic<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">bind<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">address<\/span><span style=\"color: #D8DEE9FF\">            <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">0.0<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #B48EAD\">0.0<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">max_connections<\/span><span style=\"color: #D8DEE9FF\">         <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">300<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\"># <\/span><span style=\"color: #D8DEE9\">InnoDB<\/span><span style=\"color: #D8DEE9FF\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_buffer_pool_size<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 10<\/span><span style=\"color: #D8DEE9\">G<\/span><span style=\"color: #D8DEE9FF\">       # <\/span><span style=\"color: #81A1C1\">~<\/span><span style=\"color: #B48EAD\">60<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #B48EAD\">70<\/span><span style=\"color: #81A1C1\">%<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">da<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">RAM<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_buffer_pool_instances<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">8<\/span><span style=\"color: #D8DEE9FF\">    # <\/span><span style=\"color: #D8DEE9\">Similar<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">to<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">CPU<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Cores<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_log_file_size<\/span><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 2<\/span><span style=\"color: #D8DEE9\">G<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_flush_log_at_trx_commit<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">  # <\/span><span style=\"color: #D8DEE9\">Performance<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&gt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">ACID<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">estrito<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_flush_method<\/span><span style=\"color: #D8DEE9FF\">     <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">O_DIRECT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">innodb_file_per_table<\/span><span style=\"color: #D8DEE9FF\">   <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\"># <\/span><span style=\"color: #88C0D0\">Buffers<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">Por<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">thread<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Warning<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">sort_buffer_size<\/span><span style=\"color: #D8DEE9FF\">        <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 2<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">read_buffer_size<\/span><span style=\"color: #D8DEE9FF\">        <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 2<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">read_rnd_buffer_size<\/span><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 8<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">join_buffer_size<\/span><span style=\"color: #D8DEE9FF\">        <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 8<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\"># <\/span><span style=\"color: #D8DEE9\">Temp<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Tables<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">tmp_table_size<\/span><span style=\"color: #D8DEE9FF\">          <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 128<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">max_heap_table_size<\/span><span style=\"color: #D8DEE9FF\">     <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> 128<\/span><span style=\"color: #D8DEE9\">M<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\"># <\/span><span style=\"color: #D8DEE9\">Logs<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">slow_query_log<\/span><span style=\"color: #D8DEE9FF\">          <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">slow_query_log_file<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">\/var<\/span><span style=\"color: #D8DEE9FF\">\/<\/span><span style=\"color: #D8DEE9\">log<\/span><span style=\"color: #D8DEE9FF\">\/mysql-slow.log<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">long_query_time<\/span><span style=\"color: #D8DEE9FF\">         <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">2<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">log_queries_not_using_indexes<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-click-here-to-view-our-server-management-plans\"><strong><a href=\"https:\/\/helpsysadmin.com.br\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">Click here to view our Server Management plans.<\/a><\/strong><\/h3>\n\n\n\n<p><\/p>\n\n\n\n<p>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/como-instalar-openlitespeed-no-ubuntu-20-04\/\">Como Instalar Openlitespeed no Ubuntu 20.04<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/diagnostico-linux-htop-iotop-glances\/\">Como Usar htop, iotop e Glances para Diagn\u00f3stico R\u00e1pido de Servidores Linux<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/configurar-lamp-com-wordpress-e-lets-encrypt\/\">Como configurar lamp com wordpress e let\u00b4s encrypt<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/configurar-lemp-com-wordpress-e-lets-encrypt\/\">Como configurar lemp com wordpress e let\u00b4s encrypt<\/a><\/strong><br>Veja Mais: <strong><a href=\"https:\/\/helpsysadmin.com.br\/blog\/load-alto-no-servidor\/\">Como lidar com load alto no servidor<\/a><\/strong><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a comprehensive technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware\/OS, Configuration (my.cnf), and Queries (Queries\/Indexes). Below, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":6858,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4466],"tags":[1223,1211,1271,1400,1249,1402,4470,1217],"class_list":["post-6857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-servers-and-databases","tag-almalinux-en","tag-linux-en","tag-mariadb","tag-mysql","tag-performance","tag-server-linux","tag-sysadmin","tag-ubuntu-en-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Complete guide to optimizing MariaDB performance. - Blog HelpSysAdmin<\/title>\n<meta name=\"description\" content=\"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Complete guide to optimizing MariaDB performance.\" \/>\n<meta property=\"og:description\" content=\"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog HelpSysAdmin\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-12T05:27:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-12T06:01:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1396\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"HelpSysAdmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brhelpsysad\" \/>\n<meta name=\"twitter:site\" content=\"@brhelpsysad\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/\"},\"author\":{\"name\":\"HelpSysAdmin\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\"},\"headline\":\"Complete guide to optimizing MariaDB performance.\",\"datePublished\":\"2026-05-12T05:27:17+00:00\",\"dateModified\":\"2026-05-12T06:01:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/\"},\"wordCount\":697,\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/05\\/optimizing_performance-scaled.webp\",\"keywords\":[\"almalinux\",\"linux\",\"mariadb\",\"mysql\",\"performance\",\"server linux\",\"Sysadmin\",\"ubuntu\"],\"articleSection\":[\"Web Servers and Databases\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/\",\"name\":\"Complete guide to optimizing MariaDB performance. - Blog HelpSysAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/05\\/optimizing_performance-scaled.webp\",\"datePublished\":\"2026-05-12T05:27:17+00:00\",\"dateModified\":\"2026-05-12T06:01:59+00:00\",\"description\":\"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#primaryimage\",\"url\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/05\\/optimizing_performance-scaled.webp\",\"contentUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2026\\/05\\/optimizing_performance-scaled.webp\",\"width\":2560,\"height\":1396,\"caption\":\"optimizing performance mariadb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/en\\\/optimizing-mariadb-performance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Complete guide to optimizing MariaDB performance.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"name\":\"Blog HelpSysAdmin\",\"description\":\"Blog Gerenciamento de Servidor\",\"publisher\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\"},\"alternateName\":\"HelpSysAdmin Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#organization\",\"name\":\"HelpSysAdmin Gerenciamento de Servidores\",\"alternateName\":\"HelpSysAdmin\",\"url\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"contentUrl\":\"https:\\/\\/mlkpd8g42nae.i.optimole.com\\/w:512\\/h:512\\/q:mauto\\/f:best\\/https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/uploads\\/2020\\/12\\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"HelpSysAdmin Gerenciamento de Servidores\"},\"image\":{\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/brhelpsysad\",\"https:\\\/\\\/mastodon.social\\\/@helpsysadmin\"],\"description\":\"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1\",\"maxValue\":\"10\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/bdbe3d7d71a0c6a3cb474c18da574efb\",\"name\":\"HelpSysAdmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/litespeed\\/avatar\\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604\",\"url\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/litespeed\\/avatar\\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604\",\"contentUrl\":\"https:\\/\\/helpsysadmin.com.br\\/blog\\/wp-content\\/litespeed\\/avatar\\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604\",\"caption\":\"HelpSysAdmin\"},\"sameAs\":[\"https:\\\/\\\/helpsysadmin.com.br\\\/blog\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Complete guide to optimizing MariaDB performance. - Blog HelpSysAdmin","description":"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.","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:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/","og_locale":"pt_BR","og_type":"article","og_title":"Complete guide to optimizing MariaDB performance.","og_description":"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.","og_url":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/","og_site_name":"Blog HelpSysAdmin","article_published_time":"2026-05-12T05:27:17+00:00","article_modified_time":"2026-05-12T06:01:59+00:00","og_image":[{"width":2560,"height":1396,"url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp","type":"image\/webp"}],"author":"HelpSysAdmin","twitter_card":"summary_large_image","twitter_creator":"@brhelpsysad","twitter_site":"@brhelpsysad","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#article","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/"},"author":{"name":"HelpSysAdmin","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb"},"headline":"Complete guide to optimizing MariaDB performance.","datePublished":"2026-05-12T05:27:17+00:00","dateModified":"2026-05-12T06:01:59+00:00","mainEntityOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/"},"wordCount":697,"publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp","keywords":["almalinux","linux","mariadb","mysql","performance","server linux","Sysadmin","ubuntu"],"articleSection":["Web Servers and Databases"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/","url":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/","name":"Complete guide to optimizing MariaDB performance. - Blog HelpSysAdmin","isPartOf":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#primaryimage"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp","datePublished":"2026-05-12T05:27:17+00:00","dateModified":"2026-05-12T06:01:59+00:00","description":"Technical guide to optimizing MariaDB. Database performance depends on three pillars: Hardware, Configuration, and Queries. MariaDB performance optimization.","breadcrumb":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#primaryimage","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2026\/05\/optimizing_performance-scaled.webp","width":2560,"height":1396,"caption":"optimizing performance mariadb"},{"@type":"BreadcrumbList","@id":"https:\/\/helpsysadmin.com.br\/blog\/en\/optimizing-mariadb-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/helpsysadmin.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Complete guide to optimizing MariaDB performance."}]},{"@type":"WebSite","@id":"https:\/\/helpsysadmin.com.br\/blog\/#website","url":"https:\/\/helpsysadmin.com.br\/blog\/","name":"Blog HelpSysAdmin","description":"Blog Gerenciamento de Servidor","publisher":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization"},"alternateName":"HelpSysAdmin Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/helpsysadmin.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/helpsysadmin.com.br\/blog\/#organization","name":"HelpSysAdmin Gerenciamento de Servidores","alternateName":"HelpSysAdmin","url":"https:\/\/helpsysadmin.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:512\/h:512\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/uploads\/2020\/12\/favicon.png","width":512,"height":512,"caption":"HelpSysAdmin Gerenciamento de Servidores"},"image":{"@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/brhelpsysad","https:\/\/mastodon.social\/@helpsysadmin"],"description":"Oferecemos o gerenciamento de servidores dedicados, vps ou cloud. Apresentamos a melhor experi\u00eancia em atendimento e servi\u00e7o. Nosso time cuidar\u00e1 do seu servidor com backups, an\u00e1lises constantes, ajustes de seguran\u00e7a, realiza\u00e7\u00e3o de manuten\u00e7\u00e3o preventiva e corretiva, otimiza\u00e7\u00e3o de performance al\u00e9m de monitoramento 24\u00d77 com suporte Pr\u00f3 Ativo.","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1","maxValue":"10"}},{"@type":"Person","@id":"https:\/\/helpsysadmin.com.br\/blog\/#\/schema\/person\/bdbe3d7d71a0c6a3cb474c18da574efb","name":"HelpSysAdmin","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/litespeed\/avatar\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604","url":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/litespeed\/avatar\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604","contentUrl":"https:\/\/mlkpd8g42nae.i.optimole.com\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/helpsysadmin.com.br\/blog\/wp-content\/litespeed\/avatar\/e587d5e97a45d2f6f29b0179adc1ebf4.jpg?ver=1778460604","caption":"HelpSysAdmin"},"sameAs":["https:\/\/helpsysadmin.com.br\/blog\/"]}]}},"lang":"en","translations":{"en":6857},"pll_sync_post":{},"_links":{"self":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/6857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/comments?post=6857"}],"version-history":[{"count":1,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/6857\/revisions"}],"predecessor-version":[{"id":6859,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/posts\/6857\/revisions\/6859"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media\/6858"}],"wp:attachment":[{"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/media?parent=6857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/categories?post=6857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpsysadmin.com.br\/blog\/wp-json\/wp\/v2\/tags?post=6857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}