• Monty's avatar
    Adjust table_open_cache to avoid getting error 24 (too many open files) · ca0c96fc
    Monty authored
    MDEV--15609 engines/funcs.crash_manytables_number crashes with error 24
               (too many open files)
    MDEV-10286  Adjustment of table_open_cache according to system limits
                does not work when open-files-limit option is provided
    
    Fixed by adjusting tc_size downwards if there is not enough file
    descriptors to use.
    
    Other changes:
    - Ensure that there is 30 (was 10) extra file descriptors for other usage
    - Decrease TABLE_OPEN_CACHE_MIN to 200 as it's better to have a smaller
      table cache than getting error 24
    - Increase minimum of max_connections and table_open_cache from 1 to 10
      as 1 is not usable for any real application, only for testing.
    ca0c96fc
sysvars_server_embedded.result 133 KB