… 1 innodb_flush_method O_DIRECT innodb_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb… innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… = 3600 table_definition_cache = 4096 thread_cache_size = 16K wait_timeout = 120 connect_timeout = 60 tmp_table_size = 192M max_heap_table_size…_block_size = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long_query…
Comment: Percona Toolkit 2.0.1 and 1.0.2 released
January 6, 2012 By 5 Comments
it seems there is a bug in ./pt-table-checksum line 5919, it’s easy to fix change from $sql = ‘SHOW SESSION VARIABLES LIKE “innodb_lock_wait_timeout“‘; to $sql = “SHOW SESSION VARIABLES LIKE ‘innodb_lock_wait_timeout“? i am not sure if it’s only have issue with my platform
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
… = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50… the file full: wait… InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…_trx_commit 0 innodb_log_buffer_size 8M innodb_buffer_pool_size 1G innodb_log_file_size 24M innodb_thread_concurrency 16 innodb_lock_wait_timeout 120 max…_res_unit slave_net_timeout innodb_data_file_path ibdata1:10M:autoextend innodb_file_io_threads 4 thread_concurrency 8 innodb_max_dirty_pages…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
… \ –innodb_log_file_size=900M \ –innodb_log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb_flush_log_at_trx_commit=1 \ –innodb_lock_wait_timeout=300 \ –innodb_locks_unsafe_for_binlog=1 \ –innodb…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… = 1600M innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked. select…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… InnoDB… buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 Thanks in…
