- there are misunderstatements about multicore usage per query or per server
- per server:
- multiple threaths can handle I/O operations
- InnoDB 5.7 should be able to scale up to 60 cores, in 5.1 it was max 8 cores
- parameters:
innodb_concurrency_tickets
innodb_thread_sleep_delay
innodb_read_io_threads
innodb_write_io_threads
innodb_thread_concurrency
(should be set to 0 to allow engine find optimum)
- per query:
- one query can use only one core – multicore usage requires parallel execution plan and transparent data spliting between cores which is possible only in some other databases