MDEV-16520 Out-Of-Memory running big aggregate query on Spider Engine

Change default value of the followings
quick_mode 0 -> 3
quick_page_size 100 -> 1024

Add the following parameter for limiting result page size by byte
- quick_page_byte(qpb)
  Number of bytes in a page when acquisition one by one.
  When quick_mode is 1 or 2, Spider stores at least 1 record even if
  quick_page_byte is smaller than 1 record. When quick_mode is 3,
  quick_page_byte is used for judging using temporary table.
  That is given to priority when server parameter spider_quick_page_byte
  is set.
  The default value is 10485760

Fix "out of sync" issue at using quick_mode = 1 or 2

1 files changed, 1 insertions, 0 deletions

diff --git a/storage/spider/spd_include.h b/storage/spider/spd_include.h
index 38ded445d44..23bbff22fbb 100644
--- a/storage/spider/spd_include.h
+++ b/storage/spider/spd_include.h
@@ -960,6 +960,7 @@ typedef struct st_spider_share
   longlong           priority;
   int                quick_mode;
   longlong           quick_page_size;
+  longlong           quick_page_byte;
   int                low_mem_read;
   int                table_count_mode;
   int                select_column_mode;