MySQL configuration with 256GB
Suggestions for your my.cnf-ini [mysqld] section from the limited available information provided,

max_connect_errors=10  # from 1000000 - allow hackers/crackers nn pw guesses
sort_buffer_size=4M  # REMOVE or lead with # for default
read_buffer_size=4M  # REMOVE or lead with # for default
read_rnd_buffer_size=4M  # REMOVE or lead with # for default
thread_cache_size=100  # from 128 see V8 REFMAN for CAP to prevent OOM


Take 2 minutes with MySQLCalculator.com to see what your values have done to the RAM footprint requirements that are extreme and will negatively impact performance.

Eliminate the duplicate variables in your my.cnf-ini and be consistent with underscores rather than mixing in hyphens.

Provide the additional information requested a few hours ago for additional helpful suggestions to improve performance.

Good luck with this new venture on this nice equipment configuration.  Any SSD's?