Queries: 6.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 3767/00/00/00
Sorts: 0 qps now: 1 Slow qps: 0.0 Threads: 1 ( 1/ 9) 00/00/00/00
Key Efficiency: 50.0% Bps in/out: 0.0/ 0.6 Now in/out: 21.3/ 3.5k
I did not install and check mysqltuner. I have to do that.
But for now, mytop is showing the following stats.
I am using innodb tables
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 4498391040; in additional pool allocated 0
Total memory allocated by read views 96
Internal hash tables (constant factor + variable factor)
Adaptive hash index 87311648 (75691192 + 11620456)
Page hash 553976 (buffer pool 0 only)
Dictionary cache 17811895 (17702096 + 109799)
File system 821392 (812272 + 9120)
Lock system 10626424 (10625704 + 720)
Recovery system 0 (0 + 0)
Dictionary memory allocated 109799
Buffer pool size 262136
Buffer pool size, bytes 4294836224
Free buffers 256342
Database pages 5085
Old database pages 1747
Modified db pages 226
Percent of dirty pages(LRU & free pages): 0.086
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 31, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 161, created 4924, written 76608
0.00 reads/s, 0.07 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5085, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
How to optimize mysql for more performance?