I found out how much the innodb pool size has allocated memory from
show innodb status but I couldn't figure out how much actually it uses. Maybe it needs more or I can take some memory off from it? How to find it out? Oh and one question, as I'm kinda new to the innodb configuration playground - it uses two different memories, right? One is ram and the other is disk, yes?
BUFFER POOL AND MEMORY ---------------------- Total memory allocated 7162316778; in additional pool allocated 1048576 Buffer pool size 393216 Free buffers 0 Database pages 380971 Modified db pages 1906 Pending reads 0 Pending writes: LRU 0, flush list 1, single page 0 Pages read 16986872, created 474559, written 9972877 0.00 reads/s, 39.33 creates/s, 353.48 writes/s Buffer pool hit rate 1000 / 1000
I've currently set the pool size to (see below) of my 12GB server.
innodb_buffer_pool_size = 6G