HP服务器mysql只能使用单核CPU调优

修改数据库服务器主板BIOS参数

System Configuration ---> RBSU ---> Advanced Option ---> Advanced Performance Tuning Options ---> Node Interleaving
默认disable改为enable
关闭CPU分组后，MySQL可以调用所有CPU资源。

HP官方说明.

Enabling or disabling node interleaving
From the System Utilities screen, select System Configuration → BIOS/Platform Configuration (RBSU) → Performance Options → Advanced Performance Tuning Options → Node Interleaving and press Enter.

Select a setting and press Enter.

Enabled—Memory addresses are interleaved across the memory installed for each processor. All nodes must be of equal memory size. System performance might be impacted.

Disabled (default)—Disables node interleaving, providing optimum performance in most environments.