thanks -----Original Message----- From: Partha Dutta [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 11:30 AM To: Sergei Skarupo; 'Mysql List (E-mail)' Subject: RE: innodb buffer pool size question
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:[EMAIL PROTECTED] > 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]