Optimization Guidelines BKM innodb_thread_concurrency. Different values were tried; the best performance came with the default 0 (unlimited thread_concurrency). 50 c 100 c 150 c sas‐hdd 6,329.74 5 innodb_undo_directory //mysql_log innodb_buffer_pool_size 3GB 12GB innodb_thread_concurrency 0 innodb_temp_data_file_path '../../..//mysql_log/ibtmp1:72 M:autoextend'

Information Schema • SYS Schema • Resource Groups • Partitioning • Optimized for high concurrency • Optimized for Read Only • Optimized for use with SSD • Multiple Index Type (B-tree