Hi All.

I am trying to set the best value for innodb_buffer_pool_size. My system has 6GB of ram.

My system is:
CentOS release 6.3 (Final)

My current setting:
innodb_buffer_pool_size         = 1024M
(my.cnf attached)

From show innodb status:
Total memory allocated 1250582306; in additional pool allocated 12842496
Buffer pool size   65536
Free buffers       0
Database pages     61505
Modified db pages  86
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 96616, created 97554, written 126547
0.80 reads/s, 0.20 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000

Size of innodb tables:
du -h /mysql/ibdata1 
1.8G    /mysql/ibdata1

My question: how to tell if my innodb_buffer_pool_size is ok?
Does Buffer pool hit rate 1000 / 1000 mean that I can lower it?
Does Free buffers       0 mean that I should make it larger?
Eventually what else to check?

Best regards,