transactions cease to operate and their business grind to a halt. 6. Optimization Guidelines BKM innodb_thread_concurrency. Different values were tried; the best performance came with the default 0 (unlimited MySQL with SSDs Page 8 BKM innodb_adaptive_hash_index. Turned ‘OFF’, since OLTP workloads typically do not reuse data from previous queries. BKM innodb_fill_factor. Indicates the percentage mestamp innodb_log_group_home_dir //mysql_log Best Practices for MySQL with SSDs Page 13 innodb_undo_directory //mysql_log innodb_buffer_pool_size

55 Present - Solutions! 2016 - M ySQL InnoDB Cluster MySQL 组复制:自动成员身份更改、网络分区处理、一致性... MySQL Shell 提供强大的界面，有助于自动化和集成所有组件 InnoDB 克隆以自动生成成员，完全集成在InnoDB 中 MySQL Router MySQL Server RPO =0 RTO 自动故障转移) Copyright @ 2021 Oracle and/or its affiliates. 9 / 55 Present - Solutions! 2020 - MySQL InnoDB Replicaset • "经典"、"异步"的基于复制的解决方案，完全集成 • MySQL Shell • MySQL Router • MySQL Server RPO Oracle and/or its affiliates. MySQL InnoDB ClusterSet Copyright @ 2021 Oracle and/or its affiliates. 13 / 55 一个或者多个MySQL InnoDB Cluster 副本连接到一个主MySQL InnoDB Cluster 高可用 (区域内的失败) RPO =0 RTO

business-critical MySQL applications. • Achieve database high availability using MySQL InnoDB Cluster and MySQL InnoDB ClusterSet • Build, deploy, and manage a private DBaaS and microservices using MySQL Flexible Architecture • Open Source • Multi-threaded • Pluggable Storage-Engine • InnoDB, NDB, MyISAM, ANSI SQL Standards • ANSI SQL • SubQueries, Joins, Cursors • Prepared Statements Tables • JSON Documents • X Protocol • X DevAPI Replication & High-Availability • InnoDB Cluster, ClusterSet • Group Replication • Router • Built-in Replication Engine • Row-based

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions Default value 500000 4.20. Various display setting 71 phpMyAdmin Documentation, Release 4.7.0 For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT will be used, otherwise the approximate count will be used. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since

localhost bind_port = 3306 destinations = 192.168.1.41:3306, 192.168.1.42:3306 mode = read-write 39 InnoDB Cluster 40 App Servers with MySQL Router MySQL Group Replication MySQL Shell Setup, Manage 高可用性和扩展解决方案 MySQL 复制 Oracle VM MySQL 模板 Oracle Clusterware Solaris Cluster Group Replication InnoDB Cluster MySQL Cluster 应用程序自动故障转移 ✖ ✔ ✔ ✔ ✖ ✔ ✔ 数据层自动故障转移 ✖ ✔ ✔ ✔ ✔ ✔ ✔ 零数据丢失 MySQL 5.7 ✔ ✔ ✔ 跨分片操作 N/A N/A N/A N/A N/A N/A ✔ 透明路由 ✖ ✔ ✔ ✔ ✔ ✔ ✔ 无共享 ✔ ✖ ✖ ✖ ✔ ✔ ✔ 存储引擎 InnoDB+ InnoDB+ InnoDB+ InnoDB+ InnoDB+ InnoDB+ NDB 单一供应商支持 ✔ ✔ ✔ ✔ ✔ ✔ ✔ 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 48

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions Default value 50000 4.20. Various display setting 75 phpMyAdmin Documentation, Release 4.9.11 For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT in version 4.2.6: The default value was changed to 500000. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions value true Enable Transformations. $cfg['MaxExactCount'] Type integer Default value 50000 For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT in version 4.2.6: The default value was changed to 500000. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions value true Enable Transformations. $cfg['MaxExactCount'] Type integer Default value 50000 For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT in version 4.2.6: The default value was changed to 500000. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions Default value 50000 4.20. Various display setting 75 phpMyAdmin Documentation, Release 5.0.5-dev For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT in version 4.2.6: The default value was changed to 500000. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since

displaying BLOB-data as image or download-link • track changes on databases, tables and views • support InnoDB tables and foreign keys • support mysqli, the improved MySQL extension see 1.17 Which Database versions value true Enable Transformations. $cfg['MaxExactCount'] Type integer Default value 50000 For InnoDB tables, determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT in version 4.2.6: The default value was changed to 500000. See also: 3.11 The number of rows for InnoDB tables is not correct. $cfg['MaxExactCountViews'] Type integer Default value 0 For VIEWs, since