mk-query-advisor: command not found

Maybe Your $PATH variable doesn't contain the default paths? echo $PATH should give something like:

[root@server ~]# echo $PATH
/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

If it's empty, You may set the PATH variable with this command

export PATH="/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin"

On CentOS possible default full paths are:

/usr/bin/mk-query-advisor - from package: maatkit

You may install the required package with command yum install {package}

Error in other languages:
mk-query-advisor: bevel nie gevind nie
mk-query-advisor: comandă negăsită
mk-query-advisor: comando não encontrado
mk-query-advisor: commande introuvable
mk-query-advisor: command not found
mk-query-advisor: käsku ei ole
mk-query-advisor: không tìm thấy lệnh
mk-query-advisor: komanda nerasta
mk-query-advisor: Kommando nicht gefunden.
mk-query-advisor: kommandot finns inte
mk-query-advisor: komut yok
mk-query-advisor: nie znaleziono polecenia
mk-query-advisor: níor aimsíodh an t-ordú
mk-query-advisor: no se encontró la orden
mk-query-advisor: no s'ha trobat l'ordre
mk-query-advisor: opdracht niet gevonden
mk-query-advisor: parancs nem található
mk-query-advisor: perintah tidak ditemukan
mk-query-advisor: príkaz nenájdený
mk-query-advisor: příkaz nenalezen
mk-query-advisor: команда не найдена
mk-query-advisor: командата не е открита
mk-query-advisor: 命令找不到
mk-query-advisor: コマンドが見つかりません