Menu
I am using xampp (apache + mysql) on local Windows 10. While performing a query in phpmyadmin. I accidentally clicked the box for profiling and now all queries run with profiling. How do I turn this setting off?
I have tried restarting the server and MySQL database, but the setting persists.
I did not find a setting for it in the my.ini. Also checked the database settings in phpMyAdmin and did not find a setting for profiling.
425
So the only way to stop any activity around query cache requires restarting MySQL with query_cache_type = 0 and query_cache_size=0. Disabling it or even set it to “0” on runtime is not completely stopping mutex activity. But why do we still need query_cache_size while in theory query_cache_type should be enough?
mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent statements sent to the server. The size of the list is controlled by the profiling_history_size session variable, which has a default value of 15. The maximum value is 100.
It seems the problem was the profiling option only shows up after you perform a query.
Except, it won't show up if your query uses aggregates or joins.
I used a simple query and was finally able to disable profiling again.
177
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
