… _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much space InnoDB allocates for each blob outside…: What’s the status of INNODB in 5.1.x? Specifically: What’s the current status of innodb_thread_concurrency ? Is it suggested to set this value to a LARGE value (somewhat like 200) for additional throughput? HT: ha_innodb…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=8 innodb_read_io_threads=8 innodb…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin #innodb_buffer_pool_size = 11468M #innodb_log_file_size = 2867M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_thread_concurrency = 8 [mysqldump…
Comment: InnoDB thread concurrency
August 18, 2011 By 4 Comments
Does a thread which “ENTER” cause (thread->n_tickets_to_enter_innodb > 0) is include in “entered_thread” ? Does it mean we can have more thread than innodb_thread_concurrency which inside innodb_kernel ? suppose innodb_thread_concurrency=8, 9 threads have free tickets and all of them ENTER.
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… is in concurrency on rollback segment, which by default is single and all transactions are serialized accessing to segment. Fortunately InnoDB internally…, 16-way Intel Xeon, 32GB of RAM, RAID 10 on 8 disks) to compare mysql-5.1.30-XtraDB-1.0… innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=4096 in…_average innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=16 innodb_read_io_threads=16 innodb_io…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…_size=0 table_cache=256 tmp_table_size=93M thread_cache_size=8 #*** MyISAM Specific options myisam_max_sort_file_size=100G…=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=4M innodb_buffer_pool_size=304M innodb_log_file_size=152M innodb_thread_concurrency=8 RAM…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
…=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8 My…
Comment: kernel_mutex problem cont. Or triple your throughput
December 2, 2011 By 10 Comments
innodb_thread_concurrency=8 is my favorite way to guarantee that you don’t get more than 8 pending disk operations (ignoring purge, ibuf merges… subsystems, it really is a good idea to send more concurrent operations to the disks.
