Installing MariaDB with additional options

English Applications
1

I tried to use the SHOW PROFILE option mariadb and the following happened:

MariaDB [cvt_live]> SHOW PROFiLE;
ERROR 1289 (HY000): The ‘SHOW PROFILE’ feature is disabled; you need MariaDB built with ‘enable-profiling’ to have it working

Is there a best way to install an application like mariadb so I can turn on options like that that I want?

E.g.: do I have to go the mariadb website and download what I want or could it be done with source files from opensuse.org or perhaps the debug version has things like that turned on so I could just install that?

Thanks,
Reg

2

Try

SET profiling = 1;

This only turns on profiling for the current session; the MariaDB documentation offers a script for extracting all the profile variables in one go.

3

Thanks but generally when something asks for a flag to be set for compiling it means the functionality probably won’t exist unless that flag is set when the app. is being bult and in this case running the above command gives:

ET profiling = 1 **MySQL said: **http://pma.local/themes/dot.gif](http://pma.local/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Ferror-messages-server.html)

#1193 - Unknown system variable ‘profiling’

suggesting that is the case here.