….sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file…
Comment: How long Innodb Shutdown may take
May 14, 2013 By 9 Comments
…; log sequence number 4 3582590782 130514 8:04:26 [Note] /usr/sbin/mysqld: Shutdown complete …. 130514 8:05:00 InnoDB: Initializing buffer pool, size = 4.0G 130514 8:12:29 InnoDB: Completed initialization of buffer pool Why initializing innodb buffer pool (size 4.0G…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… there are two log files by default, divide that in half, and now you can set innodb_log_file_size=64M Does that look surprisingly small? It might. I commonly see log file sizes in the gigabyte… common advice to size the logs as a fraction of the buffer pool size is just wrong. One final note: huge buffer pools or really…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it… recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which only have… are up to date), number of unflushed pages in innodb buffer pool and its size as well as performance of IO subsystem. As…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
… that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size….5 increased the default buffer pool size to something more sane (128MB instead of 8MB), but the log file size remains at 5MB. That… a default log file size into the comments. By the way, if you’re looking to choose a good log file size for your…
