How to find out the size (in Mb) of a query in mysql?

Question

MySQL

Good afternoon, there is mysql and a certain query that displays the result, you need to know the size of the received response, how to do this?

Answer 1

strlen()? ))

Answer 2

select sum(row_size) 
from (
  select 
    char_length(column1)+
    char_length(column2)+
    char_length(column3)+
    char_length(column4) ... <-- перечисляем здесь все колонки
  as row_size 
  from your_table
) as tbl1;

something like this.