Install Tuning Primer on Debian

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:

• a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian.

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

• Thanks to Tuning Primer (en) developers.