Fixing mysqltuner ERROR 1054 on Ubuntu Server 16.04

It was only last March that here at work we’ve updated our machines to Ubuntu 16.04 LTS, just a month before the 2018 edition of the server-ready realease of the Linux distribution that has come to be de ‘de-facto’ standard for Bioinformatics.

I am running mysqltuner to see how the server can be most finely tuned. Unfortunately the package still has problems (ie. in two years the updated version has not been back ported) so I am facing the mysqltuner ERROR 1054 on Ubuntu Server 16.04.

Here’s how I solved it, after a quick digging’ on my search engine:

cd /opt
git clone https://github.com/major/MySQLTuner-perl.git
cd MySQLTuner-perl
sudo mv /usr/bin/mysqltuner /usr/bin/mysqltuner.bak
sudo ln -s /opt/MySQLTuner-perl/mysqltuner.pl /usr/bin/mysqltuner

Then I’ve successfully ran my script. Enjoy!

via →

Advertisements

Author: kOoLiNuS

♂, Italian, male, husband, dad of a wonder, “cazzaro”, friendly, blogger, motorcyclist, geek, avid reader, sysadmin, ICT consultant, curious. I come in peace… I'm an active social networker since 1999. I've been using WordPress sice 2004 and WordPress.com since 2006, and I'm currently involved in WordPress and WooCommerce communities in Bari, Apulia.

2 thoughts on “Fixing mysqltuner ERROR 1054 on Ubuntu Server 16.04”

  1. I’ve run MySQLTuner on Ubuntu 16.04 with no issues. My issues is in understanding the recommendations. There is little guidance as to where to find and adjust the items that need adjusting.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

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