グラフで见る惭测厂蚕尝5.6と8.0
0 likes435 views
MySQL Casual Talks Vo.13で話した内容です。 5.6と8.0といいながら、影響した理由が5.7でかわったところなので、5.7のバージョンアップでも同じグラフにはなりそうですね。
![InnoDB Memmory Allocation
# BUFFER POOL AND MEMORY
elseif ( $mysql_version < 50700 && strpos($line, "Total memory allocated")
=== 0 && strpos($line, "in additional pool allocated") > 0 ) {
# Total memory allocated 29642194944; in additional pool allocated 0
# Total memory allocated by read views 96
$results['total_mem_alloc'] = to_int($row[3]);
$results['additional_pool_alloc'] = to_int($row[8]);
}
elseif ( $mysql_version >= 50700 && strpos($line,
"Total large memory allocated") === 0 ) {
# Post 5.7.x SHOW ENGINE INNODB STATUS syntax
# Total large memory allocated 2198863872
$results['total_mem_alloc'] = to_int($row[4]);
$results['additional_pool_alloc'] = 0;
}
17](https://image.slidesharecdn.com/mysql5680graph-200128160242/85/MySQL5-6-8-0-17-320.jpg)
More Related Content
What's hot (20)
Similar to グラフで见る惭测厂蚕尝5.6と8.0 (18)
Recently uploaded (11)
グラフで见る惭测厂蚕尝5.6と8.0
- 1. グラフで见る惭测厂蚕尝5.6と8.0 それでもボクはやってない MySQL Casual Talks vol.13 2020/01/28 @lhfukamachi 1
- 2. 自己紹介 $ cat /etc/lhfukamachi/lhfukamachi-auto.cnf | jq { "Version": 0.0.6, "lhfukamachi": { "Metadata": { "BirthDay" : 622134000, "attribute" : "渋谷で働く見習いDBA", "Twitter" : "@lhfukamachi" } } 2
- 10. 今回のグラフ Percona Monitoring Plugins for Cacti https://github.com/percona/percona-monitoring-plugins 10
- 11. InnoDB Adapive Hash Index 11
- 12. InnoDB Adapive Hash Index Hash index Cells Totalが小さくなった。 実は5.7でAHIのインスタンス数を分割（デフォルト８） innodb_adaptive_hash_index_partsで調整可能。 つまり８分割されたうち、１個が表示されている なので8倍すると同じ値になる 12
- 14. InnoDB Memmory Allocation total memoryがなくなった。 そんなはずはない。 14
- 15. InnoDB Memmory Allocation SHOW ENGINE INNODB STATUSを見てみる 8.0 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 41758490624 5.6（数字は無視してください） ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2197815296; in additional pool allocated 0 15
- 17. InnoDB Memmory Allocation # BUFFER POOL AND MEMORY elseif ( $mysql_version < 50700 && strpos($line, "Total memory allocated") === 0 && strpos($line, "in additional pool allocated") > 0 ) { # Total memory allocated 29642194944; in additional pool allocated 0 # Total memory allocated by read views 96 $results['total_mem_alloc'] = to_int($row[3]); $results['additional_pool_alloc'] = to_int($row[8]); } elseif ( $mysql_version >= 50700 && strpos($line, "Total large memory allocated") === 0 ) { # Post 5.7.x SHOW ENGINE INNODB STATUS syntax # Total large memory allocated 2198863872 $results['total_mem_alloc'] = to_int($row[4]); $results['additional_pool_alloc'] = 0; } 17
- 18. MyISAM INDEX 18
- 20. Binary log 20
- 22. CPU 22
- 25. おわり 25