total used free shared buff/cache available
Mem: 31998 3480 24668 100 3849 27937
Swap: 0 0 0
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 4.0G/1007.3M
[!!] InnoDB buffer pool instances: 8
[!!] InnoDB Used buffer: 31.84% (83466 used/ 262136 total)
[OK] InnoDB Read buffer efficiency: 100.00% (991763294 hits/ 991763458 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 6934189 writes)
DB size is increase from 289.4M to 1007.M
Why does mysql always using only one core?
The server has 8 core and i can see cpu usage in only one core.
How to buy best server for mysql?
Or can we make mysql to use all 8 cores?