Geek Answers Handbook

Innodb pool buffer size and buffer pool size when innodb status mismatch

I tried to increase the pool size of innodb buffers to 8 GB recently, but in my innodb status the pool size looks like the previous value in which it was configured (500 MB in my case).

----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 9576946034; in additional pool allocated 19271936
**Buffer pool size   524288**
Free buffers       2
Database pages     508873
Modified db pages  5
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 443350, created 76998, written 683297
0.00 reads/s, 0.00 creates/s, 0.37 writes/s
Buffer pool hit rate 1000 / 1000

But it shows the status of innodb,

mysql> show variables like 'innodb_%';
+---------------------------------+------------------------+
| Variable_name                   | Value                  |
+---------------------------------+------------------------+
| innodb_additional_mem_pool_size | 52428800               | 
| innodb_autoextend_increment     | 8                      | 
| innodb_buffer_pool_awe_mem_mb   | 0                      | 
| innodb_buffer_pool_size         | 8589934592             |

Can someone please tell me what makes this difference?

+4
source share
2 answers

You are looking at the wrong numbers.

Shared Memory 9576946034

This is consistent with the setting innodb_buffer_pool_size:

InnoDB , 10% .

Buffer pool size - .

+3

Total Memory allocated Show Engine InnoDB status; output

InnoDB SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_%'. , . , Innodb_page_size, innodb_buffer_pool_size.

(Innodb_buffer_pool_pages_data + Innodb_buffer_pool_pages_misc + Innodb_buffer_pool_pages_free) = Innodb_buffer_pool_pages_total

Innodb_buffer_pool_pages_total * Innodb_page_size= innodb_buffer_pool_size

Show Engine InnoDB Status :

, Innodb ( , ), , ( , ), , , , . , , , , , , , , . , , , - .

http://www.fromdual.com/innodb-variables-and-status-explained

http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/

+1

More articles:


All Articles