Tuning Primer is a tool helping to tune the performances of a MariaDB (MySQL) server.

This howto is tested on:

  • Debian 10.0 Buster

Requirements

This howto requires:

Installation

Detect if sudo is available (“command” is used if not):

cmdProxy='command'
command type -f 'sudo' &>'/dev/null' && cmdProxy='sudo'

Install the software’s requirements:

${cmdProxy} apt install 'bc'

Install the software:

${cmdProxy} wget 'https://raw.githubusercontent.com/BMDan/tuning-primer.sh/master/tuning-primer.sh' \
    --output-document='/usr/local/bin/tuning-primer'
${cmdProxy} chmod +x '/usr/local/bin/tuning-primer'

Usage

Wait at least 48h after starting the MariaDB (MySQL) server to use this tool. This allow for the accumulated usage data to be pertinent.

Run the software:

${cmdProxy} tuning-primer

The tool check the MariaDB (MySQL) server settings and provide tips on possible performance enhancements.

Thanks


0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.