構築中。

名古屋のITインフラお守り係です。ITイベントへの参加記録などを残していきます。

MySQL 8.0 の薄い本/リンク集(第 8 章)8.0.18

8.0.17 対応版はこちら

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://dev.mysql.com/doc/refman/8.0/en/analyze-table.html#analyze-table-histogram-statistics-analysis

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_histogram_generation_max_mem_size

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://www.percona.com/blog/2019/10/29/column-histograms-on-percona-server-and-mysql-8-0/ 【第 3 刷で追加】

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

http://variable.jp/2017/09/28/mysql8-0%E3%81%AB%E3%81%8A%E3%81%91%E3%82%8B%E3%83%92%E3%83%B3%E3%83%88%E5%8F%A5%E3%81%AE%E6%8B%A1%E5%BC%B5/

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.1.6 Hash Join(ハッシュジョイン)

https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html

https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-analyze

https://tombo2.hatenablog.com/entry/2019/10/14/212100

http://atsuizo.hatenadiary.jp/entry/2019/10/18/090000

https://www.percona.com/blog/2019/10/30/understanding-hash-joins-in-mysql-8/ 【第 3 刷で追加】

https://mysqlserverteam.com/mysql-explain-analyze/ 【第 3 刷で追加】

https://mysqlserverteam.com/hash-join-in-mysql-8/ 【第 3 刷で追加】

8.2 InnoDB

8.2.1 新しいロック:NOWAITSKIP LOCKED

https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html#innodb-locking-reads-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://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html#innodb-auto-increment-initialization

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-data-encryption.html

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-data-encryption-redo-log

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-data-encryption-undo-log

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-general-tablespace-encryption-enabling-disabling

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-mysql-tablespace-encryption-enabling-disabling

https://mysqlserverteam.com/mysql-8-0-13-innodb-transparent-tablespace-encryption-for-general-tablespaces/

https://mita2db.blogspot.com/2019/09/mysql-default-table-encryption.html

http://mita2db.blogspot.com/2019/09/mysql-tableencryptionprivilegecheck.html

https://qiita.com/hmatsu47/items/bae53fd0f6d09511732c

https://qiita.com/hmatsu47/items/f3519532c134ba0018af

https://mysqlserverteam.com/innodb-tablespace-space-management/ 【第 3 刷で追加】

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/dev/mysql-server/8.0.14/classhandler.html#a684f7429844b6a5061d5942e6f12b573

https://dev.mysql.com/doc/dev/mysql-server/8.0.14/classhandler.html#a2e052d45aa09050fdfff6e10c67cbd1e

https://dev.mysql.com/doc/dev/mysql-server/8.0.14/classhandler.html#a167d4bd2f1c5f353d77ed08dbed4c04a

https://dev.mysql.com/doc/dev/mysql-server/8.0.14/sql_2handler_8h.html#ae954cfd46ba0b8300368dccf2bebc842

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_optimizer_trace_max_mem_size

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://www.s-style.co.jp/blog/2019/08/5060/

https://dev.mysql.com/doc/refman/8.0/en/semijoins.html

https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0103

https://mysqlserverteam.com/antijoin-in-mysql-8/ 【第 3 刷で追加】

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://mysqlserverteam.com/contention-aware-transaction-scheduling-arriving-in-innodb-to-boost-performance/

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

https://dev.mysql.com/worklog/task/?id=11613

https://dev.mysql.com/doc/refman/8.0/en/xa.html

https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_idle_flush_pct