8.0.16 対応版はこちら
8.0.15 対応版はこちら
8.1 オプティマイザ
https://yakst.github.io/unofficialmysqlguide-ja/
8.1.1 ヒストグラム
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
https://yakst.com/ja/posts/4873
http://masato.ushio.org/blog/index.php/2017/09/25/uco-tech_mysql-8-0-rc-histogram-optimizing/
https://qiita.com/hmatsu47/items/3cfc6762bca766c5d9a1
8.1.2 メモリとディスクの I/O コスト
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html#cost-model-database
https://qiita.com/hmatsu47/items/d53b0471c8f279130114
8.1.3 FORCE INDEX
時に不要なインデックスダイブを回避
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html#equality-range-optimization
https://mysqlserverteam.com/optimization-to-skip-index-dives-with-force-index/
8.1.4 ヒント句
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-table-level
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-index-level
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-join-order
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-subquery
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html#optimizer-hints-set-var
https://yoku0825.blogspot.com/2017/04/mysql-801joinorder.html
8.1.5 Skip Scan Range Access Method
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html#range-access-skip-scan
https://qiita.com/hmatsu47/items/d83bda0360728d4f585a
https://dev.mysql.com/doc/refman/5.6/ja/order-by-optimization.html
8.2 InnoDB
8.2.1 新しいロック:NOWAIT
/SKIP LOCKED
https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/
https://yoku0825.blogspot.com/2018/04/mysql-80-select-for-update-skip-locked.html
8.2.2 ノンロッキング並列読み取り
https://dev.mysql.com/doc/refman/8.0/en/check-table.html#check-table-innodb
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_parallel_read_threads
http://atsuizo.hatenadiary.jp/entry/2019/01/23/112608
http://atsuizo.hatenadiary.jp/entry/2019/01/24/090000
http://atsuizo.hatenadiary.jp/entry/2019/01/26/090000
http://atsuizo.hatenadiary.jp/entry/2019/01/28/090000
http://atsuizo.hatenadiary.jp/entry/2019/01/29/090000
8.2.3 AUTO_INCREMENT
値の永続化
https://www.s-style.co.jp/blog/2018/08/2284/
https://qiita.com/hmatsu47/items/4429171c1bbaba564774
8.2.4 テーブルスペース/Redo・Undo ログと⼀般テーブルスペースの暗号化
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-encryption.html
https://qiita.com/hmatsu47/items/bae53fd0f6d09511732c
https://qiita.com/hmatsu47/items/f3519532c134ba0018af
8.2.5 その他の InnoDB 新機能
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html#innodb-add-undo-tablespaces
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html#innodb-drop-undo-tablespaces
https://mysqlserverteam.com/new-in-mysql-8-0-14-create-undo-tablespace/
https://dev.mysql.com/worklog/task/?id=7093
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html
https://bugs.mysql.com/bug.php?id=74359
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
https://dev.mysql.com/worklog/task/?id=10310
https://mysqlserverteam.com/mysql-8-0-new-lock-free-scalable-wal-design/
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html#innodb-redo-log-archiving
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_redo_log_archive_dirs
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
https://dev.mysql.com/worklog/task/?id=8960
https://mysqlserverteam.com/mysql-8-0-innodb-introduces-lob-index-for-faster-updates/
https://mysqlserverteam.com/mysql-8-0-mvcc-of-large-objects-in-innodb/
https://mysqlserverteam.com/mysql-8-0-optimizing-small-partial-update-of-lob-in-innodb/
http://masato.ushio.org/blog/index.php/2018/03/04/uco-tech_mysql-8-0_trx_scheduling_cats/
https://dev.mysql.com/worklog/task/?id=5989
https://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_serialized_dictionary_information
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
https://dev.mysql.com/worklog/task/?id=8423
https://dev.mysql.com/worklog/task/?id=9387
https://dev.mysql.com/worklog/task/?id=9383
https://dev.mysql.com/worklog/task/?id=8619
https://mysqlserverteam.com/mysql-8-0-excluding-the-buffer-pool-from-a-core-file/
https://dev.mysql.com/worklog/task/?id=11571