11g新特性: OLTP中的Adaptive Direct Read算法

read policy

对以下MySQL配置参数进行分析，从原理、不同场景下的建议值、修改影响等角度解读 ssl=0 max_connections=5000 back_log=2048 performance_schema=OFF max_prepared_stmt_count=143960 skip-log-bin #测试极限性能在参数文件中增加此参数 #file innodb_file_per_table=on innodb_log_file_size=32G innodb_log_files_in_group=2 innodb_open_files=4000 innodb_doublewrite=0 #check innodb_checksum_algorithm=none innodb_log_checksums=0 binlog_checksum=none #foreign_key_checks=none #buffers innodb_buffer_pool_size=350G innodb_buffer_pool_instances=64 innodb_log_buffer_size=256M innodb_max_dirty_pages_pct=90 thread_cache_size=300 #tune sync_binlog=1 innodb_flush_log_at_trx_commit=0 innodb_flush_log_at_timeout=2 innodb_use_native_aio=1 innodb_spin_wait_delay=180 innodb_sync_spin_loops=25 innodb_spin_wait_pause_multiplier=25 innodb_flush_method=O_DIRECT #innodb_io_capacity=200000 innodb_io_capacity_max=300000 innodb_lru_scan_depth=9000 innodb_page_cleaners=64 table_open_cache_instances=64 table_open_cache=480000 innodb_thread_concurrency=0 #perf special innodb_flush_neighbors=0 innodb_write_io_threads=16 innodb_read_io_threads=16 innodb_purge_threads=64 innodb_adaptive_hash_index=0 #thread_pool_size=384 sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL_TABLES