Sample Header Ad - 728x90

How to get the size of the result of a SQL query?

2 votes
2 answers
8833 views
How do you get the size (in bytes) of the result of a SQL query, in MySQL 5.6? EXPLAIN will return the number of fetched rows, but not their size. My aim is to evaluate common queries to know a lower bound value for query_cache_limit so that they can be served by the Query Cache.
Asked by dr_ (1334 rep)
Nov 25, 2016, 12:10 PM
Last activity: Mar 19, 2021, 10:04 PM