MariaDB [test]> install soname 'query_response_time.so';

Query OK, 0 rows affected (0.03 sec)

MariaDB [test]> set global query_response_time_stats=1;

MariaDB [test]> set statement query_response_time_exec_time_debug = 5000000 for select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> select * from information_schema.query_response_time;

+----------------+-------+----------------+

| TIME           | COUNT | TOTAL          |

+----------------+-------+----------------+

|       0.000001 |     0 |       0.000000 |

|       0.000010 |     0 |       0.000000 |

|       0.000100 |     0 |       0.000000 |

|       0.001000 |     2 |       0.000381 |

|       0.010000 |     0 |       0.000000 |

|       0.100000 |     0 |       0.000000 |

|       1.000000 |     0 |       0.000000 |

|      10.000000 |     0 |       0.000000 |

|     100.000000 |     0 |       0.000000 |

|    1000.000000 |     0 |       0.000000 |

|   10000.000000 |     0 |       0.000000 |

|  100000.000000 |     0 |       0.000000 |

| 1000000.000000 |     0 |       0.000000 |

| TOO LONG       |     0 | TOO LONG       |

+----------------+-------+----------------+

14 rows in set (0.00 sec)

MariaDB [test]> set query_response_time_exec_time_debug = 5000000;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> set query_response_time_exec_time_debug = 0;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select * from information_schema.query_response_time;

+----------------+-------+----------------+

| TIME           | COUNT | TOTAL          |

+----------------+-------+----------------+

|       0.000001 |     1 |       0.000000 |

|       0.000010 |     0 |       0.000000 |

|       0.000100 |     0 |       0.000000 |

|       0.001000 |     2 |       0.000290 |

|       0.010000 |     0 |       0.000000 |

|       0.100000 |     0 |       0.000000 |

|       1.000000 |     0 |       0.000000 |

|      10.000000 |     1 |       5.000000 |

|     100.000000 |     0 |       0.000000 |

|    1000.000000 |     0 |       0.000000 |

|   10000.000000 |     0 |       0.000000 |

|  100000.000000 |     0 |       0.000000 |

| 1000000.000000 |     0 |       0.000000 |

| TOO LONG       |     0 | TOO LONG       |

+----------------+-------+----------------+

14 rows in set (0.00 sec)