The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output)
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -----Original Message-----
> From: Sergei Skarupo [mailto:SSkarupo@stripped]
> Sent: Monday, May 16, 2005 2:18 PM
> To: Mysql List (E-mail)
> Subject: innodb buffer pool size question
>
> 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?
