Hi All. I am trying to set the best value for innodb_buffer_pool_size. My system has 6GB of ram.
My system is: 2.6.32-279.19.1.el6.centos.plus.x86_64 CentOS release 6.3 (Final) mysql-server-5.0.58 My current setting: innodb_buffer_pool_size = 1024M (my.cnf attached) >From show innodb status: ---------------------- BUFFER POOL AND MEMORY ---------------------- 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, Rafal.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql