MySQL Forums
Forum List  »  Performance

Re: MyTOP - Key Efficiency 50.0% - How to improve it?
Posted by: Mahesh Kumar
Date: January 21, 2018 08:02PM

              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?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.