The v2 patch 之 InnoDB

• Innodb_dict_size - number of bytes used for the InnoDB dictionary
• Innodb_have_atomic_builtins - indicates whether InnoDB uses atomic memory operations in place of pthreads synchronization functions
• Innodb_heap_enabled - indicates whether the InnoDB malloc heap was enabled -- see Bug38531
• Innodb_long_lock_wait - set when there is a long lock wait on an internal lock. These usually indicate an InnoDB bug. They also occur because the adaptive hash latch is not always released when it should be (such as during an external sort).
• Innodb_long_lock_waits - incremented once for each internal long lock wait
• Innodb_os_read_requests - from SHOW INNODB STATUS
• Innodb_os_write_requests - from SHOW INNODB STATUS
• Innodb_os_pages_read - from SHOW INNODB STATUS
• Innodb_os_pages_written - from SHOW INNODB STATUS
• Innodb_os_read_time - from SHOW INNODB STATUS
• Innodb_os_write_time - from SHOW INNODB STATUS
• Innodb_time_per_read - milliseconds per read
• Innodb_time_per_write - milliseconds per write
• Innodb_deadlocks - application deadlocks, detected automatically
• Innodb_transaction_count - from SHOW INNODB STATUS
• Innodb_transaction_purge_count - from SHOW INNODB STATUS
• Innodb_transaction_purge_lag - count of work to be done by the InnoDB purge thread, see InnodbLag
• Innodb_active_transactions - from SHOW INNODB STATUS
• Innodb_summed_transaction_age - from SHOW INNODB STATUS
• Innodb_longest_transaction_age - from SHOW INNODB STATUS
• Innodb_lock_wait_timeouts - count of lock wait timeouts
• Innodb_lock_waiters - from SHOW INNODB STATUS
• Innodb_summed_lock_wait_time - from SHOW INNODB STATUS
• Innodb_longest_lock_wait - from SHOW INNODB STATUS
• Innodb_pending_normal_aio_reads - from SHOW INNODB STATUS
• Innodb_pending_normal_aio_writes - from SHOW INNODB STATUS
• Innodb_pending_ibuf_aio_reads - from SHOW INNODB STATUS
• Innodb_pending_log_ios - from SHOW INNODB STATUS
• Innodb_pending_sync_ios - from SHOW INNODB STATUS
• Innodb_os_reads - from SHOW INNODB STATUS
• Innodb_os_writes - from SHOW INNODB STATUS
• Innodb_os_fsyncs - from SHOW INNODB STATUS
• Innodb_ibuf_inserts - from SHOW INNODB STATUS
• Innodb_ibuf_size - counts work to be done by the insert buffer, see InnodbLag
• Innodb_ibuf_merged_recs - from SHOW INNODB STATUS
• Innodb_ibuf_merges - from SHOW INNODB STATUS
• Innodb_log_ios_done - from SHOW INNODB STATUS
• Innodb_buffer_pool_hit_rate - from SHOW INNODB STATUS

mysql> show variables like 'INNODB%';
+----------------------------------+-------------------------------------------------------------------+
| Variable_name | Value |
+----------------------------------+-------------------------------------------------------------------+
| innodb_additional_mem_pool_size | 2097152 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 16777216 |
| innodb_checksums | ON |
| innodb_clear_replication_status | OFF |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_confirm_checksum_on_write | OFF |
| innodb_crash_if_init_fails | OFF |
| innodb_data_file_path | ibdata1:2000M;ibdata2:2000M;ibdata3:2000M:ibdata4:100M:autoextend |
| innodb_data_home_dir | /usr/local/mysql5037/var/ |
| innodb_disallow_writes | OFF |
| innodb_doublewrite | ON |
| innodb_extra_dirty_writes | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | ON |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_io_capacity | 100 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 8388608 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| innodb_read_io_threads | 1 |
| innodb_write_io_threads | 1 |
| innodb_max_merged_io | 64 |
| innodb_status_update_interval | 0 |
+----------------------------------+-------------------------------------------------------------------+
44 rows in set (0.00 sec)