CINXE.COM
Install and run mysqltuner
<!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Install and run mysqltuner</title> <meta name="description" content=""> <meta name="generator" content="Hugo 0.80.0" /> <meta name="twitter:card" content="summary"> <meta name="twitter:title" content="Install and run mysqltuner"> <meta name="twitter:description" content=""> <meta property="og:title" content="Install and run mysqltuner"> <meta property="og:type" content="documentation"> <meta property="og:description" content=""> <meta property="article:published_time" content="2022-12-21" /> <meta name="addsearch-custom-field" content="app=wordpress"/> <meta name="addsearch-custom-field" content="type=apps"/> <script async src="https://www.googletagmanager.com/gtag/js?id=G-9R2174SWXR"></script> <script type="text/plain" class="optanon-category-2"> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-9R2174SWXR', { 'page_path': location.pathname + location.search + location.hash }); </script> <link href='https://d33np9n32j53g7.cloudfront.net/fonts/overpass.css' media="screen" rel="stylesheet"> <link href='//d1d5nb8vlsbujg.cloudfront.net/hex/4.0.0/hex.min.css' media="screen" rel="stylesheet"> <link rel="stylesheet" href="https://docs.bitnami.com/css/bds.faf8b14f3c76e6860c8727547b073e6516fcda727e0e96aaffb6be74ac913dbe.css" integrity="sha256-+vixTzx25oYMhydUewc+ZRb82nJ+Dpaq/7a+dKyRPb4=" media="screen"> <script src='//d1d5nb8vlsbujg.cloudfront.net/hex/4.0.0/hex.min.js'></script> <script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script> <script src="https://docs.bitnami.com/js/bds.min.532022ed4c220659e9491eb3a1169af6c952894fee385f048eaa68dc9a518097.js"></script> <link href='https://docs.bitnami.com/images/img/favicon.png' rel='shortcut icon'> <link rel="alternate" type="application/rss+xml" title="Bitnami Documentation" href="https://docs.bitnami.com/index.xml"/> </head> <body class="aws apps"> <div class="addsearch__index" data-addsearch="include">awswordpress</div> <div class="topnav container topnav-no-hero headbloc"> <header class="header"> <script src="https://cdn.cookielaw.org/scripttemplates/otSDKStub.js" type="text/javascript" charset="UTF-8" data-domain-script=018ee37f-861a-71d5-8408-7a1202512048></script> <script type="text/javascript"> function OptanonWrapper() { var events = window.dataLayer.filter(function(element) { return element.event === "OneTrustGroupsUpdated" && element.OnetrustActiveGroups != null; }); { window.dataLayer.push({ event: 'OneTrustGroupsUpdated' }); } if (events.length > 0) { var latestEvent = events[events.length - 1]; var previousEvent = events.length === 1 ? latestEvent : events[events.length - 2]; if (latestEvent.OnetrustActiveGroups != previousEvent.OnetrustActiveGroups) { location.reload(); } } } </script> <div class="header__logo"> <a href="https://docs.bitnami.com/"><img alt="Bitnami by VMware logo" src="https://docs.bitnami.com/images/logo.svg"/></a> </div> <nav class="header__nav"> <button aria-expanded="false" aria-haspopup="true" aria-label="Toggle menu" class="header__nav__hamburguer"> <div></div> <div></div> <div></div> </button> <ul class="header__nav__menu" role="list" aria-label="Main navigation"> <li> <a class="header__nav__menu__item" href="https://bitnami.com/stacks">Applications</a> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Kubernetes</a> <ul aria-label="Kubernetes" class="header__nav__submenu header__nav__kubernetes" role="menu" aria-expanded="false"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://kubeapps.dev/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubeapps</h3> <p>Your Application Dashboard for Kubernetes</p> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://docs.bitnami.com/kubernetes/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubernetes Tutorials</h3> <p>Move Your Containers to Production</p> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://kube.academy/" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Kubeacademy</h3> <p>Unlock your full potential with Kubernetes courses designed by experts</p> </div> </a> </li> <li role="none" class='header-hide-mobile'> <a class="header__nav__list__item" role="menuitem" href="https://tanzu.vmware.com/education" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>VMware Tanzu Education</h3> <p>Invest in your future and build your cloud native skills</p> </div> </a> </li> </div> <div class="header__nav__kubernetes__others"> <li role="none"> <a role="menuitem" class="header__nav__kubernetes__other" href="https://github.com/bitnami-labs/sealed-secrets" target="_blank" rel="noopener noreferrer"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-lock"><rect x="3" y="11" width="18" height="11" rx="2" ry="2"></rect><path d="M7 11V7a5 5 0 0 1 10 0v4"></path></svg> Sealed Secrets </a> </li> <li role="none"> <a role="menuitem" class="header__nav__kubernetes__other" href="https://github.com/bitnami/charts" target="_blank" rel="noopener noreferrer"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-disk"><circle cx="12" cy="12" r="10"></circle><circle cx="12" cy="12" r="3"></circle></svg> Helm Charts </a> </li> <li role="none"> <a role="menuitem" href="https://bitnami.com/kubernetes" class="header__nav__kubernetes__all" target="_blank" rel="noopener noreferrer">See all projects</a> </li> </div> </ul> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Developers</a> <ul aria-label="Developers" class="header__nav__submenu header__nav__developers" role="menu" aria-expanded="false"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://docs.bitnami.com/"> <div class="header__nav__list__item__info"> <h3>Documentation</h3> </div> </a> </li> <li role="none" class='header-hide-mobile'> <a class="header__nav__list__item" role="menuitem" href="https://docs.vmware.com/en/VMware-Tanzu-Application-Catalog/services/tutorials/GUID-index.html" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Tutorials</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://bitnami.com/support" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Support</h3> </div> </a> </li> </div> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://github.com/bitnami" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Open Source</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.broadcom.com/company/careers" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>We're Hiring</h3> </div> </a> </li> </div> </ul> </li> <li> <a aria-expanded="false" aria-haspopup="true" class="header__nav__menu__item" href="#" tabindex="0">Company</a> <ul aria-label="Company" class="header__nav__submenu header__nav__company" role="menu" aria-expanded="false"> <div class="header__nav__company__links"> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://tanzu.vmware.com/content/tanzu-application-catalog-resources" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Resources</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://blog.bitnami.com" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Blog</h3> </div> </a> </li> </div> <div class="header__nav__list"> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.broadcom.com/company/careers" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>Careers</h3> </div> </a> </li> <li role="none"> <a class="header__nav__list__item" role="menuitem" href="https://www.vmware.com/company/news.html" target="_blank" rel="noopener noreferrer"> <div class="header__nav__list__item__info"> <h3>VMware Newsroom</h3> </div> </a> </li> </div> </div> <div class="header__nav__company__contact"> Do you want to talk? <a role="menuitem" href="https://bitnami.com/contact" target="_blank" rel="noopener noreferrer">Contact Us</a> </div> </ul> </li> <div class='tocify header__nav__menu__toc'></div> </ul> <div class="header__nav__user"> <div class="search search-overlay margin-t-small"> <div class="input-group type-small"> <div class="search__input"> <input type="search" name="q" autocomplete="on" placeholder="Search" /> </div> </div> <div class='search__results elevation-2 padding-big'></div> </div> </div> </nav> </header> </div> <main> <section> <div class="container"> <nav class="breadcrumb margin-t-big"> <a href="https://docs.bitnami.com/">Bitnami Documentation</a> > <a href="https://docs.bitnami.com/aws/">AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/">Bitnami Stacks for AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/">Bitnami package for WordPress for AWS Cloud</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/">Troubleshooting</a> > <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/install-mysqltuner/">Install and run mysqltuner</a> </nav> </div> </section> <div class="container"> <div class="row collapse-on-phone collapse-on-phone-landscape"> <div class="col-3"> <div class="category__Navigation menu-foldable padding-big margin-t-bigger margin-b-enormous"> <nav> <h4 class="margin-t-reset margin-b-normal category__navtitle">Bitnami package for WordPress for AWS Cloud</h4> <h4 class="margin-t-small category__title page"> Getting started </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/first-steps/">Obtain application and server credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-ports/">Understand the default port configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/wordpress-automattic/">Compare different Bitnami and Automattic WordPress solutions</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-config/">Understand the default Apache configuration</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-mariadb/">Understand the default MariaDB configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/find-credentials-link-mariadb/">Obtain MariaDB credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/connect-mariadb/">Connect to MariaDB</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-mysql/">Understand the default MySQL configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/find-credentials-link-mysql/">Obtain MySQL credentials</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/connect-mysql/">Connect to MySQL</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/understand-default-config-php/">Understand the default PHP configuration</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/get-started/access-phpmyadmin/">Connect to phpMyAdmin</a> </li> </ul> <h4 class="margin-t-small category__title page"> Configuration </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/change-language/">Modify the interface language</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins/">Install plugins</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/use-jetpack/">Configure and use the Jetpack plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-installed-plugins/">Enable preinstalled plugins</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-smtp/">Configure SMTP for outbound emails</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-amp/">Install the Accelerated Mobile Pages (AMP) plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-allinone/">Install the All-in-One WP migration plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-wpdbmanager/">Install the WP-DBManager plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-plugins-polly/">Install the Amazon Polly plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-cors-wordpress/">Enable CORS</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/wordpress-aws-s3/">Configure WordPress for cloud storage on Amazon S3</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/disable-wordpress-cron/">Disable the WordPress cron script</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-varnish/">Configure Varnish (TM) for WordPress</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-modules/">Enable different Apache modules</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/create-database-mariadb/">Create a new MariaDB database and user</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/create-database-mysql/">Create a new MySQL database and user</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-workbench/">Configure MySQL Workbench</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-timezone/">Modify the default PHP timezone</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/install-modules-php/">Install different PHP modules</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-phpfpm-options/">Configure PHP-FPM options</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/configure-phpfpm-processes/">Configure PHP-FPM processes</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/configuration/enable-basic-auth/">Secure phpMyAdmin</a> </li> </ul> <h4 class="margin-t-small category__title page"> Administration </h4> <ul class="margin-reset remove-style padding-l-reset"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/control-services/">Start or stop services</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-email-address/">Reset the WordPress administrator email address</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-password/">Reset the WordPress administrator password</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/reset-wp-admin-permissions/">Reset the WordPress administrator permissions</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/understand-file-permissions/">Understand WordPress filesystem permissions</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-domain/">Configure the WordPress domain name</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-jetpack/">Create and restore application backups with the Jetpack plugin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/upgrade/">Upgrade WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore/">Create and restore application backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/upload-files/">Upload files using SFTP</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-wpcli/">Use the WP-CLI command line tool</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-maintenance-mode/">Activate or deactivate maintenance mode</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/check-installed-modules/">List installed Apache modules</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-single-domain/">Access an application using only a single domain with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/redirect-custom-domains/">Redirect custom domains to the Apache server</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-port/">Modify the Apache port</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-htpasswd/">Password-protect access to an application with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/publish-pages/">Publish web pages</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/create-ssl-certificate-apache/">Create an SSL certificate for Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-https-ssl-apache/">Enable HTTPS support with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/force-https-apache/">Force HTTPS redirection with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-http2-apache/">Enable HTTP/2 support with Apache</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/check-ssl-certificate/">Troubleshoot SSL certificates and keys</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-htaccess/">Understand default .htaccess file configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/use-pagespeed/">Use PageSpeed with Apache</a> </li> <div class="component margin-t-small">gonit</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-use-gonit/">Configure and use Gonit</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/recover-database-mariadb/">Recover a MariaDB database</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/connect-remotely-mariadb/">Connect to MariaDB from a different machine</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-reset-password-mariadb/">Modify the default MariaDB administrator password</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-data-directory-mariadb/">Modify the MariaDB data directory</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/secure-server-mariadb/">Secure MariaDB</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-mysql-mariadb/">Create and restore MySQL/MariaDB backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/encrypt-tables-mariadb/">Encrypt a MariaDB database table</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/recover-database-mysql/">Recover a MySQL database</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/connect-remotely-mysql/">Connect to MySQL from a different machine</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-reset-password-mysql/">Modify the MySQL administrator password</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/change-data-directory-mysql/">Modify the MySQL data directory</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/secure-server-mysql/">Secure MySQL</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/backup-restore-mysql-mariadb/">Create and restore MySQL/MariaDB backups</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/encrypt-tables-mysql/">Encrypt a MySQL database table</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/phpinfo/">Check PHP configuration</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/create-custom-application-php/">Create a custom PHP application</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/deploy-php-application/">Deploy a PHP application</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/increase-upload-limit-php/">Modify the PHP file upload limit</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/disable-phpfpm/">Disable PHP-FPM</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/enable-phpfpm/">Enable PHP-FPM</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/export-database/">Export a database with phpMyAdmin</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/increase-upload-limit-phpmyadmin/">Modify the phpMyAdmin file upload limit</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/modify-execution-time/">Modify the phpMyAdmin script execution time</a> </li> <div class="component margin-t-small">varnish</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/administration/configure-use-varnish/">Configure and use Varnish(TM)</a> </li> </ul> <h4 class="margin-t-small category__title page"> Troubleshooting </h4> <ul class="margin-reset remove-style padding-l-reset focus"> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors/">Debug WordPress errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/optimize-bitnami-wordpress/">Optimize WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/enforce-security/">Secure WordPress</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/xmlrpc-and-pingback/">Re-enable XML-RPC pingback</a> </li> <div class="component margin-t-small">apache</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-apache/">Debug Apache errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/deny-connections-bots-apache/">Deny connections from bots/attackers using Apache</a> </li> <div class="component margin-t-small">mariadb</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mariadb/">Check the MariaDB log files</a> </li> <div class="component margin-t-small">mysql</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-mysql/">Check the MySQL log file</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/disable-binary-logging-mysql/">Disable binary logging in MySQL</a> </li> <li class="margin-b-normal focus"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/install-mysqltuner/">Install and run mysqltuner</a> </li> <div class="component margin-t-small">php</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-php-fpm/">Debug PHP-FPM errors</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/modify-execution-time/">Modify PHP script execution time</a> </li> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/send-mail/">Send email with PHP using an external SMTP account</a> </li> <div class="component margin-t-small">phpmyadmin</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/debug-errors-phpmyadmin/">Debug phpMyAdmin errors</a> </li> <div class="component margin-t-small">varnish</div> <li class="margin-b-normal"> <a href="https://docs.bitnami.com/aws/apps/wordpress/troubleshooting/deny-connections-bots/">Deny connections from bots/attackers using Varnish(TM)</a> </li> </ul> <h4 class="margin-t-small category__title related"> <a href="https://docs.bitnami.com/aws/apps/wordpress/related-how-tos/">Related guides for WordPress</a> </h4> </nav> </div> </div> <div class="col-7"> <article class="margin-t-bigger margin-b-enormous padding-h-normal"> <h1> Install and run mysqltuner </h1> <section class="category__Content install-mysqltuner"> <blockquote> <p>NOTE: We are in the process of modifying the configuration for many Bitnami stacks. On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. To identify which database server is used in your stack, run the command below:</p> <pre><code> $ test -d /opt/bitnami/mariadb && echo "MariaDB" || echo "MySQL" </code></pre> <p>The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations.</p> </blockquote> <p>To install mysqtuner, <a href="https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl">download the <em>mysqltuner.pl</em> script</a>. For example, you can download it with <em>wget</em>:</p> <pre><code>$ wget https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl </code></pre> <p>To monitor a MySQL server installed by a Bitnami stack, pass the connection values through the command line, as shown below. Note that you will need Perl installed on the system.</p> <pre><code>$ perl mysqltuner.pl --socket /opt/bitnami/mysql/tmp/mysql.sock </code></pre> </section> </article> </div> <div class="col-2"> <aside class="documentable__sidebar padding-big margin-t-bigger"> <h4 class="margin-t-reset">In this article</h4> <div class="tocify documentable__sidebar__toc"></div> </aside> <section class="documentable__lastmod padding-big padding-l-bigger margin-v-enormous"> Last modification <span class="date">December 21, 2022</span> </section> </div> </div> </div> </main> <footer class='footer bg-dark type-color-reverse-anchor-reset'> <div class='container padding-v-bigger'> <div class='row collapse-b-desktop'> <div class='col-3 footer__copyright'> <h4 class="inverse"> <img src="https://d33np9n32j53g7.cloudfront.net/assets/logos/bitnami-by-vmware-dark-bg.svg" alt="Bitnami by VMware Logo" class=logo /> </h4> <a href="https://twitter.com/Bitnami" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Twitter profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="twitter_title">See Bitnami's Twitter profile.</title> <desc id="twitter_desc">Twitter icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M14 35.618A15.166 15.166 0 0 0 22.177 38c9.904 0 15.498-8.313 15.162-15.77A10.761 10.761 0 0 0 40 19.485c-.957.422-1.985.707-3.063.834a5.314 5.314 0 0 0 2.344-2.932 10.729 10.729 0 0 1-3.386 1.287A5.344 5.344 0 0 0 32 17c-3.442 0-5.973 3.193-5.195 6.51a15.17 15.17 0 0 1-10.994-5.54 5.288 5.288 0 0 0 1.65 7.078 5.33 5.33 0 0 1-2.417-.663c-.057 2.456 1.714 4.753 4.279 5.265-.751.204-1.573.25-2.408.09a5.33 5.33 0 0 0 4.982 3.683A10.767 10.767 0 0 1 14 35.618" fill=currentColor /> </svg> </a><a href="https://github.com/bitnami" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Github profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="github_title">See Bitnami's Github profile.</title> <desc id="github_desc">Github icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M27.5 14C20.044 14 14 19.968 14 27.33c0 5.888 3.868 10.885 9.233 12.647.675.122.921-.289.921-.642 0-.317-.011-1.155-.018-2.268-3.755.806-4.547-1.786-4.547-1.786-.614-1.54-1.5-1.95-1.5-1.95-1.225-.827.094-.81.094-.81 1.355.094 2.067 1.373 2.067 1.373 1.204 2.038 3.16 1.45 3.93 1.108.122-.861.47-1.449.856-1.782-2.997-.336-6.149-1.48-6.149-6.588 0-1.455.526-2.644 1.39-3.576-.14-.337-.603-1.693.132-3.527 0 0 1.133-.36 3.712 1.366a13.085 13.085 0 0 1 3.38-.449c1.146.005 2.301.153 3.38.449 2.577-1.725 3.708-1.366 3.708-1.366.737 1.834.273 3.19.134 3.527.865.932 1.388 2.121 1.388 3.576 0 5.12-3.156 6.248-6.164 6.578.485.411.917 1.225.917 2.468 0 1.782-.017 3.22-.017 3.657 0 .356.243.77.928.64C37.135 38.21 41 33.218 41 27.33 41 19.968 34.955 14 27.5 14" fill=currentColor /> </svg> </a><a href="https://www.youtube.com/user/bitrock5" class="socialIcon margin-r-small"><svg role=img aria-label="See Bitnami's Youtube profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="youtube_title">See Bitnami's Youtube profile.</title> <desc id="youtube_desc">Youtube icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M24.2 31.286v-8.572L31.474 27 24.2 31.286zm16.215-11.163a3.543 3.543 0 0 0-2.476-2.526C35.756 17 27 17 27 17s-8.755 0-10.938.597a3.544 3.544 0 0 0-2.476 2.526C13 22.351 13 27 13 27s0 4.649.585 6.877a3.543 3.543 0 0 0 2.476 2.526C18.244 37 27 37 27 37s8.756 0 10.94-.597a3.543 3.543 0 0 0 2.475-2.526C41 31.649 41 27 41 27s0-4.649-.585-6.877z" fill=currentColor /> </svg> </a><a href="https://www.linkedin.com/company/bitnami" class=socialIcon><svg role=img aria-label="See Bitnami's LinkedIn profile" viewBox="0 0 54 54" xmlns="http://www.w3.org/2000/svg"> <title id="linkedin_title">See Bitnami's LinkedIn profile.</title> <desc id="linkedin_desc">LinkedIn icon</desc> <circle fill=currentColor cx=27 cy=27 r=27 /> <path d="M20.6 17.8c0 1.542-1.253 2.8-2.8 2.8S15 19.35 15 17.8c0-1.542 1.253-2.8 2.8-2.8s2.8 1.258 2.8 2.8zm0 5.2h-4.8v16h4.8V23zm7.889-.303H23.8V39h4.689v-8.553c0-2.295 1.024-3.656 2.979-3.656 1.802 0 2.666 1.309 2.666 3.656V39H39V28.676c0-4.364-2.395-6.476-5.755-6.476-3.351 0-4.765 2.697-4.765 2.697v-2.2h.009z" fill=currentColor /> </svg> </a><p class='type-color-light type-small'> Copyright © 2005-2024 Broadcom. All Rights Reserved. The term "Broadcom" refers to Broadcom Inc. and/or its subsidiaries. </p> </div> <div class="col-9"> <div class='row collapse-3-on-phone-land collapse-2-on-phone'> <div class="col-2"> <ul class='remove-style padding-reset'> <h3>Products</h3> <li><a href="https://bitnami.com/stacks">Application Catalog</a></li> <li> <a href="https://bitnami.com/enterprise" target="_blank" aria-label="Open in new tab" > VMware Tanzu App Catalog </a> </li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Projects</h3> <li><a href="https://kubeapps.dev">Kubeapps</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Solutions</h3> <li><a href="https://bitnami.com/kubernetes">Kubernetes</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Company</h3> <li><a href="https://www.broadcom.com/company/careers">Careers</a></li> <li><a href="https://tanzu.vmware.com/content/tanzu-application-catalog-resources">Resources</a></li> <li><a href="https://blog.bitnami.com">Blog</a></li> <li><a href="https://bitnami.com/contact">Contact</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Legal</h3> <li><a href="https://www.vmware.com/help/legal.html">Terms of Use</a></li> <li><a href="https://bitnami.com/trademark">Trademark</a></li> <li><a href="https://www.vmware.com/help/privacy.html">Privacy</a></li> <li><a href="https://www.vmware.com/help/privacy/california-privacy-rights.html">Your California Privacy Rights</a></li> </ul> </div> <div class=col-2> <ul class='remove-style padding-reset'> <h3>Support</h3> <li><a href="https://docs.bitnami.com/">Docs</a></li> <li><a href="https://github.com/bitnami/vms/issues">Bitnami Images</a></li> <li><a href="https://github.com/bitnami/charts/issues">Helm Charts</a></li> <li><a href="https://github.com/bitnami/containers/issues">Containers</a></li> </ul> </div> </div> </div> </div> </div> </footer> <script>build_search_menu('aws', 'wordpress', 'apps')</script> </body> </html>