Meta info in mysql response

[sanikolaev]

It would be nice if we could show the most important query meta info right in the mysql response without the need to do SHOW META, e.g.:

mysql> select * from hackernews;
Empty set (0.00 sec)
Time: 0.000877 sec., total found: 0

The task is to research how feasible it is and implement. Things to check:

• in what mysql clients it would work
• whether there would be any issue with Buddy

[tomatolog]

SendMysqlOkPacket already has a sMessage argument and any text there looks like one-liner at reply message

mysql> select * from hackernews;
Empty set (0.00 sec)
any text - Time: 0.000877 sec., total found: 0

[sanikolaev]

An idea of what it might look like combining total, total_found, total_relation and time:

mysql> select * from hackernews limit 0;
Empty set (0.00 sec)
--- 0 out of 1115 results in 115 ms ---

mysql> select * from t
+---------------------+
| id                  |
+---------------------+
| 1515532189620502761 |
| 1515532189620502801 |
| 1515532189620502762 |
| 1515532189620502802 |
| 1515532189620502800 |
| 1515532189620502760 |
| 1515532189620502758 |
| 1515532189620502798 |
| 1515532189620502759 |
| 1515532189620502799 |
| 1515532189620502694 |
| 1515532189620502718 |
| 1515532189620502716 |
| 1515532189620502692 |
| 1515532189620502693 |
| 1515532189620502647 |
| 1515532189620502648 |
| 1515532189620502623 |
| 1515532189620502583 |
| 1515532189620502582 |
+---------------------+
20 rows in set (5.12 sec)
--- 20 out of >= 20 results in 5.123 sec ---

[sanikolaev]

Note from today's dev call: many tests may fail when we implement this. We'll have to update them or do smth else.

[sanikolaev]

As discuss with Alexey on the call of Oct 2 2023, there's a function which can display time in human-readable format. We can use it.