mk-profile-compact: command not found

Have You tried accessing the binary with the full path?

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-profile-compact - from package: maatkit

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