…-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2…, and only have a log file for debugging purposes. Streaming logs from stdin Percona Playback now supports the –query-log-stdin command-line option… queries to playback. Read-only playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts,…give pt-upgrade a try. It also reads every type of log now (slow, general, binary, and …other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what …
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… gather statistics about how the log file writes are distributed in terms of write size. InnoDB writes to the log files in multiples of 512… So, in sum, we see that about 3/4ths of InnoDB log file writes on this workload are 512 or 1024 bytes. (It… to be read, modified, and then written again, instead of just written. Vadim did some benchmarks earlier showing that the log files need…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…=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_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… posts about 64 page read requests per a readahead. The InnoDB buffer is 256 page read requests for the aio read thread. Thus, about… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory for… first file in a log file group. My questions are: What is always being written to the first file in the log file group? HT: InnoDB writes…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…, because that defines what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk, but… is less than innodb_max_dirty_pages_pct and checkpoint age is less than 3/4 of innodb_log_file_size * innodb_log_files_in_group. If you have these conditions and observe intensive writes, InnoDB is using LRU list…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…:autoextend 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=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb. The tables… would use larger amount of rows read performance for 10000 tables would be close. Innodb with innodb_file_per_table=1 had the following…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 92684288 xtrabackup: Starting InnoDB…
