Tag Archives: profiling

If you ever face an optimization issue in MySQL or MariaDB and want to know how to measure/benchmark the differences in execution between two queries, you should definitely know about the set profiling=1; command. Here is how it works: mysql> set profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> SELECT count(login_user_id)  FROM stats.track_e_online WHERE […]