List:General Discussion« Previous MessageNext Message »
From:Partha Dutta Date:May 16 2005 6:29pm
Subject:RE: innodb buffer pool size question
View as plain text  
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?

Thread
innodb buffer pool size questionSergei Skarupo16 May
  • RE: innodb buffer pool size questionPartha Dutta16 May
RE: innodb buffer pool size questionSergei Skarupo16 May