MySQL Forums
Forum List  »  InnoDB

Re: Innodb_buffer_pool_pages_free = 0
Posted by: Douglas Nelson
Date: September 26, 2012 06:06PM

innodb_adaptive_flushing | ON
innodb_adaptive_hash_index | ON
innodb_additional_mem_pool_size | 16777216
innodb_autoextend_increment | 8
innodb_autoinc_lock_mode | 1
innodb_buffer_pool_instances | 1
innodb_buffer_pool_size | 23622320128
innodb_change_buffering | all
innodb_checksums | ON
innodb_commit_concurrency | 32
innodb_concurrency_tickets | 5000
innodb_data_file_path | ibdata1:512M;ibdata2:10M:autoextend
innodb_data_home_dir | /var/lib/mysql/
innodb_doublewrite | OFF
innodb_fast_shutdown | 1
innodb_file_format | Antelope
innodb_file_format_check | ON
innodb_file_format_max | Antelope
innodb_file_per_table | ON
innodb_flush_log_at_trx_commit | 1
innodb_flush_method |
innodb_force_recovery | 0
innodb_io_capacity | 200
innodb_large_prefix | OFF
innodb_lock_wait_timeout | 50
innodb_locks_unsafe_for_binlog | OFF
innodb_log_buffer_size | 33554432
innodb_log_file_size | 1073741824
innodb_log_files_in_group | 2
innodb_log_group_home_dir | /var/lib/mysql-transaction-log/
innodb_max_dirty_pages_pct | 75
innodb_max_purge_lag | 0
innodb_mirrored_log_groups | 1
innodb_old_blocks_pct | 37
innodb_old_blocks_time | 0
innodb_open_files | 300
innodb_purge_batch_size | 20
innodb_purge_threads | 0
innodb_random_read_ahead | OFF
innodb_read_ahead_threshold | 56
innodb_read_io_threads | 4
innodb_replication_delay | 0
innodb_rollback_on_timeout | OFF
innodb_rollback_segments | 128
innodb_spin_wait_delay | 6
innodb_stats_method | nulls_equal
innodb_stats_on_metadata | ON
innodb_stats_sample_pages | 8
innodb_strict_mode | OFF
innodb_support_xa | OFF
innodb_sync_spin_loops | 30
innodb_table_locks | OFF
innodb_thread_concurrency | 64
innodb_thread_sleep_delay | 10000
innodb_use_native_aio | OFF
innodb_use_sys_malloc | ON
innodb_version | 1.1.8
innodb_write_io_threads | 4

Options: ReplyQuote


Subject
Views
Written By
Posted
4907
September 24, 2012 10:31AM
1966
September 25, 2012 10:44AM
1926
September 26, 2012 03:21PM
Re: Innodb_buffer_pool_pages_free = 0
1636
September 26, 2012 06:06PM
1385
September 27, 2012 01:49AM
3952
September 27, 2012 02:48AM
1968
September 27, 2012 03:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.