構築中。

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

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

8.0.18 対応版はこちら

8.0.17 対応版はこちら

8.0.16 対応版はこちら

8.0.15 対応版はこちら

1.1 新規インストール

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

https://dev.mysql.com/doc/refman/8.0/en/mysql-secure-installation.html

1.1.1 Dedicated Server Mode

https://dev.mysql.com/doc/refman/8.0/en/innodb-dedicated-server.html

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

https://yakst.com/ja/posts/4781

https://www.s-style.co.jp/blog/2018/08/2281/

1.2 アップグレードインストール

https://speakerdeck.com/yoshiakiyamasaki/20181201-mysqlbaziyonatupufalseji-chu-zhi-shi?slide=26

https://lefred.be/content/upgrading-from-mysql-5-7-to-8-0-on-windows/

1.2.1 インプレースアップグレード

https://www.mysql.com/jp/why-mysql/presentations/mysql-80-upgrade-checker-201811-jp/

https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html

https://blog.pinkumohikan.com/entry/could-not-start-mysql8-after-version-up

https://mgng.mugbum.info/1542

https://mita2db.hateblo.jp/entry/MySQL_8.0_%E3%81%AF%E3%83%80%E3%82%A6%E3%83%B3%E3%82%B0%E3%83%AC%E3%83%BC%E3%83%89%E3%81%A7%E3%81%8D%E3%81%AA%E3%81%84

1.2.2 mysqldump→新環境へのリストアを⾏う場合の注意点

https://hit.hateblo.jp/entry/MYSQL/MYSQL8/SETTING

https://speakerdeck.com/yoshiakiyamasaki/20181201-mysqlbaziyonatupufalseji-chu-zhi-shi?slide=70

1.2.3 レプリケーションを利⽤するアップグレードの注意点

https://qiita.com/hmatsu47/items/2cfbb7dec89ce5ddd647

1.2.4 Upgrade Checker

https://www.mysql.com/jp/why-mysql/presentations/mysql-80-upgrade-checker-201811-jp/

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-upgrade.html

https://yakst.com/ja/posts/5190

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

https://mysqlserverteam.com/upgrade-checker-evolution/

https://elephantdolphin.blogspot.com/2019/09/upgrading-from-mysql-57-to-mysql-80_25.html

https://github.com/yoku0825/p5-mysql-upgrade-checker

https://yoku0825.blogspot.com/2018/07/mysql-shellupgrade-checkerperl-5.html

http://next4us-ti.hatenablog.com/entry/2018/12/05/085115

1.2.5 データディクショナリInnoDB

https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html

https://mysqlserverteam.com/mysql-8-0-data-dictionary-architecture-and-design/

https://lefred.be/content/mysql-8-0-data-dictionary-tables-and-why-they-should-stay-protected/

1.3 設定パラメータ・起動パラメータの変更

https://www.mysql.com/jp/why-mysql/presentations/mysql-80-upgrade-checker-201811-jp/

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

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

1.3.1 対象となるサーバ設定パラメータ・起動パラメータ

https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html

https://dev.mysql.com/doc/mysqld-version-reference/en/

https://mysql-params.tmtms.net/

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

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

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

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

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

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

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

1.3.2 その他の変更点

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

https://mita2db.hateblo.jp/entry/admin_network_if

https://dev.mysql.com/doc/refman/8.0/en/client-connections.html

https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_service-connection-admin

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

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

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

https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_daemonize

https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_initialize

https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html

https://www.s-style.co.jp/blog/2020/02/5847/ 【第 2 刷で追加】

1.4 キーワードと予約語

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

https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html

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

1.5 キャラクタセットと照合順序

https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html

https://mysqlserverteam.com/mysql-8-0-1-japanese-collation-for-utf8mb4-ja_jp/

https://mysqlserverteam.com/mysql-8-0-kana-sensitive-collation-for-japanese-ja_jp/

https://tmtms.hatenablog.com/entry/201805/mysql-innovation-day-tokyo

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

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

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

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

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

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

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

http://dimitrik.free.fr/blog/archives/2018/04/mysql-performance-80-and-utf8-impact.html

https://yoku0825.blogspot.com/2018/12/utf8mb40900aici.html

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html

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

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

https://www.s-style.co.jp/blog/2018/09/2519/