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!