We are running few benchmark queries against our test RDS instance for checking efficiency of partitioning, before adapting it to production, where there is no partitions presently.
We have few tables of time series data, and hence partitioning based on
RANGE( unix_timestamp(event_time) ). Queries we run against sets of tables(partitioned and non-partitioned ones) which has millions of rows is taking too much time, which we are stuck at the moment.
We see from MySQL Workbench it's quite obviously the fetch time(network dependent) takes up the time. What we are concerned about is only the runtime duration of the queries we run. Is there any way we can skip the fetched results part and only get the runtime duration for respective queries?
Query Examples we try :
SELECT * FROM app_event1 WHERE `event_time` BETWEEN '2018-01-01 00:00:01' AND '2018-02-30 23:59:59';
What we do for saving time is with limit the results with,
SELECT * FROM app_event1 WHERE `event_time` BETWEEN '2018-01-01 00:00:01' AND '2018-02-30 23:59:59' Limit 0,1000000;
which won't match live scenarios.