Link to home
Start Free TrialLog in
Avatar of fosiul01
fosiul01Flag for United Kingdom of Great Britain and Northern Ireland

asked on

how to view how much innodb buffer pool size using

HI
We have setup

Innodb_buffer_pool size = 12 GB

Now how will we know, how much ram its actually using ?

its windows server.

what variables shall i check from mysql to see how much ram its its utilizing .

i have read few article

http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

but can you please specifiq about that varibles or command to check ram utilization.

thanks
ASKER CERTIFIED SOLUTION
Avatar of wesly_chen
wesly_chen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kevin Cross
They deprecated that status in MySQL 5.5 by the way.
In MySQL 5.5, you should use: SHOW ENGINE INNODB STATUS;

An alternative is:
-- http://dev.mysql.com/doc/refman/5.1/en/show-status.html
-- http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html
SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_total';

The result will be in pages, which by default is 16KB, but you can check:
SHOW GLOBAL STATUS LIKE 'Innodb_page_size';
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fosiul01

ASKER

hi

mine is like this

BUFFER POOL AND MEMORY
----------------------
Total memory allocated 10752867514; in additional pool allocated 25947648
Buffer pool size   589824
Free buffers       1
Database pages     567582
Modified db pages  5


so how much Buffer Pool Size ?? 500K ??

also
from console

mysql> SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_total';
+--------------------------------+--------+
| Variable_name                  | Value  |
+--------------------------------+--------+
| Innodb_buffer_pool_pages_total | 589824 |
+--------------------------------+--------+
1 row in set (0.17 sec)

mysql> SHOW GLOBAL STATUS LIKE 'Innodb_page_size';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| Innodb_page_size | 16384 |
+------------------+-------+
1 row in set (0.17 sec)


so how much ram is utilizing ..   ??
Innodb_buffer_pool_pages_total  * Innodb_page_size = 589824 * 16384 = 9663676416 Bytes
= 9 GB
hi thanks

is there any documentation of this calculation ?

total innodb_buffer_pol_size uses = Innodb_buffer_pool_pages_total  * Innodb_page_size

can you please give me the link
thanks
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Innodb_buffer_pool_pages_total
Innodb_buffer_pool_pages_total : The total size of buffer pool, in pages

http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Innodb_page_size
Innodb_page_size : The compiled-in InnoDB page size (default 16KB)
I provided those earlier, but thanks for clarifying - I had to go offline for awhile.