fosiul01
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ??
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 ??
ASKER
also
from console
mysql> SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_ total';
+------------------------- -------+-- ------+
| Variable_name | Value |
+------------------------- -------+-- ------+
| Innodb_buffer_pool_pages_t otal | 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 .. ??
from console
mysql> SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_
+-------------------------
| Variable_name | Value |
+-------------------------
| Innodb_buffer_pool_pages_t
+-------------------------
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_t otal * Innodb_page_size = 589824 * 16384 = 9663676416 Bytes
= 9 GB
= 9 GB
ASKER
hi thanks
is there any documentation of this calculation ?
total innodb_buffer_pol_size uses = Innodb_buffer_pool_pages_t otal * Innodb_page_size
can you please give me the link
thanks
is there any documentation of this calculation ?
total innodb_buffer_pol_size uses = Innodb_buffer_pool_pages_t
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_t otal : 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)
Innodb_buffer_pool_pages_t
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.
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_
The result will be in pages, which by default is 16KB, but you can check:
SHOW GLOBAL STATUS LIKE 'Innodb_page_size';