Shulou(Shulou.com)06/01 Report--

There are two ways:

First, through show status

Mysql > show status like 'innodb_buffer_pool_pages_data' +-- +-+ | Variable_name | Value | +-+-+ | Innodb_buffer_pool_pages_data | 3226366 | +- -+-+ 1 row in set (0.00 sec) mysql > show status like 'innodb_buffer_pool_pages_total' +-- +-+ | Variable_name | Value | +-+-+ | Innodb_buffer_pool_pages_total | 3244032 | +- -+-+ 1 row in set (0.00 sec)

Val=innodb_buffer_pool_pages_data/innodb_buffer_pool_pages_total x 100% "3226366Accord 3244032 x 100%" 99.46%

Second, check through SQL

Mysql > select * from performance_schema.global_status where variable_name in ('innodb_buffer_pool_pages_data','innodb_buffer_pool_pages_total') +-- +-+ | VARIABLE_NAME | VARIABLE_VALUE | +-- +-+ | Innodb_buffer _ pool_pages_data | 3226437 | | Innodb_buffer_pool_pages_total | 3244032 | +-- +-+ 2 rows in set (sec)

Val=innodb_buffer_pool_pages_data/innodb_buffer_pool_pages_total x 100% 3226437Accord 3244032 x 100% = 99.46%

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.