• Kentoku's avatar
    MDEV-16520 Out-Of-Memory running big aggregate query on Spider Engine · 41e60e7f
    Kentoku authored
    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
    41e60e7f
spd_include.h 51.7 KB