izer_selectivity_sampling_limit rows to calculate the
selectivity of the LIKE expression before starting to calculate the query
plan. This can help speed up some LIKE queries by providing the optimizer with
more information about your data.

URL: https://mariadb.com/kb/en/like/https://mariadb.com/kb/en/like/