Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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
share|improve this question

3 Answers 3

up vote 0 down vote accepted

Innodb pool recomended 2/3 of ram u have.

no, all pool in memory, but it have complex layout and use also additional memory pool +some more ram for internal need.

most of innodb pool is just cache of ur data. so no way to determine how much realy "need". porbably no sence in have pool more then size of your database.

in your output u can see that Freebuffers = 0. so all memory used. but as i said before, that just mean your database able use all ram.

Buffer pool hit rate 1000 / 1000

mean u have hi hit rate(all request use pool,not disk), so not need worry/increase buffer.

share|improve this answer

From the output you've provided, your 6 gigabytes of RAM have been fully utilized. That doesn't mean that you're not using enough -- it just means that at some point that much data was read off the drive. What you need to be looking for are other details about your system utilization. If you have a lot of drive activity, that may be an indicator that you need more memory devoted to InnoDB. It may mean many other things.

Because there is so much to learn about this level of tuning, I suggest that you check out http://www.mysqlperformanceblog.com and do several hours of reading.

share|improve this answer
    
+1 for the great link! :) –  Richards Jul 29 '11 at 22:52

Usually, i just set innodb buffer size = (total innodb tables' cumulative size + 10-25%)

some queries i found to help find total innodb table size at http://vbtechsupport.com/462/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.