innodb_buffer_pool_size
InnoDB用来缓存它的数据和索引的内存缓冲区的大小。我理解是把索引和数据放在innodb_buffer_pool里操作会很快。服务器共16G内存, innodb_buffer_pool 设置的6G ,数据库里的innodb的数据+索引一共用了5G,innodb_buffer_pool 也占用了5G
于是我删除了一些比较大的innodb的表后
mysql> select sum(DATA_LENGTH),sum(INDEX_LENGTH) from information_schema.TABLES where engine="innodb" ;
+------------------+-------------------+
| sum(DATA_LENGTH) | sum(INDEX_LENGTH) |
+------------------+-------------------+
| 1669464064 | 1368981504 |
+------------------+-------------------+innodb的数据+索引减少到了3G左右但是为什么Innodb_buffer_pool_pages_free还是那么少呢,已经删了这么多了
mysql> show status like '%innodb%';
+-----------------------------------+---------------+
| Variable_name | Value |
+-----------------------------------+---------------+
| Com_show_innodb_status | 0 |
| Innodb_buffer_pool_pages_data | 318940 |
| Innodb_buffer_pool_pages_dirty | 249 |
| Innodb_buffer_pool_pages_flushed | 162765981 |
| Innodb_buffer_pool_pages_free | 55101 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 19175 |
| Innodb_buffer_pool_pages_total | 393216 | 请教 我删除innodb大表以后,再执行什么操作才能使innodb_buffer_pool的占用减小,大家帮帮忙
InnoDB用来缓存它的数据和索引的内存缓冲区的大小。我理解是把索引和数据放在innodb_buffer_pool里操作会很快。服务器共16G内存, innodb_buffer_pool 设置的6G ,数据库里的innodb的数据+索引一共用了5G,innodb_buffer_pool 也占用了5G
于是我删除了一些比较大的innodb的表后
mysql> select sum(DATA_LENGTH),sum(INDEX_LENGTH) from information_schema.TABLES where engine="innodb" ;
+------------------+-------------------+
| sum(DATA_LENGTH) | sum(INDEX_LENGTH) |
+------------------+-------------------+
| 1669464064 | 1368981504 |
+------------------+-------------------+innodb的数据+索引减少到了3G左右但是为什么Innodb_buffer_pool_pages_free还是那么少呢,已经删了这么多了
mysql> show status like '%innodb%';
+-----------------------------------+---------------+
| Variable_name | Value |
+-----------------------------------+---------------+
| Com_show_innodb_status | 0 |
| Innodb_buffer_pool_pages_data | 318940 |
| Innodb_buffer_pool_pages_dirty | 249 |
| Innodb_buffer_pool_pages_flushed | 162765981 |
| Innodb_buffer_pool_pages_free | 55101 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 19175 |
| Innodb_buffer_pool_pages_total | 393216 | 请教 我删除innodb大表以后,再执行什么操作才能使innodb_buffer_pool的占用减小,大家帮帮忙
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货