两种方法：

一、通过show status

mysql>showstatuslike'innodb_buffer_pool_pages_data';+-------------------------------+---------+|Variable_name|Value|+-------------------------------+---------+|Innodb_buffer_pool_pages_data|3226366|+-------------------------------+---------+1rowinset(0.00sec)mysql>showstatuslike'innodb_buffer_pool_pages_total';+--------------------------------+---------+|Variable_name|Value|+--------------------------------+---------+|Innodb_buffer_pool_pages_total|3244032|+--------------------------------+---------+1rowinset(0.00sec)

val=innodb_buffer_pool_pages_data/innodb_buffer_pool_pages_total x 100%=3226366/3244032 x 100%=99.46%

二、通过SQL查看

mysql>select*fromperformance_schema.global_statuswherevariable_namein('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|+--------------------------------+----------------+2rowsinset(0.00sec)

val=innodb_buffer_pool_pages_data/innodb_buffer_pool_pages_total x 100%=3226437/3244032 x 100%=99.46%