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.