赖明星数据库技术组2015年4月2日.pptVIP

Operational Improvement: Separate TableSpaces for undo logs Separate Tablespaces for Innodb Undo Logs： innodb_undo_tablespaces. innodb_undo_directory. innodb_undo_logs（ innodb_rollback_segments ） ?User Defined?DATA DIRECTORY?for Innodb Tables： mysql CREATE TABLE t1 (c1 INT PRIMARY KEY) DATA DIRECTORY = /alternative/directory; 将更热的数据存储到性能更好、价格更高的固态盘中，以期获取更好的性能。 参考资料 What Is New in MySQL 5.6?/doc/refman/5.6/en/mysql-nutshell.html Whats New in MySQL 5.6?/tech-resources/articles/whats-new-in-mysql-5.6.html Split of “kernel mutex”: /mysqlinnodb/entry/mysql_5_6_innodb_scalability Improved Adaptive Flushing: /mysqlinnodb/entry/new_flushing_algorithm_in_innodb Persistent Statistics for Innodb : /doc/refman/5.6/en/innodb-persistent-stats.html Global Transaction Identifiers: /blog/1770398 Crash Safe Slave and Binlog /blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/） Time Delayed Replication /mysql-replication/delayed-replication-in-mysql-5-6-development-release http://marcalff.blogspot.hk/2013/02/mysql-56-performance-schema-is-ga.html /news-and-events/events/innovation-day/slides/MySQL_Innovation_Day_Performance_Schema.pdf http://www.markleith.co.uk/2011/04/01/a-big-bag-of-epic-awesomeness/ /Leithal/mysql-tech-dayparispsandsys?ref=http://www.markleith.co.uk/presentations/ http://marcalff.blogspot.hk/2013/02/mysql-56-performance-schema-is-ga.html Separate Tablespaces for Innodb Undo Logs /mysqlinnodb/entry/allow_undo_logs_to_reside /doc/refman/5.6/en/innodb-undo-tablespace.html /doc/refman/5.6/en/innodb-online-ddl.html /mysqlinnodb/entry/online_alter_table_in_mysql? /doc/refman/5.6/en/innodb-create-index-overview.html#innodb-online-ddl-summary-grid MySQL 5.6新特性深入剖析——innodb引擎: /?p=637 《MySQL技术内幕：InnoDB存储引擎》: /subject/5373022/ 谢谢！ 赖明星 数据库技术组 2015年4月2日 What’s New In MySQL 5.6 Overview Overview: Scalability Overview: Optimizer and Execution Overview: Replication Overview: Transparency Overview: Operational Improvements Overview: New Functionality for Develo