Hi all, I set the innodb_buffer_pool_size=1024M in my.cnf show variables returns ..... innodb_buffer_pool_size | 1073741824 .... show innodb status returns ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1169691576; in additional pool allocated 1041024 Buffer pool size 65536 Free buffers 0 Database pages 65170 Modified db pages 979 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 170494, created 940061, written 2512012 41.96 reads/s, 2.00 creates/s, 0.00 writes/s Buffer pool hit rate 843 / 1000
why is the buffer pool size different?
