構築中。

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

MySQL 8.0 の薄い本/リンク集(第 1 章)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

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

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

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

1.2.4 Upgrade Checker

https://mysqlserverteam.com/mysql-shell-8-0-4-introducing-upgrade-checker-utility/

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://tmtm.github.io/mysql-params/

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-options.html#option_mysqld_event-scheduler

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://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/server-options.html#option_mysqld_basedir

1.4 キーワードと予約語

https://dev.mysql.com/doc/refman/8.0/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-options.html#option_mysqld_character-set-server

https://dev.mysql.com/doc/refman/8.0/en/server-options.html#option_mysqld_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://www.s-style.co.jp/blog/2018/09/2519/