A server running only a MySql 5.7.30 instance consumes on average around 25% of its CPU, having over 100 threads connected, and of which generally 15-25 are running threads. The CPU in the server has 8 cores / 16 threads, and the load on CPU seems to be distributed over all cores/threads well.
Now a second identical CPU has been added to the server, but we notice that the second CPU does not get any load on any of its cores/threads. Are there any settings I need to adjust, to tell MySql to make use both CPU's?
Here are some settings from the my.ini on the machine:
default-storage-engine=INNODB log-output=FILE table_open_cache=2000 thread_cache_size=10 myisam_max_sort_file_size=100G read_buffer_size=64K read_rnd_buffer_size=256K innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_autoextend_increment=64 innodb_buffer_pool_instances=8 innodb_concurrency_tickets=5000 innodb_old_blocks_time=1000 innodb_stats_on_metadata=0 innodb_file_per_table=1 innodb_checksum_algorithm=0 back_log=80 flush_time=0 open_files_limit=4161 table_definition_cache=1400 binlog_row_event_max_size=8K max_connections=301 tmp_table_size=6G myisam_sort_buffer_size=12G key_buffer_size=11M innodb_buffer_pool_size=20G innodb_log_file_size=2G innodb_thread_concurrency=33 innodb_open_files=2000 join_buffer_size=4M max_allowed_packet=32M sort_buffer_size=512K event-scheduler=ON max_heap_table_size=32M query_cache_type=1