profiling - turn on mysql profiler globally -

i want profile mysql sessions using mysql profiler, how can turn on profiling globally?

thanks!

log mysql command line , use query logger or slow query logger. it's not same profiler, pretty performs same function. here starting tip.

mysql> set global log_output='table'; mysql> set global slow_query_log=1; ...wait... mysql> use mysql; mysql> select * slow_log order query_time desc; 

please remember turn off when you're done. remember logging table slower file, of course, more convenient.