My mysql takes 700% of CPU while loading the website. top command shows -
784% of CPU 6.3% of MEM.
This is the output of lscpu command.
Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 8 On-line CPU(s) list: 0-7 Thread(s) per core: 2 Core(s) per socket: 4 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 58 Model name: Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz Stepping: 9 CPU MHz: 3499.804 CPU max MHz: 3700.0000 CPU min MHz: 1600.0000 BogoMIPS: 6584.91 Virtualization: VT-x L1d cache: 32K L1i cache: 32K L2 cache: 256K L3 cache: 8192K NUMA node0 CPU(s): 0-7